Gajesh Nagesh. We had issues with GL10 DS too but our issue was that the keys do not match between the PSA and the ODS. 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. 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. Hence the Process Chains relating to 0FI_GL_10 Datasource were failing with TSV_TNEW_PAGE_ALLOC_FAILED dump. However, I do not want this new field in the second system. x DS)). Since you have installed the complete dataflow with the cubes, you will now have to create a InfoPackage for the DataSource. It successfully extracted data. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). 0FI_ACDOCA_10, delta, missing, fields , KBA , BW-BCT-FI-GL , BW only - General Ledger , How To . In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. x DS)). We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. 10: 0FI_GL_2: General ledger: Transaction figures - Cost of sales ledger : 11: 0FI_GL_8: General Ledger: Statistical Key Figures : 12: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction : 13: 0FI_GL_21: G/L Accounts: Balances : 14: 0ACE_CALC_RESULT: Accrual Engine: Calculated Accrual Values : 15:ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . 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. It runs for several days and fails due to connectivity issues after several days (5-6). Dates are expressed in the format YYYYMMM. Extractor Tables. With New G/L in SAP ECC 6. Please let me know how we can achieve this . Mar 27, 2015 at 06:46 AM Hi, Shortly, Comparing 0figl10 and 0figl14 you'll find a lot more in 0figl14. You may choose to manage your own preferences. 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. ADJ. Implementing them has nothing to do with 0FI_GL_10 or 4. However we do not see anything flowing into the delta queue in RSA7. Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14? Is it preferred to use one over another one? Should both be used? Thanks, Hi, Can someone explain to me the difference between 0FI_GL_10 and 0FI_GL_14?The simple step for FI load is. Visit SAP Support Portal's SAP Notes and KBA Search. Visit SAP Support Portal's SAP Notes and KBA Search. 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. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. RSS Feed. In this cases we are exposing a DataSource with direct access on tables. Since the generated objects no longer correspond to the old active version, they were reset to inactive. some Records are missing when we check Total Debit Postings & Total Credit postings. 0FIS_GL_LINEITEM. This InfoSource is based on DataSource Raw Data of G/L Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA). Now if i trigger delta IP then it is failing with source system erroiam having fi gl data source named as 0FI_GL_10 . [Enter your Keywords here. You're wondering to know using which fields as the selection could improve the performance. 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. The safety parameter will take care of the delta loads for all the FI data sources. Financial Statements are based on 0FI_GL_10 i. 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. 0. For Datasource: 0FI_GL_10 — Create Indexes on the New GL Summary Table (FAGLFLEXT). I am using the data source 0FI_GL_10 and I am creating an InfoObject to hold the 'ACTIV' field. We are doing an RRI from the Financial Statements to the GL Line Items. DSO key figures are set to "overwrite". We have intilzed the delta one year back and we are pulling delta records to BW. Delta Update. Fields like that (and a lot more) are only in 14. We are using the ODP mechanism for data extraction from S4. 01) schedules a daily job for this extraction daily and it takes approximately around 12 - 16 hours for daily data load. So now can I create a multiprovider on both and take document type and 0fi_ar_4 DSO and rest of the fields from 0fi_gl_10 cube and run a report. As. DataStore Objects. 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. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 4. 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. The Non-Leading Ledger — What is it? These ledgers, as stated above, work in parallel to the leading. This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10. It doesnot impact the currently configured datasources and their data. 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. Page Not Found | SAP Help Portal. Could someone help me understand delta mechanism for 0fi_gl_14?. IDoc s enable the connection of different application systems using a message-based. CURTYPE=00 Transaction Currency. It's always 0 in RSA7 transaction for 0FI_GL_10. This didn't give a very bad result, except for the account 129000 which represents the profit and loss for the year before. 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. First you need to install the datasource 0FI_GL_10 in ECC system in RSA5 transaction. We applied several SAP notes: 1. 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. Please share with me your suggestion or view. The 0FI_GL_10 datasource contains data from the Leading Ledger. Choose your transport. DataSource 0FI_GL_10 EOPCLNT030 could not be reset to the old active version. MultiProviders. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. This may be the behaviour of the key fields which leads to less no of records when data is transfered to BW side. 0FI_AP_20 : Vendor Balances. for Infosource 0fi_gl_10 - Structure 13 : BWOM_SETTINGS BW CO-OM: Control Data CO - Information System, iViews: Transparent Table 14 : RSDS DataSource in BW BW - Data Staging: Transparent Table 15 : ROOSOURCE Table Header for SAP BW OLTP Sources (Relevant From 2. . ZBW_ 0FI_GL_10; ZBW_ 0FI_GL_14; ZBW_ 2LIS_02_HDR; ZBW_ 2LIS_02_ITM . 0FI_GL_14. ADD. Version Date Description 1. It contains all the totals records (transaction. Procedure. Currently we have ECC 5. Timestamp Tables. . This InfoSource is based on DataSource 0FI_GL_14. We would like to make it a drilldown able report on Material and Country. (MATNR). 0FI_GL_10 General Ledger: Balances, Leading Ledger. We now realize we need the cumulated balance at a plant level for specific GL Accounts. My explanation in this blog is focusing on transfering data with ODP to another system. 0. Dates are expressed in the format YYYYMMM. 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. The structure gets. Search for additional results. The data records are read from table ACDOCA. Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. 0), there is an extractor for extracting totals records from the new General Ledger to BI: 0FI_GL_10. But when I checked table BWOM2_TIMEST, there is no entry for the above data source. Below are the details of the FSV. Filled with the 2-digit system ID of the connected source system. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). The problem is that when we extract INIT load. FI-GL: New GL - Balances - /IMO/D_FIGL12. Thanks, Manjunath. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. 1 Document History The following table provides an overview of the most important changes to this document. can not, 3FI_GL_0L_TT , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem . I Have a problem with the extracción delta of the extractor 0fi_gl_10. Unit - account Grp - FS Assertion - Control - 7 :Transformation. For all other ledgers, you have to create separate DataSources . sap__0fi_gl_14: This model extracts line items from the leading ledger in new General Ledger Accounting. Follow RSS Feed Hi, We are using 0fi_gl_14 DS for extracting leading ledger's line item data. <u>Now, I dont get the delta. 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 ). 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. 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. Hi Experts, I'm trying to extract the data from FLAGFLEXT table. I use 10 and 14. In the extraction structure, there fields are marked as Hidden. but that field not visible at RSA6,Extractor 0FI_GL_10 pulls data from table FAGLFLEXT. 2LIS_03_UM: Revaluations MM - Materials Management: 10. All is standard. I would like to consult the issue that I encountered in extraction of 0FI_GL_10. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. There are lot of sap notes available for this strange behavior and its corrections. For FI AP - I have replicated the following datasources . Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table. Fields need to be enhanced are TSLVT TSL01. DataSource Transactional Data: 0FI_GL_14 This DataSource extracts line items from the leading ledger in new General Ledger 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 . 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. Experts: Extraction of data from 0FI_GL_10 (ECC 6. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a. Non-leading ledgers can be created as per the local accounting rules in your country/region. In this DS eg. The current BW system (SAP BW 7. 0. There are situations, when the scheduled jobs are unscheduled during production push, the Delta’s stop functioning. So if you want data for Non leading ledger , you will have to implement 3FI_GL_xx_SI, and 3FI_GL_xx_TT as required. BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. 09. So questions as below. When we extracted . Delta Tables. Technical name 0FI_GL_14 General Ledger Accounting (New): Line Items of the Leading Ledger is based on the BSEG table of accounting. 0FI_TAX_4. CURTYPE=10 Local Currency CURTYPE=00 Transaction Currency Dates are expressed in the format YYYYMMM In ERP the number of fiscal periods per year is configurableI'm using the datasource 0FI_GL_12, it brings me the debit and credit value good, but the balance (Accumulated balance) is on zero. System Response Caller. . . 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. 0VTYPE Value Type for. My Question is on the Balance field in the Line Items. Implementing generic extractor is not a. for Infosource 0fi_gl_10 - Structure 13 : BWOM_SETTINGS BW CO-OM: Control Data CO - Information System, iViews: Transparent Table 14 : RSDS 0FI_GL_10 Datasource. All planned Versions <> 001 However during Delta load it extracts only actual data (Version = '001') but no planned versio. And now the FAGLFLEXT is no longer populated with any FI. InfoProvider for BPC planning dataThis is the third part of the 3 part blog series – Part I – Reading List and Pre-Upgrade Checks & Activities. Hi, I wish to export the RSA3 output from my standard 0FI_GL_10 extractor with technical names of the fields. InfoProvider for actuals data. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information. 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). Dear All, For FI related below data sources i want to do full upload. Debit postings are Tally but credit postings are. 0A (BW PlugIn 2001. The old active version of DataSource 0FI_GL_10 EOPCLNT030 can no longer be used. 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. Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. Hi , We have a requirement to get MATNR to 0FI_GL_14 DS. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. With Simple Finance, ACDOCA table will be the primary table. hi professional! using 0FI_GL_10 Data are wrong in case of an Delta extraction to PSA. In this case use FM EXIT_SAPLRSAP_001 as template. Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. SM66 shows that 'Sequential Read of DB FAGLFLEXA' last a long time. 0FIGL_C10 is getting data from source 0FI_GL_10 through ODS. 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 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. for Infosource 0fi_gl_4 0 - Structure 12 : DTFIGL_4: Extract Structure: General Ledger Line Items to BW FI - Financial Accounting: Structure 13 : ROOSFIELD: DataSource FieldsHi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. We faced this issue couple of years and has been stable for years now. 1. the extracted no of records may not. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. . 1. Fields like that. 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. Visit SAP Support Portal's SAP Notes and KBA Search. A myth about 0FI_GL_10 Datasource. To enable determination of the datasets, note 535016 must be installed in all. DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. Yes, you can use the GL_11 datasource in place of GL_10. It is used as a source for reconstructions without the need to access the sources again. Hi All, Currently i am working on FI GL Extractors (New). Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. Click more to access the full version on SAP for Me (Login required). The DSO enables balance and flow reporting for defined periods. 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. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. Describing the Test Scenario. I have made an enhancement to extractor 0FI_gl_4 using EXIT_SAPLRSAP_001 and FUNCTION ZXRSAU01 in our DEV Client. Please help. Yes. e: Company code: 1300 and GL Account Number:20340010 till here all the values are matching. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. Table contains 16fields(HSL01. It is available only with a minimal version of ECC (ECC 6. Extractor: BWFID_GET_FIGL_ITEM. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4). DSO. ] , 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 ). 1), BW offers consistent data extraction to the BW system in the Delta update procedure for line items from General Ledger Accounting (FI-GL), Accounts Receivable Accounting and Accounts Payable Accounting (FI-AP). A number of GL postings have been created and we can pick them up using the extractor checker (RSA3) and the delta initialisation works OK. after every load completes based on this period the next period needs to get loaded. InfoSources. 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. All line items in fbl3n can be reported. Questions: Based on above. About the 0FI_AP_4 / 0FI_AP_30 Datasources . In ECC while Reconciling Data in FS10N and table FAGLFLEXT I found Difference in Monthly Data for a specific account in 2013 and remaining entire Data is Matching for other periods. RSM340, 0FI_GL_10, 0FI_GL_14 , KBA , BC-BW , BW Service API , BW-BCT-FI-GL , BW only - General Ledger , How To . Jan 19, 2011 at 10:09 AM Delta mechanism for 0fi_gl_14. I want to load Non-ledger data to BW, unfortunately 0FI_GL_14 extractor can support Leading ledger (0L) data only. 4 system with HANA database. The missing key was 'Business Transaction' and it did the trick for us. We have the requirement with the data from tables BSEG and BKPF Tables. About the 0FI_GL_10 / 0FI_GL_20 Datasources . line items respectively. My question is if "0FI_GL_10 - Leading Ledger Balance" and "0FI_GL_4 - Actual Line Items" datsources are already configured. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. FI-GL: New GL - Balances - /IMO/D_FIGL12. Also check if all the key fields are used in DSO and also all the fields are mapped at PSA level. Load : Init delta load. Source structure: BKPF, BSEG. About this page This is a preview of a SAP Knowledge Base Article. I have loaded 0FI_GL_10, 0FI_AR_4 and 0FI_AP_4 Init load on before two days, today I was checking in RSA7 (BW Delta Queue) where I didn't found any delta records while there are records created on both days in ECC system. The output is from Profit Center Accounting (PCA) Amounts expressed by currency using Currency type column (CURTYPE) CURTYPE=10 Local Currency. After the chain was removed from the scheduled and streaming, ran the DTP manually and it brought. SAP Knowledge Base Article - Preview. 0FI_GL_10: Data missing in BW (Business Warehousing) because RTCUR is not in field list. but Execute in Data tranfer Proc of this DSO then it's Sucsess and have only 1 row data. Datasource : 0FI_GL_10. InfoSources. 0. Drill Down in P&L Report. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. 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. About the 0FI_AR_4 / 0FI_AR_30 Datasource . New GL: If the source system still based on New GL, Then. 0FI_GL_10 for Balance Sheet reporting. Nov 15, 2016 at 09:09 AM. 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. 3 million records – 13 mins (0FI_GL_14 ODP) / 2. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. However we do not see anything flowing into the. For more information, see SAP. 0 Ehp3 SP2 ) does not provide Material No. As I'll need to report FMGLFLEXT information I need to enhance the 0FI_GL_10 datasource with these new fields. General Ledger Accounts (GL) in SAP are divided into two parts a. The latter is available from ECC60 onwards. Source structure: BKPF, BSEG. 0FIS_GL_LINEITEM. I have done following steps to get delta data. 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. General ledger: Data for taxes on sales and purchases. regards. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as. DataStore Objects. 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. Tried searching the forum but the answers keep suggesting to use the List mode (which has all the problems I stated above). IDoc (Intermediate Document) is a standard SAP document format. 1 million records in 56 mins to PSA and extracted 2 million records in 62 mins to PSA post-HANA DB upgrade. This data source is based on FAGLFLEXT and I want to enhance from the same table. Currently we dont have any field coming from 0FI_GL_10 datasource to include characterstics like Country and Material. " 0FI_GL_8 General Ledger: Statistical Key Figures". 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. 0COMP_CODE Company code. 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. 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. FSV report is based on Virtual cube 0FIGL_V10 and this cube is. 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 . In ECC 5. 0FI_AP_20 : Vendor Balances. 0 (=> SAP ERP 2004) and ECC 6. 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. 1392817 - Description of the delta procedure for the balance extraction. As soon as DataSource 0FI_GL_4 is loaded, it is the leading DataSource with regard to the time limits – such as maximum time (CPU date) – up to. 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. "1002272 - Fi-GL (new) DataSource 0FI_GL_10, 3FI_GL_*: Incorrect data in BI. 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. 2. We have changed also the SMQS qRFC monitor with RFC destination to None. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. 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. This InfoSource is based on DataSource 0FI_GL_12. MultiProviders. Hi everybody, I met a delta problem related to 0FI_GL_10. This table contains field like Table name, FI Account Number, Business Area, Company code along with the date and time stamp of the. About the 0FI_AP_4 / 0FI_AP_30 Datasources . Can anyone pls clarify this for me. 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. 1. When I checked RSA5 for these datasources, I saw that these new datasources are not ODP enabled as they dont have that tick. KDGRP to FSV Report. ) Field in. The ODQ uses the following three tables to store data: 1. This InfoSource is based on DataSource 0FI_GL_14. This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. 1505 Views. The DSO enables flow reporting for defined periods. -- Cube 0FIGL_C10. Hi , Could you please help us for the datasource 0Fi_GL_10 that we are using in our FI-GL development. 2LIS_11_VAHDR: Sales Document. About the 0FI_GL_10 / 0FI_GL_20 Datasources . The 0FI_GL_20 datasource contains data from all ledgers. (1) See SAP note 1012874 for FAQ on extractors 0FI_AP_* 0FI_AR_* 0FI_GL_* (except 0FI_GL_10, 0FI_GL_11, 0FI_GL_12, 0FI_GL_14) (2) T o extract the changed delta records , there are some pre-requisites steps to be performed on the SAP server as summarized in following steps: While using the data source 0FI_GL_10 could someone please shed light on which table should be used to load actual data among FAGLFLEXA and FAGLFLEXT for SEM-BCS company consolidation purposes. If. 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. 0COSTCENTER Cost Center. 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). Operational Data Provisioning (ODP) provides a new technical infrastructure for data extraction and replication. FI-TX. As per the SAP note 1012874, the table BWFI_AEDA3 is the table which is holding the Change data Pointer details. Now, I used RSDS in BW to try to replicate it in. - 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. 0FI_GL_4 (G/L Accounts- line items) Takes the data from the FI document tables (BKPF/BSEG) that are relevant to general ledger accounting (compare table BSIS). 0FISCPER Fiscal year / period. What are the advantages of using one over the other. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. 1) Init with data transfer setting in infopack and execute it to load the data,give some time to reach delta records to RSA7 - around 12 to 24 hrs*. doc no and doc pos can be used. Due to which our deltas did not bring any records to the BW system. Monitor the extraction. AIED. 0FI_GL_10 is based on table FAGLFLEXT 0FI_GL_14 --> 0FIGL_O14 (for Line item). Some of the infopackage and transfer rules are missing. Missing document using 0FI_ACDOCA_10. 2) Run Delta infopackage to get rsa7 records. Development:-To start the development we have to know the fields which are going to be enhanced and the base table for that fields. 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. DS 0FI_GL_10 -- iNFOSOURCE 0FI_GL_10 - DSO Write optimized. 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 ALV settings do not show any way to fix this. 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. The key figures from the ledgers are calculated for the ledger environment selected, and for the key date you specify.