6 million records – 100 mins (0FI_GL_14 7. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. Data source setup table filling. A myth about 0FI_GL_10 Datasource. I'm using the datasource 0FI_GL_12, it brings me the debit and credit value good, but the balance (Accumulated balance) is on zero. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. As soon as DataSource 0FI_GL_4 is loaded, it is the leading DataSource with regard to the time limits – such as maximum time (CPU date) –. We applied several SAP notes: 1. This table covers field in General Ledger Accounting (FI-GL), Asset Accounting (FI-AA), Profitability Analysis (CO-PA) and the Material Ledger (CO-PC-ACT). 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. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. Date Time Message text. 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. Missing document using 0FI_ACDOCA_10. Search for additional results. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. 0)0FI_GL_10 Datasource. 0 and BW 3. RSS Feed. For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. 10 characters required. Join. 0fi Gl 10 Base Tables Tables Most important Database Tables for 0fi Gl 10 Base Tables # TABLE Description Application Table Type; 1 : MARA: General Material Data Logistics - Material Master: Transparent Table 2 : BSEG: Accounting Document Segment FI - Financial Accounting: Cluster Table 3 : KOMP:Dear Experts, I am working on the Fund Flow Report. December 2, 2015 at 10:57 am. 0FISCPER Fiscal year / period. Examples of such DataSources include 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 0EC_PCA_1, 0EC_PCA_3, 0FI_GL_4, 0APO_LPROD_ATTR, etc. 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. Description of Field in Extract Structuree. Hi Shehzad, 0FI_GL_10 and GL_4 is used for leading ledger. Also if you have not yet migrated the transfer and update rules to Transformations, you need to do that, and then create DTP to load the data from PSA to the Cube. 0. 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 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 ). Yes, the table is really huge and. FL819. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. Use. Fields of Origin in the Extraction Structure - Accounts Receivable: Line Items. based on basic cube 0FIGL_C10. FI-GL: GL - Line Items (0FI_GL_4) FI-GL: General. Delta is capturing additional record which were already capture in init . For Datasource 0FI_GL_12, Full load/Initial load extracts all versions of data: 1. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. The process chain now is running every minute. Fields like that (and a lot more) are only in 14. Symptom. Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. If the CALLER is the first system, perform the. This increase in performance compared to a full data extraction on the same ODP datasource is due to. I've searched the forum and read this. 0 (=> SAP ERP 6. * For more information about source system IDs, see SAP. For more information, see SAP Note 1523670. When i am checking my ECC Report with BW report, Some fields are showing wrong values, for this reason, i reconciled the ECC Report and BW PSA (0FI_GL_10 ), for one combination, i. Worked extensively in the Finance - Accounts Payable (FI-AP) -. The symptom materializes in d The note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. 0fi_gl_10. Check table FAGL_ACTIVEC for the NewGL flag. 0fi Gl 10 Tables. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. Questions: Based on above. In this case use FM EXIT_SAPLRSAP_001 as template. Delta Update. 4. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. 2) Run Delta infopackage to get rsa7 records. - 0FI_GL_10. About this page This is a preview of a SAP. 0, version for SAP HANA. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. Dear All, For FI related below data sources i want to do full upload. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. Records loaded into PSA = 900. Check that in RSA7. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with TSV_TNEW_PAGE_ALLOC_FAILED dump. Generated totals records DataSource 3FI_GL_xx_TT (xx = ledger) or 0FI_GL_10 does not extract any data in delta mode. that is not extracing the data completly in the psa itself. It is working fine at DEV, However after transport to QA, the custom fields are missing in the ROOSFIELD table at QA. 2013 01:05:28 Job started 0FI_GL_10 and FAGLFLEXT - Key Fields. However we do not see anything flowing into the. InfoProvider for actuals data. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. My explanation in this blog is focusing on transfering data with ODP to another system. line items respectively. I using 0FI_GL_10 and load data to DSO in BW. ADDD. Message no. Transfer struct. 0FI_GL_14. Values in R/3 FI tcode and RSA3 are matching but not in BW Infoproviders. DataStore Object (advanced): CM S/4 FI: GL. 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. As soon as DataSource 0FI_GL_4 has been loaded, it is the leading DataSource with regard to accruals, such as the time and date (CPU date) by which extraction should be carried out. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. For more information, see SAP. Step-4: Creating function modules for each extractor enhancement. The steps is following, 1. 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. About this page This is a preview of a SAP Knowledge Base Article. :) Please help us on the below issue as it seems to be ITSP migration ( BW - HANA) issue so that is the reason unable to activate the Datasource from the F50 . Examples of such DataSources include 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 0EC_PCA_1, 0EC_PCA_3, 0FI_GL_4, 0APO_LPROD_ATTR, etc. 6 or higher. Follow. 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. Technical name: 0FI_GL_4 . Skip to Content. Line items can be requested in the general ledger view and in the entry view. 0FI_GL_10 ( Data Source )Relevancy Factor: 1. 1 Document History The following table provides an overview of the most important changes to this document. Could someone help me understand delta mechanism for 0fi_gl_14?. The engine can be expected to use more engine oil. Dates are expressed in the format YYYYMMM. Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. 0FI_GL_10 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. Sine 0FI_GL_10 is a totals extractor for balances, you can use 0FI_ACDOCA_20 based on notes: 2341038 - Usage of datasources 0FI_ACDOCA_10 and 0FI_ACDOCA_20 in sFIN / S4HANA -- you can find the field mapping. I am trying to pull GL data (for consolidation)from ECC to BW (using 0FI_GL_10) and then intend pull to BPC Model via data manager package. Functional Area. 3. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. I m using 2 data sources : <b>0FI_GL_10</b> to load into ODS 0FIGL_O10 and the second datasource <b>0FI_GL_4</b> to load into ODS 0FIGL_O02. 1. 0FI_AP_1 : Vendors: Transaction figures. And then you need to replicate it to BI. I have made an enhancement to extractor 0FI_gl_4 using EXIT_SAPLRSAP_001 and FUNCTION ZXRSAU01 in our DEV Client. DS 0FI_GL_10 -- iNFOSOURCE 0FI_GL_10 - DSO Write optimized. I try with the old data source 0FI_GL_10 and it works just fine, it brings me the cumulative balance good, but I'm using the standard business content for hana. e FLAGFLEXT. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. Application: FI - General Ledger Accounting. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. In step two, all logically dependent records of these records (for example, the credit record. but Cumulative balance of 0FI_GL_10 extractor is not matching with. About the 0FI_GL_10 / 0FI_GL_20 Datasources . Delta is capturing additional record which were already capture in init . KDGRP to FSV Report. 0FIS_GL_LINEITEM. 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. Never run an engine at a constant engine speed for long periods during the running-in period. Search for additional results. 0FI_AP_3 : Vendors: Line Items. We have used sap standard data source and DSO for the data extraction. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. If no data inbound layer. 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). 10: 0FI_GL_2: General ledger: Transaction figures - Cost of sales ledger : 11: 0FI_GL_8: General Ledger: Statistical Key Figures : 12: 0FI_GL_7: General Ledger Cost. causes changes to be made to the line items in the FAGLFLEXA table, which are not reflected in BSEG (by design), but are also not captured. 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). It was formed. The new solution is based on new extractors that are available with Plug-In Release PI2003. . More Information. These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. 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. Do we need access key to enhance the structure ? Are there any other suggestions. Version Date Description 1. (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. Procedure. 0FI_GL_10 General Ledger: Leading Ledger Balances 0FI_GL_10 is a delta-enabled Data Source that extracts the general ledger balances for only the defined 'leading ledger' in your source system. SAP enhancement package 6 for SAP ERP 6. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. 1st loading scenario: This is the sm37 of ECC6. tcode to generate data. CURTYPE=10 Local Currency CURTYPE=00 Transaction Currency Dates are expressed in the format YYYYMMM In ERP the number of fiscal periods per year is configurableI'm using the datasource 0FI_GL_12, it brings me the debit and credit value good, but the balance (Accumulated balance) is on zero. Procedure. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). Click more to access the full. HSL16, KSL01. Hello Friends please suggest me at the earliest, We have a critical GL Model designed in which we have flow as below. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. 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. I am validating few gl accounts values related to 0FI_GL_10 both in R/3 and BW. 0 more than a year back but then we stopped doing any delta loads from the datasource. In ERP the number of fiscal periods per year is configurable. Its a one time process for GL , we will not set separately for all the GL data sources. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. The Extractor Connector contains two different options. . the activation throws up these errors. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 668 Views. From the transition of the data requirements in Delta-Init-Modus to Delta operation therefore, the data requirement in Delta mode 0FI_GL_4 should take place first. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. Table contains 16fields(HSL01. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. Visit SAP Support Portal's SAP Notes and KBA Search. Description: General Ledger: Leading Ledger Balances. 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. And now the FAGLFLEXT is no longer populated with any FI. </u>From SAP BW - There is one data-source 0FI_GL_4 is not been activated. As soon as DataSource 0FI_GL_4 is loaded, it is the leading DataSource with regard to the time limits – such as maximum time (CPU date) – up to which data. e. Hello, we are in a process of implementing 0FI_GL_10. FI-GL: New GL - Balances - /IMO/D_FIGL12. For all other ledgers, you have to create separate DataSources . 0COMP_CODE Company code. 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. Timestamp Tables. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. The extraction procedure delivered with the business content for SAP BW 1. Diagnosis An error occurred in the source system. Purpose. <u>Now, I dont get the delta. Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor:. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). However we do not see anything flowing into the delta queue in RSA7. I am using the FI data source 0FI_GL_10. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. . 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. what would be the logic if i want to populate values of cost center in the faglflext table from BSEG or FAGLFLEXA table. 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. " 0FI_GL_8 General Ledger: Statistical Key Figures". Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. Monitor the extraction. Performance enhancements might be available for data extraction. We have a P&L Report implemented in SAP BI and data is coming from 0FI_GL_10 datasource. Any standard procedure or we need to follow cmid code to append the extract structure?Fields of Origin in the Extraction Structure of 0CO_OM_CCA_4. As mentioned by Parth, the above 2 datasources are for new gl. For a certain GL Account values from R3 don't match BW. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. 2. Any particular reason for that? So If I want line item reporting my best solution will be RRI? Correct!! Question2: SAP recommended dataflow for new GL uses virtual cube 0FIGL_V10. Version Date Description 1. Functional Area. (ie posting date). A myth about 0FI_GL_10 Datasource. In ECC while Reconciling Data in FS10N and table FAGLFLEXT I found Difference in Monthly Data for a specific account in 2013 and remaining entire Data is Matching for other periods. Even though there were no data in RSA7, I tried to run Delta Infopackage but I didn't get any records in that. Issues loading 0FIGL_C10. About this page This is a preview of a SAP Knowledge Base Article. The data source 0FI_GL_10 for the extraction of r/3 accounts can be used in the same way with s/4 HANA? Us would help a lot if someone could provide us with practical information about how to define BW extractors to s/4, for. Let me know if you have any questions. So questions as below. During the last 10 hours the periods of running at WOT can be increased to 5-10 minutes at a time. Table BKPF shows the same timestamp. Symptom In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. It contains all the totals records (transaction figures) from new General Ledger Accounting that were uploaded from the connected source system (s) using the InfoSource General Ledger (New): Transaction Figures . Yes, you can use the GL_11 datasource in place of GL_10. We were doing delta loads using this datasource when BW was on 7. So we enhanced it (using append structure populated in CMOD). ) Now, for that same particular combination (in DSO Active Table) some records are missing. Check if New GL is activated in ECC. 0FI_AP_20 : Vendor Balances. Datasource is not having WBS Field. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. To enter a delta dataset, you can use any of the following InfoSources (with the corresponding DataSources and extractors in SAP R/3): Component. Bw Delta Pointer For Delta Tables. I've searched the forum and read this "0FI_GL_10 enhancement" post. I am trying to create transfer rules for one of the datasource '0FI_GL_10'. 1 Answer Sort by: Best Answer Vote up 0 Vote down SAP Support Feb 09, 2023 at 03:59 AM Sine 0FI_GL_10 is a totals extractor for balances, you can use. 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. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). . -- Cube 0FIGL_C10. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. About this page This is a preview of a SAP Knowledge Base Article. Extractor Tables. [Enter your Keywords here. CURTYPE=10 Local Currency. Financial Statements are based on 0FI_GL_10 i. 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. 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. 01. the extracted no of records may not. 1 Document History The following table provides an overview of the most important changes to this document. From the OBJNR of the totals record (places 3-6 of the object number) From the OBJNR of the totals record (places 7-16 of the object number) From the OBJNR of the totals record (places 17-24 of the object number) Whether SSME or SSMED is filled depends on the category of the. The following BI Content objects are available:0FI_GL_14: General Ledger (New): Line Items Leading Ledger: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 0FI_AP_4: Vendors: Line Items with Delta Extrcation:After going through the help document I understood that the BI 7 version came up with General Ledger Accounting (New), If this is true then can we still use 0FI_GL_04 in Ecc and BI7. FAGLFLEXT table for end of period balances. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. Extract structure OLTP: DTFIGL_4. You may choose to manage your own preferences. Does it contain extra fu. 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. Data Source 0FI_GL_4 , will satisfy this requirement. 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. 3. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. If the custom fields available in the std table, at least I can update the property of these. When we extracted . In the following table only the fields BIUKRS and FISCPER are filterable: Field in Extract Structure. We can do the same reconciliation steps for the line item level data using the table FAGLFLEXA which is used by the DS 0FI_GL_14,however is should match with the totals tables and since the volume of the posting would be more for an account, total table level reconciliation is suffice. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. I know nothing about 0figl12. This is for the DS – 0FI_GL_10. There are lot of sap notes available for this strange behavior and its corrections. till that everything did well. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. In S/4 HANA there many changes in GL master compare to ECC environment. InfoSource 0FI_GL_4 transfers only. This InfoSource is based on DataSource 0FI_GL_14. The DataSources can then be used independently of one another (see note 551044). We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. 0. We have the requirement with the data from tables BSEG and BKPF Tables. Generally-used fields are as follows:Transformation. 0FI_TAX_4. About this page This is a preview of a SAP Knowledge Base Article. Can you please tell me the how to do this . 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). 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). 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. The 0FI_GL_10 datasource contains data from the Leading Ledger. As. b) Now this is for extractor 2LIS_13_VITM , here RSA3 is showing correct number of records. 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals) 0FI_GL_14 --> 0FIGL_O14 (for Line item) Question1: The DSO 0FIGL_O14 does not feed the cube. 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. Click more to access the full version on SAP for Me (Login required). This is applicable for the following data sources. 1. Delta extraction 0FI_GL_10 VERY SLOW. CURTYPE=00 Transaction Currency. 2) All key figures 0BALANCE,0DEBIT and 0CREDIT in DSO(0FIGL_O10) has the transformations with summation in Aggregation not overwrite. Here are the 25 most used bw_datasources in SAP Bw datasource Description Functional Area 2LIS_03_BF Goods Movements From Inventory MM - Materials Management Management 2LIS_02_ITM Purchasing. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. 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. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. Please help. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. I test it on rsa3 tx and the balance value is zero. You may choose to manage your own preferences. 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. x DS)). 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. The 0FI_GL_20 datasource contains data from all ledgers. 07. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with. For FI AP - I have replicated the following datasources . This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. The data records are read from table ACDOCA. Load : Init delta load. I had activated the DS 0FI_GL_10 in source system and when i check in RSA3 it does not fetch any reocrds ( 0 Records) When i see the Table of origin FAGLFLEXT it also has 0 entries. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. . It is used as a source for reconstructions without the need to access the sources again. 1) first delta init load to PSA (yesterday 08:00 pm) 2) delta load to PSA (today 09:30 am) 3) full load to PSA (tThe 0FI_GL_10 datasource contains data from the Leading Ledger. 0 SP 18). With New G/L in SAP ECC 6. Which view is applied depends on the. As it is CDC enabled, I cant load it in pieces as the Full load needs to be completed for Delta queue initialization. Index on FAGLFLEXT. I create some GL documents in the source system. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. This InfoSource is based on DataSource 0FI_GL_12. Datasource 0FI_GL_4 (GL: Line items), Master Data Attribute, Custom Datasource with delta type E (PULL)]: As this is a ‘PULL’ delta-type, the delta data records are determined during the delta update by the Datasource extractor, updated to the ODQ, and passed on to the SAP BW directly from there. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. This data source extracts data records for universal journal entries. Implementing generic extractor is not a. Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. I have loaded 0FI_GL_10, 0FI_AR_4 and 0FI_AP_4 Init load on before two days, today I was checking in RSA7 (BW Delta Queue) where I didn't found any delta records while there are records created on both days in ECC system. Extractor: BWFID_GET_FIGL_ITEM. Data. actually i loaded the data to ods & infocube by using of reinitialization bcoz of delta failed. Due to which our deltas did not bring any records to the BW system. The balance should be changed. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. We have intilzed the delta one year back and we are pulling delta records to BW. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. Click more to access the full version on SAP for Me (Login required). Now we have following system configurations. CURTYPE=10 Local Currency CURTYPE=00 Transaction Currency Dates are expressed in the format YYYYMMM In ERP the number of fiscal periods per year is configurable. Data source setup table filling. This table covers field in General Ledger Accounting (FI-GL), Asset Accounting (FI-AA), Profitability Analysis (CO-PA) and the Material Ledger (CO-PC-ACT). We are BW4HANA system. what are the application components we have to use fill the setup table. But there are few considerations to this. Related content. We are using the ODP mechanism for data extraction from S4. It is available only with a minimal version of ECC (ECC 6. (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:Oct 10, 2007 at 03:48 PM FAGLFLEXT vs. So if you want data for Non leading ledger , you will have to implement 3FI_GL_xx_SI, and 3FI_GL_xx_TT as required. . DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. But its picking the sales document type ZX. Visit SAP Support Portal's SAP Notes and KBA Search. In order to work with 0FI_ACDOCA_10 you have to setup a DSO with overwrite mode (to process also document changes, clearings and reversals correctly) with the key fields as shown below. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10).