0FIS_GL_LINEITEM. 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. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. 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. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. 1. DBSQL_SQL_INTERNAL_DB_ERROR, , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem . can not, 3FI_GL_0L_TT , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem . Symptom In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. We have intilzed the delta one year back and we are. 0fi_gl_10. Mainly applicable for Expense line items (P&L line items). For performance improvements for extraction, see SAP Note 1731175. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. actually i loaded the data to ods & infocube by using of reinitialization bcoz of delta failed. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. You can use this DataSource to extract average daily balances (ADB) and other key figures for ledger dimensions to the FI component. In ERP the number of fiscal periods per year is configurable. There are lot of sap notes available for this strange behavior and its corrections. About this pageDataSource Transactional Data: 0FI_GL_40. Initialization was done With data transfer. We now realize we need the cumulated balance at a plant level for specific GL Accounts. 0. CURTYPE=00 Transaction Currency. 0FI_GL_14 provides you detail level information of account number at day level. Version Date Description 1. The Extractor Connector contains two different options. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. SAP enhancement package 6 for SAP ERP 6. Can you please advise how to initalize correctly for this datasource? SolutionDatasource 0FI_GL_4 (GL: Line items) with delta type E (PULL): As this is a ‘PULL’ delta-type, the delta data records are determined during the delta update by the Datasource extractor, updated to the ODQ, and passed on to the SAP BW directly from there. In ECC, when asked functional folks, we got the inputs saying we need to use Group Currency field, which is KSL ( from FAGLFLEXT table ) . Procedure. This InfoSource is based on DataSource 0FI_GL_14. Datasource : 0FI_GL_10. 0 system and we have 0FI_GL_10 extractor providing us the reports based on P&L and Balance Sheet. Actual data : Version = '001' 2. Sub Modules. 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. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). 0FI_TAX_4. 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. Transfer struct. My explanation in this blog is focusing on transfering data with ODP to another system. My question is if "0FI_GL_10 - Leading Ledger Balance" and "0FI_GL_4 - Actual Line Items" datsources are already configured. 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. Filled with the 2-digit system ID of the connected source system. Thank You AdvanceDataStore object (advanced): FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/CMFIGL06. x DS)). Currently we have ECC 5. I'm designing GL summary report. Non-leading ledgers can be created as per the local accounting rules in your country/region. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. 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. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). In BW, we always need to see. This data source extracts data records for universal journal entries. Let me know if you have any questions. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. </u>From SAP BW - There is one data-source 0FI_GL_4 is not been activated. 2013 01:05:28 Job started 0FI_GL_10 and FAGLFLEXT - Key Fields. Hello, we are in a process of implementing 0FI_GL_10. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. You may choose to manage your own preferences. 10 characters required. All fields from the Infosource are transferred to the ODS object. Technical name: 0FI_GL_10 Use This InfoSource contains transaction figures from the leading ledger of the new General Ledger. Let us say "RMVCT - Transaction Type" is available in the datasource but missing in the transfer rules. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. Data Source 0FI_GL_4 , will satisfy this requirement. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). Purpose. This table contains field like Table name, FI Account Number, Business Area, Company code along with the date and time stamp of the. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. 5. 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. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no. I wolud like the test the 0FI_GL_10 in SAPR/3 and SAP BW system for reconcilliation . 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. Please provide the code. Enter the InfoPackage description, select the Data Source and click Save. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. However we do not see anything flowing into the delta queue in RSA7. Delta determination using the procedure AIED (for example, DataSource 0FI_GL_10) If you choose this delta procedure, in step one, the TIMESTAMP field in the totals table is used to select all records that have been changed since the last delta load. 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. 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. I not enhance 0FI_GL_10. Company Codes Section. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. 6 million records – 100 mins (0FI_GL_14 7. 1) first delta init load to PSA (yesterday 08:00 pm) 2) delta load to PSA (today 09:30 am) 3) full load to PSA (tThe 0FI_GL_10 datasource contains data from the Leading Ledger. 2. We faced this issue couple of years and has been stable for years now. 0 October 2010 Initial versionIn particular, the extract structure contains no fields from Accounts Receivable and Accounts Payable Accounting. The following are the few design considerations when reporting for New General Ledger Accounting module is implemented in SAP BW. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. Please find an example setup of the InfoProvider for the actuals data below. 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). 3. Since the generated objects no longer correspond to the old active version, they were reset to inactive. About this page This is a preview of a SAP Knowledge Base Article. An initialization did delta to itself on the 20. To do so, go to the configuration menu path Financial Accounting > Financial Accounting Global Settings > Ledgers > Ledger > Define Settings for Ledgers and Currency Types or use Transaction FINSC_LEDGER. 0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. 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 ). Init without data transfer. In this case use FM EXIT_SAPLRSAP_001 as template. Relevancy Factor: 1. We have used sap standard data source and DSO for the data extraction. 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. Does it contain extra fu. DSO key figures are set to "overwrite". For more information, see SAP. 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*. For example: Number of records from RSA3 extract checker = 1000. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. Extractor: BWFID_GET_FIGL_ITEM. We then implemented steps in SAP note 1692484 as seen below but timestamp is still incorrect. 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. As it is CDC enabled, I cant load it in pieces as the Full load needs to be completed for Delta queue initialization. BW-BCT-FI-GL , BW only - General Ledger , Problem . So questions as below. If the CALLER is the first system, perform the. RK0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 4 : 0FI_GL_6: General Ledger Sales Figures via Delta Extraction FI - General Ledger Accounting: 5 : 0GL_ACCOUNT_ATTR: G/L account Number FI - Financial Accounting: 6 : 0CGVMIC_13: Assignment: Org. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. Check that in RSA7. However, we have a problem in that splitting in the new GL in ECC 6. We have the requirement with the data from tables BSEG and BKPF Tables. 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). InfoProvider for BPC planning dataThis is the third part of the 3 part blog series – Part I – Reading List and Pre-Upgrade Checks & Activities. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as they dont have that tick. sap. I test it on rsa3 tx and the balance value is zero. I have activated datasource 0FI_GL_10 for leading ledger, additionally generic extractors 3_* for the non-leading ledgers. line items respectively. AIED. We have migrated classical/old GL to the new GL. -- Cube 0FIGL_C10. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. For FI AP - I have replicated the following datasources . what are the application components we have to use fill the setup table. KSL16, TSL01. ca. 1 Document History The following table provides an overview of the most important changes to this document. 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. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. Reports can be based on any value type that is recorded in the source. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. Join. This DSO contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). 0GL_ACCOUNT G/L Account. In this DS eg. On Controlling (CO) data sources:- 0FI_GL_10: for total records. 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. 2) All key figures 0BALANCE,0DEBIT and 0CREDIT in DSO(0FIGL_O10) has the transformations with summation in Aggregation not overwrite. After doing Init with data transfer, check in RSA7 if the Current Status of the generic delta for 0FI_GL_10 is updated or not. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. Source System of BW system. Dates are expressed in the format YYYYMMM. 0 PSA is bringing less number of records when compared to the records in RSA3 extract checker. However, the key field Ref. I have analysed looking to all existing to obtain as attribute but none of the field is not having WBS Maintain as attribute to it. If not present go to SM30. Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. Filled with the 2-digit system ID of the connected source system. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. Is it reuire to create the statistics. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 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. I planned for generic with time stamp by creating the view, but. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. 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. 1392817 - Description of the delta procedure for the balance extraction. This table covers field in General Ledger Accounting (FI-GL), Asset Accounting (FI-AA), Profitability Analysis (CO-PA) and the Material Ledger (CO-PC-ACT). Functional Area. Delta is capturing additional record which were already capture in init . But when I compare values from the PSA to the DSO, some values are missing. 0FIS_GL_LINEITEM. When I run delta load, it takes 1 hour and no data has been pulled from source. Now, I used RSDS in BW to try to replicate it in. Delta initializing also has been set, DSO is the object which is positioned between datasource and client defined infocube ZFIGL_C01. 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. * For more information about source system IDs, see SAP HANA-Optimized BI Content. A myth about 0FI_GL_10 Datasource. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. FI-GL: New GL - Balances - /IMO/D_FIGL12. InfoSources. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. You have probably used an ABAP feature in the interface definition that is not yet supported in the test. Delta Tables. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. There is not a single field is hidden in 0FI_GL_10 DS. 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. 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. It was formed. " 0FI_GL_8 General Ledger: Statistical Key Figures". 2. MultiProviders. I Have a problem with the extracción delta of the extractor 0fi_gl_10. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. Is there any other DS which caters the same data almost as 0fi_gl_10 DS and has document. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. 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. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. our ECC system is on ERP on HANA with Simple Finance add-on. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. 0FI_GL_10 ( Data Source )Relevancy Factor: 1. This is for the DS – 0FI_GL_10. However, I do not want this new field in the second system. 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. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. 0FI_AP_1 : Vendors: Transaction figures. 668 Views. I have searched in SCN but no extractor found which pulls all the data from this FAGLFLEXT table. This DataSource is delta-compatible. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. The system could not generate a syntactically correct test frame for function module FAGL_GET_TT_DATA_LEAD. 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 contains the structure to provide new general ledger line item data to the EDW Core Layer. 0. I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the. 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. 0FI_GL_14. However, the key field Ref. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. ". what would be the logic if i want to populate values of cost center in the faglflext table from BSEG or FAGLFLEXA table. Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. The fields in the datasource are more than the 16 allowed keys in the DSO,. 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. 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 vs. 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 this page This is a preview of a SAP Knowledge Base Article. *Let some posting get completed on ECC side only then we are able to see records in RSA7. 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) Run Delta infopackage to get rsa7 records. Now we have following system configurations. Visit. We would like to make it a drilldown able report on Material and Country. 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. 2LIS_11_VAHDR: Sales Document. This should work. 0FI_GL_40: G/L Accounts: Line Items: FI - General Ledger Accounting: 0CO_OM_OPA_6: Orders: Actual Costs Using Delta Extraction: CO - Overhead Cost Orders: 0SEM_BCS_10: Preparation for Consolidation: Transfer of Data to SEM-BCS - 0EC_PCA_1: Profit Center: Transaction Data on Accounts:Data sources – 0FI_AP_6, 0FI_AR_6, 0FI_GL_6, 0FI_AP_7, 0FI_AR_7, 0FI_GL_7, which are transaction figures extractors, use this table for managing delta records. 0FI_AP_3 : Vendors: Line Items. When we extracted . 0FI_GL_10 vs. 0 and BW 3. This is for the DS – 0FI_GL_10. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). 0FI_GL_14 is based on tables FAGLFLEXA, BSEG, BKPF Functionally, this affects other financial modules like AP, AR, PCA (Profit Center Accounting) For ex: with new G/L. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. In ECC 5. The below mentioned are the key fields in the standard DSO : FIGL_O10. When i am checking my ECC Report with BW report, Some fields are showing wrong values, for this reason, i reconciled the ECC Report and BW PSA (0FI_GL_10 ), for one combination, i. All other ledgers, again if required, would require separate Data Sources be created for each ledger. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. We were doing delta loads using this datasource when BW was on 7. Introduction: In many BW Projects, we have seen that most of the time we need to enhance the standard FI_GL/AR/AP extractors and pull the data for additional fields of the base/origin tables. 0COMP_CODE Company code. With New G/L in SAP ECC 6. Some of the infopackage and transfer rules are missing. 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. Monitor the extraction. Hi Shehzad, 0FI_GL_10 and GL_4 is used for leading ledger. ADD. Follow RSS Feed Hi, We are using 0fi_gl_14 DS for extracting leading ledger's line item data. (MATNR). If the custom fields available in the std table, at least I can update the property of these. 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. A myth about 0FI_GL_10 Datasource. In this case use FM EXIT_SAPLRSAP_001 as template. In DSO Transfered Records are 60264 and Added Records are 47034. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . 01. 311 Views. Yes, the table is really huge and. 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. But it is not there in data source 0FI_GL_10 in ECC. I have made an enhancement to extractor 0FI_gl_4 using EXIT_SAPLRSAP_001 and FUNCTION ZXRSAU01 in our DEV Client. Hi, What would probably the cause of the long running delta load from source to BW of 0FI_GL_10? There's enough resource for background process, no TRFC locked or short dump occurred. Version Date Description 1. 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. I am validating few gl accounts values related to 0FI_GL_10 both in R/3 and BW. 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. in the 0FI_GL_4 extractor. The missing key was 'Business Transaction' and it did the trick for us. RSS Feed. DataStore Objects. I init the datasource, and get the right data. b) Now this is for extractor 2LIS_13_VITM , here RSA3 is showing correct number of records. 0FI_AP_4 extracts data from the table BSIK (Open Items) and BSAK (Cleared Items). I have done following steps to get delta data. But now there's a small change where I need document type field data which is not available in 0fi_gl_10 DS. Currently we dont have any field coming from 0FI_GL_10 datasource to include characterstics like Country and Material. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . 0. 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. In step two, all logically dependent records of these records (for example, the credit record. 0FI_AP_3 : Vendors: Line Items. 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. All other ledgers, again if required, would require separate DataSources be created for each ledger. This question is for New GL. 0fi Gl 10 Tables. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. Performance enhancements might be available for data extraction. Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10 | SAP Blogs Relevancy Factor: 2. 4 system with HANA database. In particular, the. For Datasource 0FI_GL_12, Full load/Initial load extracts all versions of data: 1. Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. Please let me know how we can achieve this . . Does it contain extra fu. The problem faced here was particularly relating to 0FI_GL_10 Datasource. 1 million records in 56 mins to PSA and extracted 2 million records in 62 mins to PSA post-HANA DB upgrade. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). It contains all the totals records (transaction. System must add buffer to timestamp because of the document saving time consuming. I would recommend you to reload the data once for the missing periods and then make sure that you. We are BW4HANA system. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. Module Name. 0. 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). 0FI_GL_10 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. 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. Performance enhancements might be available for data extraction. Enhancement issue with 0FI_GL_10. to the ACDOCA extractors. Issues loading 0FIGL_C10. 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 InfoSource is based on DataSource 0FI_GL_14. FI-GL: New GL - Balances - /IMO/D_FIGL12. The extraction procedure delivered with the business content for SAP BW 1. It seems that all values that. Date Time Message text. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. 1. BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. 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. . I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC. Currently we are in SAP ECC 6. the delivered extractors 0FI_GL_10 and 0FI_GL_4 to extract totals and. About this page This is a preview of a SAP Knowledge Base Article. We are doing an RRI from the Financial Statements to the GL Line Items. Extractor Tables. This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. The performance of 0FI_GL_40 extraction is not good. The balance should be changed. ACDOCA, mismatch,. The ALV settings do not show any way to fix this. 0FI_GL_14. 0. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. During the last 10 hours the periods of running at WOT can be increased to 5-10 minutes at a time. 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. I've implemented standard cube 0FIGL_C10. The process chain now is running every minute. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. Trying to activate nut could not be activate due to the an issue ? Urgent help required. ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . Technical name: 0FI_GL_4 . Standard Approach: Normally in the general practices the extract. 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. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. Index on FAGLFLEXT. About the 0FI_GL_10 / 0FI_GL_20 Datasources . The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). data using Tcode : RSA3 for datasource 0FI_GL_12 we are getting all the values for the debit, credit and Turnover, however . 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. Thanks. 07.