e. 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. CURTYPE=00 Transaction Currency. The structure gets. 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. With New G/L in SAP ECC 6. Source structure: BKPF, BSEG. Chart of Account Section and b. The following are the few design considerations when reporting for New General Ledger Accounting module is implemented in SAP BW. On Controlling (CO) data sources:- 0FI_GL_10: for total records. DSO. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. - 0FI_GL_14: for line items. Thanks. Init without data transfer. 0 EhP4) Generally used fields are as follows: FISCPER : Fiscal Period. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. We now realize we need the cumulated balance at a plant level for specific GL Accounts. Page Not Found | SAP Help Portal. In that process I launched FAGLBW03. And now the FAGLFLEXT is no longer. Dates are expressed in the format YYYYMMM. System must add buffer to timestamp because of the document saving time consuming. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. Extract structure OLTP: DTFIGL_4. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. 0. Performance enhancements might be available for data extraction. Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10(Actual Data). BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . These would be named 3FI_GL_XX_TT, where XX would be replaced with the ledger name. Procedure. 01) schedules a daily job for this extraction daily and it takes approximately around 12 - 16 hours for daily data load. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. 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. And now the FAGLFLEXT is no longer populated with any FI. Technical Name of Target InfoObject. 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. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). 1505 Views. Delta Tables. The latter is available from ECC60 onwards. AIED. 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. 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__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. You may choose to manage your own preferences. We have migrated classical/old GL to the new GL. Thanks, Manjunath. For more information, see SAP. 0 and BW 3. The safety parameter will take care of the delta loads for all the FI data sources. 1 Document History The following table provides an overview of the most important changes to this document. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. This datasource after init with data transfer, Delta bringing wrong values . As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. I have gone through certain threads and found out that we will have to generate our own data source for any other ledger. Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor. 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. 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. We have used sap standard data source and DSO for the data extraction. Does it contain extra fu. Version Date Description 1. . 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. ACDOCA, mismatch,. 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. But there are few considerations to this. CURTYPE=10 Local Currency. KDGRP to FSV Report. Hi Nilesh. For performance improvements for extraction, see SAP Note 1731175. FI-GL: GL - Line Items (0FI_GL_4) FI-GL: General. 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. Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. Delta is capturing additional record which were already capture in init . 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. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. Yes. The requirement was to run multiple deltas/day during period end closing. SQL cod The following error may also. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. 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. Message no. The symptom materializes in d The note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. 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. 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. But its picking the sales document type ZX. Table of Origin. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. 09. 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. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. 0VTYPE Value Type for. line items respectively. 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 ). 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). Since the generated objects no longer correspond to the old active version, they were reset to inactive. Diagnosis An error occurred in the source system. It is working fine at DEV, However after transport to QA, the custom fields are missing in the ROOSFIELD table at QA. 2. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. Procedure. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. So we enhanced it (using append structure populated in CMOD). RSA6->SELECT THE DATASOURCE 0FI_GL_10 >CHANGE DS ->datasource customer version display-- ->SELECTION -->RLDNR(LEDGER IN GENERAL LEDGER ACCOUNTING) AFTER THIS I M NOT. 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. DataStore object: /IMO/FIGL_D04. 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. 0FI_AP_3 : Vendors: Line Items. 0FI_GL_10 General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 10 : 0BPARTNER_ATTR SAP BP: BW Extraction Central data - 11 : 0FI_AA_001 ANNUAL VALUES FI - Asset Accounting: 12 : 0FI_AA_006 TRANS. As soon as DataSource 0FI_GL_4 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. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. " 0FI_GL_8 General Ledger: Statistical Key Figures". 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. Datasource is not having WBS Field. To enable determination of the datasets, note 535016 must be installed in all. I am trying to create transfer rules for one of the datasource '0FI_GL_10'. 07. Please find an example setup of the InfoProvider for the actuals data below. ISU BW Extractors. I made a settings change in BWOM_SETTINGS table with PARAM_NAME = BWFIOVERLA and PARAM_VALUE = 'X'. However, the key field Ref. Extractor: BWFID_GET_FIGL_ITEM. There are lot of sap notes available for this strange behavior and its corrections. This is for the DS – 0FI_GL_10. Data. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. 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. For more. 0FI_GL_14. I also checked for 0FI_GL_10 and 14 but both are not pulling all the values from this table. 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. Any standard procedure or we need to follow cmid code to append the extract structure?Fields of Origin in the Extraction Structure of 0CO_OM_CCA_4. 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 indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. Step-4: Creating function modules for each extractor enhancement. 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). Load : Init delta load. But it is not there in data source 0FI_GL_10 in ECC. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. Date Time Message text. Purpose. Data Source 0FI_GL_4 , will satisfy this requirement. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. 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. BTE used is 00005012. ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . Source System of BW system. All other ledgers, again if required, would require separate Data Sources be created for each ledger. what are the application components we have to use fill the setup table. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 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. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. To enter a delta dataset, you can use any of the following InfoSources (with the corresponding DataSources and extractors in SAP R/3): Component. Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. Perhaps there are delta records which makes the difference between RSA3 and BW cube. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. About the 0FI_GL_10 / 0FI_GL_20 Datasources . Performance enhancements might be available for data extraction. Visit SAP Support Portal's SAP Notes and KBA Search. Do we need access key to enhance the structure ? Are there any other suggestions. General ledger: Data for taxes on sales and purchases. 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. Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. You can find full information in the below SAP note: 1153944 - New delta extraction in new G/L. 0 more than a year back but then we stopped doing any delta loads from the datasource. 0. Average Daily Balance. 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 ). e FLAGFLEXT. Experts: Extraction of data from 0FI_GL_10 (ECC 6. Table BKPF shows the same timestamp. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. 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). 1. in the 0FI_GL_4 extractor. This is applicable for the following data sources. The ALV display doesn't show technical. 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. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. In this case use FM EXIT_SAPLRSAP_001 as template. Step-4: Creating function modules for each extractor enhancement. Delta load. 07. Enter the InfoPackage description, select the Data Source and click Save. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. If. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. Delta Update. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. A number of GL postings have been created and we can pick them up using the extractor checker (RSA3) and the delta initialisation works OK. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. 1), BW offers consistent data extraction to the BW system in the Delta update procedure for line items from General Ledger Accounting (FI-GL), Accounts Receivable Accounting and Accounts Payable Accounting (FI-AP). 4 on HANA or if we use the new extractors. The data records are read from table ACDOCA. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. Check table FAGL_ACTIVEC for the NewGL flag. For more information, see SAP. 1 Document History The following table provides an overview of the most important changes to this document. Accounts receivable: Line items. (ie posting date). I had operated info package in full update, then did initialize without data. The problem faced here was particularly relating to 0FI_GL_10 Datasource. We have a P&L Report implemented in SAP BI and data is coming from 0FI_GL_10 datasource. 3. SAP delivers the DataSource 0SEM_BCS_10 for the data collection of the leading ledger from the new general ledger into the consolidation. 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. causes changes to be made to the line items in the FAGLFLEXA table, which are not reflected in BSEG (by design), but are also not captured. Describing the Test Scenario. I would recommend you to reload the data once for the missing periods and then make sure that you. In ERP the number of fiscal periods per year is configurable. Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10 | SAP Blogs Relevancy Factor: 2. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. You have probably used an ABAP feature in the interface definition that is not yet supported in the test. ) Field in. About this page This is a preview of a SAP Knowledge Base Article. I init the datasource, and get the right data. It contains the complete history of the loaded data. So you will accumulated balance using these Infoproviders Profit Center wise (Segmentwise Also),with new G/L implented in BI side, this fullfils most of profit center Acounting. I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC. Please provide the code. based on basic cube 0FIGL_C10. included. What are the advantages of using one over the other. We then implemented steps in SAP note 1692484 as seen below but timestamp is still incorrect. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. About the 0FI_GL_10 / 0FI_GL_20 Datasources . A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. Regards,The Business content 0FI_GL_1 is just a summary cube, our customer has a need to have GL line item details in BW ODS/Cube from BSIS/BSAS R/3 tables. 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. Datasource : 0FI_GL_10. More Information. I am using the Keyfigure 0VALUE_LC. In ERP the number of fiscal periods per year is configurable. InfoSource. what would be the logic if i want to populate values of cost center in the faglflext table from BSEG or FAGLFLEXA table. RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To . 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. Was working on the extractor - 0FI_GL_21 which has very less documentation. (MATNR). 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. General Ledger Accounts (GL) in SAP are divided into two parts a. can not, 3FI_GL_0L_TT , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem . 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. The DataSources can then be used independently of one another (see note 551044). This datasource replaces the 0FI_AP_3, Accounts Payable: Line Items, datasource and uses the same extraction structure. I've checked Datasource in R3 (RSA3) and it matches the R3 reports and the PSA. Visit SAP Support Portal's SAP Notes and KBA Search. However, I do not want this new field in the second system. 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). 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. 4 system with HANA database. As. Field COST_ELEM is missing in Data Source 0FI_GL_10 | SAP Community Relevancy Factor: 1. For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. 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). 0, version for SAP HANA. 0 PSA is bringing less number of records when compared to the records in RSA3 extract checker. You're wondering to know using which fields as the selection could improve the performance. The transfer rules are created fine but some fields are missing in the transfer rules. Please suggest. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. 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. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a key field. 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). Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). For this I enhanced the 0fi_gl_10 DS and checked the data but its showing wrong document types. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. You may choose to manage your own preferences. 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 output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. The problem is that when we extract INIT load. 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. 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. Questions: Based on above. About FI Extractors Mechanism. 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 . I had activated the DS 0FI_GL_10 in source system and when i check in RSA3 it does not fetch any reocrds ( 0 Records) When i see the Table of origin FAGLFLEXT it also has 0 entries. 0FI_AP_3 : Vendors: Line Items. It was formed. 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). 2 0FI_AP_4 Customization. This didn't give a very bad result, except for the account 129000 which represents the profit and loss for the year before. Enhancement issue with 0FI_GL_10. Fields need to be enhanced are TSLVT TSL01. However, the key field Ref. The below mentioned are the key fields in the standard DSO : FIGL_O10. Implementing them has nothing to do with 0FI_GL_10 or 4. 0 (=> SAP ERP 6. Currently we have ECC 5. We applied several SAP notes: 1. Based on DataSource: 0FI_GL_4. With SAP BW/4HANA, Operational Data Provisioning (ODP) now becomes the central infrastructure for data extraction and replication from SAP (ABAP) applications to a SAP. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. 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. 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. while start Infopackage and choose parameter then having 2 row data. 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. 0FI_TAX_4. I've searched the forum and read this. The fields in the datasource are more than the 16 allowed keys in the DSO,. 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. Enhancement issue with 0FI_GL_10. Data loaded successfull to Data store Object. IDoc s enable the connection of different application systems using a message-based. regards. About this page This is a preview of a SAP Knowledge Base Article. Go to the update tab and select Initialize the delta process. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. This DataSource is delta-compatible. Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. Extractors only exist for the source system from R/3 Release 4. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. All planned Versions <> 001 However during Delta load it extracts only actual data (Version = '001') but no planned versio. Thanks, Manjunath. 0FI_GL_14 provides you detail level information of account number at day level. 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. Mandatory. 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. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. 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. 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. There is not a single field is hidden in 0FI_GL_10 DS. This InfoSource is based on DataSource Raw Data of G/L Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA). x DS)). Purpose. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). for Infosource 0fi_gl_4 - 11 /BIC/CCTA0FI_GL_40: Transfer struct. 3. 0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. 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. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. Monitor the extraction. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. Filled with the 2-digit system ID of the connected source system. Index on FAGLFLEXT. 0FI_AR_4: Customers: Line Items with Delta Extraction FI - Accounts Receivable: 3. till that everything did well. Search for additional results. This increase in performance compared to a full data extraction on the same ODP datasource is due to. ODQ Tables. Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. Untill and unless this checkbox is ticked, you will not be able to see that field in RSA3. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. The DataSources can then be used independently of one another (see note 551044). This question is for New GL. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. Unit - account Grp - FS Assertion - Control - 7 :Transformation. 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. Join. 1 Document History The following table provides an overview of the most important changes to this document. Looking in the table. Please let me know how we can achieve this . Search for additional results. 0FI_GL_10 General Ledger: Balances, Leading Ledger. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. This InfoSource is based on DataSource 0FI_GL_14. We have changed also the SMQS qRFC monitor with RFC destination to None. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. 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 extractor calculates the same key figures as transaction GADBKFC. I have searched in SCN but no extractor found which pulls all the data from this FAGLFLEXT table. . . 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. 0FI_GL_10 Delta Load Issues. 0. 2) Check whether aggregate behavior is maintained for key figures in DSO and infocube. Correction specified in the note: 1152755 have to be incorporated in order to resolve the issue with the AA data sources. InfoSource 0FI_GL_4 transfers only.