I had operated info package in full update, then did initialize without data. 0 onwards, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled in BI side you have to use data model. I am trying to create transfer rules for one of the datasource '0FI_GL_10'. 0 October 2010 Initial versionPost Pre prod refresh, our timestamp for the datasource 0FI_GL_10 got reset. For more information, see SAP. The symptom. My explanation in this blog is focusing on transfering data with ODP to another system. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. Full load. Please see picture for reference. the activation throws up these errors. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. I tried to find these new extractors in the BI content but couldn't find it. Name of Target InfoObject. 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. DataStore Object (advanced): CM S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA) (/IMO/C_FI401) No Field Rules. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. 1. 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. This InfoSource is based on DataSource 0FI_GL_14. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. 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. You may choose to manage your own preferences. The extrator is the function module FAGL_GET_TT_DATA_LEAD for the data source. I've searched the forum and read this "0FI_GL_10 enhancement" post. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. 0FI_GL_10 for Balance Sheet reporting. </u>From SAP BW - There is one data-source 0FI_GL_4 is not been activated. the extracted no of. "Totals Table FAGLFLEXT will be automatically enhanced with the Customer Enhancement CI_FAGLFLEX04. However, we have a problem in that splitting in the new GL in ECC 6. I added custom fields to the standard data source 0FI_GL_10. The following BI Content objects are available:0FI_GL_14: General Ledger (New): Line Items Leading Ledger: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 0FI_AP_4: Vendors: Line Items with Delta Extrcation:After going through the help document I understood that the BI 7 version came up with General Ledger Accounting (New), If this is true then can we still use 0FI_GL_04 in Ecc and BI7. here i found two BC Datasources. 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. For example, the GL Line item (0FI_GL_14) data extraction from ECC pre-HANA DB upgrade extracted 2. Hi Nilesh. I want it either in 0FI_GL_14 or 0FI_AP_30. - 0FI_GL_14: for line items. GoTo Schedule tab and start the extraction. Hi All , I'm in mid of implementing P&L and Balance sheet reporting via BW and not sure which data source to use . Financial Accounting: Accounts Receivable (SAP HANA-Optimized) Financial Accounting: Accounts Payable (SAP HANA-Optimized) Financial Accounting: General Ledger (SAP HANA-Optimized) Queries. Transformation Rule. Hello Gurus, I have to add a new field in 0FI_GL_10 DS, already i loaded the data but functional team need 1 more field. RSS Feed. But datasource conts three fields Accumulated balance,Credit Total,Debit Total, Turn over with different currency types. 2LIS_11_VAHDR: Sales Document. regards. In step two, all logically dependent records of these records (for example, the credit record. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp. 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. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. Extractors only exist for the source system from R/3 Release 4. Dear All, For FI related below data sources i want to do full upload. When we extracted . Daily debit and credit and balance for the period selected can be reported in local and foreign currency. Table contains 16fields(HSL01. 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. . Now We found that there is a different table called FAGLFLEXA & FAGLFLEXT , Which will have the combined data from BSEG , BKPF and some other tables. InfoSource 0FI_GL_4 transfers only. Jan 19, 2011 at 10:09 AM Delta mechanism for 0fi_gl_14. 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. Only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the BW. Visit SAP Support Portal's SAP Notes and KBA Search. FI-GL: New GL - Balances - /IMO/D_FIGL12. Delta extraction 0FI_GL_10 VERY SLOW. I wolud like the test the 0FI_GL_10 in SAPR/3 and SAP BW system for reconcilliation . 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. Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14? Is it preferred to use one over another one? Should both be used? Thanks, Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14? I have loaded 0FI_GL_10 datasource in BW Production with below steps: 1. I test it on rsa3 tx and the balance value is zero. before creating report, I did initial level of data validation 0FI_GL_10 data with SAP provided GL summary Tcode FS10N data. However there has been a migration of the FAGL table to FMGL table. System Response Caller. data using Tcode : RSA3 for datasource 0FI_GL_12 we are getting all the values for the debit, credit and Turnover, however . 2) Run Delta infopackage to get rsa7 records. 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 ). However we do not see anything flowing into the delta queue in RSA7. I am using the FI data source 0FI_GL_10. Procedure. 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. 668 Views. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). I know nothing about 0figl12. 1) first delta init load to PSA (yesterday 08:00 pm) 2) delta load to PSA (today 09:30 am) 3) full load to PSA (tThe 0FI_GL_10 datasource contains data from the Leading Ledger. W/ VAL. 0 (=> SAP ERP 6. This InfoSource is based on DataSource 0FI_GL_14. KSL16, TSL01. Hi All, We are using 0FI_GL_10 Datasource to extract General ledger data. Line Items of the Leading Ledger. 3. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. The extractor calculates the same key figures as transaction GADBKFC. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. My Question is on the Balance field in the Line Items. It contains the complete history of the loaded data. . 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 . Please let me know scenario if I am using FI extractor 0FI_AP_4 & RSA3 is showing 0 records. We know that New GL data stores in FAGLFLEXT table. VALUETYPE = 20) then it will be available in 0FI_ACDOCA_20 extractor). [Enter your Keywords here. 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. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. And now the FAGLFLEXT is no longer populated with any FI. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. Prerequisites. 2069 Views. For all other ledgers, you have to. Follow RSS Feed Hi, We are using 0fi_gl_14 DS for extracting leading ledger's line item data. We are using the datasource 0FI_GL_40 (G/L Accounts: Line Items) for our reporting requirements in BI system (BI 7. General ledger: Data for taxes on sales and purchases. As a prerequisite for using this note, you must have been using the old DataSources (FI_AP_3 and FI_AR_3) and intend to replace them with the new ones (0FI_GL_4, 0FI_AP_4 and 0FI. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. the delivered extractors 0FI_GL_10 and 0FI_GL_4 to extract totals and. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. We are BW4HANA system. Source structure: BKPF, BSEG. Steps I've already performed: Checked and found that the extract structure for 0FI_GL_10 (called FAGL_EXTSTRUCT_LEAD) aleady contains this field. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. 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. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. e. Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. The DSO enables balance and flow reporting for defined periods. The performance benefit of a delta execution of the 0FI_GL_14 ODP is from 74% to 86%. 0 SP 18). 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. Chart of Account Section and b. 1 million records in 56 mins to PSA and extracted 2 million records in 62 mins to PSA post-HANA DB upgrade. Dear Experts, I have initialized infopackage (init without data transfer) for 0FI_GL_10 datasouce and delta is enabled in ECC RSA7. InfoProvider for actuals data. 2) All key figures 0BALANCE,0DEBIT and 0CREDIT in DSO(0FIGL_O10) has the transformations with summation in Aggregation not overwrite. 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. Relevancy Factor: 1. Message no. InfoSource 0FI_GL_4. 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 . Timestamp Tables. This InfoSource is based on DataSource 0FI_GL_14. All other ledgers, again if required, would require separate Data Sources be created for each ledger. If the CALLER is the first system, perform the. This data source is based on FAGLFLEXT and I want to enhance from the same table. 0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). Extractor: BWFID_GET_FIGL_ITEM. currently we don’t have data, if we keen some plan data( i. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . Use This DataSource extracts the totals records from the leading ledger in the new General Ledger. 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. Problem is GL_1 has cumulated balance and GL_4 does not. Page Not Found | SAP Help Portal. However, I do not want this new field in the second system. in the 0FI_GL_4 extractor. In ECC, when asked functional folks, we got the inputs saying we need to use Group Currency field, which is KSL ( from FAGLFLEXT table ) . Init without data transfer. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. An initialization did delta to itself on the 20. Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10 | SAP Blogs Relevancy Factor: 2. 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. 0FI_AA_11 0FI_AP_4 0FI_AP_6 0FI_GL_4 0FI_AR_4 0FI_GL_10. ] , KBA , BW-BCT-FI-GL , BW only - General Ledger , How ToDelta Extract Stage was tested with custom Datasources and with the following standard Datasources:In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). Dates are expressed in the format YYYYMMM. It contains the complete history of the loaded data. 1392817 - Description of the delta procedure for the balance extraction. But when new FI document appears (new entry in FAGLFLEXT), no Delta Queue appears in SMQ1 transaction. Follow. " 0FI_GL_8 General Ledger: Statistical Key Figures". Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor: 1. 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. The extraction procedure delivered with the business content for SAP BW 1. But when I checked table BWOM2_TIMEST, there is no entry for the above data source. It's always 0 in RSA7 transaction for 0FI_GL_10. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with. 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). 3. DetaInit Simulation = 1 supported. Field COST_ELEM is missing in Data Source 0FI_GL_10 | SAP Community Relevancy Factor: 1. 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. 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 CDS view provides access to all details of a G/L account line item including the most important business entities, such as G/L account, company code, cost center or profit center (without the ledger). In this DS eg. If not present go to SM30. This InfoSource is based on DataSource 0FI_GL_14. . Please suggest. The latter is available from ECC60 onwards. 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. The ALV settings do not show any way to fix this. e. This might be a case of where in extractor has not pulled up the right data. Can't Initialize Delta on 0fi_gl_10 datasource | SAP Community Relevancy Factor:. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger. 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. 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. 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 . This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. 2. . 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. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. Because If I use overwrite in Aggregation all GL Account values are incorrect in InfoCube(0FIGL_C10). 0FI_AP_4 extracts data from the table BSIK (Open Items) and BSAK (Cleared Items). The balance should be changed. The following are the few design considerations when reporting for New General Ledger Accounting module is implemented in SAP BW. The DSO enables balance and flow reporting for defined periods. The 0FI_GL_10 datasource contains data from the Leading Ledger. 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. 0)0FI_GL_10 Datasource. 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. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 11. Thanks. For FI AP - I have replicated the following datasources . We also have Line Item. 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. hi professional! using 0FI_GL_10 Data are wrong in case of an Delta extraction to PSA. Functional Area. 0fi_gl_10. More Information. We would like to make it a drilldown able report on Material and Country. 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 0FI_GL_11: General Ledger: Balances of Leading Ledger via Line Items: FI - General Ledger Accounting: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction: FI - General Ledger Accounting: 0FI_GL_20: G/L Accounts: Transaction. 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. But it is not there in data source 0FI_GL_10 in ECC. 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. 4 on HANA or if we use the new extractors. TSL16). Which is built on 0FI_GL_10---> 0FIGL_C10---> 0FIGL_V10. 0FI_GL_10 vs. 0 more than a year back but then we stopped doing any delta loads from the datasource. Describing the Test Scenario. Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. You can use this DataSource to extract average daily balances (ADB) and other key figures for ledger dimensions to the FI component. MultiProviders. Use corresponding exit FM as template and copy the import, Export, Table, Exception. Fields of Origin in the Extraction Structure of 0CO_OM_CCA_9. 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. I went to FAGLBW03 t-code in ECC as mentioned in below screenshot but couldn't find Z1 ledger. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. 0FI_AP_3 : Vendors: Line Items. Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. Write a program and in the process chain, when once a POPER is gettting populated eg: 001 or 002, etc. The documentation states GL_1 is for transaction while GL_4 is. Delta Update. what are the application components we have to use fill the setup table. 0FIS_GL_LINEITEM. Filled with the 2-digit system ID of the connected source system. MultiProviders. sap. Worked extensively in the Finance - Accounts Payable (FI-AP) -. When we jump for the Income Statement or P&L, the jump reports shows the correct value. 0? 2)what is the difference between 0FI_GL_04 and 0FI_GL_14? 3) Is there any material or link or pdf that explains more clearly about FI - GL. Technical Name of Target InfoObject. With New G/L in SAP ECC 6. I've been specific in the WHERE clause of the coding to restrict the result set to a specific document number. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. This DSO contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). I am using the FI data source 0FI_GL_10. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. There are no changes in the system and the extraction is running already for 3 months but last Tuesday we encountered a long running time of job in ECC6. Below are the details of the FSV. while start Infopackage and choose parameter then having 2 row data. We are working on BI 7. Generally-used fields are as follows:Transformation. Skip to Content. Datasource Type: Transaction Data Extractor. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. For more information, see SAP Note 1523670. 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. Nov 15, 2016 at 09:09 AM. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. The indexes can be primarily created for the fields: TIMESTAMP, RACCT & PRCTR. Can anyone pls clarify this for me. We applied several SAP notes: 1. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. DSO key figures are set to "overwrite". 6. As i checked in the System, there is no entry in this table. 0FI_AP_20 : Vendor Balances. I use 10 and 14. 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. Go to the update tab and select Initialize the delta process. Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. tcode to generate data. From the OBJNR of the totals record (places 3-6 of the object number) From the OBJNR of the totals record (places 7-16 of the object number) From the OBJNR of the totals record (places 17-24 of the object number) Whether SSME or SSMED is filled depends on the category of the. Version Date Description 1. Diagnosis An error occurred in the source system. 0 October 2010 Initial version In particular, the extract structure contains no fields from Accounts Receivable and Accounts Payable Accounting. :) Please help us on the below issue as it seems to be ITSP migration ( BW - HANA) issue so that is the reason unable to activate the Datasource from the F50 . 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. based on basic cube 0FIGL_C10. 0VTYPE Value Type for. 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. 311 Views. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. 0FI_AP_1 : Vendors: Transaction figures. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. FI-GL: Actuals/plan/budget: Balance and Flow Comparison. As in the past we have performance problems (especially with the extractor 0FI_GL_14), we found some notes concerning the new FI-GL extractors that have been released to decide, if we continue with the 0FI_GL_10 and 0FI_GL_14 on BW 7. Search for additional results. If any of you implemented custom GL line item level generic data extraction, please let me know how you handled the delta for your generic extractor. I also checked for 0FI_GL_10 and 14 but both are not pulling all the values from this table. As per Note 410799, the Structure CI_BSIK was created to include the additional fields. Also if you have not yet migrated the transfer and update rules to Transformations, you need to do that, and then create DTP to load the data from PSA to the Cube. 0FI_AR_4: Customers: Line Items with Delta Extraction FI - Accounts Receivable: 3. 6 million records – 100 mins (0FI_GL_14 7. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. 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. Was working on the extractor - 0FI_GL_21 which has very less documentation. Mandatory. Performance enhancements might be available for data extraction. Data source setup table filling. Activating newGL doesn't mean the tables BSEG, BKPF will be redundant. Need your expert advice, I've initialized 0FI_GL_10 but the delta is not working afterwards, citing that the timestamp is incorrect. IDoc (Intermediate Document) is a standard SAP document format. Currently we have ECC 5. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. The fields in the datasource are more than the 16 allowed keys in the DSO,. So we enhanced it (using append structure populated in CMOD). A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. 3) Before Delta Load all GL. You may choose to manage your own preferences. I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. In DSO Transfered Records are 60264 and Added Records are 47034. Is it reuire to create the statistics. 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. 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). So we added ZZBUDAT and ZZKDGRP to source 0FI_GL_10 in RSA6. Implementing them has nothing to do with 0FI_GL_10 or 4. But it is not easy to find out how the buffer are given and what is the value, this blog post will help you to understand and get necessary information. I have gone through certain threads and found out that we will have to generate our own data source for any other ledger. 0FI_GL_10 gives balances for the leading ledger and 0FI_GL_14 gives line items for the leading ledger. Description of Field in Extract Structuree. . 6 or higher. 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 ). 0FI_GL_10 General Ledger: Balances, Leading Ledger. The problem faced here was particularly relating to 0FI_GL_10 Datasource. Please provide the code. 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. 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. 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. In this cases we are exposing a DataSource with direct access on tables. About this page This is a preview of a SAP Knowledge Base Article. We are implementing SEM BCS60 and ECC60 with new GL. FL819. This should work. . 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. 0FI_AP_20 : Vendor Balances. Thanks, Manjunath. Reports can be based on any value type that is recorded in the source system.