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. Does it contain extra fu. 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 in FS10N there are only Postings made for the Month 04/2013 and 05/2013. Please help. The DSO enables line item reporting on actual 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. FSV report is based on Virtual cube 0FIGL_V10 and this cube is fetching through Function Modeule RS_BCT_FIGL_DATA_GET_VC10 and is based on basic. regards. 1. As i checked in the System, there is no entry in this table. 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. 0FI_GL_10 General Ledger: Balances, Leading Ledger. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. In ERP the number of fiscal periods per year is configurable. 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. 0FI_GL_10: General Ledger: Leading Ledger balance s FI - General Ledger Accounting: 2 : 0FI_GL_60: Average Daily balance s FI - General Ledger Accounting: 3 : 0FS_BALIND_TEXT: balance Sheet Indicator (Texts) Fi Services - Financial Services: 4 : 0GLACCEXT_T011_HIER Financial Statement Item• 0FI_GL_10 - Interface to New General Ledger, data from Leading Ledger • 0FI_GL_20 - Interface to New General Ledger, data from all ledgers • 0FI_AP_4 - Interface to Accounts Payable • 0FI_AP_30 - Interface to Accounts Payable • 0FI_AR_4 - Interface to Accounts Receivable0FIGL_R10 pre and post processing. The performance of 0FI_GL_40 extraction is not good. DataStore Object (advanced): CM S/4 FI: GL. 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. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. 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. 0)0FI_GL_10 Datasource. Search for additional results. here i found two BC Datasources. With New G/L in SAP ECC 6. But when I checked table BWOM2_TIMEST, there is no entry for the above data source. Check table FAGL_ACTIVEC for the NewGL flag. But i havnt understand the structure of this datasource. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. For example, a document was posted at 10:25 in the morning. I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the. Step-4: Creating function modules for each extractor enhancement. 0FISCPER Fiscal year / period. 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. . Hi, We have done Full Uploads by executing the 0FI_GL_10 infopackage in SAP BI. I added custom fields to the standard data source 0FI_GL_10. Correction specified in the note: 1152755 have to be incorporated in order to resolve the issue with the AA data sources. Filled with the 2-digit system ID of the connected source system. . I have done following steps to get delta data. I create some GL documents in the source system. You can use this DataSource to extract average daily balances (ADB) and other key figures for ledger dimensions to the FI component. 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?The simple step for FI load is. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). The Field COST_ELEM is there in extract structure FAGL_EXTSTRUCT_LEAD. This data source extracts data records for universal journal entries. 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) –. If timestamp is not updated,in your R/3 system check if the Function Module "BWIP_WRITE_AEDAT_POINTER" is present in Table TPS31. KDGRP to FSV Report. 6. Worked extensively in the Finance - Accounts Payable (FI-AP) -. 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. Thanks. The documentation states GL_1 is for transaction while GL_4 is. 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. Examples of such DataSources include 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 0EC_PCA_1, 0EC_PCA_3, 0FI_GL_4, 0APO_LPROD_ATTR, etc. 0. 0, version for SAP HANA. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. Extract structure OLTP: DTFIGL_4. 0FI_GL_10 vs. 0), there is an extractor for extracting totals records from the new General Ledger to BI: 0FI_GL_10. RSS Feed. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor:. Generated totals records DataSource 3FI_GL_xx_TT (xx = ledger) or 0FI_GL_10 does not extract any data in delta mode. The requirement was to run multiple deltas/day during period end closing. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. 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. Load : Init delta load. 3. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. 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 ). 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. I GOTO. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. Dates are expressed in the format YYYYMMM. Table of Origin. 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. Introduction: This blog guides us through on how to Optimize the performance for FI Related Standard Datasources – 0FI_GL_10 & 0CO_OM_OPA_6. So we enhanced it (using append structure populated in CMOD). But when I compare values from the PSA to the DSO, some values are missing. In BW, we always need to see. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. It contains the complete history of the loaded data. In particular, the. 0FI_AP_20 : Vendor Balances. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. 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. We applied several SAP notes: 1. To enter a delta dataset, you can use any of the following InfoSources (with the corresponding DataSources and extractors in SAP R/3): Component. In this case use FM EXIT_SAPLRSAP_001 as template. Source System of BW system; SAP R/3; SAP R/3 Enterprise; SAP ERP Central Component; SAP ERP; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANA1 Answer. mygns . Delta extraction 0FI_GL_10 VERY SLOW. The new solution is based on new extractors that are available with Plug-In Release PI2003. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. About the 0FI_AR_4 / 0FI_AR_30 Datasource . 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. This InfoSource contains the structure to provide new general ledger balance data to the EDW Core Layer. TSL16). Please find an example setup of the InfoProvider for the actuals data below. Follow. 0FI_GL_10 Delta Load Issues. We are on ECC 5. Related content. The balance should be changed. Version Date Description 1. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. I am using the data source 0FI_GL_10 and I am creating an InfoObject to hold the 'ACTIV' field. 1505 Views. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. I also checked for 0FI_GL_10 and 14 but both are not pulling all the values from this table. The steps is following, 1. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. About the 0FI_AR_4 / 0FI_AR_30 Datasource . This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. Date Time Message text. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. Yes. For more information, see SAP Note 1523670. In this DS eg. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. 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. A myth about 0FI_GL_10 Datasource. We also have Line Item. Experts: Extraction of data from 0FI_GL_10 (ECC 6. It was formed. 0FI_TAX_4. KSL16, TSL01. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. Functional Area. 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. 6 or higher. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). And then you need to replicate it to BI. The 0FI_GL_20 datasource contains data from all ledgers. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). Hello Experts, Delta load for the datasource 0FI_GL_10 is failing with the following error. 2 0FI_AP_4 Customization. So if you want data for Non leading ledger , you will have to implement 3FI_GL_xx_SI, and 3FI_GL_xx_TT as required. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 12. 1. 01. Any one have a solution how to test the sapr/3 and sap BW system. 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. I init the datasource, and get the right data. We are implementing SEM BCS60 and ECC60 with new GL. This might be a case of where in extractor has not pulled up the right data. 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. 5. "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. For more information, see SAP. 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). A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. The DataSources can then be used independently of one another (see note 551044). 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. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. 2. We are BW4HANA system. Company Codes Section. AIED. This should work. 2013 01:05:28 Job started 0FI_GL_10 and FAGLFLEXT - Key Fields. 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. About this page This is a preview of a SAP Knowledge Base Article. 0FI_GL_4 (G/L Accounts- line items) Takes the data from the FI document tables (BKPF/BSEG) that are relevant to general ledger accounting (compare table BSIS). sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. based on basic cube 0FIGL_C10. 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. 2) In the customer exit used for the first system, I have to write some code to check the CALLER system. 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. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. ODQ Tables. But there are few considerations to this. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. In that process I launched FAGLBW03. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with TSV_TNEW_PAGE_ALLOC_FAILED dump. It successfully extracted data. ISU BW Extractors. Bw Delta Pointer For Delta Tables. Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. Check the below note: Note 1002272 - NewGL-DataSource 0FI_GL_10, 3FI_GL_*: Records missing in BI. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. Please advice how to add WBS Element to existing. x DS)). Init without data transfer. In ECC while Reconciling Data in FS10N and table FAGLFLEXT I found Difference in Monthly Data for a specific account in 2013 and remaining entire Data is Matching for other periods. 0fi_gl_10. System Response Caller. Version Date Description 1. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. sap. Hello experts, We are running over S4H (SAPK-10102INS4CORE) and SAP_BW (SAPK-75006INSAPBW) trying to activate BW Business Content datasource 0FI_GL_10 but unable to end the process successfully. (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. DataStore Objects. 0FI_AP_4 extracts data from the table BSIK (Open Items) and BSAK (Cleared Items). 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 ). Was working on the extractor - 0FI_GL_21 which has very less documentation. I've checked Datasource in R3 (RSA3) and it matches the R3 reports and the PSA. As. 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). 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. Module Name. after I map the fields , I checked the trnasformation, It is OK. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). 0fi Gl 10 Tables. Performance enhancements might be available for data extraction. 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. I am using the Keyfigure 0VALUE_LC. 3. About the 0FI_AP_4 / 0FI_AP_30 Datasources . We are doing an RRI from the Financial Statements to the GL Line Items. It is used as a source for reconstructions without the need to access the sources again. Since the generated objects no longer correspond to the old active version, they were reset to inactive. 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. Unfortunately this standard content delivered datasource ( source system- ECC 6. that is not extracing the data completly in the psa itself. Data source setup table filling. Production – 74% performance improvement (1. 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*. We are using the ODP mechanism for data extraction from S4. I have activated datasource 0FI_GL_10 for leading ledger, additionally generic extractors 3_* for the non-leading ledgers. The below mentioned are the key fields in the standard DSO : FIGL_O10. Describing the Test Scenario. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. 1 Document History The following table provides an overview of the most important changes to this document. but Cumulative balance of 0FI_GL_10 extractor is not matching with. Search for additional results. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. Data. what would be the logic if i want to populate values of cost center in the faglflext table from BSEG or FAGLFLEXA table. Relevancy Factor: 1. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. 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 . Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. Fields like that. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. My understanding is that 0FI_GL_10 supports multiple deltas based on TIMESTAMP in the table FAGLFLEXT. Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). 6 million records – 100 mins (0FI_GL_14 7. 10: 0FI_GL_2: General ledger: Transaction figures - Cost of sales ledger : 11: 0FI_GL_8: General Ledger: Statistical Key Figures : 12: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction : 13: 0FI_GL_21: G/L Accounts: Balances : 14: 0ACE_CALC_RESULT: Accrual Engine: Calculated Accrual Values : 15:ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. I am trying to create an InfoObject and I do not know what reference characteristic to use. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. 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. As it is CDC enabled, I cant load it in pieces as the Full load needs to be completed for Delta queue initialization. Use. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. So I went the other route - I went to source system in RSA5 and activated it. Hello Friends please suggest me at the earliest, We have a critical GL Model designed in which we have flow as below. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. Actual data : Version = '001' 2. New GL: If the source system still based on New GL, Then. More Information. Mainly applicable for Expense line items (P&L line items). We would like to make it a drilldown able report on Material and Country. 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. This DSO contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). About this page This is a preview of a SAP Knowledge Base Article. However, we have a problem in that splitting in the new GL in ECC 6. 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. The Extractor Connector contains two different options. Hello experts, Derived of a business requirement it is needed to add the Cost Element (KSTAR) field in the 0FI_GL_10 extractor in ECC in order to put it available for its use in the BW side. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. The DSO enables flow reporting for defined periods. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the DataStore object to the InfoSource. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Go to the update tab and select Initialize the delta process. -- Cube 0FIGL_C10. However there has been a migration of the FAGL table to FMGL table. Is there any other DS which caters the same data almost as 0fi_gl_10 DS and has document. Uso 0FI_GL_10 o el 0FI_GL_14. Does it contain extra fu. I am trying to create transfer rules for one of the datasource '0FI_GL_10'. Since Release 3. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . 0VERSION Version. Reports can be based on any value type that is recorded in the source. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. for Infosource 0fi_gl_4 - 11 /BIC/CCTA0FI_GL_40: Transfer struct. Now We found that there is a different table called FAGLFLEXA & FAGLFLEXT , Which will have the combined data from BSEG , BKPF and some other tables. Technical name: 0FI_GL_10 Technical Data Prerequisites In the OLTP system, you have activated new General Ledger Accounting in Customizing for Financial Accounting under Financial Accounting Global Settings. 2LIS_03_UM: Revaluations MM - Materials Management: 10. To enable determination of the datasets, note 535016 must be installed in all. About FI Extractors Mechanism. Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). KDGRP to FSV Report. Click more to access the full version on SAP for Me (Login required). The structure gets. Regards. Monitor the extraction. VALUETYPE = 20) then it will be available in 0FI_ACDOCA_20 extractor). 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. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the DataStore object to the InfoSource. Debit postings are Tally but credit postings are. 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. 0 EhP4)2 Answers. Delta load. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. Data loaded successfull to Data store Object. 0) into BI 7. 0GL_ACCOUNT G/L Account. Drill Down in P&L Report. Gajesh Nagesh. I've searched the forum and read this "0FI_GL_10 enhancement" post. " 0FI_GL_8 General Ledger: Statistical Key Figures". So questions as below. Extractor Tables. currently we don’t have data, if we keen some plan data( i. Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10(Actual Data). Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor. [not with the procedure, but with what info-object can be mapped to which dimension]Note 1012874 – FAQ extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 10) Note 411758 – Extracting noted item; 2. 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. We know that New GL data stores in FAGLFLEXT table. I have made an enhancement to extractor 0FI_gl_4 using EXIT_SAPLRSAP_001 and FUNCTION ZXRSAU01 in our DEV Client. ACDOCA, mismatch,. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. 0. - 0FI_GL_14: for line items. MultiProviders. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. 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. [Enter your Keywords here. 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. Due to which our deltas did not bring any records to the BW system. I am using the FI data source 0FI_GL_10. 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. All line items in fbl3n can be reported. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. Not. This is to facilitate mutiple delta loads/day for FI-GL/AR/AP/AA. However we do not see anything flowing into the delta queue in RSA7. Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. I'm designing GL summary report. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. But it is not there in data source 0FI_GL_10 in ECC. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). 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. Follow. Let us say "RMVCT - Transaction Type" is available in the datasource but missing in the transfer rules. For this I enhanced the 0fi_gl_10 DS and checked the data but its showing wrong document types. I am using the FI data source 0FI_GL_10. In ERP the number of fiscal periods per year is configurable. Fields need to be enhanced are TSLVT TSL01. 2069 Views.