This DataSource provides the line items in General Ledger Accounting from tables BKPF, BSEG, FAGLFLEXA, . 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. 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. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 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. All planned Versions <> 001 However during Delta load it extracts only actual data (Version = '001') but no planned versio. 0FI_AP_1 : Vendors: Transaction figures. to the ACDOCA extractors. I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC. 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). Procedure. For all other ledgers, you have to create separate DataSources . 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. 0. 1. I am stuck at mapping BPC dimensions and properties to BW info-objects. For more. 1) Init with data transfer setting in infopack and execute it to load the data,give some time to reach delta records to RSA7 - around 12 to 24 hrs*. Yes, the table is really huge and. 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. You therefore cannot test the function module using the test environment. Line Items of the Leading Ledger. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. About the 0FI_GL_10 / 0FI_GL_20 Datasources . Below are the details of the FSV. sap. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Use. 0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). Can anyone pls clarify this for me. 3. SAP enhancement package 6 for SAP ERP 6. About the 0FI_AR_4 / 0FI_AR_30 Datasource . [Enter your Keywords here. the extracted no of records may not. For information on how to start using this new procedure, see OSS note 410797. Even though there were no data in RSA7, I tried to run Delta Infopackage but I didn't get any records in that. We have a P&L Report implemented in SAP BI and data is coming from 0FI_GL_10 datasource. -- Cube 0FIGL_C10. 1392817 - Description of the delta procedure for the balance extraction. My understanding is that 0FI_GL_10 supports multiple deltas based on TIMESTAMP in the table FAGLFLEXT. . FI-TX. 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. 6. 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. 0. 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. Perhaps there are delta records which makes the difference between RSA3 and BW cube. some Records are missing when we check Total Debit Postings & Total Credit postings. A myth about 0FI_GL_10 Datasource. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. This InfoSource is based on DataSource 0FI_GL_14. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. The problem is that when we extract INIT load. 0FI_GL_10 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). Below are the details of the FSV. SAP Library - General Ledger Accounting (New)RSM, 340, 0CO_OM_CCA_9, 0EC_PCA_3, 0FI_AR_4, 0FI_GL_4, 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 3FI_GL_xx_TT, 1_CO_PA, RSC2_QOUT_CONFIRM_DATA, RSDBTIME , KBA , BC-BW , BW Service API , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , Problem . I've been specific in the WHERE clause of the coding to restrict the result set to a specific document number. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. 1. 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. Timestamp Tables. 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. Hello Friends please suggest me at the earliest, We have a critical GL Model designed in which we have flow as below. The balance should be changed. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). till that everything did well. . You may choose to manage your own preferences. During the last 10 hours the periods of running at WOT can be increased to 5-10 minutes at a time. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. For example Finance data extractor 0FI_GL_10 is Whitelisted with S/4 HANA, this means the data source is fully supported and will work with out any restriction. About this page This is a preview of a SAP Knowledge Base Article. The latter is available from ECC60 onwards. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. Step-4: Creating function modules for each extractor enhancement. An initialization did delta to itself on the 20. About the 0FI_GL_10 / 0FI_GL_20 Datasources . The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. 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 . The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). our ECC system is on ERP on HANA with Simple Finance add-on. Data source setup table filling. We faced this issue couple of years and has been stable for years now. 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. ] , KBA , BW-BCT-FI-GL , BW only - General Ledger , How ToDelta Extract Stage was tested with custom Datasources and with the following standard Datasources:In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). but that field not visible at RSA6,Extractor 0FI_GL_10 pulls data from table FAGLFLEXT. The standard data source for the Financials New Legder is 0FI_GL_10 General Ledger: Leading Ledger Balances, which fetches the data from the FAGLFLEXT Table using the Extract Structure FAGL_EXTSTRUCT_LEAD. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. 2. 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. 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. December 2, 2015 at 10:57 am. Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. 0. It contains the complete history of the loaded data. FI-TX. 2 0FI_AP_4 Customization. Join. 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). In BW, we always need to see. Delta is capturing additional record which were already capture in init . 1 million records in 56 mins to PSA and extracted 2 million records in 62 mins to PSA post-HANA DB upgrade. 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. 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. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. 0, version for SAP HANA. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. 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. 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. This ensures that the data in BW for Accounts Receivable and Accounts Payable Accounting is exactly as up to date as the data for General Ledger Accounting. Date Time Message text. For example: Number of records from RSA3 extract checker = 1000. 0FI_GL_10 - Current Status Timestamp issue. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). 2) In the customer exit used for the first system, I have to write some code to check the CALLER system. But now there's a small change where I need document type field data which is not available in 0fi_gl_10 DS. CURTYPE=00 Transaction Currency. 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. Rsa7 Database Tables in SAP (15 Tables)Hi, I am trying to load data of extractor, 0FI_GL_10, which is CDC enabled but not able to initialise it by loading full load. As i checked in the System, there is no entry in this table. The full or delta extraction job is terminated by the following runtime error: RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To About this page This is a preview of a SAP Knowledge Base Article. Chart of Account Section and b. 0FI_AP_4 (AP-line items) and 0FI_AR_4 (AR- line items Selections are made from tables BSID/BSAD (Accounts Receivable) and BSIK/BSAK (Accounts Payable) For New GL, in BI New GL accounting as an Application Area under that you can have Basic Cube 0FIGL_C10 and DSO 0FIGL_O10 which are based on Datasource 0FI_GL_10. The problem faced here was particularly relating to 0FI_GL_10 Datasource. The DSO enables flow reporting for defined periods. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. Load : Init delta load. 1505 Views. Click more to access the full version on SAP for Me (Login required). Purpose. 0fi Gl 10 Base Tables Tables Most important Database Tables for 0fi Gl 10 Base Tables # TABLE Description Application Table Type; 1 : MARA: General Material Data Logistics - Material Master: Transparent Table 2 : BSEG: Accounting Document Segment FI - Financial Accounting: Cluster Table 3 : KOMP:Dear Experts, I am working on the Fund Flow Report. DataStore Object (advanced): CM S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA) (/IMO/C_FI401) No Field Rules. Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. It is available only with a minimal version of ECC (ECC 6. If the custom fields available in the std table, at least I can update the property of these. Drill Down in P&L Report. 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. Jul 20, 2012 at 10:30 AM. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. 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. tcode to generate data. 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. what are the application components we have to use fill the setup table. It's always 0 in RSA7 transaction for 0FI_GL_10. As a prerequisite for using this note, you must have been using the old DataSources (FI_AP_3 and FI_AR_3) and intend to replace them with the new ones (0FI_GL_4, 0FI_AP_4 and 0FI. Extract structure OLTP: DTFIGL_4. In the following table only the fields BIUKRS and FISCPER are filterable: Field in Extract Structure. e. System Response Caller. 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. You may choose to manage your own preferences. 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. RSS Feed. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a key field. Search for additional results. ISU BW Extractors. 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. Use corresponding exit FM as template and copy the import, Export, Table, Exception. The transfer rules are created fine but some fields are missing in the transfer rules. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. Please find an example setup of the InfoProvider for the actuals data below. Click more to access the full version on SAP for Me (Login required). Source System for R/3 Entry* 0GN_R3_SSY. We have requested users to change some transactions and tried the. 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. I am using the Keyfigure 0VALUE_LC. 2LIS_11_VAHDR: Sales Document. 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. The fields in the datasource are more than the 16 allowed keys in the DSO,. Due to which our deltas did not bring any records to the BW system. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. Hi All, Currently i am working on FI GL Extractors (New). 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. 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. General Ledger (New): Line Items Leading Ledger (0FI_GL_14) Sample Business Explorer (BEx) Queries are delivered on top of the MultiProviders FI-GL: General Ledger and FI-GL: New GL: FI-GL: Actuals Balance and Flow Comparison. Unfortunately this standard content delivered datasource ( source system- ECC 6. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. 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. Is there any other DS which caters the same data almost as 0fi_gl_10 DS and has document. 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. 0COSTCENTER Cost Center. 09. how to execute this DSO having 2 row data. 0fi Gl 10 Tables. Diagnosis. Can you please tell me the how to do this . Visit. 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. These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. 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. 0FUNC_AREA Functional area. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. In that process I launched FAGLBW03. The symptom. In ERP the number of fiscal periods per year is configurable. For all other ledgers, you have to. 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. 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. Please suggest. Full load. The DSO enables line item reporting on actual data. 4 system with HANA database. You should be fine running both, but they have different purposes: Technical name: 0FI_GL_10 General Ledger: Balances, Leading Ledger is based on the. Purpose. 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 HANA1 Answer. A myth about 0FI_GL_10 Datasource. 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. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. Please share with me your suggestion or view. 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. 0), there is an extractor for extracting totals records from the new General Ledger to BI: 0FI_GL_10. 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. 0FI_TAX_4. Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. The DSO enables balance and flow reporting for defined periods. It is used as a source for reconstructions without the need to access the sources again. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. 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. This didn't give a very bad result, except for the account 129000 which represents the profit and loss for the year before. Datasource Type: Transaction Data Extractor. ". There are no changes in the system and the extraction is running already for 3 months but last Tuesday we encountered a long running time of job in ECC6. Uso 0FI_GL_10 o el 0FI_GL_14. Datasource is not having WBS Field. The Field COST_ELEM is there in extract structure FAGL_EXTSTRUCT_LEAD. For the General Ledger, the selection is made from the tables BKPF and BSEG, while selection for the subledgers is made from tables BSID/BSAD (Accounts Receivable) and BSIK/BSAK (Accounts Payable). The safety parameter will take care of the delta loads for all the FI data sources. DataStore Objects. BTE used is 00005012. for Infosource 0fi_gl_4 - 11 /BIC/CCTA0FI_GL_40: Transfer struct. 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. Skip to Content. If not present go to SM30. Now We found that there is a different table called FAGLFLEXA & FAGLFLEXT , Which will have the combined data from BSEG , BKPF and some other tables. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. SM66 shows that 'Sequential Read of DB FAGLFLEXA' last a long time. It contains the complete history of the loaded data. I init the datasource, and get the right data. So I went the other route - I went to source system in RSA5 and activated it. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. CURTYPE=10 Local Currency CURTYPE=00 Transaction Currency Dates are expressed in the format YYYYMMM In ERP the number of fiscal periods per year is configurable. 0FI_AP_20 : Vendor Balances. 0 more than a year back but then we stopped doing any delta loads from the datasource. Worked extensively in the Finance - Accounts Payable (FI-AP) -. Mainly applicable for Expense line items (P&L line items). DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. 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. We had installed 0FI_GL_10 and available in all the systems (dev/qa/prod). Performance enhancements might be available for data extraction. The DataSources can then be used independently of one another (see note 551044). 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. 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. 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. for Infosource 0fi_gl_4 0 - Structure 12 : DTFIGL_4: Extract Structure: General Ledger Line Items to BW FI - Financial Accounting: Structure 13 : ROOSFIELD: DataSource FieldsHi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. Hi Team, How to do enhancement for 0FI_GL_10 data source ,I would like add filed BWART to this data source . This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). The standard data source for the Financials New Legder is 0FI_GL_10 General Ledger: Leading Ledger Balances, which fetches the data from the FAGLFLEXT Table using the Extract Structure FAGL_EXTSTRUCT_LEAD. . There are lot of sap notes available for this strange behavior and its corrections. . We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. I test it on rsa3 tx and the balance value is zero. For FI AP - I have replicated the following datasources . We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. The extractor calculates the same key figures as transaction GADBKFC. ISU BW Extractors. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. :) Please help us on the below issue as it seems to be ITSP migration ( BW - HANA) issue so that is the reason unable to activate the Datasource from the F50 . I would recommend you to reload the data once for the missing periods and then make sure that you. InfoSource. In BI side u have to use data model 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals). 3 million records – 13 mins (0FI_GL_14 ODP) / 2. In the extraction structure, there fields are marked as Hidden. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. However, I do not want this new field in the second system. Search for additional results. 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 2LIS_03_UM: Revaluations: MM - Materials Management: 0FI_AR_3: Customers: Line Items: FI - Accounts Receivable: 0FI_GL_1:there is 10 records for that particular combination(For Ex. 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. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. TSL16). Does it contain extra fu. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. Correction specified in the note: 1152755 have to be incorporated in order to resolve the issue with the AA data sources. Understand that SAP is providing the above two datasources to extract consolidation data from ECC (FAGLFLEXT) to staging cube and subsequently to the 0BCS_C11 total cube. 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. 2 possible ways I can figure out are the following: 1) Copy 0FI_GL_10 to another customized datasource, but I don't know how to do it. 0 Ehp3 SP2 ) does not provide Material No. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. 1. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. All line items in fbl3n can be reported. Hello, we are in a process of implementing 0FI_GL_10. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. 0FI_AP_3 : Vendors: Line Items. Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). 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. 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. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. Hello experts, We are running over S4H (SAPK-10102INS4CORE) and SAP_BW (SAPK-75006INSAPBW) trying to activate BW Business Content datasource 0FI_GL_10 but unable to end the process successfully. CURTYPE=10 Local Currency. SQL cod The following error may also. 09. 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. This might be a case of where in extractor has not pulled up the right data. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. Technical Name of Target InfoObject. 0fi_gl_10. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. Source System of BW system. 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 . 0. Please provide the code. I have done following steps to get delta data. MultiProviders. Description of Field in Extract Structuree. 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. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. Properties of Delta Process (Indicates Record Mode values) Data load in data target with delta processes: Delta Process Support Data Load into DSO or Cube?? ABR (After Image, Before Image) DSO and Cube. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. 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) –. 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. We applied several SAP notes: 1. The 0FI_GL_20 datasource contains data from all ledgers. We are working on BI 7. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. With Simple Finance, ACDOCA table will be the primary table. Hi everybody, I met a delta problem related to 0FI_GL_10. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. Thank You AdvanceDataStore object (advanced): FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/CMFIGL06. 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. Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. The extrator is the function module FAGL_GET_TT_DATA_LEAD for the data source. 07. Any one have a solution how to test the sapr/3 and sap BW system. sap__0fi_gl_14: This model 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 they dont have that tick. Fields of Origin in the Extraction Structure - Accounts Receivable: Line Items. "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. DSO key figures are set to "overwrite". About this page This is a preview of a SAP Knowledge Base Article. I am trying to create an InfoObject and I do not know what reference characteristic to use. I added custom fields to the standard data source 0FI_GL_10. The problem faced here was particularly relating to 0FI_GL_10 Datasource. 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). Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. All is standard. 1. Yes. I've checked Datasource in R3 (RSA3) and it matches the R3 reports and the PSA. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here.