0. The performance of 0FI_GL_40 extraction is not good. Run the delta DTP to update DSO 0FIGL_14. Now i need to read non-leading ledgers. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). Use. mygns . FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. General Ledger: Cost of Sales Ledger Using Delta Extraction. SAP R/3; SAP R/3 Enterprise; SAP ERP; SAP ERP Central Component; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANAHi Experts, I want to buld report which is similar to ecc report fbl3n. we couldn't see the same at cube level. Which view is applied depends on the. 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. 0FL_GI_14 is a delta-enabled DataSource that extracts the general ledger line items for only one ledger, the one that's defined as the 'leading ledger' in your source system. Record mode for 0FI_GL_14. Request loaded from 0FI_GL_14 is highlighted. Step 2: Create a Class and Method in SE18/19 – GUI. 317 Views. " =09 Dear all=20 I am using 0FI_GL_4 DataSource. Performance enhancements might be available for data extraction. For more information, see SAP Note 1523670. When we extract the data based on just Company Code, Fiscal Year, Posting Period and Ledger, it fails to extract data simply because this selection criteria doesn't use any Table. For more information, see SAP Notes 1476708 and 1531175 . 0FL_GI_14 is a delta-enabled DataSource that extracts the general ledger line items for only one ledger, the one that's defined as the 'leading ledger' in your source system. I activated 0FI_GL_10 DataSource and its working fine. Use. Our understanding is we can go with eithere. The datasource extracts PS_POSID for a document. In routine function module RSKC_CHAVL_CHECK is used. This InfoSource is based on DataSource 0FI_GL_14. About the 0CO_OM_ABC_2 Datasource . In Extractor, it just updated in the same document. 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. Datasource 0FI_GL_4 (GL: Line items) 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. FAGLFLEXT where as 0FI_GL_14 is used to fetch Line item table info i. I am having problems appending the newly installed extractor 0FI_GL_14 (General Ledger Accounting (New): Line Items of the Leading Ledger). To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. x DS)). I would like to create data source YFI_GL_14 that is a exact copy of standard data source 0FI_Gl_14. Hi experts. Can anyone suggest, is it enough if we just add MATNR to the structure. Transformation. 0FI_GL_4 – General ledger: Line Items; 0FI_AP_4 – Accounts payable: Line Items;. As per my understanding 0FI_GL-_14 & 0FI_GL_10 & 0FI_GL_20 are the new data sources that come in to picture after new GL. Data sources – 0FI_AP_6, 0FI_AR_6, 0FI_GL_6, 0FI_AP_7, 0FI_AR_7, 0FI_GL_7, which are transaction figures extractors, use this table for managing delta records. I want to use to the business content extractor - '0FI_GL_14' - General Ledger Accounting (New): Line Items of the Leading Ledger to load data into the DSO - 0FIGL_O14. I have to fetch balance brought forward for the combination for comp code 5110 , vendor 5114 and fiscper 012. Please provide the code. Object Type. General Ledger , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , Problem . The. The following CDS views have now been released: CDS Views for Master Data. Thanks. Please suggest. Description: General Ledger: Leading Ledger Balances. Visit SAP Support Portal's SAP Notes and KBA Search. 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. Write a Blog Post Close; Categories. I think for document 100000012, the FAGLFLEXA-DRCRK should be 'H-Credit' , because in BSEG-SHKZG is 'H' and there is no ‘X’ in BSEG-XNEGP field. (MATNR). 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. It updates the data to DSO 0FI_GL_O14. About this page This is a preview of a SAP Knowledge Base Article. BI-CONT - 7. 6 million records – 61 mins (0FI_GL_14 ODP) / 100 mins (0FI_GL_14 7. 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. is there any note or any. 1、使用rsa7查看增量队列时，确实可以看到财务数据源：0fi_gl_4, 0fi_gl_6, 2、总账凭证过账后，立即进行数据抽取， 0fi_gl_4并不能立刻抽取到数据，而 0fi_gl_6 立刻就可以抽取到最新数据， 这是怎么回事呢？ 或者我哪里理解错了？Performance: ODP extraction performance benefits – for example the extraction reduction of a delta execution of the 0FI_GL_14 ODP is from 74% to 86% in PRD – (ODP—Performance-improvements-and-benefits) BI Schedule:. Now I want to add one more field as a selection field . u2022 Users need to become familiar only with the interface and functions of one application. ca. For New GL Data Sources 0FI_GL_14 , Please check safety interval from ROOSOURCE table and last delta time stamp from ROOSGENDLM table. RemoteCube Compatibility. BAdI Provider . The leading ledger is always a standard ledger. Structure Delta Update. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 0 yet. More Information. 0FI_GL_12 Extracts general ledger balances for only the leading ledger. Queries . The data records are read from table ACDOCA. Regards. Request loaded from 0FI_ACDOCA_10 are highlighted. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. I have traced the record in ECC, it is ok in both the tables FAGLFLEXA and BSEG. WBS Element (0WBS_ELEMT) comes from R/3 field PROJK. I am told that we should be using same DSO and Cube. 0. 0FI_GL_14 and 20 work fine with no settings. . 0FI_GL_14 ; 2LIS_05_Q0NOTIF; Also the Table - ROOSOURCE doesn't have the field Direct access & Real-time checked for above data sources. This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. 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. 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. Can the Extractor 0FI_GL_14 be used in ECC 6. Users already familiar with SAP. Production - 39% performance improvement (2. we found the both data sources mentioned in sap ecc but we din't find any business content related to the both. 0fi_gl_14 delta extract. I am able to see "R" images in the PSA of 2LIS_11_VAITM via ROCANCEL/RECORDMODE. The ODQ uses the following three tables to store data:It contains the complete history of the loaded data. 1505 Views. Since its Line Item data you don't need cube on that. RemoteCube-Compatible. 01) schedules a daily job for this extraction daily and it takes approximately around 12 - 16 hours for daily data load. 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). 2004. u2022 The introduction of business models now occurs within a single solution. If anybody has worked on this please let us know. As stated in the blog 0FI_*_4 data sources needs additional settings in BWOM_SETTINGS table to facililate the multiple data delta loads in a day. Hello experts, It is commonly understood that the (yellow) key fields of FAGLFLEXT must also be key fields in the DSO on the BI side, so that totals are not overwritten. I am trying to fetch FI GL data using extractor 0FI_GL_14 via BODS. For more information, see SAP Note 1523670. serves as the staging and corporate memory DSO for the DataSource General Ledger:. Grant. SAP BW Datasource : 0FI_GL_20 - G/L Accounts: Transaction Figures. 6 million records – 100 mins (0FI_GL_14 7. For New GL data sources safety limit (UL and LL) set to 3600 seconds by default. Regards. SAP Note 430303 already implemented in our SAP System. To get full information on 0FI_GL_14 data flow in BW. Similarly we have 0FI_GL_14 based on AIED (After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)). Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor. Yes, the table is really huge and. (0FI_GL_4). Structure Delta Update. 2736942-0FI_GL_14: Exception in LFAGL_ITEMS_SELECT_BWU01 for ODP data loading. We had RRI (jump targets) from totals (C10/V10) reports to custom line item report on O14. When the delta is made on 0FI_GL_14 this doc with same line item and customer gets updated with status 'O'. About this pageOnce this is done, in order to extract the customer fields in the data source 0FI_GL_10, the Customer Include CI_COBL needs to be added as an Append in the Extract structure – FAGL_EXTSTRUCT_LEAD. My client is implementing BW-BPC Consolidation, so that we already have 0FI_GL14 data source and from this we are extracting data into customized DSO, for BW-BPC Consolidation client has given KE24 Tcode and ask to enhance to 0FI_GL14 Data source. specifications is greater than the field length are not allowed. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. For more information, see SAP Notes 1476708. i am unable to find the relation between. BAdI Provider . As. After looking into this a while it seems likely it's impossible to go from the 0FI_GL_14 Transactions back to the. 财务数据使用时间戳，就是说不通过增量队列，数据由业务系统直接到达BW系统，. Search for additional results. Material Group Tables. Datasource 0FI_GL_4 (GL: Line items), Master Data Attribute, Custom Datasource with delta type E (PULL)]:DataStore object (advanced): FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/CMFIGL06. Unfortunately 0FI_GL_14 does not contain a lot of the sales fields like Material, Sales Org, Sales Office, Sales Group, Billing Type, etc. General ledger amt PSWBT CURR 23 24 PSWSL G/L currency PSWSL CUKY 5 TCURC: 25 TXBHW Original Tax Base Amount in Local Currency TXBHW CURR 23 26. Data Source This DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). 7; SAP ERP Central Component; SAP ERP; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANAAbout this page This is a preview of a SAP Knowledge Base Article. We used 0FI_GL_4 because tables GLT0 were empty in R3. 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 Values Financial Accounting: Customers:FI-AR (BSIK, BSAK. Related content. Visit. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Add a. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. Hi Naveen, if you have a BW on HANA, you can collect the dataflow before for the following DSO (no InfoCube needed): FI-GL: New GL - Line Items - /IMO/FIGL_D14 - Financial Accounting: General Ledger (SAP HANA-Optimized) - SAP Library. 6 million records – 1263 seconds (0FI_GL_14 ODP) / 1533 seconds (0FI_GL_14 7. However I would like to get data from PS_POSID field (as it stands for for instance for datasource 2LIS_11_VAITM). To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. 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. Application Component. Search for additional results. ZDSO_4 with transformations for 0FI_GL_4 from client 100 and 110. For all other ledgers, you have to. For more information, see SAP Notes 1476708. 534 Views. 1. Can you please suggest what is the option i need to. we have a requriment of extracting new gl and we are using 0fi_gl_12 and 0fi_gl_14 extractors. When I enter the extracting structure, field LIFNR is there. Visit SAP Support Portal's SAP Notes and KBA Search. Currently existing datasource is loading to DSO and then to Cube. This extractor assigns specific field attributes to the append fields. xSLnn and xSLVT. You will see full flow with all multiprovider, queries and all objects used in this flow. But then you have will have to filter what are the relevant doc types for AR. that is not extracing the data completly in the psa itself. Accounting Principle ( I_AccountingPrinciple) Accounting Principle Text ( I_AccountingPrincipleText) CDS View for Transaction Data. BW-BCT-FIGeneral Le 1392518 1 0FI_GL_14 doesn't deliver partner cost center. In the. What is SAP Recommendation to use 0FI_GL_14 (Line Item) and 0FI_GL_10(Summary). 11. sap. For performance improvements for extraction, see SAP Note 1731175. The. Reports can be based on any value type that is recorded in the source. (Shipped with BI Content Release 737/747 SP07 or. This InfoSource is based on DataSource 0FI_GL_14. What happens in 0FIAR_O03 is the doc-1100 with line item 1 and 2 are set to 'C' after delta. How to increase safety interval time setting for FIGL extractors ? Mainly 0FI_GL_14 extractor steps needed ? If we increase safety interval time from Default(1hr) to 2hrs for 0FI_GL_14 extractor what are the pros and cons ? Please suggest . In order to get the net store credit for the customer, we need to get the accounting document number with the customer number (KUNNR) first. 0fi Gl 12 Tables Database Tables in SAP (22 Tables)Hi Friends, I have gone through many threads and Blogs but did not find the exact information on Data sources 0FI_GL_14 & 0FI_GL_10 Delta mechanism. Characteristic. 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. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. Unfortunately this standard content delivered datasource ( source system- ECC 6. *_4 data sources needs additional settings in BWOM_SETTINGS table to facililate the multiple data delta loads in a day. Since Release 3. The line item extractor (0FI_GL_14) enables you to extract documents from the leading ledger in new General Ledger Accounting for BI reporting. Visit SAP Support Portal's SAP Notes and KBA Search. iam having fi gl data source named as 0FI_GL_10 . Append extractor 0FI_GL_14_APPE is used to provide the corresponding fields in BI. in which barry has suggested to write a code for populate the GKONT value. For more information, see SAP Note 1523670. 0FI_GL_14: General Ledger (New): Line Items Leading Ledger: FI - General Ledger Accounting: 0FI_GL_1: General ledger: Transaction figures: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_21: G/L Accounts: Balances:Unfortunately, the report consists of those data from a standard extractor named 0FI_GL_14 which involve with really huge SAP tables such as FAGLFLEXA. Thank-You. Version 0004 of DataSource 0fi_gl_14 - 10 /BIC/CCBA0FI_GL_14 Transfer struct. Is there a way to make the above mentioned data sources for Real-time acquisition without affecting the existing flow. 0FI_GL_14 brings in all the fi documents. 0A (BW PlugIn 2001. Your membership also includes. It seems the table RSOSFIELDMAP is missing many or most of the active. "0FI_GL_14, problem with PS_POSID - SAP Q&A"Source System of BW system; SAP R/3; SAP R/3 Enterprise; SAP ERP Central Component; SAP ERP; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANA0FI_GL_4 Enhancement from BSEG Table. ADD. Storage Type Tables. As these two fields are dependent on the same table that 0FI_GL_14 is based,there is no need of writing any CMOD code, so we just created an append structure and added these fields . Adding one more selection field in the standard data source. You're asking for a 'BEST practice' of the FULL extraction. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14 . General ledger: Data for taxes on sales and purchases. About this page This is a preview of a SAP Knowledge Base Article. When we tested the delta extraction, everything was good except the Text Field Changed. SAP Help Portal · General Ledger Details: Line Items — 0FI_GL_4 · Accounting data related to the General Ledger: Line Items of the Leading Ledger — 0FI_GL_14. Sub Modules. Finance Accounting Finance & Lease Accounting General Ledger Account receivables Account Payable Asset Accounting Contract Accounts Finance Genaral FI-TV(travel mangement) Controlling Plant Maintainance Project Systems Material Management sales and distribution management HCM IS-Retail Total. 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. 0FI_GL_14 takes the data from FAGLFLEXA and if your ECC data in that table is blank then 0FI_GL_!4 will also provide you with 0 data. This InfoSource is based on DataSource 0FI_GL_14. The DataSources can then be used independently of one another (see note 551044). But when I checked table BWOM2_TIMEST, there is no entry for the above data source. Murali. But i am getting G/L Accounts as less or more with respective to Account document nos. You may choose to manage your own preferences. Can anyone suggest, is it enough if we just add MATNR to the structure or do we need to write code in CMOD. Cumulated balance. My requirement is to enhance 0FI_GL_4 with fields from BSEG Table. I have a situation where I need to change the exisitng datasource (0FI_GL_4) to new datasource (0FI_GL_14). FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue (0FI_GL_12). Regards. Grant. 0 - Basis, ABAP support packs 16, SAP-AP - 7. We are loading delta in hourly basis. sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. 2LIS_11_VASCL: Sales. I heard that, It is possible to add a field without writing CMOD. We need this field in BI side in the existing cube and then need to use it in to existing reports. Search for additional results. Some documents are not getting posted and e_err_subrc is returning 4. This InfoSource is based on DataSource 0FI_GL_14. See all updates on 14 (from Victoria General Hospital), including real-time status info, bus delays, changes of routes, changes of stops locations, and any other service changes. Key field. xlsx), PDF File (. Regards. 0FI_GL_14 is line items, sap has 0FIGL_O14 which feeds from FAGLFLXA. Use corresponding exit FM as template and copy the import, Export, Table, Exception. but in system, it is ‘S-Debit’. With New G/L in SAP ECC 6. Characteristics. e. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. Material Type Tables. We were running between master data and transaction data without any problem. Technical Data. Check the data in RSA3. 0FI_GL_14: General Ledger (New): Line Items Leading Ledger FI - General Ledger Accounting: 18. Any resemblance to real data is purely coincidental. Dear Manoj, If the New GL has not been implemented in your ECC side 0FI_GL_14 will not be brining any data. Module Name. Now when i0fi Gl 14 Ecc Table Tables Most important Database Tables for 0fi Gl 14 Ecc Table # 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 : BUT000:FAGLFLEXT is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores General Ledger: Totals data. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. However, when i test extraction on R3 (RSA3) doesn't appear. 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). Use. The logic is written in new HANA Optimized ABAP code, this code will do the calculation in the. The DSO enables line item reporting on actual data. DataSources in General Ledger Accounting (New) General Ledger: Balances, Leading Ledger. In our scenario, during the night (03:00 am), we perform. 0FI_GL_14 Clearing date missing even after implementing Note 1802912. 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 ). When the fI document is cleared BSEG is updated with the clearing date but the TIMESTASMP field in FAGLFLEXA does not get updated, so extractor does not pick up the change. Key Fields. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 5. Check if MATNR is available in this table first. Examples of such DataSources include 0FI_GL_10, 0FI_GL_14,. 13. But i found that the IP ran for 3 hours bringing 200k + records into my BW. All fields from the Infosource are transferred to the ODS object. * For more information about source system IDs, see SAP. We would like to use the extractor 0FI_GL_14. 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. Corporate Memory: storage of all data records delivered by the DataSource for rebuilding the Integrated DWH. BW-BCT-FIGeneral Le 1396438 1 0FI_GL_14: Update from DSO to cube. Could you please let me know steps I need to follow to update data source with required fields from BSEG Table. I thought may be. 2. Here, x stands for T, H, K or O. The extraction procedure delivered with the business content for SAP BW 1. 0fi Gl 14 Tables Tables Most important Database Tables for 0fi Gl 14 Tables # TABLE Description Application Table Type; 1 : BSEG: Accounting Document Segment FI - Financial Accounting: Cluster Table 2 : BKPF: Accounting Document Header FI - Financial Accounting: Transparent Table 3 : MSEG:For 0FI_AA_11 and 0FI_AA_12, both 0ASSET_ATTR_TEXT and 0ASSET_AFAB_ATTR should have successful data extractions. 11. Use. x and ODP datasources was based off full loads (except for the 2. Symptom. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). But there is no blog in this link. I have already refer below forum, Offset account 'GKONT' information in the Extractor 0FI_GL_14. RSS Feed. When using datasource 0FI_GL_14, this has both BELNR/BUZEI and DOCNR/DOCLN and in general, DOCNR is mapped to. tcode to generate data. ( This field is part of FBL3N output ) Could you please share your inputs on t. As part of your project you want to take advantage of the ODP-SAP replication API to extract data e. . This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource General Ledger (New): Line Items Leading Ledger (0FI_GL_14). Symptom. This question is for New GL. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Reports can be based on any value type that is recorded in the source. Mainly applicable for Expense line items (P&L line items). Performance enhancements might be available for data extraction. Gajesh. Tools. In Customizing of the OLTP system, you have activated new General Ledger Accounting under Financial Accounting Financial Accounting Global Settings . But I could not find any BC update rules or Transformations for it. The additional 100 records that you have in the Init w/ Data Transfer may be that those 100 records were flagged for deletion and that's how they. Questions: Based on above. The field from which the data is taken depends on the ledger master data, the characteristics of the InfoObject OCURTYPE, and the posting period. Technical name: 0FI_GL_10. Performance enhancements might be available for data extraction. We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. Jul 10, 2015 at 10:51 AM. Can you please let. We have a scenario where we have enhanced 0FI_GL_14 datasource with MATNR and loaded the data in the DSO. My client is implementing BW-BPC Consolidation, so that we already have 0FI_GL14 data source and from this we are extracting data into customized DSO, for BW-BPC Consolidation client has given KE24 Tcode and ask to enhance to 0FI_GL14 Data source. The data source which fulfills my requirement is 0FI_GL_4. 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. Based on DataSource: 0FI_GL_4. Configuration of Accounts Payable. For New GL data sources safety limit (UL and LL) set to 3600 seconds by default. Hello Experts, We are facing issue with missing Clearing date for 0fi_gl_14. This is a technical Blog Post for SAP BW and SAP BW/4HANA consultants. If you use transaction RSA5 to activate the extractor of DataSource 0FI_GL_14, the field attributes of the append extractor are assigned to the actual extractor. The following CDS views have now been released: CDS Views for Master Data. Hello Experts, I am trying to use the table RSOSFIELDMAP in SAP BW 7. FAGLFLEXT where as 0FI_GL_14 is used to fetch Line item table info i. In General Ledger Accounting, only one ledger must be specified as the leading ledger. 6 million extraction on 7. This is a preview of a SAP Knowledge Base Article. Hi, I'm currently using 0FI_GL_14 extractor. Follow. CompositeProvider . Replace existing datasource with new one. Production – 74% performance improvement (1. 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. RSS Feed. 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. I have the below questions: 1. 0COMP_CODE. x DS)). We have been running these 2 extractors for years with no issues and pulling the deltas in 40 seconds to 4 minutes depending on the time of month and data volume. I now have a requirement to get the Offset Account (GKONT) field. An answer explains that. X.