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 ). 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. In ECC, when asked functional folks, we got the inputs saying we need to use Group Currency field, which is KSL ( from FAGLFLEXT table ) . The 0FI_GL_20 datasource contains data from all ledgers. About the 0FI_AP_4 / 0FI_AP_30 Datasources . 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. We have intilzed the delta one year back and we are pulling delta records to BW. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. . Dates are expressed in the format YYYYMMM. For Datasource 0FI_GL_12, Full load/Initial load extracts all versions of data: 1. The DSO enables flow reporting for defined periods. The DataSources can then be used independently of one another (see note 551044). Describing the Test Scenario. Source System for R/3 Entry* 0GN_R3_SSY. Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor:. Screen from ROOSOURCE table for. 0FI_GL_14 is based on tables FAGLFLEXA, BSEG, BKPF Functionally, this affects other financial modules like AP, AR, PCA (Profit Center Accounting) For ex: with new G/L. However, we have a problem in that splitting in the new GL in ECC 6. 2. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no. For FI AP - I have replicated the following datasources . The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. 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. This InfoSource is based on DataSource Raw Data of G/L Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA). DataStore object: /IMO/FIGL_D12. An initialization did delta to itself on the 20. Use corresponding exit FM as template and copy the import, Export, Table, Exception. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . Can I load another GL DS data into BI which has document type field and then create a multiprovider on both the cubes and generate a report. Is it reuire to create the statistics. Data source setup table filling. Missing document using 0FI_ACDOCA_10. here i found two BC Datasources. Issues loading 0FIGL_C10. Extractor: BWFID_GET_FIGL_ITEM. Step-4: Creating function modules for each extractor enhancement. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. There are lot of sap notes available for this strange behavior and its corrections. I am trying to create an InfoObject and I do not know what reference characteristic to use. 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 ). FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. . KDGRP to FSV Report. About the 0FI_AR_4 / 0FI_AR_30 Datasource . 3 million records – 13 mins (0FI_GL_14 ODP) / 2. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. Does it contain extra fu. 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. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. 1st loading scenario: This is the sm37 of ECC6. LIVE: Global News BC ; Global TV News BC ; breaking news & headlines, local weather forecasts, sports and traffic reports; your source for 7 day weather conditions from. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. Please help. 311 Views. 6. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. For more information, see SAP. In this case use FM EXIT_SAPLRSAP_001 as template. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. 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. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. InfoProvider for actuals data. And then you need to replicate it to BI. Introduction: In many BW Projects, we have seen that most of the time we need to enhance the standard FI_GL/AR/AP extractors and pull the data for additional fields of the base/origin tables. I am using the data flow . Performance enhancements might be available for data extraction. It is working fine at DEV, However after transport to QA, the custom fields are missing in the ROOSFIELD table at QA. 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 . Can you please tell me the how to do this . tcode to generate data. Search for additional results. 1. 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. 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 . line items respectively. However, the key field Ref. But it is not there in data source 0FI_GL_10 in ECC. The engine can be expected to use more engine oil. We have used sap standard data source and DSO for the data extraction. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). (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. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. To enable determination of the datasets, note 535016 must be installed in all. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. 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. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. Follow. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. Delta extraction 0FI_GL_10 VERY SLOW. I am using the Keyfigure 0VALUE_LC. The below mentioned are the key fields in the standard DSO : FIGL_O10. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. sap. Click more to access the full version on SAP for Me (Login required). We are working on BI 7. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. We are on ECC 5. The system could not generate a syntactically correct test frame for function module FAGL_GET_TT_DATA_LEAD. All other ledgers, again if required, would require separate Data Sources be created for each ledger. 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. Datasource : 0FI_GL_10. Source System of BW system. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. We faced this issue couple of years and has been stable for years now. 0 SP 18). SQL cod The following error may also. When I load full loads, all the 1000 records are loaded. Date Time Message text. 3. The standard data source for the Financials New Legder is 0FI_GL_10 General Ledger: Leading Ledger Balances, which fetches the data from the FAGLFLEXT Table using the Extract Structure FAGL_EXTSTRUCT_LEAD. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. How can I resolve this issue?0FI_GL_10 is a delta-enabled DataSource that extracts the general ledger balances for only the defined 'leading ledger' in your source system. 0FI_TAX_4. 0FI_AA_11; 0FI_AA_12; This is due to Asset Accounting data sources and FI Line item data sources uses the same Function Modules to fetch and update the time stamps for extraction. 3. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a key field. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). 2LIS_03_UM: Revaluations MM - Materials Management: 10. Description: General Ledger: Leading Ledger Balances. Diagnosis An error occurred in the source system. The latter is available from ECC60 onwards. Delta Tables. ADJ. We had installed 0FI_GL_10 and available in all the systems (dev/qa/prod). System must add buffer to timestamp because of the document saving time consuming. Version Date Description 1. Non-leading ledgers can be created as per the local accounting rules in your country/region. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. In BW, we always need to see. ". 0. We are looking at implementing HANA Optimised FI-GL Business Content that came with BW/4HANA. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. included. The performance of 0FI_GL_40 extraction is not good. The DataSources can then be used independently of one another (see note 551044). 668 Views. System must add buffer to timestamp because of the document saving time consuming. 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. DataStore object: /IMO/FIGL_D04. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. 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. TSL16). Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. 4 system with HANA database. A myth about 0FI_GL_10 Datasource. 0fi Gl 10 Data Tables Most important Database Tables for 0fi Gl 10 Data # TABLE Description Application Table Type; 1 : BSEG: Accounting Document Segment FI - Financial Accounting: Cluster Table 2 : RSDS: data Source in BW BW - Data Staging: Transparent Table 3 : BKPF: Accounting Document HeaderAssigned Tags. After doing Init with data transfer, check in RSA7 if the Current Status of the generic delta for 0FI_GL_10 is updated or not. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no longer be used. Note. the activation throws up these errors. I tried to find these new extractors in the BI content but couldn't find it. 2012th and today we have thrown the extraction delta, and ride like thing of 8 hours executing and still it has not raised ningun information to bw. Line Items of the Leading Ledger. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. based on basic cube 0FIGL_C10. Check table FAGL_ACTIVEC for the NewGL flag. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. Hi Team, While creating a transformation for 0fi_gl_10 to 0figl_o10. Version Date Description 1. Diagnosis. Cost center values are missing for some of the G/L account in FAGLFLEXT table while it is appearing in the BSEG and FAGLFLEXA tables. 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. SAP enhancement package 6 for SAP ERP 6. 0FISCPER Fiscal year / period. W/ VAL. GL is created initially for Chart of Account section and further extension is done to different company codes on need basis. Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. As. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with. 1. 0FI_AP_20 : Vendor Balances. If not present go to SM30. All other ledgers, again if required, would require separate Data Sources be created for each ledger. 1 Document History The following table provides an overview of the most important changes to this document. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. For more information, see SAP. It was formed. Below are the details of the FSV. In the S/4HANA system, 0FI_GL_10 returns error when using RSA3 to test: SQL Error the database registered an internal error. The DataSources can then be used independently of one another (see note 551044). 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. FI-GL: New GL - Balances - /IMO/D_FIGL12. Table contains 16fields(HSL01. For all other ledgers, you have to create separate DataSources . Check that in RSA7. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. The target applications (referred to as ODQ ‘subscribers’ or more generally “ODP Consumers”) retrieve the data from the delta queue and continue processing the data. Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. For performance improvements for extraction, see SAP Note 1731175. About this pageDataSource Transactional Data: 0FI_GL_40. This InfoSource is based on DataSource 0FI_GL_12. Problem with Delta: Is it required to have the 0RECORDMODE Infoobject in DSO Write optimized. I use 10 and 14. ca. DSO key figures are set to "overwrite". The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. Prerequisites. Source structure: BKPF, BSEG. Average Daily Balance. It is available only with a minimal version of ECC (ECC 6. . 0fi_gl_10. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). the extracted no of. doc no and doc pos can be used. As i checked in the System, there is no entry in this table. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. 1. 10 characters required. I create some GL documents in the source system. 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). The fields in the datasource are more than the 16 allowed keys in the DSO,. 2) In the customer exit used for the first system, I have to write some code to check the CALLER system. sap. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. This DataSource provides the line items in General Ledger Accounting from tables BKPF, BSEG, FAGLFLEXA, . The problem faced here was particularly relating to 0FI_GL_10 Datasource. 0FI_GL_10 for Balance Sheet reporting. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. . 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). Implementing them has nothing to do with 0FI_GL_10 or 4. 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_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. My understanding is that 0FI_GL_10 supports multiple deltas based on TIMESTAMP in the table FAGLFLEXT. 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. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. This increase in performance compared to a full data extraction on the same ODP datasource is due to. Filled with the 2-digit system ID of the connected source system. My explanation in this blog is focusing on transfering data with ODP to another system. Reduce throttle to idle engine speed between WOT running so that engine temperature drops. I init the datasource, and get the right data. 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. Functional Area. I checked in 0fi_ar_4 there is document type. Check if New GL is activated in ECC. Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. "Termination occurred in the ABAP program " GP_GLX_FAGLFLEXT " - in"FI-GL: Line Items - /IMO/FIGL_D04. 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. As i checked in the System, there is no entry in this table. This explains how to convert from using the old extraction procedure (DataSources 0FI_AP_3 and 0FI_AR_3) to the new one (DataSources 0FI_GL_4, 0FI_AP_4 and 0FI_AR_4). sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). 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. If someone could provide a method for how to determine the InfoObject for a field from a data source that would be great. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. 1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table. Understood. sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. 0FI_GL_14. Sub Modules. This DataSource is delta-compatible. 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. In this case use FM EXIT_SAPLRSAP_001 as template. 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. 2 0FI_AP_4 Customization. So questions as below. I am validating few gl accounts values related to 0FI_GL_10 both in R/3 and BW. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. And now the FAGLFLEXT is no longer. This datasource after init with data transfer, Delta bringing wrong values . 1. I have searched in SCN but no extractor found which pulls all the data from this FAGLFLEXT table. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. But i havnt understand the structure of this datasource. We are implementing SEM BCS60 and ECC60 with new GL. Hi, We have done Full Uploads by executing the 0FI_GL_10 infopackage in SAP BI. Now we have following system configurations. If timestamp is not updated,in your R/3 system check if the Function Module "BWIP_WRITE_AEDAT_POINTER" is present in Table TPS31. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. 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. The documentation states GL_1 is for transaction while GL_4 is. At the time of init with data transfer the balance in BW report exactly matches that in ECC . The most important attributes of business entities are included, such as. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. Unit - account Grp - FS Assertion - Control - 7 :Transformation. With New G/L in SAP ECC 6. * For more information about source system IDs, see SAP HANA-Optimized BI Content. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. Why 0FI_Gl_40 General Ledger Accounting: Line Items datasource is not delta supported? Full upload of FI-GL line item for any big industries is not a feasible solution. The ALV display doesn't show technical. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. Nov 15, 2016 at 09:09 AM. 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. 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. Symptom. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. We have migrated classical/old GL to the new GL. 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. after every load completes based on this period the next period needs to get loaded. Visit. (0FI_GL_10, 3FI_GL_XX_TT) But it is not useful for me. The full or delta extraction job is terminated by the following runtime error: RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To About this page This is a preview of a SAP Knowledge Base Article. hi professional! using 0FI_GL_10 Data are wrong in case of an Delta extraction to PSA. but Cumulative balance of 0FI_GL_10 extractor is not matching with. 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. I not enhance 0FI_GL_10. mygns . However we do not see anything flowing into the. I'm designing GL summary report. DataStore Object (advanced): CM S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA) (/IMO/C_FI401) No Field Rules. Application: FI - General Ledger Accounting. We know that New GL data stores in FAGLFLEXT table. This InfoSource is based on DataSource 0FI_GL_14. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. ISU BW Extractors. Currently we dont have any field coming from 0FI_GL_10 datasource to include characterstics like Country and Material. 0, version for SAP HANA. Hello Friends please suggest me at the earliest, We have a critical GL Model designed in which we have flow as below. 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. It's always 0 in RSA7 transaction for 0FI_GL_10. For all other ledgers, you have to. RSS Feed. Now, I used RSDS in BW to try to replicate it in. Enhancement issue with 0FI_GL_10. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 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. Drill Down in P&L Report. 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. A myth about 0FI_GL_10 Datasource. Extract structure OLTP: DTFIGL_4. KDGRP to FSV Report. However, I do not want this new field in the second system. You may choose to manage your own preferences. 1505 Views. 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. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. Follow RSS Feed Hi, While using the data source 0FI_GL_10 could someone please shed light on which table should be used to load actual data among FAGLFLEXA and FAGLFLEXT for SEM-BCS company consolidation purposes. 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. I want to load this extractor through a process chain based on every POPER. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). 01. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. Use corresponding exit FM as template and copy the import, Export, Table, Exception. Please see picture for reference. Dear All, For FI related below data sources i want to do full upload. ACDOCA, mismatch,. Yes its a normal procedure as we do for other data sources. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. 1 Answer Sort by: Best Answer Vote up 0 Vote down SAP Support Feb 09, 2023 at 03:59 AM Sine 0FI_GL_10 is a totals extractor for balances, you can use. what are the application components we have to use fill the setup table. 0 more than a year back but then we stopped doing any delta loads from the datasource. 2873265 - 0FI_ACDOCA_10: Missing clearing info in delta mode. 0 October 2010 Initial versionIn particular, the extract structure contains no fields from Accounts Receivable and Accounts Payable Accounting. 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. I try with the old data source 0FI_GL_10 and it works just fine, it brings me the cumulative balance good, but I'm using the standard business content for hana. Functional Area. 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. IDoc (Intermediate Document) is a standard SAP document format. 0A (BW PlugIn 2001. In this DS eg. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. It runs for several days and fails due to connectivity issues after several days (5-6). 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 ). For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013. Looking in the table. RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To . 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. 0 Ehp3 SP2 ) does not provide Material No. 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: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. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. Procedure. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). InfoProvider for BPC planning dataThis is the third part of the 3 part blog series – Part I – Reading List and Pre-Upgrade Checks & Activities. Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. 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 delta mode, data requests with InfoSource 0FI_AR_4 and InfoSource 0FI_AP_4 do not provide any data if no new extraction has taken place with InfoSource 0FI_GL_4 since the last data transfer. 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. But when I am matching 0FI_GL_10 DS with 3FI_GL_AA_TT DS I found that RLDNR - Ledger in General Ledger Accounting, RUNIT - Base Unit of Measure and RRCTY - Record Type fields are not available under 3FI_GL_US_TT DS. I made a settings change in BWOM_SETTINGS table with PARAM_NAME = BWFIOVERLA and PARAM_VALUE = 'X'. It contains the complete history of the loaded data. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. Line items can be requested in the general ledger view and in the entry view. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). Name of Target InfoObject. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. Follow. The safety parameter will take care of the delta loads for all the FI data sources. About this page This is a preview of a SAP Knowledge Base Article.