"1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. The ALV display doesn't show technical. We are BW4HANA system. 1505 Views. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. Delta Process for Data Source 0FI_GL_10 . DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. 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 ). Enhancement for 0FI_GL_10 (or similar) my FI functional team added an append to the FMGLFLEXT table with fields FISTL and FIPOS to better detail the information there. System Response Caller. Delta Tables. I have analysed looking to all existing to obtain as attribute but none of the field is not having WBS Maintain as attribute to it. This InfoSource is based on DataSource 0FI_GL_12. based on basic cube 0FIGL_C10. All planned Versions <> 001 However during Delta load it extracts only actual data (Version = '001') but no planned versio. 0fi Gl 10 Tables. It is available only with a minimal version of ECC (ECC 6. 1st loading scenario: This is the sm37 of ECC6. Use corresponding exit FM as template and copy the import, Export, Table, Exception. 1. 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. 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. 0FI_AA_11 Transactions and annual values; 0FI_AA_12 Posted depreciation (period values) The correct load sequence is checked by the extraction routines!. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated) 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated. InfoSource 0FI_GL_4. The Field COST_ELEM is there in extract structure FAGL_EXTSTRUCT_LEAD. Follow. I've searched the forum and read this. We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. Functional Area. Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. 09. 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. 2. Untill and unless this checkbox is ticked, you will not be able to see that field in RSA3. And now the FAGLFLEXT is no longer. Below are the details of the FSV. 4 on HANA or if we use the new extractors. sap. our ECC system is on ERP on HANA with Simple Finance add-on. 0A (BW PlugIn 2001. *Let some posting get completed on ECC side only then we are able to see records in RSA7. DataStore Objects. based on basic cube 0FIGL_C10. 0FI_GL_10 vs. 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. sap. InfoSources. Thanks, Manjunath. Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. Bw Delta Pointer For Delta Tables. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. 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). Please see picture for reference. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). FI-TX. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. With New G/L in SAP ECC 6. 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. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. . We also have Line Item. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC. line items respectively. And then you need to replicate it to BI. Trying to activate nut could not be activate due to the an issue ? Urgent help required. The partner fields that are relevant for consolidation are not updated in the InfoProvider 0FI_GL_10 and, therefore, you cannot use it as the "staging" InfoProvider for SEM-BCS. ODQ Tables. IDoc (Intermediate Document) is a standard SAP document format. Part II – Post-Upgrade Checks, Repairs and Activities0FI_GL_4 General Ledger: Line items (only if used) 0ASSET_ATTR_TEXT Asset master data; 0ASSET_AFAB Asset depreciation parameters; And then the transaction data. Relevancy Factor: 1. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. About this page This is a preview of a SAP Knowledge Base Article. I test it on rsa3 tx and the balance value is zero. VALUETYPE = 20) then it will be available in 0FI_ACDOCA_20 extractor). Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10(Actual Data). The structure gets. We are doing an RRI from the Financial Statements to the GL Line Items. 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. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. December 2, 2015 at 10:57 am. A myth about 0FI_GL_10 Datasource. 2. (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. 2069 Views. Reports can be based on any value type that is recorded in the source. Date Time Message text. We have intilzed the delta one year back and we are. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. But when I compare values from the PSA to the DSO, some values are missing. General ledger: Data for taxes on sales and purchases. Load : Init delta load. Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. Financial Statements are based on 0FI_GL_10 i. 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). Production – 74% performance improvement (1. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. 3. Search for additional results. This InfoSource is based on DataSource 0FI_GL_14. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. 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. Join. but that field not visible at RSA6,Extractor 0FI_GL_10 pulls data from table FAGLFLEXT. Never run an engine at a constant engine speed for long periods during the running-in period. 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. 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. About the 0FI_AP_4 / 0FI_AP_30 Datasources . Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). Use corresponding exit FM as template and copy the import, Export, Table, Exception. Let us say "RMVCT - Transaction Type" is available in the datasource but missing in the transfer rules. In this case use FM EXIT_SAPLRSAP_001 as template. All other ledgers, again if required, would require separate DataSources be created for each ledger. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. InfoProvider for BPC planning dataThis is the third part of the 3 part blog series – Part I – Reading List and Pre-Upgrade Checks & Activities. 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. The symptom. what are the application components we have to use fill the setup table. 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. In ERP the number of fiscal periods per year is configurable. 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. S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. 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). " 0FI_GL_8 General Ledger: Statistical Key Figures". Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor:. ADDD. (ie posting date). KDGRP to FSV Report. Source System of BW system. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. 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. Actual data : Version = '001' 2. . Delta is capturing additional record which were already capture in init . Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor: 1. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. 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 of Sales Ledger via Delta Extraction : 13: 0FI_GL_21: G/L Accounts: Balances : 14: 0ACE_CALC_RESULT: Accrual Engine: Calculated Accrual Values : 15:ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . There are two fields in 0FI_GL_10 namely RTCUR and CURRUNIT and both get the data for all currencies but we want to see the data in BW for only one currency ie USD. It contains the complete history of the loaded data. SQL cod The following error may also. 0FISCPER Fiscal year / period. ". Check if New GL is activated in ECC. This datasource after init with data transfer, Delta bringing wrong values . Symptom In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. 6. 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). 0 PSA is bringing less number of records when compared to the records in RSA3 extract checker. Extractors only exist for the source system from R/3 Release 4. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. CURTYPE=10 Local Currency. Message no. Data source setup table filling. I using 0FI_GL_10 and load data to DSO in BW. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. Please suggest. The DataSources can then be used independently of one another (see note 551044). I know nothing about 0figl12. Version Date Description 1. 3. Fields like that (and a lot more) are only in 14. InfoSources. In ECC, when asked functional folks, we got the inputs saying we need to use Group Currency field, which is KSL ( from FAGLFLEXT table ) . 2. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. 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. We have changed also the SMQS qRFC monitor with RFC destination to None. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. the activation throws up these errors. Enhancement issue with 0FI_GL_10. This question is for New GL. Below are the details of the FSV. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. RSA6->SELECT THE DATASOURCE 0FI_GL_10 >CHANGE DS ->datasource customer version display-- ->SELECTION -->RLDNR(LEDGER IN GENERAL LEDGER ACCOUNTING) AFTER THIS I M NOT. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . Glenlyon Norfolk School (GNS) is an independent, co-ed, university preparatory day school in Victoria and Oak Bay, British Columbia, Canada. Screen from ROOSOURCE table for. About the 0FI_AP_4 / 0FI_AP_30 Datasources . Chart of Account Section and b. 0) into BI 7. Performance enhancements might be available for data extraction. 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. 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. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). Generated totals records DataSource 3FI_GL_xx_TT (xx = ledger) or 0FI_GL_10 does not extract any data in delta mode. DataStore object: /IMO/FIGL_D12. As. Does it contain extra fu. System must add buffer to timestamp because of the document saving time consuming. Please find an example setup of the InfoProvider for the actuals data below. Please provide the code. 07. The DSO enables flow reporting for defined periods. b) Now this is for extractor 2LIS_13_VITM , here RSA3 is showing correct number of records. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. We have used sap standard data source and DSO for the data extraction. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. 0FI_GL_10 Delta Load Issues. I have activated datasource 0FI_GL_10 for leading ledger, additionally generic extractors 3_* for the non-leading ledgers. Search for additional results. In this cases we are exposing a DataSource with direct access on tables. The problem is that when we extract INIT load. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. [not with the procedure, but with what info-object can be mapped to which dimension]Note 1012874 – FAQ extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 10) Note 411758 – Extracting noted item; 2. DataStore object: /IMO/FIGL_D04. 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. About the 0FI_GL_10 / 0FI_GL_20 Datasources . Now if i trigger delta IP then it is failing with source system erroiam having fi gl data source named as 0FI_GL_10 . This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. InfoSource. As it is CDC enabled, I cant load it in pieces as the Full load needs to be completed for Delta queue initialization. We have intilzed the delta one year back and we are pulling delta records to BW. Table of Origin. Questions: Based on above. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. 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 Data (Item Level) MM - Materials Management 2LIS_03_BX Stock Initialization for Inventory MM - Materials Management Management 2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution 0FI_GL_4. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. 0fi_gl_14 it is allowed. So I went the other route - I went to source system in RSA5 and activated it. We have the requirement with the data from tables BSEG and BKPF Tables. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. As per OSS note 2341038, I was trying to understand how to remap the 0FI_GL_ extractors like 0FL_GL_10/14 . For more information, see SAP Note 1523670. About the 0FI_AR_4 / 0FI_AR_30 Datasource . This DataSource is delta-compatible. I also checked for 0FI_GL_10 and 14 but both are not pulling all the values from this table. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. I have gone through certain threads and found out that we will have to generate our own data source for any other ledger. 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. It successfully extracted data. 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 ). We are on ECC 5. InfoProvider for actuals data. DS 0FI_GL_10 -- iNFOSOURCE 0FI_GL_10 - DSO Write optimized. SAP enhancement package 6 for SAP ERP 6. Uso 0FI_GL_10 o el 0FI_GL_14. For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. actually i loaded the data to ods & infocube by using of reinitialization bcoz of delta failed. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. 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). KDGRP to FSV Report. Line Items of the Leading Ledger. This CDS view provides access to all details of a G/L account line item including the most important business entities, such as G/L account, company code, cost center or profit center (without the ledger). The fields in the datasource are more than the 16 allowed keys in the DSO,. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. We know that New GL data stores in FAGLFLEXT table. All is standard. This should work. 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. 1), BW offers consistent data extraction to the BW system in the Delta update procedure for line items from General Ledger Accounting (FI-GL), Accounts Receivable Accounting and Accounts Payable Accounting (FI-AP). 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). Sub Modules. I am trying to create transfer rules for one of the datasource '0FI_GL_10'. 1st loading scenario: This is the sm37 of ECC6. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a key field. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. ADJ. Which view is applied depends on the. GL is created initially for Chart of Account section and further extension is done to different company codes on need basis. Looking in the table. Is it reuire to create the statistics. About this page This is a preview of a SAP Knowledge Base Article. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. (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. General ledger: Data for taxes on sales and purchases. In particular, the. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. Mainly applicable for Expense line items (P&L line items). doc no and doc pos can be used. (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. Click more to access the full version on SAP for Me (Login required). DataStore Objects. 0FI_GL_10 vs. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. Delta extraction 0FI_GL_10 VERY SLOW. With Simple Finance, ACDOCA table will be the primary table. For example, a document was posted at 10:25 in the morning. DataStore Object (advanced): CM S/4 FI: GL. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. Hello Experts, Delta load for the datasource 0FI_GL_10 is failing with the following error. Delta is capturing additional record which were already capture in init . Search for additional results. 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. 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. 4. Version 0008 of DataSource 0fi_gl_4 - 10 /BIC/CCWA0FI_GL_4: Transfer struct. SAP enhancement package 6 for SAP ERP 6. Perhaps there are delta records which makes the difference between RSA3 and BW cube. Debit postings are Tally but credit postings are. 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. 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. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. . I planned for generic with time stamp by creating the view, but. 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. Description of Field in Extract Structuree. 1 million records in 56 mins to PSA and extracted 2 million records in 62 mins to PSA post-HANA DB upgrade. 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. Thank You AdvanceDataStore object (advanced): FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/CMFIGL06. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. DetaInit Simulation = 1 supported. Symptom. The data records are read from table ACDOCA. The safety parameter will take care of the delta loads for all the FI data sources. With New G/L in SAP ECC 6. About this page This is a preview of a SAP Knowledge Base Article. 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. Enhancement issue with 0FI_GL_10. Even though there were no data in RSA7, I tried to run Delta Infopackage but I didn't get any records in that. There is not a single field is hidden in 0FI_GL_10 DS. 3. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 12. Please share with me your suggestion or view. 0FI_GL_10 for Balance Sheet reporting. Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. 0 (=> SAP ERP 6. 0VERSION Version. 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 ). However, the key field Ref. Introduction: This blog guides us through on how to Optimize the performance for FI Related Standard Datasources – 0FI_GL_10 & 0CO_OM_OPA_6. Timestamp Tables. Transfer struct. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no. FI-TX. Follow. 1. Data. 2) In the customer exit used for the first system, I have to write some code to check the CALLER system. The ODQ uses the following three tables to store data: 1. We have migrated classical/old GL to the new GL. Diagnosis. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. This data source extracts data records for universal journal entries. Based on DataSource: 0FI_GL_4. I've checked Datasource in R3 (RSA3) and it matches the R3 reports and the PSA. You can also use the DataSources 0FI_AR_4, 0FI_AP_4, and 0FI_TX_4 separately without 0FI_GL_4. CURTYPE=00 Transaction Currency. Extract structure OLTP: DTFIGL_4. 0FI_GL_10 ( Data Source )Relevancy Factor: 1. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. Yes. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. Please let me know how we can achieve this . Standard Approach: Normally in the general practices the extract. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 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. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats (0UC SALES STATS 02) and Mass Extraction Activity for FI-CA: BP Items, Payments and Payments Lot, Promise to Pay, Installment Plans, Settlement Documents, Returns and Checks. 0 system and we have 0FI_GL_10 extractor providing us the reports based on P&L and Balance Sheet. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). All other ledgers, again if required, would require separate DataSources be created for each ledger. Technical name: 0FI_GL_4 . Unfortunately this standard content delivered datasource ( source system- ECC 6. My explanation in this blog is focusing on transfering data with ODP to another system. Technical name: 0FI_GL_10 Technical Data Prerequisites In the OLTP system, you have activated new General Ledger Accounting in Customizing for Financial Accounting under Financial Accounting Global Settings. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. So we enhanced it (using append structure populated in CMOD). I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). the extracted no of records may not. Now my problem is the field BLART is not picking the exact document type, I mean am loading the data of 0fi_gl_10 to see the collections, and the document type for collections is XX or YY or ZZ . Search for additional results. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. 0, version for SAP HANA. In step two, all logically dependent records of these records (for example, the credit record. 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. Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10 | SAP Blogs Relevancy Factor: 2. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. In step two, all logically dependent records of these records (for example, the credit record. 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. I tried to find these new extractors in the BI content but couldn't find it. Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). For Datasource 0FI_GL_12, Full load/Initial load extracts all versions of data: 1. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. 2LIS_03_UM: Revaluations MM - Materials Management: 10. Page Not Found | SAP Help Portal. 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. For this I enhanced the 0fi_gl_10 DS and checked the data but its showing wrong document types. KSL16, TSL01. 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. . Drill Down in P&L Report. ACDOCA, mismatch,. The missing key was 'Business Transaction' and it did the trick for us.