1 Document History The following table provides an overview of the most important changes to this document. 0 system and we have 0FI_GL_10 extractor providing us the reports based on P&L and Balance Sheet. System must add buffer to timestamp because of the document saving time consuming. Standard Approach: Normally in the general practices the extract structure is enhanced with the required fields and the data is populated using the external logic in the CMOD. At the time of init with data transfer the balance in BW report exactly matches that in ECC . FI-GL: GL - Line Items (0FI_GL_4) FI-GL: General. In the following table only the fields BIUKRS and FISCPER are filterable: Field in Extract Structure. SAP BW/4HANA 1. It contains all the totals records (transaction. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). 0, version for SAP HANA. Data Source 0FI_GL_4 , will satisfy this requirement. This InfoSource is based on DataSource 0FI_GL_12. Jul 20, 2012 at 10:30 AM. New GL: If the source system still based on New GL, Then. 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. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. Click more to access the full version on SAP for Me (Login required). As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. Never run an engine at a constant engine speed for long periods during the running-in period. Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. [Enter your Keywords here. For more information, see SAP. Thanks. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. About this page This is a preview of a SAP Knowledge Base Article. Extractors only exist for the source system from R/3 Release 4. ) Field in. 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. About this page This is a preview of a SAP Knowledge Base Article. for Infosource 0fi_gl_10 - Structure 13 : BWOM_SETTINGS BW CO-OM: Control Data CO - Information System, iViews: Transparent Table 14 : RSDS 0FI_GL_10 Datasource. Performance enhancements might be available for data extraction. Any one have a solution how to test the sapr/3 and sap BW system. Index on FAGLFLEXT. I've searched the forum and read this. This InfoSource is based on DataSource 0FI_GL_14. 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. Extractor: BWFID_GET_FIGL_ITEM. 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. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!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. Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. 1. 0FI_AP_1 : Vendors: Transaction figures. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. 2) Run Delta infopackage to get rsa7 records. <u>Now, I dont get the delta. . Since Release 3. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. Due to which our deltas did not bring any records to the BW system. 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. 1. 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. All amounts are extracted using different currencies for example, transaction currency, company code, currency, and controlling area currency, therefore, in most cases, you must put a filter on the CURTYP column of the extractor (CURTYP=00 means transaction currency. 0FI_AP_1 : Vendors: Transaction figures. For information on how to start using this new procedure, see OSS note 410797. 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. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. Problem is GL_1 has cumulated balance and GL_4 does not. Module Name. 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. Use corresponding exit FM as template and copy the import, Export, Table, Exception. The DSO enables balance and flow reporting for defined periods. Hello Experts, Delta load for the datasource 0FI_GL_10 is failing with the following error. In step two, all logically dependent records of these records (for example, the credit record. Functional Area. 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. ADJ. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. 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. The new solution is based on new extractors that are available with Plug-In Release PI2003. Production – 74% performance improvement (1. . As i checked in the System, there is no entry in this table. The 0FI_GL_20 datasource contains data from all ledgers. The 0FI_GL_10 datasource contains data from the Leading Ledger. How i can solve this issue? How i can get correct Data in BI(DSO)? Is there any problem with DataSource (0FI_GL_10) Can any have faced same issue, Please help me out. However, we have a problem in that splitting in the new GL in ECC 6. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. This DataSource provides the line items in General Ledger Accounting from tables BKPF, BSEG, FAGLFLEXA, . in the 0FI_GL_4 extractor. But when I checked table BWOM2_TIMEST, there is no entry for the above data source. 0, version for SAP HANA. 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. 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. Prerequisites. Yes, the table is really huge and. Please note, that the following key figures must be available in your base InfoProvider (filled with data provided from the NewGL DataSources 0FI_GL_10 or 0FI_GL_12): 0TURNOVER, 0DEBIT, or 0CREDIT. General ledger: Data for taxes on sales and purchases. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). And now the FAGLFLEXT is no longer populated with any FI. Glenlyon Norfolk School (GNS) is an independent, co-ed, university preparatory day school in Victoria and Oak Bay, British Columbia, Canada. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. 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. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. for Infosource 0fi_gl_10 - Structure 13 : BWOM_SETTINGS BW CO-OM: Control Data CO - Information System, iViews: Transparent Table 14 : RSDS DataSource in BW BW - Data Staging: Transparent Table 15 : ROOSOURCE Table Header for SAP BW OLTP Sources (Relevant From 2. I'm designing GL summary report. I wolud like the test the 0FI_GL_10 in SAPR/3 and SAP BW system for reconcilliation . Hello experts, I'm currently working on loading data from DS 0FI_GL_10, the data flow is as follows, 0FI_GL_10 -> 0FIGL_O10 -> 0FIGL_C10,first I excuted the infopackage as delta initialization with data update and. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). [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. 1. We have migrated classical/old GL to the new GL. It is used as a source for reconstructions without the need to access the sources again. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. 0. 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. · General Ledger Details: Line Items — 0FI_GL_4 · Accounting data related to the General Ledger: Line Items of the Leading Ledger — 0FI_GL_14. All line items in fbl3n can be reported. Datasource Type: Transaction Data Extractor. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. ADDD. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). Visit. 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. Performance enhancements might be available for data extraction. 0 EhP4)2 Answers. Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. Yes. 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. Description of Field in Extract Structuree. It is used as a source for reconstructions without the need to access the sources again. 0)0FI_GL_10 Datasource. 0FI_GL_10 extracts data from FAGLFLEXT table. 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. The extraction procedure delivered with the business content for SAP BW 1. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. I am using the Keyfigure 0VALUE_LC. (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 0FI_TAX_4. 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. After going through the SAP documentation, I came to know that SAP has given standard procedure to generate extractor which can support Non-leading ledger data. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no longer be used. The data records are read from table ACDOCA. . 0. We are doing an RRI from the Financial Statements to the GL Line Items. I know nothing about 0figl12. Performance enhancements might be available for data extraction. By default, all corporate memory DSOs provided by the SAP HANA-optimized BI Content have been created according to the DataStore object (advanced) template Corporate memory without compression. 0FI_GL_10: General Ledger: Leading Ledger balance s FI - General Ledger Accounting: 2 : 0FI_GL_60: Average Daily balance s FI - General Ledger Accounting: 3 : 0FS_BALIND_TEXT: balance Sheet Indicator (Texts) Fi Services - Financial Services: 4 : 0GLACCEXT_T011_HIER Financial Statement Item• 0FI_GL_10 - Interface to New General Ledger, data from Leading Ledger • 0FI_GL_20 - Interface to New General Ledger, data from all ledgers • 0FI_AP_4 - Interface to Accounts Payable • 0FI_AP_30 - Interface to Accounts Payable • 0FI_AR_4 - Interface to Accounts Receivable0FIGL_R10 pre and post processing. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. 2) All key figures 0BALANCE,0DEBIT and 0CREDIT in DSO(0FIGL_O10) has the transformations with summation in Aggregation not overwrite. 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. My Question is on the Balance field in the Line Items. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. FSV report is based on Virtual cube 0FIGL_V10 and this cube is fetching through Function Modeule RS_BCT_FIGL_DATA_GET_VC10 and is based on basic. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. Hi everybody, I met a delta problem related to 0FI_GL_10. Name of Target InfoObject. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as. Important: As of Enhancement Pack 3 (=> EhP3) / Business Function FIN_GL_CI_1 (=> New General Ledger Accounting), you can also use the line item extractor 0FI_GL_14 (=>. 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. FAGLFLEXT table for end of period balances. 0 (=> SAP ERP 6. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. Step-4: Creating function modules for each extractor enhancement. 2013 01:05:28 Job started0FI_GL_10 and FAGLFLEXT - Key Fields. Datasource is not having WBS Field. I init the datasource, and get the right data. what are the application components we have to use fill the setup table. 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. 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. Dear All, For FI related below data sources i want to do full upload. Regards, Leszek Technical name: 0FI_GL_10 Use This InfoSource contains transaction figures from the leading ledger of the new General Ledger. This DataSource is delta-compatible. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). It contains the complete history of the loaded data. The ODQ uses the following three tables to store data: 1. 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. This is for the DS – 0FI_GL_10. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). 6 million records – 100 mins (0FI_GL_14 7. The latter is available from ECC60 onwards. But when new FI document appears (new entry in FAGLFLEXT), no Delta Queue appears in SMQ1 transaction. 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. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. 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. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. All fields from the Infosource are transferred to the ODS object. that is not extracing the data completly in the psa itself. sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. General Ledger Accounts (GL) in SAP are divided into two parts a. InfoSource 0FI_GL_4. Below are the details of the FSV. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. SAP delivers the DataSource 0SEM_BCS_10 for the data collection of the leading ledger from the new general ledger into the consolidation. Please advice how to add WBS Element to existing. 0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor. Do we need access key to enhance the structure ? Are there any other suggestions. 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. 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. 0. 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. Chart of Account Section and b. Follow RSS Feed Hi, We are using 0fi_gl_14 DS for extracting leading ledger's line item data. On Controlling (CO) data sources:- 0FI_GL_10: for total records. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. Visit SAP Support Portal's SAP Notes and KBA Search. 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. DataStore Objects. I've implemented standard cube 0FIGL_C10. 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. 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. I Have a problem with the extracción delta of the extractor 0fi_gl_10. What are the advantages of using one over the other. SQL cod The following error may also. 0fi Gl 10 Data Tables Most important Database Tables for 0fi Gl 10 Data # TABLE Description Application Table Type; 1 : BSEG: Accounting Document Segment FI - Financial Accounting: Cluster Table 2 : RSDS: data Source in BW BW - Data Staging: Transparent Table 3 : BKPF: Accounting Document HeaderAssigned Tags. Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. FI-TX. Dates are expressed in the format YYYYMMM. 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. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To . All fields from the Infosource are transferred to the ODS object. (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. However, the key field Ref. 01. * For more information about source system IDs, see SAP HANA-Optimized BI Content. 4 system with HANA database. Looking in the table. 0), there is an extractor for extracting totals records from the new General Ledger to BI: 0FI_GL_10. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 11. Enter the InfoPackage description, select the Data Source and click Save. 0 Ehp3 SP2 ) does not provide Material No. MultiProviders. 0fi_gl_10. For more information, see SAP. About this page This is a preview of a SAP. 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 . 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. Mainly applicable for Expense line items (P&L line items). the activation throws up these errors. 07. So I went the other route - I went to source system in RSA5 and activated it. Now we have following system configurations. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. FI-GL: New GL - Balances - /IMO/D_FIGL12. 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? I have loaded 0FI_GL_10 datasource in BW Production with below steps: 1. I test it on rsa3 tx and the balance value is zero. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. I went through the SAP helpand they have 2 option which is reporting based on 0FIGL_C10 which is based on data source 0FI_GL_10 or 0FIGL_C0 which make use of 0FI_GL_1data source1) 0FI_GL_10 with Init with data transfer. 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. Based on my understanding the below Business Content Extractors pull from FAGLFLEXT and. -- Cube 0FIGL_C10. Reports can be based on any value type that is recorded in the source. If no data inbound layer. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. 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 . 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 . These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. Production – 74% performance improvement (1. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. You may choose to manage your own preferences. Using this approach, the advantages are: Introduction: This blog guides us through on how to Optimize the performance for FI Related Standard Datasources – 0FI_GL_10 & 0CO_OM_OPA_6. This DataSource is delta-compatible. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 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. 0FIS_GL_LINEITEM. As per Note 410799, the Structure CI_BSIK was created to include the additional fields. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 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. It contains the complete history of the loaded data. Extract structure OLTP: DTFIGL_4. Click more to access the full version on SAP for Me (Login required). A myth about 0FI_GL_10 Datasource. Version Date Description 1. 3. 668 Views. 1st loading scenario: This is the sm37 of ECC6. 0 more than a year back but then we stopped doing any delta loads from the datasource. The most important attributes of business entities are included, such as. 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. An initialization did delta to itself on the 20. The extractor calculates the same key figures as transaction GADBKFC. 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. But i havnt understand the structure of this datasource. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. This is applicable for the following data sources. About FI Extractors Mechanism. 0COMP_CODE Company code. Transfer struct. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. I create some GL documents in the source system. 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. Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. It doesnot impact the currently configured datasources and their data. The ALV display doesn't show technical. Delta extraction 0FI_GL_10 VERY SLOW. 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 ). For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. 3. 2069 Views. 3. Nov 15, 2016 at 09:09 AM. As it is CDC enabled, I cant load it in pieces as the Full load needs to be completed for Delta queue initialization. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. This didn't give a very bad result, except for the account 129000 which represents the profit and loss for the year before. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). The DataSources can then be used independently of one another (see note 551044). We have requested users to change some transactions and tried the. 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. It is working fine at DEV, However after transport to QA, the custom fields are missing in the ROOSFIELD table at QA. (ie posting date). BW-BCT-FI-GL , BW only - General Ledger , Problem . Fields of Origin in the Extraction Structure of 0CO_OM_CCA_9. For all other ledgers, you have to create separate DataSources . DataStore object: /IMO/FIGL_D04. 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 is loaded, it is the leading DataSource with regard to the time limits – such as maximum time (CPU date) – up to. Follow. Implementing generic extractor is not a. In DSO Transfered Records are 60264 and Added Records are 47034. About this page This is a preview of a SAP Knowledge Base Article. 0FI_GL_10 ( Data Source )Relevancy Factor: 1. The Field COST_ELEM is there in extract structure FAGL_EXTSTRUCT_LEAD. 1. Click more to access the full. 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. For all other ledgers, you have to. . DSO key figures are set to "overwrite". 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. Delta is capturing additional record which were already capture in init . Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. after I map the fields , I checked the trnasformation, It is OK. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. This should work. Follow RSS Feed Hi, 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. Delta Tables. Extractor Tables. Extractor: BWFID_GET_FIGL_ITEM. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. Describing the Test Scenario. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . 0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). I have made an enhancement to extractor 0FI_gl_4 using EXIT_SAPLRSAP_001 and FUNCTION ZXRSAU01 in our DEV Client. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). I made a settings change in BWOM_SETTINGS table with PARAM_NAME = BWFIOVERLA and PARAM_VALUE = 'X'. 09. 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. DetaInit Simulation = 1 supported. Can I load another GL DS data into BI which has document type field and then create a multiprovider on both the cubes and generate a report. 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 delivered extractors 0FI_GL_10 and 0FI_GL_4 to extract totals and. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 3 million records – 13 mins (0FI_GL_14 ODP) / 2.