1st loading scenario: This is the sm37 of ECC6. Data source setup table filling. The DSO enables balance and flow reporting for defined periods. SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats (0UC SALES STATS 02) and Mass Extraction Activity for FI-CA: BP Items, Payments and Payments Lot, Promise to Pay, Installment Plans, Settlement Documents, Returns and Checks. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. Hi everybody, I met a delta problem related to 0FI_GL_10. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. Click more to access the full version on SAP for Me (Login required). I tried to find these new extractors in the BI content but couldn't find it. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. If the custom fields available in the std table, at least I can update the property of these. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. 1. FI-TX. 668 Views. Fields of Origin in the Extraction Structure - Accounts Receivable: Line Items. I am using the data source 0FI_GL_10 and I am creating an InfoObject to hold the 'ACTIV' field. I am stuck at mapping BPC dimensions and properties to BW info-objects. It is commonly understood that the (yellow) key fields of FAGLFLEXT must also be key fields in the DSO on the BI side, so that totals are not overwritten. RSS Feed. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. We are BW4HANA system. I test it on rsa3 tx and the balance value is zero. 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. About this page This is a preview of a SAP Knowledge Base Article. 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. 0 October 2010 Initial versionPost Pre prod refresh, our timestamp for the datasource 0FI_GL_10 got reset. You should be fine running both, but they have different purposes: Technical name: 0FI_GL_10 General Ledger: Balances, Leading Ledger is based on the. To do so, go to the configuration menu path Financial Accounting > Financial Accounting Global Settings > Ledgers > Ledger > Define Settings for Ledgers and Currency Types or use Transaction FINSC_LEDGER. It is available only with a minimal version of ECC (ECC 6. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. Purpose. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. About the 0FI_AR_4 / 0FI_AR_30 Datasource . I m using 2 data sources : <b>0FI_GL_10</b> to load into ODS 0FIGL_O10 and the second datasource <b>0FI_GL_4</b> to load into ODS 0FIGL_O02. 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. DSO key figures are set to "overwrite". There is not a single field is hidden in 0FI_GL_10 DS. Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. e. - 0FI_GL_14: for line items. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. In the following table only the fields BIUKRS and FISCPER are filterable: Field in Extract Structure. Gajesh Nagesh. Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario. sap__0fi_gl_10: This model extracts the transaction figures from the leading ledger in the new General Ledger. 668 Views. The DSO enables balance and flow reporting for defined periods. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. As i checked in the System, there is no entry in this table. 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. 1392817 - Description of the delta procedure for the balance extraction. sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. My requirement is to enhance the 0FI_GL_10 data source from FAGLFLEXT (Totals) table. 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. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. Chart of Account Section and b. 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. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. For example: Number of records from RSA3 extract checker = 1000. 0A (BW PlugIn 2001. Never run an engine at a constant engine speed for long periods during the running-in period. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. 07. 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. 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. 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . The 0FI_GL_20 datasource contains data from all ledgers. 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. Experts: Extraction of data from 0FI_GL_10 (ECC 6. 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. Source structure: BKPF, BSEG. ISU BW Extractors. However there has been a migration of the FAGL table to FMGL table. The steps is following, 1. Daily debit and credit and balance for the period selected can be reported in local and foreign currency. SAP enhancement package 6 for SAP ERP 6. Non-leading ledgers can be created as per the local accounting rules in your country/region. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. Glenlyon Norfolk School (GNS) is an independent, co-ed, university preparatory day school in Victoria and Oak Bay, British Columbia, Canada. The system could not generate a syntactically correct test frame for function module FAGL_GET_TT_DATA_LEAD. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). Data. You therefore cannot test the function module using the test environment. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as they dont have that tick. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. However we do not see anything flowing into the delta queue in RSA7. We applied several SAP notes: 1. 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. Use SAP BW/4HANA Business Content delivers this field-based DataStore Object (advanced) as a first persistence layer of data replicated into a SAP BW/4HANA data warehouse. Regards, Leszek Technical name: 0FI_GL_10 Use This InfoSource contains transaction figures from the leading ledger of the new General Ledger. 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). The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. The ALV settings do not show any way to fix this. I test it on rsa3 tx and the balance value is zero. after every load completes based on this period the next period needs to get loaded. Check that in RSA7. 0 and BW 3. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 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. how to execute this DSO having 2 row data. 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. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. Introduction: This blog guides us through on how to Optimize the performance for FI Related Standard Datasources – 0FI_GL_10 & 0CO_OM_OPA_6. I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. doc no and doc pos can be used. 0FI_AR_4: Customers: Line Items with Delta Extraction FI - Accounts Receivable: 3. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. Based on my understanding the below Business Content Extractors pull from FAGLFLEXT and. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with. Version 0008 of DataSource 0fi_gl_4 - 10 /BIC/CCWA0FI_GL_4: Transfer struct. More Information. that is not extracing the data completly in the psa itself. ADD. 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. Dates are expressed in the format YYYYMMM. This DSO contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). 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. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. 2 0FI_AP_4 Customization. HSL16, KSL01. Follow. It was formed. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). The problem faced here was particularly relating to 0FI_GL_10 Datasource. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. Hi Shehzad, 0FI_GL_10 and GL_4 is used for leading ledger. Visit SAP Support Portal's SAP Notes and KBA Search. This is applicable for the following data sources. BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. Go to the update tab and select Initialize the delta process. Since the generated objects no longer correspond to the old active version, they were reset to inactive. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. Jul 20, 2012 at 10:30 AM. InfoSource 0FI_GL_4 transfers only. Functional Area. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). 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. I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the. 0FI_GL_14 (replacement to 0FI_GL_4) to be used for GL Line Item data extraction and mainly used for P&L Reports. The 0FI_GL_20 datasource contains data from all ledgers. Untill and unless this checkbox is ticked, you will not be able to see that field in RSA3. The fields in the datasource are more than the 16 allowed keys in the DSO,. Standard Approach: Normally in the general practices the extract structure is enhanced with the required fields and the data is populated using the external logic in the CMOD. 0VTYPE Value Type for. Please provide the code. 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. 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. 3FI_GL_XX_SI General Ledger Accounting (New): Line Items of Any Ledger (Generated) Factors / Delta Methods. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. The major issue with it is that it brings in 51 times the number of records because we have 16 periods and 3 currencies. . FL819. Delta determination using the procedure AIED (for example, DataSource 0FI_GL_10) If you choose this delta procedure, in step one, the TIMESTAMP field in the totals table is used to select all records that have been changed since the last delta load. Step-4: Creating function modules for each extractor enhancement. I have activated datasource 0FI_GL_10 for leading ledger, additionally generic extractors 3_* for the non-leading ledgers. The symptom materializes in d The note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. Unit - account Grp - FS Assertion - Control - 7 :Transformation. General ledger: Data for taxes on sales and purchases. This InfoSource is based on DataSource 0FI_GL_14. This data source is based on FAGLFLEXT and I want to enhance from the same table. Relevancy Factor: 1. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 4. while start Infopackage and choose parameter then having 2 row data. Problem is GL_1 has cumulated balance and GL_4 does not. This DataSource provides the line items in General Ledger Accounting from tables BKPF, BSEG, FAGLFLEXA, . CURTYPE=00 Transaction Currency. Please see picture for reference. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Unfortunately, the report consists of those data from a standard extractor named 0FI_GL_14 which involve with really huge SAP tables such as FAGLFLEXA. We then implemented steps in SAP note 1692484 as seen below but timestamp is still incorrect. 6 million records – 100 mins (0FI_GL_14 7. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. 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). 0FI_GL_10 ( Data Source )Relevancy Factor: 1. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. AIED. 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. In this case use FM EXIT_SAPLRSAP_001 as template. We are looking at implementing HANA Optimised FI-GL Business Content that came with BW/4HANA. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). 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. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. Relevancy Factor: 1. 1 Document History The following table provides an overview of the most important changes to this document. 2. When I load full loads, all the 1000 records are loaded. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. . the delivered extractors 0FI_GL_10 and 0FI_GL_4 to extract totals and. In particular, the. ACDOCA, mismatch,. Hi All, I have a requirement that needs to pull all the data from FI_GL table FAGLFLEXT. We have the requirement with the data from tables BSEG and BKPF Tables. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. It seems that all values that. 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. (ie posting date). Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. I need to activate the Remote cube 0FIGL_R10 as well as Virtual cube 0FIGL_V11 and should i use DS 0FI_GL_10. Any one have a solution how to test the sapr/3 and sap BW system. Let us say "RMVCT - Transaction Type" is available in the datasource but missing in the transfer rules. 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. I changed the record in ECC system, the streaming process chain did not bring the delta for next 15 runs, all the time it was 0. In this DS eg. All fields from the Infosource are transferred to the ODS object. 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. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. Regards. SM66 shows that 'Sequential Read of DB FAGLFLEXA' last a long time. 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. 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. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . DS 0FI_GL_10 -- iNFOSOURCE 0FI_GL_10 - DSO Write optimized. 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. mygns . 2 possible ways I can figure out are the following: 1) Copy 0FI_GL_10 to another customized datasource, but I don't know how to do it. Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. 2013 01:05:28 Job started0FI_GL_10 and FAGLFLEXT - Key Fields. 3269451-0FI_GL_10: DBSQL_SQL_ERROR when accessing table FAGLFLEXT. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. 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. In the extraction structure, there fields are marked as Hidden. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. Could someone help me understand delta mechanism for 0fi_gl_14?. 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 . . 0FI_AP_4 extracts data from the table BSIK (Open Items) and BSAK (Cleared Items). 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 0 more than a year back but then we stopped doing any delta loads from the datasource. Version Date Description 1. ADJ. For more information, see SAP. 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. 0FI_AP_3 : Vendors: Line Items. 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. Initialization was done With data transfer. RSS Feed. 0FI_GL_10 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. 0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). 0FI_ACDOCA_10 ; 0FI_ACDOCA_20 . Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. 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. Currently we are in SAP ECC 6. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. 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. In ECC, when asked functional folks, we got the inputs saying we need to use Group Currency field, which is KSL ( from FAGLFLEXT table ) . 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. Performance enhancements might be available for data extraction. our ECC system is on ERP on HANA with Simple Finance add-on. Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. 0FI_GL_10 extracts data from FAGLFLEXT table. FAGLFLEXT table for end of period balances. 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. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger Accounting. We have migrated classical/old GL to the new GL. For performance improvements for extraction, see SAP Note 1731175. 0FI_GL_10 General Ledger: Leading Ledger Balances 0FI_GL_10 is a delta-enabled Data Source that extracts the general ledger balances for only the defined 'leading ledger' in your source system. b) Now this is for extractor 2LIS_13_VITM , here RSA3 is showing correct number of records. I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC. 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 . 0FI_GL_4/14 all prev extractors were delta enable but why SAP has made new 0FI_GL_40 delta disable? Quite strange step. 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (Generated). Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). DataStore Objects. Financial Accounting: Accounts Receivable (SAP HANA-Optimized) Financial Accounting: Accounts Payable (SAP HANA-Optimized) Financial Accounting: General Ledger (SAP HANA-Optimized) Queries. Datasource : 0FI_GL_10. 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. . The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. The DataSources can then be used independently of one another (see note 551044). ) Now, for that same particular combination (in DSO Active Table) some records are missing. Click more to access the full. 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. We have used sap standard data source and DSO for the data extraction. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. All other ledgers, again if required, would require separate DataSources be created for each ledger. Unfortunately this standard content delivered datasource ( source system- ECC 6. The latter is available from ECC60 onwards. In order to work with 0FI_ACDOCA_10 you have to setup a DSO with overwrite mode (to process also document changes, clearings and reversals correctly) with the key fields as shown below. This InfoSource is based on DataSource 0FI_GL_14. Can you please tell me the how to do this . We are working on BI 7. Generated totals records DataSource 3FI_GL_xx_TT (xx = ledger) or 0FI_GL_10 does not extract any data in delta mode. Correction specified in the note: 1152755 have to be incorporated in order to resolve the issue with the AA data sources. 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. 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. 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. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. * For more information about source system IDs, see SAP HANA-Optimized BI Content. Index on FAGLFLEXT. Delta Update. 2. Hi All, Currently i am working on FI GL Extractors (New). Now in BW side I am creating infopackage for above extractor, then I do Init without data transfer and then I execute the delta infopackage. We are doing an RRI from the Financial Statements to the GL Line Items. 0 (=> SAP ERP 2004) and ECC 6. 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. Any particular reason for that? So If I want line item reporting my best solution will be RRI? Correct!! Question2: SAP recommended dataflow for new GL uses virtual cube 0FIGL_V10. 0. About this page This is a preview of a SAP Knowledge Base Article. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. FI-GL: GL - Line Items (0FI_GL_4) FI-GL: General. . As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. 6. 0FIS_GL_LINEITEM. DetaInit Simulation = 1 supported. the extracted no of. . 0FI_GL_10 for Balance Sheet reporting. The most important attributes of business entities are included, such as. For this I enhanced the 0fi_gl_10 DS and checked the data but its showing wrong document types. What are the advantages of using one over the other. Date Time Message text. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. after I map the fields , I checked the trnasformation, It is OK. 0fi Gl 10 Tables. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. 0. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. Now we have following system configurations. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). Extractor: BWFID_GET_FIGL_ITEM. 3) Before Delta Load all GL. About the 0FI_AR_4 / 0FI_AR_30 Datasource . 2. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. 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). This table contains field like Table name, FI Account Number, Business Area, Company code along with the date and time stamp of the. Company Codes Section. sap__0gl_account_attr: This model is used for loading G/L Account Number master data, originating from the ska1 source. what are the application components we have to use fill the setup table. This InfoSource is based on DataSource 0FI_GL_14. In ERP the number of fiscal periods per year is configurable. x DS)). 0FI_AP_1 : Vendors: Transaction figures. For all other ledgers, you have to. 0 PSA is bringing less number of records when compared to the records in RSA3 extract checker. And now the FAGLFLEXT is no longer populated with any FI. 0 (=> SAP ERP 6. In ECC 5. Since Release 3. Delta determination using the procedure AIED (for example, DataSource 0FI_GL_10) If you choose this delta procedure, in step one, the TIMESTAMP field in the totals table is used to select all records that have been changed since the last delta load. 1st loading scenario: This is the sm37 of ECC6. 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. Please suggest. Please advice how to add WBS Element to existing. However, the key field Ref.