- 0FI_GL_10. Dates are expressed in the format YYYYMMM. doc no and doc pos can be used. 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. 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 . The DataSources can then be used independently of one another (see note 551044). 0 SP 18). In this cases we are exposing a DataSource with direct access on tables. It is used as a source for reconstructions without the need to access the sources again. 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. So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. HSL16, KSL01. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. KSL16, TSL01. For example: Number of records from RSA3 extract checker = 1000. Below are the details of the FSV. For all other ledgers, you have to create separate DataSources . Search for additional results. In ERP the number of fiscal periods per year is configurable. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. 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. Source System of BW system. FI-GL: New GL - Balances - /IMO/D_FIGL12. Company Codes Section. 1. About this page This is a preview of a SAP. I have done following steps to get delta data. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 11. This DataSource is delta-compatible. Unit - account Grp - FS Assertion - Control - 7 :Transformation. In DSO Transfered Records are 60264 and Added Records are 47034. 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. ca. We have intilzed the delta one year back and we are. 1. As. For example, a document was posted at 10:25 in the morning. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. We have intilzed the delta one year back and we are pulling delta records to BW. The most important attributes of business entities are included, such as. 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. 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management: 0FI_GL_6: General Ledger. . 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. Important: As of Enhancement Pack 3 (=> EhP3) / Business Function FIN_GL_CI_1 (=> New General Ledger Accounting), you can also use the line item extractor 0FI_GL_14 (=>. the extracted no of records may not. Use corresponding exit FM as template and copy the import, Export, Table, Exception. ODQ Tables. In ECC 5. Questions: Based on above. At the time of init with data transfer the balance in BW report exactly matches that in ECC . All other ledgers, again if required, would require separate Data Sources be created for each ledger. For example Finance data extractor 0FI_GL_10 is Whitelisted with S/4 HANA, this means the data source is fully supported and will work with out any restriction. 0COMP_CODE Company code. Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. For all other ledgers, you have to. 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. This InfoSource is based on DataSource 0FI_GL_14. 0. Extract structure OLTP: DTFIGL_4. currently we don’t have data, if we keen some plan data( i. I GOTO. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. During the last 10 hours the periods of running at WOT can be increased to 5-10 minutes at a time. 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 ). InfoSources. Initialization was done With data transfer. I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. 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. We have migrated classical/old GL to the new GL. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. Since the generated objects no longer correspond to the old active version, they were reset to inactive. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. About this page This is a preview of a SAP Knowledge Base Article. Functional Area. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. We have used sap standard data source and DSO for the data extraction. Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10(Actual Data). 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. It contains all the totals records (transaction. 0 (=> SAP ERP 2004) and ECC 6. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. 668 Views. 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. You may choose to manage your own preferences. This InfoSource is based on DataSource 0FI_GL_14. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. About this page This is a preview of a SAP Knowledge Base Article. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. Implementing generic extractor is not a. If 0FI_GL_14 is replacement for 0FI_GL_4 for line item extraction between Old and New GLFI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. Delta extraction 0FI_GL_10 VERY SLOW. Purpose. our ECC system is on ERP on HANA with Simple Finance add-on. Fields like that. Table contains 16fields(HSL01. General ledger: Data for taxes on sales and purchases. You have probably used an ABAP feature in the interface definition that is not yet supported in the test. Data source setup table filling. 1. I am using the FI data source 0FI_GL_10. 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. sap. 0FISCPER Fiscal year / period. 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. Extractor: BWFID_GET_FIGL_ITEM. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Hello SAP Experts, I missing my data in SAP BW (Business Warehousing) while using data source 0FI_GL_10 (or generated 3FI_GL_xx_TT with delta mode AIED) in delta mode. Thanks. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with. FI-GL: New GL - Balances - /IMO/D_FIGL12. 0 EhP4)2 Answers. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. 1. Currently we have ECC 5. 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. 0FI_AP_3 : Vendors: Line Items. For more information, see SAP. Extractors only exist for the source system from R/3 Release 4. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. This data source extracts data records for universal journal entries. Procedure. Since the generated objects no longer correspond to the old active version, they were reset to inactive. Search for additional results. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. DataStore Object (advanced): CM S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA) (/IMO/C_FI401) No Field Rules. InfoSource. 3. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. GL is created initially for Chart of Account section and further extension is done to different company codes on need basis. 3. I am trying to pull GL data (for consolidation)from ECC to BW (using 0FI_GL_10) and then intend pull to BPC Model via data manager package. 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 . -- Cube 0FIGL_C10. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. 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). If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. Datasource is not having WBS Field. 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. 0FI_GL_14. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. Financial Statements are based on 0FI_GL_10 i. KDGRP to FSV Report. Accounts receivable: Line items. the activation throws up these errors. 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. We also have Line Item. Hi, We have done Full Uploads by executing the 0FI_GL_10 infopackage in SAP BI. 0. (1) See SAP note 1012874 for FAQ on extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 0FI_GL_10, 0FI_GL_11, 0FI_GL_12, 0FI_GL_14) (2) T o extract the changed delta records , there are some pre-requisites steps to be performed on the SAP server as summarized in following steps: While using the data source 0FI_GL_10 could someone please shed light on which table should be used to load actual data among FAGLFLEXA and FAGLFLEXT for SEM-BCS company consolidation purposes. I've searched the forum and read this "0FI_GL_10 enhancement" post. We are on ECC 5. For FI AP - I have replicated the following datasources . 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. Thanks, Manjunath. 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. Please find an example setup of the InfoProvider for the actuals data below. 07. 0; SAP NetWeaver; SAP ERP; SAP ERP Central Component; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANA0FI_AR_4: Customers: Line Items with Delta Extraction FI - Accounts Receivable: 9. Diagnosis An error occurred in the source system. All other ledgers, again if required, would require separate Data Sources be created for each ledger. 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. 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). 0. 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. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. The missing key was 'Business Transaction' and it did the trick for us. Never run an engine at a constant engine speed for long periods during the running-in period. A myth about 0FI_GL_10 Datasource. Source System for R/3 Entry* 0GN_R3_SSY. 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. Fields of Origin in the Extraction Structure - Accounts Receivable: Line Items. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. 1505 Views. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. Source structure: BKPF, BSEG. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). 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. Enhancement issue with 0FI_GL_10. The fields in the datasource are more than the 16 allowed keys in the DSO,. Table BKPF shows the same timestamp. FI-GL: Actuals/plan/budget: Balance and Flow Comparison. Delta Update. Technical name: 0FI_GL_10 Use This InfoSource contains transaction figures from the leading ledger of the new General Ledger. DS 0FI_GL_10 -- iNFOSOURCE 0FI_GL_10 - DSO Write optimized. 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. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Symptom. In this case use FM EXIT_SAPLRSAP_001 as template. e. With New G/L in SAP ECC 6. Mandatory. This table contains field like Table name, FI Account Number, Business Area, Company code along with the date and time stamp of the. About the 0FI_GL_10 / 0FI_GL_20 Datasources . 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. My understanding is that 0FI_GL_10 supports multiple deltas based on TIMESTAMP in the table FAGLFLEXT. 0VERSION Version. "Termination occurred in the ABAP program " GP_GLX_FAGLFLEXT " - in"FI-GL: Line Items - /IMO/FIGL_D04. that is not extracing the data completly in the psa itself. Version Date Description 1. The ALV display doesn't show technical. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as. All line items in fbl3n can be reported. Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10 | SAP Blogs Relevancy Factor: 2. The most important attributes of business entities are included, such as. 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. FI-TX. 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. SAP enhancement package 6 for SAP ERP 6. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). 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. Performance enhancements might be available for data extraction. 1st loading scenario: This is the sm37 of ECC6. Hi Team, How to do enhancement for 0FI_GL_10 data source ,I would like add filed BWART to this data source . The DSO enables balance and flow reporting for defined periods. 1. 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). Click more to access the full version on SAP for Me (Login required). The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). As per Note 410799, the Structure CI_BSIK was created to include the additional fields. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. DetaInit Simulation = 1 supported. I checked in 0fi_ar_4 there is document type. For performance improvements for extraction, see SAP Note 1731175. 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). Which view is applied depends on the. With New G/L in SAP ECC 6. We know that New GL data stores in FAGLFLEXT table. BTE used is 00005012. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. 1392817 - Description of the delta procedure for the balance extraction. based on basic cube 0FIGL_C10. 0A (BW PlugIn 2001. 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. 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_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. 07. SAP Library - General Ledger Accounting (New)RSM, 340, 0CO_OM_CCA_9, 0EC_PCA_3, 0FI_AR_4, 0FI_GL_4, 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 3FI_GL_xx_TT, 1_CO_PA, RSC2_QOUT_CONFIRM_DATA, RSDBTIME , KBA , BC-BW , BW Service API , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , Problem . W/ VAL. 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. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. This might be a case of where in extractor has not pulled up the right data. after I map the fields , I checked the trnasformation, It is OK. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . Symptom In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. You can also use the DataSources 0FI_AR_4, 0FI_AP_4, and 0FI_TX_4 separately without 0FI_GL_4. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. (1) See SAP note 1012874 for FAQ on extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 0FI_GL_10, 0FI_GL_11, 0FI_GL_12, 0FI_GL_14) (2) T o extract the changed delta records , there are some pre-requisites steps to be performed on the SAP server as summarized in following steps:Oct 10, 2007 at 03:48 PM FAGLFLEXT vs. We are using the ODP mechanism for data extraction from S4. 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). Bw Delta Pointer For Delta Tables. Follow. We then implemented steps in SAP note 1692484 as seen below but timestamp is still incorrect. </u>From SAP BW - There is one data-source 0FI_GL_4 is not been activated. The performance of 0FI_GL_40 extraction is not good. Functional Area. When I load full loads, all the 1000 records are loaded. "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. Delta initializing also has been set, DSO is the object which is positioned between datasource and client defined infocube ZFIGL_C01. Use corresponding exit FM as template and copy the import, Export, Table, Exception. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. 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) –. Please share with me your suggestion or view. what are the application components we have to use fill the setup table. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. It doesn't appear the real ammount since it is just a flow of amounts without no document behing. 0GL_ACCOUNT G/L Account. DataStore object: /IMO/FIGL_D04. The extraction procedure delivered with the business content for SAP BW 1. SQL cod The following error may also. General Ledger (New): Line Items Leading Ledger (0FI_GL_14) Sample Business Explorer (BEx) Queries are delivered on top of the MultiProviders FI-GL: General Ledger and FI-GL: New GL: FI-GL: Actuals Balance and Flow Comparison. ACDOCA, mismatch,. Please see picture for reference. 2) Check whether aggregate behavior is maintained for key figures in DSO and infocube. SAP BW/4HANA 1. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). About FI Extractors Mechanism. Table of Origin. Was working on the extractor - 0FI_GL_21 which has very less documentation. The safety parameter will take care of the delta loads for all the FI data sources. So I went the other route - I went to source system in RSA5 and activated it. 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. 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. 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. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. Note. 09. 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 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. Enhancement issue with 0FI_GL_10. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. This DSO contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). 6 million records – 100 mins (0FI_GL_14 7. 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. 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). SAP Knowledge Base Article - Preview. ADD. 3. We have changed also the SMQS qRFC monitor with RFC destination to None. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. 1 Document History The following table provides an overview of the most important changes to this document. All is standard. what are the application components we have to use fill the setup table. The extrator is the function module FAGL_GET_TT_DATA_LEAD for the data source. Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. 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. 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). Sub Modules. We are in the process of testing the 0FI_GL_10 datasource and its delta capability when loading the 0FIGL_O10 ODS. Relevancy Factor: 1. RSS Feed. MultiProviders. Hello experts, I'm currently working on loading data from DS 0FI_GL_10, the data flow is as follows, 0FI_GL_10 -> 0FIGL_O10 -> 0FIGL_C10,first I excuted the infopackage as delta initialization with data update and. 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. We are doing an RRI from the Financial Statements to the GL Line Items. . Description: General Ledger: Leading Ledger Balances. 4 on HANA or if we use the new extractors. Fields need to be enhanced are TSLVT TSL01. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as they dont have that tick. 10 characters required. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. About the 0FI_AP_4 / 0FI_AP_30 Datasources . ) Now, for that same particular combination (in DSO Active Table) some records are missing. Chart of Account Section and b. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. 0FI_AP_1 : Vendors: Transaction figures. However, I do not want this new field in the second system. Actual data : Version = '001' 2. 1. Understood. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. Glenlyon Norfolk School (GNS) is an independent, co-ed, university preparatory day school in Victoria and Oak Bay, British Columbia, Canada. I test it on rsa3 tx and the balance value is zero. 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. About the 0FI_AR_4 / 0FI_AR_30 Datasource . The problem faced here was particularly relating to 0FI_GL_10 Datasource. ". 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. 0FI_TAX_4. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. Drill Down in P&L Report. The latter is available from ECC60 onwards. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 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.