5 (BW4 to be). Relevancy Factor: 1. I have some questions around 0FI_GL_4 datasource and data flow around this. But for some reason it isn't picking up all the records that were created in the previous night (but it. Regards. RemoteCube Compatibility. FI-GL: Line Items (0FI_GL_4) - /IMO/CMFIGL04 /IMO/CMFIGL04 This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource. Transformation. The DataSources can then be used independently of one another (see note 551044). To maintain a consistent dataset in Financial Accounting during data extraction, new and changed datasets are loaded for the same time interval for which line items in the General Ledger (0FI_GL_4) were last loaded. In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). In Business Content, following flow is available. The delta time stamp is stored in table BWOM2_TIMEST. Step1: Append the Structure of Datasource 0FI_ACDOCA_10. Extractors only exist for the source system from R/3 Release 4. The extractor calculates the same key figures as transaction GADBKFC. 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 . Hi Gurus, I want to know the standard cube name for 0FI_GL_4. ( i'll take care of master data). AEDAT : 12/17/2012. It means that only fields that are relevant for the general ledger are. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. The delta load of 0FI_GL_4 bring data if the delta (Info Package) triggered after 2:00 AM. 4 ; SAP NetWeaver 7. Based on DataSource: 0FI_GL_4. 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. tRFC (Transactional RFC), previously known as asynchronous RFC), is an asynchronous communication method that executes the. Not sure if this is of help, but there are some OSS notes around performance of this extractor also, which may give you some options if this is not applicable - 1322418. Thanks in advance. 0B. However, we have a problem in that splitting in the new GL in ECC 6. Search for additional results. This. Reduce throttle to idle engine. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). We are enhancing standard datasource(0FI_GL_4) which contains data form 2009 till date. The Business content 0FI_GL_1 is just a summary cube, our customer has a need to have GL line item details in BW ODS/Cube from BSIS/BSAS R/3 tables. 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. This DSO (advanced) contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction ( 0FI_GL_4 ). IDoc s enable the connection of different application systems using a message-based interface. Note: Uncoupled" extraction possible with Plug-In PI 2002. In that case pointer will keep on increasing ( and this will come in the delta). InfoSource 0FI_GL_4 transfers only those fields that are relevant for General Ledger Accounting from the Financial Accounting document (tables BKPF and BSEG) to the BW system. This InfoSource is based on DataSource 0FI_GL_14. FAGLFLEXA. 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 HANAAverage Daily Balance. This increase in performance compared to a full data extraction on the same ODP datasource is due to the. Data source setup table filling. Fields : BKPF–USNAM. You may choose to manage your own preferences. About FI Extractors Mechanism. * For more information about source system IDs, see SAP. If you use 0FI_AR_3/4 or system exclusively. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. SAP. Currenly we are loading deltas for 0FI_GL_4 once in a day. The delta timestamps can be seen in table BWOM2_TIMEST. 0fi_aa_11 0FI_AA_12 If you have GL extractors enabled which is 0FI_GL_4 then you have to extract GL data first followed by remaining set of extraction in sequence. This field is not available in BSEG & BKPF tables but available in the datasource structure. If you use transaction RSA5 to activate the extractor of DataSource 0FI_GL_14, the field attributes of the append extractor are assigned to the actual extractor. 0FI_GL_4 Initialization. So please let me know whether It is possible to add without writing CMOD. Note 410799 – Enhancement of line item extraction FI-GL, FI-CIS, FI-CIS Implemented for 0FI_AP_4 DataSource customization. e. 0ASSET_ATTR. 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. To enable determination of the datasets, note 535016 must be installed in all. The same is with the field BKTXT in the Include CI_BSIS. But it is not possible. FI-GL: New GL Balances (0FI_GL_12) - /IMO/CMFIGL12. This question is for New GL. 0FI_GL_6 . Reports can be based on any value type that is recorded in the source. Below are some advantages of the ODP Framework: If you use ODP, you. Append extractor 0FI_GL_14_APPE is used to provide the corresponding fields in BI. 2, see OSS note 551044 0FI_GL_4 writes the entries into the time stamp table BWOM2_TIMEST in the. ODQ Tables. * For more information about source system IDs, see SAP HANA-Optimized BI Content. The symptom materializes in dDelta Extract Stage was tested with custom Datasources and with the following standard Datasources:0FI_GL_20: G/L Accounts: Transaction Figures: FI - General Ledger Accounting: 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 0FI_AR_4: Customers: Line Items with Delta Extraction: FI - Accounts Receivable: 0FI_GL_1: General ledger: Transaction figures: FI - General Ledger Accounting: 0FI_GL_12As 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 which data extraction is allowed. But some document numbers are found missing in the extractor when compared with BKPF table. ODS object 0FIGL_O07 is connected to infoSource 0FI_GL_7 which is further connected to datasource 0FI_GL_7. To do this, create structure CI_BSIS in the data dictionary of the R/3 source system and include the VALUT field in it. We now realize we need the cumulated balance at a plant level for specific GL Accounts. engine speeds but at a maximum of 3/4 throttle for the first two hours. 2) No you can not. So, if we fetch the data at 02:00 AM, then any other delta run (delta info pack run. 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. The field from which the data is taken depends on the ledger master data, the characteristics of the InfoObject OCURTYPE, and the posting period. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. Now, we're discontinuing the 0FI_GL_4 to the 0FI_GL_14. The delta dataset is transferred directly, without records being transferred to the delta queue in the SAP R/3 system". Data Modeling. /IMO/D_FIGL14. In order to over come the above challenge, lets start up with Extraction using. Can somebody help me in creating function module generic extractor similar to the 0FI_GL_4 . 668 Views. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. 0. 3. This DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). Get timestamps of the leading source (0FI_GL_4 or when this is not used 0ASSET_ATTR_TEXT) Get timestamp of the extraction source; Build Selection Ranges for the extractor; Extraction Phase. 4 system (target). This note describes the transfer from the old extraction procedure (datasources 0FI_AP_3 and 0FI_AR_3) to the new extraction procedure (datasources. The ODS object General Ledger: Line Items contains all line items transferred from the source. Page Not Found | SAP Help Portal. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. 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 generated Data Source 3FI_GL_xx_SI) are also deleted in the source system. Follow. 0FI_GL_4: General Ledger: Line Items with Delta Extraction: FI - General Ledger Accounting: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable: 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. I used 0FI_GL_4 Datasource . If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation. Many thanks Geoff. if it is triggered prior to 2:00 AM it’s not extracting any data. 0FI_GL_4: General Ledger: Line Items with Delta Extraction: FI - General Ledger Accounting: 0FI_GL_50: G/L Accounts: Plan Line Items: FI - General Ledger Accounting: 0EC_PCA_1: Profit Center: Transaction Data on Accounts: Enterprice Controlling - Profit Center Accounting: 0FI_AP_30: Vendor Line Items:I am trying to make some sense of it and make it work quickly. This field is not available in BSEG & BKPF tables but available in the datasource structure. I tried this ODQ approach for 0FI_GL_4 with streaming enabled. x DS)). Here, x stands for T, H, K or O. problem with 0FI_GL_4 Delta extractor. This means that you can now load 0FI_GL_4, 0FI_AR_4, 0FI_AP_4, and 0FI_TX_4 in any order. Requires; Object Type. Type of DataSource. In this case, activate the DataSource using transaction RSA5, by following the steps given below. To maintain a consistent dataset in Financial Accounting during data extraction, new and changed datasets are loaded for the same time interval for which line items in the General Ledger (0FI_GL_4) were last loaded. Follow the steps to append, hide, unhide and extract the fields from BSEG table using SAP Note 430303 and the data dictionary. Thanks, Manjunath. Note: The below scenario is applicable only for the datasources 0FI_GL_4 (General ledger: Line Items),0FI_AP_4 (Accounts payable: Line Items), 0FI_AR_4 (Accounts receivable: Line Items) Scenario. I want to use to the business content extractor - '0FI_GL_14' - General Ledger Accounting (New): Line Items of the Leading Ledger to load data into the DSO -. 0 · If all fields in the customer include structure are contained in the above-mentioned R/3 table, no further ABAP programming is required. g. This DSO (advanced) contains the new general ledger line items extracted with DataSource General Ledger (New): Line Items Leading Ledger ( 0FI_GL_14 ). FI-GL: New GL - Balances - /IMO/D_FIGL12. All my FI reports were well managed by 10 and 14. The safety interval is defined in table BWOM_SETTINGS. I originally loaded . Scenario 1: Datasource is maintained in a specific language. The delta queue pulls data into the delta queue via an extractor (e. 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. The values I got is. Need to write small abap logic at source side SE38 to modify ROOSEFIELD table data. Corporate Memory: storage of all data records delivered by the DataSource for rebuilding the Integrated DWH. This InfoSource provides the General Ledger Accounting line items from tables BKPF and BSEG in the R/3 source system. This should 'automatically' bring data to MWSKZ field, because it's part of the table BSIS, however, the field is not visible in RSA3, RSA6 or in BW after replication. Reason being it fetches the delta as per standard settings i. This DSO (advanced) contains the new general ledger balances extracted with DataSource General Ledger: Balances of Leading Ledger via Delta Queue ( 0FI_GL_12 ). 6 or higher. Data sources – 0FI_AP_4, 0FI_AR_4, 0FI_GL_4, which are line item extractors, use this table for managing delta records. From the transition of the data requirements in Delta-Init-Modus to Delta operation therefore, the data requirement in Delta mode 0FI_GL_4 should take place first. Note: Uncoupled" extraction possible with Plug-In PI 2002. As FI-GL DS is based on BSEG,BKPF, do we need to do any enhancements or any other technique? Thanks for relpy in advance. mygns . This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource General Ledger (New): Line Items Leading Ledger (0FI_GL_14). The DSO enables balance and flow reporting for defined periods. 0FI_AA_11 Transactions and annual values; 0FI_AA_12 Posted depreciation (period values) The correct load sequence is checked by the extraction routines!. First of all Numeric Pointer is used when in the Source system is creating new records say for example Customer Code. Hierarchy Extractor for Balance Sheet & P&L Structure. Click more to access the full. This DataSource is used to load General Ledger transaction figures (table GLTO) from the R/3 source system to the Business Information Warehouse. Transformation. Visit SAP Support Portal's SAP Notes and KBA Search. 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. One of our old clients on ECC is now upgraded to S/4 Hana. 3 Keywords RODPS_SAPI 021, RSQU 052, ODQMON, sapi, odp, parallel , KBA , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BW-WHM-DST-DTP , Data Transfer. And now, 0FI_AP_4 and 0FI_AR_4 will copy this new upper limit for the time stamp selection during the next data extraction in the SAP R/3 System. Relevancy Factor: 1. We are extracting from ECC 6. Create and run Init load for the 3 Cubes. Type of DataSource. Source structure: BKPF, BSEG. Data Source 0FI_GL_4 , will satisfy this requirement. I have created an ODP-SAP Extractors source system in BW and replicated a datasource 0FI_GL_4. The extractor does not transfer any redundant fields to BW. Technical Data. 4. xlsx - Free download as Excel Spreadsheet (. From the transition of the data requirements in Delta-Init-Modus to Delta operation therefore, the data requirement in Delta mode 0FI_GL_4 should take place first. FI-GL: GL - Line Items (0FI_GL_4) FI-GL: General. Related content. The data is not restricting to a particular GL Account. Due to the 16–key field restriction of the DSO, seven technical characteristics, 0FI_CK01 – 0FI_CK06 (+ 0FI_CK07), have been introduced into which all relevant source fields are concatenated to preserve the original. We have a requirement to enhance general ledger datasource (0FI_GL_4). 4. 2- I have to implement FI_GL_4 and UC_SALES_STATS utility extractor in BW4HANA but we have existing BW version as well where. Actually Delta procedure is not suitable for filling Infocubes in BI directly. 0FI_GL_4 is a Business Content datasource and when running test extractor RSA3 the only selection fields are BUKRS (Co Code) and FISCPER (Fiscal Period). You may choose to manage your own preferences. 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?FAGLFLEXA & FAGLFLEXT. Production – 74% performance improvement (1. Learn how to add fields from BSEG table to the data source extract structure of 0FI_GL_4, a SAP Business Warehouse data source for general ledger line items. The data source which fulfills my requirement is 0FI_GL_4. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. FI-GL: New GL - Balances - /IMO/D_FIGL12. 0 . Therefore, from the transfer of the data requests in delta initial mode to the delta only operation, the data request in delta mode of 0FI_GL_4 should be. Hi, We are upgrading SAP ECC support pack. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. we extracting delta records use 0fi_gl_4 one time every day. I activated Local Ledger via Tcode: FAGLBW03. Cumulated balance. At least the following characteristics must be available in your base InfoProvider: 0GL_ACCOUNT, 0CHRT_ACCTS, 0FISCPER, 0FISCYEAR. SAP BW Datasource 0FI_GL_4 - Documentaion and other resources. 2. IDoc s enable the connection of different application systems using a message-based interface. Object Type. Now We found that there is a different table called FAGLFLEXA & FAGLFLEXT , Which will have the combined data from BSEG , BKPF and some other. We have intilzed the delta one year back and we are. ), as it's calculated. This DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_4) (/IMO/FIGL_IS04). Use. About this pageHello Hi, Just would like to ask something about the delta extraction of 0FI_GL_4. BTE used is 00005011. ) Also. Visit SAP Support Portal's SAP Notes and KBA Search. July and only documents posted on 30. /IMO/D_FIGL14. FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/FIGL_IS12. This ensures the proper synchronization of accounts. For example, for 0FI_GL_04 we need BSEG table, which is still in S4/HANA, but not storing all the data. In 0FI_GL_4, we are having the following selections Document Type, Company Code, Fiscal Period and GL Account. We used 0FI_GL_4 because tables GLT0 were empty in R3. The DSO enables balance and flow reporting for defined periods. On this way you could also enable ODP extraction for obsolete SAP standard. 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 apart from the base/origin tables on certain Business logic/requirement. How to mark that field as selection?I tried by using RSA6 ,But I'm unable to change the previous selection. Module Name. For example lets take 0FI_GL_4,the table used are BSEG and BKPF . General Ledger: Cost of Sales Ledger Using Delta Extraction. 0FI_GL_14 takes the data from FAGLFLEXA and if your ECC data in that table is blank then 0FI_GL_!4 will also provide you with 0 data. Atul. General Ledger: Direct Line Items. The problem is we have activated the datasources of 0FI_AR_4, 0FI_AP_4, 0FI_GL_4 from delivery version RSA5, After activation we checked in RSA6, and even the data is available we checked in RSA3 also. 0. 2. You're wondering to know using which fields as the selection could improve the performance. DSO - 0FIGL_O02. 0FI_GL_4: General ledger line items (if required) 0ASSET_ATTR_TEXT: Master data for asset subnumber; 0ASSET_AFAB_ATTR: Depreciation area;. 0FI_GL_4. As soon as DataSource 0FI_GL_4 has been loaded, it is the leading DataSource with regard to accruals, such as the time and date (CPU date) by which extraction should be carried out. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. The problem is we have activated the datasources of 0FI_AR_4, 0FI_AP_4, 0FI_GL_4 from delivery version RSA5, After activation we checked in RSA6, and even the data is available we checked in RSA3 also. The consistent recording of data from General Ledger Accounting and Subledger Accounting is provided by means of coupled delta extraction in the time stamp procedure. The article explains the step by step procedure for the DataSource Enhancement without using ABAP Code for the standard FI_GL/AR/AP extractors. Can any one help us with the steps in doing repair full load to populate history loads for new fields added. InfoSource 0FI_GL_4 transfers only those fields that are relevant for General Ledger Accounting from the Financial Accounting document (tables BKPF and BSEG) to the BW system. I understood that we need to fetch all the extract queues to BW before upgrade. ①0FI_GL_4 (0FI_AR_4 and 0FI_AP_4 as well): The safety interval logic is implemented in function BWFIT_GET_TIMESTAMPS. Transformation. Please give some guidelines to follow when implement above three. 0FI_GL_12: General Ledger Balances of leading Ledger; 0FI_GL_14: General Ledger Line Items of Leading Ledger; 0FI_AA_11: Asset Accounting Transactions; 0FI_AA_12: Asset Accounting posted Depreciations; Controlling: 0EC_PCA_1: Profit Center: Transaction Data on Accounts; 0EC_PCA_2: Statistical key figures; 0EC_PCA_3: Actual Line Items; 0EC_PCA_4. Thanks Rober. The extraction procedure delivered with the business content for SAP BW 1. Technical Data. I am using the FI data source 0FI_GL_10. 0FI_GL_40: G/L Accounts: Line Items: FI - General Ledger Accounting: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable: 0FI_GL_20: G/L Accounts: Transaction Figures: FI - General Ledger Accounting: 0FI_GL_6: General Ledger Sales Figures via Delta Extraction: FI - General Ledger Accounting: 0FI_GL_50: G/L Accounts:. transformation: TRCS 0FI_GL_4 -> ODSO 0FIGL_O02 . FI-GL: General Ledger: Balances (0FI_GL_6) - /IMO/FIGL_IS06 . Available from Plug-In Release. Right click and copy the link to share this comment. 5. 2895141-0FI_GL_4: what fields can be used as the selection criteria. We have the requirement with the data from tables BSEG and BKPF Tables. Screen Shot 1: BWFI_AEDAT table and its fields The 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 be able to. General Ledger: Transaction Figures – Cost of Sales Ledger. Then I have enhanced the datasource in ECC. My question is if "0FI_GL_10 - Leading Ledger Balance" and "0FI_GL_4 - Actual Line Items" datsources are already configured. If you use transaction RSA5 to activate the extractor of DataSource 0FI_GL_14, the field attributes of the append extractor are assigned to the actual extractor. 0CO_OM_CCA_10 . We have the requirement with the data from tables BSEG and BKPF Tables. Fields of Origin in the. 0GN_R3_SSY. The DSO enables flow reporting for defined periods. when we go to SAP NetWeaver 2004s to replicate the datasources, i went to source system and after double clicking on the Source system a. Sequence of Data Extractions into BW:General Ledger: Line Items with Delta Extraction (0FI_GL_4) General Ledger: Balances of Leading Ledger via Delta Queue (0FI_GL_12) 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:从数据源0fi_gl_4到DSO，再从DSO到CUBE，最后通过CUBE展示出来的操作步骤？. We are planning to do repair full update for the history loads of newly added fields. But then you have will have to filter what are the relevant doc types for AR. InfoSources. Enhancing 0FI_GL_4 datasource with fields from BKPF and BSEG - SAP Q&A Relevancy Factor: 2. 0FI_GL_1: General ledger: Transaction figures: FI - General Ledger Accounting: 0FI_GL_4: General Ledger: Line Items with Delta Extraction: FI - General Ledger Accounting: 0FI_GL_10: General Ledger: Leading Ledger Balances: FI - General Ledger Accounting: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction: FI - General. Transaction data (movement data) Application Component. The DataSources can then be used independently of one another (see note 551044). We are upgrading the PI add-on in R/3 source system from 2003_1_46C to 2004_1_46C. This DataStore objectis required for the delta process of the DataSource General Ledger: Balances, Leading Ledger (0FI_GL_10). Hi, we edit in ROOSFIELD value in selection in 0FI_GL_4 for Field HKONT. Say, you have a down-time available: You will have to perform a Full Load first and then the Initialization. BKPF–PPNAM. I understood that the DELTA are based on the BWOM2_TIMEST Table. The job is stucking alwyas in the step : Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel tasks) And when i check SM50 , i find the folowing process still in progress ( Report SAPLBWFIR and table. WBS Element – urgent! Posted by previous_toolbox_user on Feb 26th, 2003 at 5:52 AM. Questions: Based on above. The documentation states GL_1 is for transaction while GL_4 is direct line items. In this case, the fields in the customer include structure are automatically supplied with data by the DataSource. 0FI_GL_4, 0FI_AP_4, 0FI_AR_4, 0FI_TX_4. 0FI_GL_6 . But this time it contains value for field Gkont (i. Name. I know that these datasources use AIE as delta mode. 4. 0B. We are planning to change the existing FI_AR line item load from current fiscal year full to delta. Update table ROOSFIELD for the missing fields of the datasource, changing the SELECTION from A to blank. Thank you. The BADI . 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. Newly created FI documents will be extracted to BW based on BKPF-CPUDT( Entry Date). SAP BW/4HANA all versions ; SAP NetWeaver 7. 0CO_PC_ACT_02 . This ensures the proper synchronization of accounts. All other fields are grey and cannot be marked for selection, e. Requires; Object Type. Financial Accounting: General Ledger Accounting (FI-GL) Available from OLTP Release. 2. For performance improvements for extraction, see SAP Note 1731175. Learn how to add fields from BSEG table to the data source extract structure of 0FI_GL_4, a SAP Business Warehouse data source for general ledger line items. 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. While checking the help. Data Source 0FI_GL_4 , will satisfy this requirement. 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. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. FAGLFLEXA & FAGLFLEXT. Related content. RSS Feed. Scenario 3: Extracting from FI (Financial) DataSources. 1999. For more information, see SAP Note 1523670. The new datasources 0FI_GL_4, 0FI_AR_4 and 0FI_AP_4 use a time stamp method instead of the BW Delta queue in the R/3 source system in order to determine the Delta dataset. The safety interval is defined in table BWOM_SETTINGS. 0FI_GL_4. It's because the BSEG-PROJK (NUMC 8) was assigned instead of PS_POSID (CHAR 24). From the transition of the data requirements in Delta-Init-Modus to Delta operation therefore, the data requirement in Delta mode 0FI_GL_4 should take place first. And now, 0FI_AP_4 and 0FI_AR_4 will copy this new upper limit for the time stamp selection during the next data extraction in the SAP R/3 System. Technical name: 0FI_GL_4. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Use. the log of the job in erp system as follow. Currently we are in SAP ECC 6. Use corresponding exit FM as template and copy the import, Export, Table, Exception. This is incorrect. Data sources – 0FI_AP_4, 0FI_AR_4, 0FI_GL_4, which are line item extractors, use this table for managing delta records. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04 . I know there is a datasource 0FI_GL_4, and this datasource is based on BKPF and BSEG. Datasource 0FI_GL_4 (GL: Line items) with delta type E (PULL): As this is a ‘PULL’ delta-type, the delta data records are determined during the delta update by the Datasource extractor, updated to the ODQ, and passed on to the SAP BW directly from there. 0FI_GL_4 is based on both BKPF and BSEG tables, So is that the reason why document no are missing, and if such then is there any standard DS based exclusively on BKPF table. 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 apart from the base/origin. Here we are able to load data by giving selection for Fiscal Period. Introduction. Therefore, from the transfer of the data requests in delta initial mode to the delta only operation, the data request in delta mode of 0FI_GL_4 should be. Datasource : 0FI_GL_4. Transaction data (movement data) Application Component. 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 which data. No record is written to the BW delta queue. Prerequisite: I_INITFLAG is initial. Follow. Hi SAP Gurus, I'd like to know how to add one field as a selection field for the data source. Note. Field ZBD1T in table DTFIGL_4 is specified twice. If no data exists for 0FI_GL_4, extraction is not linked to the General Ledger. Also suggest me if any other efficient method available for the. The DataSources can then be used independently of one another (see note 551044). I've inserted a Breakpoint in the code and ran RSA3 the results from the checker agree to the results given in (SE16). G/L Account Number (HKONT) and controlling. The currencies of non leading ledgers in New GL (T882G) were a subset of the currencies in the leading ledger (T001A). Extractor: BWFID_GET_FIGL_ITEM. 0FI_GL_4 writes the entries into the time stamp table BWOM2_TIMEST in the SAP R/3 System with a new upper limit for the time stamp selection. Type of DataSource. However I would like to get data from PS_POSID field (as it stands for for instance for datasource 2LIS_11_VAITM). For more information, see SAP. The ODP performance scenario that we’ve completed was on the GL Line item datasource (0FI_GL_14) from ECC system (source) into a BW 7. To maintain a consistent dataset in Financial Accounting during data extraction, new and changed datasets are loaded for the same time interval for which line items in the General Ledger (0FI_GL_4) were last loaded. 0FI_AA_12. This extractor assigns specific field attributes to the append fields. Accumulated Balance ( OBALANCE ) field is showing u201C Zero Values u201C . This DSO (advanced) contains the general ledger line items extracted with DataSource General Ledger: Line Items with Delta Extraction (0FI_GL_4). RLOGSYS = BWPCLNT880. 1 Answer. 0ASSET_AFAB_TEXT. Available from Plug-In Release. You may choose to manage your own preferences. For performance improvements for extraction, see SAP Note 1731175. I need two fields from EKKN table (NAVNW,AUFNR) into FI-GL datasource (0FI_GL_4) and those two should be available in report.