0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). In BW, we always need to see. The DataSources can then be used independently of one another (see note 551044). To check this go to RSA2 --> open this datasource --> in the FIELDS tab check whether for the field RASSC the checkbox "Selection Poss" (Field can be Used for Selection) is checked or not. 0 Ehp3 SP2 ) does not provide Material No. For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. that is not extracing the data completly in the psa itself. Follow. 0FI_GL_10:General Ledger: Leading Ledger Balances 0FI_GL_14:General Ledger: Line Items of the Leading Ledger(New GL in ECC) 0FI_TX_4: Taxes:General Ledger:Data for Tax on Sales/Purchases 0ACAC_CALC:Manual Accruals: Calculated Accrual Values 0ACE_CALC_RESULT:Accrual Engine: Calculated Accrual ValuesIn that case how about 0FI_GL_10 datasource, do they have to wait for one hour to look the data in BI or this datasource 0FI_GL_10 will not follow the settings in table BWOM2_SETTINGS and only follow the safety interval available for this datasource, its lower limit as 3600 secs. RSS Feed. " 0FI_GL_8 General Ledger: Statistical Key Figures". "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. Does it contain extra fu. About this page This is a preview of a SAP Knowledge Base Article. regards. Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. 0fi Gl 10 Tables. sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. 0FI_AP_3 : Vendors: Line Items. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. DetaInit Simulation = 1 supported. Now, I used RSDS in BW to try to replicate it in. 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals) 0FI_GL_14 --> 0FIGL_O14 (for Line item) Functionally, this effects other financial modules like AP, AR, PCA (Profit Center Accounting) for ex. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. There are no changes in the system and the extraction is running already for 3 months but last Tuesday we encountered a long running time of job in ECC6. 0FI_AA_11 Transactions and annual values; 0FI_AA_12 Posted depreciation (period values) The correct load sequence is checked by the extraction routines!. It runs for several days and fails due to connectivity issues after several days (5-6). But when I checked table BWOM2_TIMEST, there is no entry for the above data source. The Field COST_ELEM is there in extract structure FAGL_EXTSTRUCT_LEAD. The DSO enables line item reporting on actual data. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). System Response Caller. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. I understood that FI data sources delta is based on timestamp. ACDOCA, mismatch,. to the ACDOCA extractors. 0FI_GL_4 (G/L Accounts- line items) Takes the data from the FI document tables (BKPF/BSEG) that are relevant to general ledger accounting (compare table BSIS). Extractor Tables. 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management: 0FI_GL_6: General Ledger. Click more to access the full version on SAP for Me (Login required). Dates are expressed in the format YYYYMMM. Financial Accounting: Accounts Receivable (SAP HANA-Optimized) Financial Accounting: Accounts Payable (SAP HANA-Optimized) Financial Accounting: General Ledger (SAP HANA-Optimized) Queries. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. Looking in the table. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). A number of GL postings have been created and we can pick them up using the extractor checker (RSA3) and the delta initialisation works OK. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. However we do not see anything flowing into the delta queue in RSA7. IDoc s enable the connection of different application systems using a message-based. I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. DSO key figures are set to "overwrite". 1505 Views. I am stuck at mapping BPC dimensions and properties to BW info-objects. 2012th and today we have thrown the extraction delta, and ride like thing of 8 hours executing and still it has not raised ningun information to bw. Thanks. We are implementing SEM BCS60 and ECC60 with new GL. Hello experts, Derived of a business requirement it is needed to add the Cost Element (KSTAR) field in the 0FI_GL_10 extractor in ECC in order to put it available for its use in the BW side. Hello SAP Experts, I missing my data in SAP BW (Business Warehousing) while using data source 0FI_GL_10 (or generated 3FI_GL_xx_TT with delta mode AIED) in delta mode. You may choose to manage your own preferences. 0FI_GL_14 provides you detail level information of account number at day level. Description of Field in Extract Structuree. 1 Document History The following table provides an overview of the most important changes to this document. InfoSource 0FI_GL_4 transfers only those fields that are relevant for General Ledger Accounting from the Financial Accounting document (tables BKPF and BSEG) to the BW system. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. I create some GL documents in the source system. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the DataStore object to the InfoSource. 01. Enhancement issue with 0FI_GL_10. . The symptom. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the DataStore object to the InfoSource. 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals) 0FI_GL_14 --> 0FIGL_O14 (for Line item) Functionally, this effects other financial modules like AP, AR, PCA (Profit Center Accounting) for ex: while implementing new G/L in BI side, this fulfills most of profit center Accounting requirements, and you do not have to implement PCA module. Monitor the extraction. Experts: Extraction of data from 0FI_GL_10 (ECC 6. In step two, all logically dependent records of these records (for example, the credit record. our ECC system is on ERP on HANA with Simple Finance add-on. However, we have a problem in that splitting in the new GL in ECC 6. Nov 15, 2016 at 09:09 AM. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. Click more to access the full version on SAP for Me (Login required). 0FI_GL_14. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. Use corresponding exit FM as template and copy the import, Export, Table, Exception. 0COMP_CODE Company code. [Enter your Keywords here. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. When i tried to create Generic data source wh. Source System for R/3 Entry* 0GN_R3_SSY. In step two, all logically dependent records of these records (for example, the credit record. As i checked in the System, there is no entry in this table. Click more to access the full version on SAP for Me (Login required). I have searched in SCN but no extractor found which pulls all the data from this FAGLFLEXT table. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource General Ledger: Balances of Leading Ledger via Delta Queue (0FI_GL_12). InfoSource 0FI_GL_4 transfers only. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. DataStore object: /IMO/FIGL_D12. You have probably used an ABAP feature in the interface definition that is not yet supported in the test. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. Procedure. Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. 0 system and we have 0FI_GL_10 extractor providing us the reports based on P&L and Balance Sheet. We faced this issue couple of years and has been stable for years now. When we extracted . The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource General Ledger: Line Items with Delta Extraction (0FI_GL_4). 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. Delta load. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. Fields need to be enhanced are TSLVT TSL01. Performance enhancements might be available for data extraction. 3) Before Delta Load all GL. Let us say "RMVCT - Transaction Type" is available in the datasource but missing in the transfer rules. In addition to the Data Source 0FI_GL_14 (or the generated Data Source 3FI_GL_xx_SI), you also use precisely one of the following extractors in delta mode only: 0FI_GL_4, 0FI_AP_4, 0FI_AR_4, 0FI_TX_4 When the initialization selections for one of these extractors are deleted, the BWFI_AEDAT entries necessary for the Data Source 0FI_GL_14 (or the. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. Fields like that (and a lot more) are only in 14. (1) See SAP note 1012874 for FAQ on extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 0FI_GL_10, 0FI_GL_11, 0FI_GL_12, 0FI_GL_14) (2) T o extract the changed delta records , there are some pre-requisites steps to be performed on the SAP server as summarized in following steps: While using the data source 0FI_GL_10 could someone please shed light on which table should be used to load actual data among FAGLFLEXA and FAGLFLEXT for SEM-BCS company consolidation purposes. included. And now the FAGLFLEXT is no longer. At the time of init with data transfer the balance in BW report exactly matches that in ECC . Search for additional results. TSL16). Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). Functional Area. I had operated info package in full update, then did initialize without data. The current BW system (SAP BW 7. Visit. Sub Modules. With New G/L in SAP ECC 6. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. 2. Please share with me your suggestion or view. I want it either in 0FI_GL_14 or 0FI_AP_30. The problem is that when we extract INIT load. Date Time Message text. This explains how to convert from using the old extraction procedure (DataSources 0FI_AP_3 and 0FI_AR_3) to the new one (DataSources 0FI_GL_4, 0FI_AP_4 and 0FI_AR_4). GoTo Schedule tab and start the extraction. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. The system could not generate a syntactically correct test frame for function module FAGL_GET_TT_DATA_LEAD. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. Generally-used fields are as follows:Transformation. Visit SAP Support Portal's SAP Notes and KBA Search. This InfoSource is based on DataSource 0FI_GL_14. Choose your transport. The DSO enables balance and flow reporting for defined periods. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. My explanation in this blog is focusing on transfering data with ODP to another system. The data records are read from table ACDOCA. the activation throws up these errors. You may choose to manage your own preferences. till that everything did well. Values in R/3 FI tcode and RSA3 are matching but not in BW Infoproviders. This InfoSource is based on DataSource 0FI_GL_14. 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. Company Codes Section. Does it contain extra fu. ISU BW Extractors. Since Release 3. Mainly applicable for Expense line items (P&L line items). One of the CO currencies needed to be the local currency, but it was not necessary that the other currency in CO was also configured in FI. We had installed 0FI_GL_10 and available in all the systems (dev/qa/prod). 07. Based on my understanding the below Business Content Extractors pull from FAGLFLEXT and. InfoProvider for actuals data. 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_1: General ledger: Transaction figures: FI - General Ledger Accounting: 0FI_GL_12: General Ledger: Balances of Leading Ledger via Delta Queue: FI - General Ledger. 3. 1. . Delta determination using the procedure AIED (for example, DataSource 0FI_GL_10) If you choose this delta procedure, in step one, the TIMESTAMP field in the totals table is used to select all records that have been changed since the last delta load. Datasource is not having WBS Field. Is it reuire to create the statistics. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. InfoSources. For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. About the 0FI_AR_4 / 0FI_AR_30 Datasource . About this page This is a preview of a SAP Knowledge Base Article. Dates are expressed in the format YYYYMMM. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. 0FI_AA_11; 0FI_AA_12; This is due to Asset Accounting data sources and FI Line item data sources uses the same Function Modules to fetch and update the time stamps for extraction. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no longer be used. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. W/ VAL. It is used as a source for reconstructions without the need to access the sources again. SAP delivers the DataSource 0SEM_BCS_10 for the data collection of the leading ledger from the new general ledger into the consolidation. Understood. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. And then you need to replicate it to BI. Was working on the extractor - 0FI_GL_21 which has very less documentation. SAP BW/4HANA 1. VALUETYPE = 20) then it will be available in 0FI_ACDOCA_20 extractor). Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. It seems that all values that. Missing document using 0FI_ACDOCA_10. Application: FI - General Ledger Accounting. We applied several SAP notes: 1. This InfoSource is based on DataSource 0FI_GL_14. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 11. 0FI_GL_10 vs. How can I resolve this issue?0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. after every load completes based on this period the next period needs to get loaded. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. Delta Update. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. I Have a problem with the extracción delta of the extractor 0fi_gl_10. I changed the record in ECC system, the streaming process chain did not bring the delta for next 15 runs, all the time it was 0. Drill Down in P&L Report. All planned Versions <> 001 However during Delta load it extracts only actual data (Version = '001') but no planned versio. To do so, go to the configuration menu path Financial Accounting > Financial Accounting Global Settings > Ledgers > Ledger > Define Settings for Ledgers and Currency Types or use Transaction FINSC_LEDGER. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. Data source setup table filling. 3. but that field not visible at RSA6,Extractor 0FI_GL_10 pulls data from table FAGLFLEXT. Issues loading 0FIGL_C10. in the 0FI_GL_4 extractor. All other ledgers, again if required, would require separate Data Sources be created for each ledger. Hello experts, We are running over S4H (SAPK-10102INS4CORE) and SAP_BW (SAPK-75006INSAPBW) trying to activate BW Business Content datasource 0FI_GL_10 but unable to end the process successfully. 0FI_GL_10 General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 10 : 0BPARTNER_ATTR SAP BP: BW Extraction Central data - 11 : 0FI_AA_001 ANNUAL VALUES FI - Asset Accounting: 12 : 0FI_AA_006 TRANS. Follow. 0FI_TAX_4. 1505 Views. We now realize we need the cumulated balance at a plant level for specific GL Accounts. IDoc (Intermediate Document) is a standard SAP document format. About this page This is a preview of a SAP Knowledge Base Article. 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. 0 (=> SAP ERP 6. SQL cod The following error may also. But it is not easy to find out how the buffer are given and what is the value, this blog post will help you to understand and get necessary information. (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. However, the key field Ref. Correction specified in the note: 1152755 have to be incorporated in order to resolve the issue with the AA data sources. I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the. The ODS object General Ledger: Line Items contains all line items transferred from the source system (s) using the InfoSource General Ledger Line Items (0FI_GL_4). We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. 6 million records – 100 mins (0FI_GL_14 7. The new solution is based on new extractors that are available with Plug-In Release PI2003. The extrator is the function module FAGL_GET_TT_DATA_LEAD for the data source. There are lot of sap notes available for this strange behavior and its corrections. Not. ) Now, for that same particular combination (in DSO Active Table) some records are missing. The Non-Leading Ledger — What is it? These ledgers, as stated above, work in parallel to the leading. Please help. Some of the infopackage and transfer rules are missing. The fields in the datasource are more than the 16 allowed keys in the DSO,. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. there are no long texts onThe name of the DataSource (0FI_GL_4) The name of the extract structure (DTFIGL_4) The name of the field that was added to the structure (ZZBKTXT) The name of the BW InfoSource (0FI_GL_4) The name of the R/3 table and field that contains the data you need (BKPFBKTXT) With this information, an experienced ABAP developer should. The target applications (referred to as ODQ ‘subscribers’ or more generally “ODP Consumers”) retrieve the data from the delta queue and continue processing the data. Bw Delta Pointer For Delta Tables. My question is if "0FI_GL_10 - Leading Ledger Balance" and "0FI_GL_4 - Actual Line Items" datsources are already configured. 0FIS_GL_LINEITEM. So now can I create a multiprovider on both and take document type and 0fi_ar_4 DSO and rest of the fields from 0fi_gl_10 cube and run a report. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. Currently we dont have any field coming from 0FI_GL_10 datasource to include characterstics like Country and Material. Description: General Ledger: Leading Ledger Balances. All other ledgers, again if required, would require separate DataSources be created for each ledger. As per the document, the datasources "0FI_GL_10 - Leading Ledger Balance" and "0FI_GL_4 - Actual Line Items" or generated datasources 3FI_GL_xx_SI, and 3FI_GL_xx_TT could be used for delta extraction. Why 0FI_Gl_40 General Ledger Accounting: Line Items datasource is not delta supported? Full upload of FI-GL line item for any big industries is not a feasible solution. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. I need to Install Standard reports related FI Module and that too related to Financial Accounting: Vendors ( FI AP ) and Financial Accounting: General Ledger ( FI GL ). In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. Financial Statements are based on 0FI_GL_10 i. About the 0FI_AR_4 / 0FI_AR_30 Datasource . Accounts receivable: Line items. You can find full information in the below SAP note: 1153944 - New delta extraction in new G/L. 0 (=> SAP ERP 2004) and ECC 6. Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14? Is it preferred to use one over another one? Should both be used? Thanks, Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14?The simple step for FI load is. I not enhance 0FI_GL_10. Please see picture for reference. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. 0FI_AP_4 (AP-line items) and 0FI_AR_4 (AR- line items Selections are made from tables BSID/BSAD (Accounts Receivable) and BSIK/BSAK (Accounts Payable) For New GL, in BI New GL accounting as an Application Area under that you can have Basic Cube 0FIGL_C10 and DSO 0FIGL_O10 which are based on Datasource 0FI_GL_10. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. But i havnt understand the structure of this datasource. 4. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. We have intilzed the delta one year back and we are pulling delta records to BW. Extractor: BWFID_GET_FIGL_ITEM. For the General Ledger, the selection is made from the tables BKPF and BSEG, while selection for the subledgers is made from tables BSID/BSAD (Accounts Receivable) and BSIK/BSAK (Accounts Payable). Use SAP BW/4HANA Business Content delivers this field-based DataStore Object (advanced) as a first persistence layer of data replicated into a SAP BW/4HANA data warehouse. This InfoSource is based on DataSource 0FI_GL_14. This increase in performance compared to a full data extraction on the same ODP datasource is due to. I planned for generic with time stamp by creating the view, but. e. Since the generated objects no longer correspond to the old active version, they were reset to inactive. . Regards,The Business content 0FI_GL_1 is just a summary cube, our customer has a need to have GL line item details in BW ODS/Cube from BSIS/BSAS R/3 tables. LIVE: Global News BC ; Global TV News BC ; breaking news & headlines, local weather forecasts, sports and traffic reports; your source for 7 day weather conditions from. 0)0FI_GL_10 Datasource. I have done following steps to get delta data. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. The logic in function module BW4C_FIGL_DATA_GET is designed to work with data provided from the NewGL DataSources 0FI_GL_10 or 0FI_GL_12. Now in BW side I am creating infopackage for above extractor, then I do Init without data transfer and then I execute the delta infopackage. 0FI_GL_10 vs. ODQ Tables. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). Hi Shehzad, 0FI_GL_10 and GL_4 is used for leading ledger. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 4 : 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 5 : 0FI_GL_6: General Ledger Sales Figures via Delta Extraction FI - General Ledger Accounting: 6 : 0GL_ACCOUNT_ATTR: G/L account NumberI am using 0FIGL_O10 Business Content Data store Object and Data source is 0FI_GL_10. Note. 1. Chart of Account Section and b. The latter is available from ECC60 onwards. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 668 Views. The issue you have with 0FI_GL_10 extractor in the delta load is that the key fields of the DSO are not correct, with the result that records are being overwritten by the last record when 2 similar records are received by the Delta process and updated to the DSO. doc no and doc pos can be used. Relevancy Factor: 1. For more information, see SAP. With SAP BW/4HANA, Operational Data Provisioning (ODP) now becomes the central infrastructure for data extraction and replication from SAP (ABAP) applications to a SAP. If any of you implemented custom GL line item level generic data extraction, please let me know how you handled the delta for your generic extractor. 10 characters required. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. You can use this DataSource to extract average daily balances (ADB) and other key figures for ledger dimensions to the FI component. Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14? Is it preferred to use one over another one? Should both be used?Financial Accounting: General Ledger (SAP HANA-Optimized) Queries. Visit. But when I am matching 0FI_GL_10 DS with 3FI_GL_AA_TT DS I found that RLDNR - Ledger in General Ledger Accounting, RUNIT - Base Unit of Measure and RRCTY - Record Type fields are not available under 3FI_GL_US_TT DS. while start Infopackage and choose parameter then having 2 row data. Transformation Rule. Hello Friends please suggest me at the earliest, We have a critical GL Model designed in which we have flow as below. Use SAP BW/4HANA Business Content delivers this field-based DataStore Object (advanced) as a first persistence layer of data replicated into a SAP BW/4HANA data warehouse. About the 0FI_AP_4 / 0FI_AP_30 Datasources . This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). I added custom fields to the standard data source 0FI_GL_10. Go to the update tab and select Initialize the delta process. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. before creating report, I did initial level of data validation 0FI_GL_10 data with SAP provided GL summary Tcode FS10N data. 0FI_GL_10 Delta Load Issues. It doesnot impact the currently configured datasources and their data. RSS Feed. Enter the InfoPackage description, select the Data Source and click Save. 0. I GOTO. With Simple Finance, ACDOCA table will be the primary table. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. Purpose. FI - Asset Accounting: 13 : 0CCMS_MTE_TDEP_MASTER_DATAThis DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). 0FI_AP_1 : Vendors: Transaction figures. However there has been a migration of the FAGL table to FMGL table. Hi all, Does anybody know the difference between General Ledger DS 0FI_GL_10 and 0FI_GL_20? Both used to extract new GL line items. Cost center values are missing for some of the G/L account in FAGLFLEXT table while it is appearing in the BSEG and FAGLFLEXA tables. For more information, see SAP Note 1523670. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. RJ 012, , KBA , BW-BCT-FI , BW only - Financial Accounting , BW-BCT-CO-PC , BW only - Product Cost Controlling , ProblemFI_GL_10 Datasource enhancement from FAGLFLEXT. Currently we have ECC 5. 1. Yes, you can use the GL_11 datasource in place of GL_10. The 0FI_GL_10 datasource contains data from the Leading Ledger. Implementing generic extractor is not a. I would recommend you to reload the data once for the missing periods and then make sure that you. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. Hi all, Does anybody know the difference between General Ledger DS 0FI_GL_10 and 0FI_GL_20? Both used to extract new GL line items. Version Date Description 1. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. All line items in fbl3n can be reported. So we enhanced it (using append structure populated in CMOD). ADD. Non-leading ledgers can be created as per the local accounting rules in your country/region. You therefore cannot test the function module using the test environment. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). ". Let me know if you have any questions. Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. It contains the complete history of the loaded data. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. The note 2341038 says that we can use the new 0FI_ACDOCA_10/20 datasources and even though we don't have any BI content for them, we can just remap the 0F_GL_10/14 BI content to use these new ACDOCA datasources instead.