Follow. As i checked in the System, there is no entry in this table. Hi Team, How to do enhancement for 0FI_GL_10 data source ,I would like add filed BWART to this data source . Please advice how to add WBS Element to existing. As soon as DataSource 0FI_GL_4 has been loaded, it is the leading DataSource with regard to accruals, such as the time and date (CPU date) by which extraction should be carried out. Datasource 0FI_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. Hi all, Does anybody know the difference between General Ledger DS 0FI_GL_10 and 0FI_GL_20? Both used to extract new GL line items. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. 0FI_GL_10 extracts data from FAGLFLEXT table. System must add buffer to timestamp because of the document saving time consuming. 2. The ALV settings do not show any way to fix this. This is for the DS – 0FI_GL_10. You can also use the DataSources 0FI_AR_4, 0FI_AP_4, and 0FI_TX_4 separately without 0FI_GL_4. This InfoSource is based on DataSource 0FI_GL_14. 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). I am using the Keyfigure 0VALUE_LC. I am trying to create an InfoObject and I do not know what reference characteristic to use. Monitor the extraction. Extractor Tables. 0. 1 Document History The following table provides an overview of the most important changes to this document. General ledger: Data for taxes on sales and purchases. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). * For more information about source system IDs, see SAP HANA-Optimized BI Content. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. I GOTO. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. Diagnosis An error occurred in the source system. And then you need to replicate it to BI. DataStore Object (advanced): CM S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA) (/IMO/C_FI401) No Field Rules. ACDOCA, mismatch,. Jan 19, 2011 at 10:09 AM Delta mechanism for 0fi_gl_14. It is used as a source for reconstructions without the need to access the sources again. We then implemented steps in SAP note 1692484 as seen below but timestamp is still incorrect. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. e. Dates are expressed in the format YYYYMMM. Can anyone suggest, is it enough if we just add MATNR to the structure or do we need to write code in CMOD. 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. . 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. 0 PSA is bringing less number of records when compared to the records in RSA3 extract checker. The latter is available from ECC60 onwards. We noticed, when we make a GL posting in FI system, there is 4-hour difference in timestamps between BKPF table and FAGLFLEXT (and FAGLFLEXA) tables. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 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. Please let me know how we can achieve this . 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. The following BI Content objects are available:0FI_GL_14: General Ledger (New): Line Items Leading Ledger: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 0FI_AP_4: Vendors: Line Items with Delta Extrcation:After going through the help document I understood that the BI 7 version came up with General Ledger Accounting (New), If this is true then can we still use 0FI_GL_04 in Ecc and BI7. Data Source 0FI_GL_4 , will satisfy this requirement. 1 Document History The following table provides an overview of the most important changes to this document. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. HSL16, KSL01. 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. Hi Nilesh. Production – 74% performance improvement (1. 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). 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. I understood that FI data sources delta is based on timestamp. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. From the OBJNR of the totals record (places 3-6 of the object number) From the OBJNR of the totals record (places 7-16 of the object number) From the OBJNR of the totals record (places 17-24 of the object number) Whether SSME or SSMED is filled depends on the category of the. 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. based on basic cube 0FIGL_C10. InfoSource 0FI_GL_4. 1. Description: General Ledger: Leading Ledger Balances. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. All other ledgers, again if required, would require separate DataSources be created for each ledger. 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 0FI_GL_11: General Ledger: Balances of Leading Ledger via Line Items: FI - General Ledger Accounting: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction: FI - General Ledger Accounting: 0FI_GL_20: G/L Accounts: Transaction. I Have a problem with the extracción delta of the extractor 0fi_gl_10. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . AIED. IDoc s enable the connection of different application systems using a message-based. 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. 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. For performance improvements for extraction, see SAP Note 1731175. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. Follow. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. This table contains field like Table name, FI Account Number, Business Area, Company code along with the date and time stamp of the. As mentioned by Parth, the above 2 datasources are for new gl. ) Field in. The new solution is based on new extractors that are available with Plug-In Release PI2003. This InfoSource is based on DataSource Raw Data of G/L Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA). We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. I have loaded 0FI_GL_10, 0FI_AR_4 and 0FI_AP_4 Init load on before two days, today I was checking in RSA7 (BW Delta Queue) where I didn't found any delta records while there are records created on both days in ECC system. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. The ALV display doesn't show technical. 4 system with HANA database. 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 tried to find these new extractors in the BI content but couldn't find it. 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. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. This is for the DS – 0FI_GL_10. FI-GL: Actuals/plan/budget: Balance and Flow Comparison. x DS)). In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. I am using the FI data source 0FI_GL_10. Use SAP BW/4HANA Business Content delivers this field-based DataStore Object (advanced) as a first persistence layer of data replicated into a SAP BW/4HANA data warehouse. 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). For more information, see SAP. Symptom In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. 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. The problem faced here was particularly relating to 0FI_GL_10 Datasource. Sub Modules. 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. At the time of init with data transfer the balance in BW report exactly matches that in ECC . Not. Click more to access the full version on SAP for Me (Login required). I am stuck at mapping BPC dimensions and properties to BW info-objects. But now there's a small change where I need document type field data which is not available in 0fi_gl_10 DS. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. Application: FI - General Ledger Accounting. 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. But its picking the sales document type ZX. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. As per OSS note 2341038, I was trying to understand how to remap the 0FI_GL_ extractors like 0FL_GL_10/14 . ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . 3 million records – 13 mins (0FI_GL_14 ODP) / 2. FI - Asset Accounting: 13 : 0CCMS_MTE_TDEP_MASTER_DATAThis DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). Performance enhancements might be available for data extraction. 0FI_AP_3 : Vendors: Line Items. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. the delivered extractors 0FI_GL_10 and 0FI_GL_4 to extract totals and. 2. Hello, we are in a process of implementing 0FI_GL_10. here i found two BC Datasources. Name of Target InfoObject. Could someone help me understand delta mechanism for 0fi_gl_14?. The issue you have with 0FI_GL_10 extractor in the delta load is that the key fields of the DSO are not correct, with the result that records are being overwritten by the last record when 2 similar records are received by the Delta process and updated to the DSO. Below are the details of the FSV. 2069 Views. Diagnosis. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Jul 20, 2012 at 10:30 AM. This datasource after init with data transfer, Delta bringing wrong values . Hello Gurus, I have to add a new field in 0FI_GL_10 DS, already i loaded the data but functional team need 1 more field. Functional Area. 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. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. Experts: Extraction of data from 0FI_GL_10 (ECC 6. The structure gets. Procedure. About the 0FI_AP_4 / 0FI_AP_30 Datasources . Accounts receivable: Line items. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . The DSO enables line item reporting on actual data. 1. Performance enhancements might be available for data extraction. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). Use corresponding exit FM as template and copy the import, Export, Table, Exception. how to execute this DSO having 2 row data. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. Reports can be based on any value type that is recorded in the source system. It doesnot impact the currently configured datasources and their data. The system could not generate a syntactically correct test frame for function module FAGL_GET_TT_DATA_LEAD. Check that in RSA7. But there are few considerations to this. In delta mode, data requests with InfoSource 0FI_AR_4 and InfoSource 0FI_AP_4 do not provide any data if no new extraction has taken place with InfoSource 0FI_GL_4 since the last data transfer. 0. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. In ERP the number of fiscal periods per year is configurable. 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. Regards. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. 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. 1. 0FI_GL_10 - Current Status Timestamp issue. Based on DataSource: 0FI_GL_4. (1) See SAP note 1012874 for FAQ on extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 0FI_GL_10, 0FI_GL_11, 0FI_GL_12, 0FI_GL_14) (2) T o extract the changed delta records , there are some pre-requisites steps to be performed on the SAP server as summarized in following steps:Oct 10, 2007 at 03:48 PM FAGLFLEXT vs. I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. The most important attributes of business entities are included, such as. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. However there has been a migration of the FAGL table to FMGL table. Questions: Based on above. The process chain now is running every minute. Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. 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. The ODQ uses the following three tables to store data: 1. Some of the infopackage and transfer rules are missing. I checked in 0fi_ar_4 there is document type. ca. Company Codes Section. In that process I launched FAGLBW03. 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. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. Let me know if you have any questions. 0COSTCENTER Cost Center. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. The data source 0FI_GL_10 for the extraction of r/3 accounts can be used in the same way with s/4 HANA? Us would help a lot if someone could provide us with practical information about how to define BW extractors to s/4, for. The engine can be expected to use more engine oil. 0FI_GL_14. All is standard. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. Search for additional results. 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. Source structure: BKPF, BSEG. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. DataStore Objects. Functional Area. ". The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. 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. Hello SAP Experts, I missing my data in SAP BW (Business Warehousing) while using data source 0FI_GL_10 (or generated 3FI_GL_xx_TT with delta mode AIED) in delta mode. Delta load. Source System for R/3 Entry* 0GN_R3_SSY. 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. In this case use FM EXIT_SAPLRSAP_001 as template. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. Its a one time process for GL , we will not set separately for all the GL data sources. Search for additional results. 0. Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. Transfer struct. 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. 0. This InfoSource is based on DataSource 0FI_GL_14. You may choose to manage your own preferences. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no. Datasource Type: Transaction Data Extractor. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. Describing the Test Scenario. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. We were doing delta loads using this datasource when BW was on 7. 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. 0FI_AP_4 extracts data from the table BSIK (Open Items) and BSAK (Cleared Items). I am using the data source 0FI_GL_10 and I am creating an InfoObject to hold the 'ACTIV' field. Worked extensively in the Finance - Accounts Payable (FI-AP) -. . You can use this DataSource to extract average daily balances (ADB) and other key figures for ledger dimensions to the FI component. For all other ledgers, you have to create separate DataSources . 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. About this page This is a preview of a SAP Knowledge Base Article. Even though there were no data in RSA7, I tried to run Delta Infopackage but I didn't get any records in that. the extracted no of. VALUETYPE = 20) then it will be available in 0FI_ACDOCA_20 extractor). 2) In the customer exit used for the first system, I have to write some code to check the CALLER system. Problem is GL_1 has cumulated balance and GL_4 does not. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. Records loaded into PSA = 900. Initialization was done With data transfer. BTE used is 00005012. Filled with the 2-digit system ID of the connected source system. Technical Name of Target InfoObject. And now the FAGLFLEXT is no longer. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. Source System of BW system. The symptom. This might be a case of where in extractor has not pulled up the right data. 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 information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. For FI AP - I have replicated the following datasources . . As in the past we have performance problems (especially with the extractor 0FI_GL_14), we found some notes concerning the new FI-GL extractors that have been released to decide, if we continue with the 0FI_GL_10 and 0FI_GL_14 on BW 7. The Non-Leading Ledger — What is it? These ledgers, as stated above, work in parallel to the leading. 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). DataStore object: /IMO/FIGL_D04. So questions as below. actually i loaded the data to ods & infocube by using of reinitialization bcoz of delta failed. 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. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Dear All, For FI related below data sources i want to do full upload. Click more to access the full version on SAP for Me (Login required). I've been specific in the WHERE clause of the coding to restrict the result set to a specific document number. 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals) 0FI_GL_14 --> 0FIGL_O14 (for Line item) Question1: The DSO 0FIGL_O14 does not feed the cube. So we enhanced it (using append structure populated in CMOD). 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. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. 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. 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. 0fi_gl_10. But it is not easy to find out how the buffer are given and what is the value, this blog post will help you to understand and get necessary information. 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. 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. Now if i trigger delta IP then it is failing with source system erroiam having fi gl data source named as 0FI_GL_10 . 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. InfoSource. If no data inbound layer. Hi All, Currently i am working on FI GL Extractors (New). The DSO enables balance and flow reporting for defined periods. I not enhance 0FI_GL_10. MultiProviders. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. doc no and doc pos can be used. Relevancy Factor: 1. Part II – Post-Upgrade Checks, Repairs and Activities0FI_GL_4 General Ledger: Line items (only if used) 0ASSET_ATTR_TEXT Asset master data; 0ASSET_AFAB Asset depreciation parameters; And then the transaction data. 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. DBSQL_SQL_INTERNAL_DB_ERROR, , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem . 09. 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). Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). For this I enhanced the 0fi_gl_10 DS and checked the data but its showing wrong document types. Now we have following system configurations. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. For more. We have requested users to change some transactions and tried the. 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 ). Chart of Account Section and b. About this page This is a preview of a SAP Knowledge Base Article. In step two, all logically dependent records of these records (for example, the credit record. As per Note 410799, the Structure CI_BSIK was created to include the additional fields. 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. In this DS eg. Implementing them has nothing to do with 0FI_GL_10 or 4. Unit - account Grp - FS Assertion - Control - 7 :Transformation. 1st loading scenario: This is the sm37 of ECC6. Performance enhancements might be available for data extraction. About the 0FI_GL_10 / 0FI_GL_20 Datasources . FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. 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 . 0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. We have migrated classical/old GL to the new GL. All fields from the Infosource are transferred to the ODS object. This increase in performance compared to a full data extraction on the same ODP datasource is due to. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General 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. Filled with the 2-digit system ID of the connected source system. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. This data source extracts data records for universal journal entries. Unfortunately this standard content delivered datasource ( source system- ECC 6. 0FI_GL_10 Delta Load Issues. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. - 0FI_GL_14: for line items. Visit SAP Support Portal's SAP Notes and KBA Search. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. Now, I used RSDS in BW to try to replicate it in. 6 million records – 100 mins (0FI_GL_14 7. CURTYPE=00 Transaction Currency. 0FI_GL_10 vs. The 0FI_GL_20 datasource contains data from all ledgers. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. December 2, 2015 at 10:57 am. More Information. 2013 01:05:28 Job started 0FI_GL_10 and FAGLFLEXT - Key Fields. . 0FIS_GL_LINEITEM. We have a P&L Report implemented in SAP BI and data is coming from 0FI_GL_10 datasource. hi professional! using 0FI_GL_10 Data are wrong in case of an Delta extraction to PSA. GL is created initially for Chart of Account section and further extension is done to different company codes on need basis. 0 Ehp3 SP2 ) does not provide Material No. Can anyone pls clarify this for me. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. 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. Line items can be requested in the general ledger view and in the entry view. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. 0COMP_CODE Company code. hi experts, till yesterday ,my new TOTAL G/L account(0fi_gl_10) was working fine and now also, but clients has recently accepting to use AWTYP (Reference Transaction) field, but problem is this field had included in FAGLFLEXA table and EXTRACT STRUCTURE also. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. ISU BW Extractors. Looking in the table. About FI Extractors Mechanism. 0FI_GL_10 --> 0FI_GL_10 --> 0FIGL_C10 (for Totals) 0FI_GL_14 --> 0FIGL_O14 (for Line item) Question1: The DSO 0FIGL_O14 does not feed the cube. . SAP BW/4HANA 1. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. 2. What are the advantages of using one over the other. "Termination occurred in the ABAP program " GP_GLX_FAGLFLEXT " - in"FI-GL: Line Items - /IMO/FIGL_D04. 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. This question is for New GL. Hello Experts, Delta load for the datasource 0FI_GL_10 is failing with the following error. 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. Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. However, the key field Ref. It is available only with a minimal version of ECC (ECC 6. 0 EhP4)2 Answers. But when new FI document appears (new entry in FAGLFLEXT), no Delta Queue appears in SMQ1 transaction. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. When we jump for the Income Statement or P&L, the jump reports shows the correct value. Mainly applicable for Expense line items (P&L line items). During the last 10 hours the periods of running at WOT can be increased to 5-10 minutes at a time. The current BW system (SAP BW 7. For information on how to start using this new procedure, see OSS note 410797. In this case use FM EXIT_SAPLRSAP_001 as template. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . 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. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. 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. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. .