Using 0FI_AP_4, this will also give me direct FI posting on non PO spend as well. Apply source code corrections mentioned in OSS note 1424403. About the 0CO_OM_CCA_9 Datasource . About the 0EC_PCA_1 Datasource . Data volume is not too much and it take hours to load it in BW from ECC. Search for additional results. In particular, the extract structure contains no fields from Accounts Receivable and Accounts Payable Accounting. Hope this helped. Steps: 1. Hi Satya. The delta time stamp is stored in. Right now in my company there are using 0FI_AP_4 datasource as an Invoice masterdata. DataSource Transactional Data: 0FI_AP_30 . PleaseAcc Doc No (BELNR) is in BSEG Table, but record is NOT in 0FI_AP_4 Extrctr. It has two other fields ATTR1 & ATTR2. Hi Experts, For S/4 extractors - Customer Line Items 0FI_AR_4 / 0FI_AR_30, to bring data to BW4HANA. Use transaction RSA7 to find records with the value U in the field. · Source structure: BKPF, BSEG · Extractor: BWFID_GET_FIGL_ITEM · Extract structure OLTP: DTFIGL_4. 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable: 0FI_GL_7: General Ledger Cost of Sales Ledger via Delta Extraction:. Thanks praveen. 0FI_AP_4; 0FI_AR_4; 0FI_AA_12; InfoCubes; Flat Files; 12 Shipping / Deliveries - COPIED; BDLS; Excel to BW; Webservices;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:. On the S/4 HANA cloud home page, Search for the “Custom CDS View” App as shown: Click on the App displayed. 0B, based on DataSources 0FI_AR_3 and 0FI_AP_3. DataSource Type. This is an issue in PowerCenter 9. Later I appended the view BIW_T001 with those three new. Customer Tables. The problem is in BW report Discount Base takes all. Invoice Ref Num REBZG BSIK 0FI_AP_4 - REBZG. Financial Accounting: Vendors (FI-AP) Available as of Release. But I couldn't find some of the fields in account payable data source 0FI_AP_4 or tables. Characteristic. we are using SAP NetWeaver 2004s and we are implementing for the first time. There are several tables that are contain Vendor Master related data which can be used for extraction to BW. The challenge is then trying to determine the direct relation between MM and FI. This is a preview of a SAP Knowledge Base Article. This InfoSource contains the transaction figures for Accounts Payable (table LFC1). Technical name: 0FI_AP_4 Based on DataSource: Accounts payable: Line items ( 0FI_AP_4) This InfoSource shows the line items in Accounts Payable Accounting from. The extractor does not transfer any redundant fields to BW. Report Fields R/3 Field Table Datasource-Field. 0FI_AR_9 Customer Credit Managmt. We use 0FI_AP_4 to extract R3 data to an ODS. Today R3 people added one new accounting document type with 10 records generated. 0. This is described in. However, my confusion is when I read the help documentation. Quantity in the corresponding stock table. amount WSKTO CURR 23 49. FI-GL: GL - Line Items (0FI_GL_4) - /IMO/FIGL_IS04. As you know it is based on BSIK and BSAK tables. Related content. Hello All, I need to find the timestamp maintained in the system for the following datasources: 0FI_GL_10 0FI_GL_4 0FI_AP_4 0FI_AR_4 0CO_OM_OPA_6 And also if we can change the timestamp to a lesser in. FI (Financial Accounting) BW Datasources. For more information, see SAP Note 1523670. You can base a custom cycle for a patient in the Nursing, Service Management, or Medication modules on a standard cycle. Use. Follow. General Ledger: Direct Line Items. 0FI_AP_4: Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 8 : 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 9 :Use. If. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. SAP S/4 Hana; SAP Financials; Product. This extractor is taking too long to extract data from ECC and load performance is becoming poor by the day. I know for old version BW, 0FI_AR_30 supports remote cube. Master data for 0FI_AP_4 and 0FI_AR_4 | SAP Community Relevancy Factor: 1. 0. With old G/L in R/3, the tables GLT0 (totals), BSEG, BKPF (Line Item) get filled in SAP BI side you should have to use data model. About the 0FI_AP_4 / 0FI_AP_30 Datasources . DataStore Objects. LFBW : Vendor master record (withholding tax types) X. , KBA , FI-AP-AP-A , Posting/Clearing/Special General Ledger , FI-AR-AR-A , Posting/Clearing/Special General. Relevancy Factor: 40. 2lis 13 Vditm Related Tables Bw Datasources in SAP. This blog has been substantially rewritten in December 2018 to include information on how to retrieve fields from various associated master data tables like LFA1 and KNA1, and to clarify the steps for including the additional fields as. Delta Extract Stage was tested with custom Datasources and with the following standard Datasources:This DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). FIAP Extraction. Valuation Type. for Infosource 0fi_ap_4 - 18 : BSTAT: Choose Statement Status PY - Germany: Structure 19 : EKPO: Purchasing Document Item MM - Purchasing: Transparent TableThe note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. Vendor LIFNR PAYR . No records show up in transaction RSA7 despite DataSource 0FI_AP_30/0FI_AR_30 has been initialized and documents have been posted. Append extractor 0FI_GL_14_APPE is used to provide the corresponding fields in BI. 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. That doesn't mean that all these documents will get loaded to BW. 4. Base Unit MEINS UNIT 3 T006: 63 RVUNIT Unit of Measure RVUNIT UNIT 3 T006: 64 RRUNIT Base Unit of Measure. Go to the Eclipse ABAP Perspective and find extract structure for the. Kitchen Table. 18 26 35,230. 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable:The DataStore object is supplied with data from both of these DataSources: 0FI_AA_11 and 0FI_AA_12. Environment. RSEG is a standard Invoice Verification Transparent Table in SAP MM application, which stores Document Item: Incoming Invoice data. Init : Does same as above. Regards. No record is written to. With New G/L in SAP ECC 6. 0FI_AP_4 Init Delta load does not link with 0FI_GL_4 in BWOM2_TIMEST Relevancy Factor: 1. 0FI_AP_4 and 0FI_TX_4 in any order you like. Extractors only exist for the source system from R/3 Release 4. 0FI_GL_10: General Ledger: Leading Ledger Balances FI - General Ledger Accounting: 5. In particular, the InfoSource contains no InfoObjects from Accounts Receivable and Accounts Payable Accounting. enabled:true in the Search box and press Enter. About the 0FI_AP_4 / 0FI_AP_30 Datasources . sap links, I found that this field is based on the followiing fields from the BSEG table:Most important BW Extractors for Base Tables For Fi Datasources # BW DATASOURCE Description Application; 1 : 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2 :. currently we don’t have data, if we keen some plan data ( i. How can I add that?Below is the functional difference between 0FI_AP_30 & 0FI_AP_4: 0FI_AP_4 gives you accounts payable line items in your report. Delta type “Extractor“: · Delta records are directly selected from the R/3 tables using a. With BW Release 2. You can the table from which particular field is coming suing SE11. InfoSource 0FI_GL_4 transfers only those fields that are relevant for General Ledger Accounting from the Financial Accounting. Hi, My requirement is to enhance 0FI_GL_4 with fields. 6 or higher. WHT Tax Base Amount WT_BS CURR 23 9 WT_QSSHB Withholding tax base amount in document currency WT_BS1 CURR 23 10. Application Component. During delta extraction, only those entries are selected that belong to posting runs started. Symptom. Performance wise also standard ds will be faster than generic. About the 0CO_OM_CCA_4 Datasource . (See also SAP Note 2383115. It enhances SQL to allow defining and consuming these data models in applications, thereby improving productivity, consumability, performance and interoperability. This is a preview of a SAP Knowledge Base Article. We've tried BKPF, BSEG, and PAYR, not successful. Document Date. , KBA , FI-AP-AP-A , Posting/Clearing/Special General Ledger , Problem . 0ACCT_TYPE. Source Tables (Function Module): BWFIAA_EXTRACT_DELTA (Function Module). the problem is in the form of control of the delta of the datasource 0FI_AR_9 eg if run 2 times on the same day: 1º Execution: 200 records. AP - SRM Purchase Order Processing (AP-POP)11 Customer Extensions Extension of extract structures using customer includes Data source R/3 table Extract struct. BWPSPEX. Financial Accounting: Vendors (FI-AP) Available as. Transactional data (transaction data) Application Component. The FAGLPOSBW structure has a specific append for Public Sector (FMGL_FIELDS). 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable: 0FI_AR_1: Customers: Transaction figures: FI - Accounts Receivable: 0FI_AR_10:Hi SDN, Could please share some steps . Name of Target InfoObject. 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. 0 October 2010 Initial versionThis DataSource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system. RSS Feed. Hi Experts, Can anyone provide the based table names for 0FI_TX_4 data source? and can anyone tell me how to eassly find out the filed table names. BKPF is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting Document Header data. It can be achieved by changing the settings at back end in the source system. Is Simple Finance designed to be used in BW? If so, will the new universal journal table (ACDOCA) have an extractor such as previous tables in finance (e. In particular, the InfoSource contains no InfoObjects from Accounts Receivable and Accounts Payable Accounting. Sales document. 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. You're wondering to know using which fields as the selection could improve the performance. Oct 30, 2007 at 11:06 PM. You found some of the items are missing during FULL loading for datasource 0FI_AP_4 even though they are in table BSAK. In InfoSource 0FI_AP_4, the InfoObject 0DEB_CRE_DC is mapped with R3 field WRSHB (Amount in FC). Data volume is not too much and it take hours to load. Existing data in table BWFI_AEDAT is also deleted. 2. Relevancy Factor: 1. InfoSource 0FI_GL_4 transfers only those fields that are relevant for General Ledger Accounting from the Financial Accounting. 2B, which is based on the DataSources 0FI_GL_1, 0FI_GL_2, 0FI_AR_1, and 0FI_AP_1, can be replaced. Step1: The base tables (BSAK and BSIK). The data records are read from table ACDOCA. when we go to SAP NetWeaver 2004s to replicate the datasources, i went to source system and after. The sides of this table are straight and smooth and in between all of these beautiful pieces is 4-6mm crushed glass filled with epoxy. But I have a requirement like I need to enhance this 0FI_AP_4 with other tables (PAYR,REUGH). Technical Data. Quantity in base unit of measure MENGE_D QUAN 13 18 BSTME Order unit BSTME UNIT 3 T006: 19. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!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. The delta request does not fetch any records from the 0FI_AP_30, 0FI_AR_30, and 0FI_AR_10 even though there is delta data available in SAP server. So you can use 0FI_AP_4. ABAP Sample for. How can we get the data from BSAK table. About the 0FI_AP_4 / 0FI_AP_30 Datasources . This is an issue in PowerCenter 9. I have searched the content data sources 0FI_AR_4, 0FI_AR_5 but I dont get these metrics at all in them. INCLU--AP 0 82 . If you delete the last initialization selection in the source system for the InfoSources 0FI_*_4 in the BW system Administrator Workbench, the entry from table TPS31 is also removed. So for this field, it fetches data from. Now you will get the list of tables from from which field is populating. 0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable: 17 : 2LIS_12_VCITM Delivery Item data: SD - Sales and Distribution: 18 : 0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 19 : 2LIS_13_VDKONDear Experts, I need to work on S/4 Embedded analytics where in I have to use CDS views and Expose them to Fiori using O data integration. 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. This DataSource provides Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system. 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 2. But the changed documents are coming in. Performance enhancements might be available for data extraction. I have a problem. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Please help to find base tables for the 0FI_AA_20 and in RSA 3, it need mandatory selections for BUKRS and FISCPER While executing to. Extraction structure: FAGLPOSBW. ROOSOURCE. Hence I need to enhace the datasources. AEDAT is not present in the tables. 0FI_AP_4 and 0FI_TX_4 in any order. CPUDT is a field in both BSIK and BSAK, but system does not fetch data from these tables. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. Key Fields; Object Type. As most databases, HANA supports SQL as the. This DataSource supplies the values of depreciation postings by period. 4 249 TXBH2 Tax Base/Original Tax Base in Second Local Currency TXBH2 CURR 23 250 TXBH3. The extractor reads from the depreciation posting run table, ANLP. presentation (country-specific) T060U: Description of. It is a view. Table of Contents SAP BW/4HANA Content Add-On. 0A (BW PlugIn 2001. Delta : takes only delta data from base table using function module BWFID_GET_FIGL_ITEM and poupulates in. AEDAT is not present in the tables. 0. Follow. 0FI_AR_4 Initialization - millions of records | SAP Community. Document Amount WRBTR BSIK 0FI_AP_4 -WRBTR. 36 Views. Acc Doc No (BELNR) is in BSEG Table, but record is NOT in 0FI_AP_4 Extrctr. 0FI_AR_30: Accounts Receivable; 0FI_AP_4: Vendors: Line Items with Delta Extraction; 0FI_AP_30: Accounts Payable; 0FI_GL_4: General Ledger Line Items; 0FI_GL_6: General Ledger General Ledger Sales Figures; 0FI_GL_12: General Ledger Balances of leading Ledger; 0FI_GL_14: General Ledger Line Items of Leading Ledger; 0FI_AA_11: Asset. We tried RSO2 and find that no view/table is attached to the datasource 0FI_AP_4, instead the. . e. About the 0FI_AP_4 / 0FI_AP_30 Datasources. 0FI_AP_4 and 0FI_TX_4 in any order. 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 details: Billing Doc: 9001, Accounting Doc. Search for additional results. About the 0CO_OM_ABC_2 Datasource . state (= “After Image“). In this scenario, enhancing the 0FI_GL_4 DataSource and adding the extra fields from the BSEG table. This InfoSource contains the structure to provide vendor line item data into the EDW Core Layer. Now if changes happen to the enhanced fields then the delta must be captured. This DataSource is delta-compatible (in contrast to 0FI_GL_1). 0FI_GL_14; 0FI_AP_4; 0FI_AR_4; 0FI_AA_12; InfoCubes; Flat Files; 12 Shipping / Deliveries - COPIED; BDLS; Excel to BW; Webservices;. Transaction type. The billing document tables in R/3 are VBRK and VBRP. Open View Browser app from the search results. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. 57 SP 06 and higher, this object is obsolete and has been replaced by Advanced DSO (ADSO) FI-AP: Vendor Line Items - /IMO/D_FIAP30. For more information, see Overview Page Obsolete Content. Delta loads using DataSource 0FI_AP_30/0FI_AR_30 does not bring any record. Data Modeling. RTCUR. ROOSGENDLM. Append extractor 0FI_GL_14_APPE is used to provide the corresponding fields in BI. 0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable: 21 : 0CUSTOMER_ATTR Customer Number Logistics - Logistics - General: 22 :. About the 0FI_AR_4 / 0FI_AR_30 Datasource . Gurus, 0FI_AP_4 Data souce is getting data from BSAK and BSIK tables. goto SE11 in R3 system --> give field name and click on where used list ( 3rd icon from left on top). Document Flow Tables. DataSources 0FI_AR_3 and 0FI_AP_3 , can be replaced. 0FI_AP_4; 0FI_AR_4; 0FI_AA_12; InfoCubes; Flat Files; 12 Shipping / Deliveries - COPIED; BDLS; Excel to. Some components are marked as mandatory as these are part of the standard SAP Financial Accounting (SAP-FI) validations that need to happen for a successful posting0fi Ar 4 Tables Most important Database Tables for 0fi Ar 4 # TABLE Description Application Table Type; 1 /BIC/CCWA0FI_AR_4: Transfer struct. RRCTY. This ensures the proper synchronization of accounts. The delta time stamp is stored in. Parked Documents 1 Scope: From the Functional Specs it was derived that Business required reporting on the AP Line Item Data, Transaction Figures and Payment history along with some Vendor Master Data. 0DOC_NUMBER. This DataSource is used to load accounts payable transaction figures (table LFC1) from the R/3 source system to the Business Information Warehouse. SAP Knowledge Base Article - Preview. Base Unit of Measure RRUNIT UNIT 3 T006: 56 RIUNIT FINS_RIUNIT UNIT 3 T006: 57 QUNIT1 FCO_QUNIT1 UNIT 3 T006: 58. However, Business Content InfoCubes (0FIAR_C20, 0FIAR_C30 ) are connected. The extractor considers all data from the tables FAGLFLEXA (or similar customer tables), BKPF, BSEG, and BSEG_ADD. About the 0FI_AP_4 / 0FI_AP_30 Datasources. Delta Process AIE Only after images are passed through this extractor. You can also use DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. About the 0FI_AR_4 / 0FI_AR_30 Datasource . "All BSET. Former Member. In a similar way, the annual values from table ANLC are converted to pseudo-transactions (using transaction type PLN for planned values and transaction type CUM for cumulative annual values). 2 Add-On. Related content. 0B, based on DataSources 0FI_AR_3 and 0FI_AP_3 , can. the BW delta queue. Is there any simple way to follow. About the 0FI_AR_4 / 0FI_AR_30 Datasource . About the 0FI_AR_4 / 0FI_AR_30 Datasource . About the 0CO_OM_ABC_2 Datasource . Extraction structure: FAGLPOSBW. Cntrl Area Data via Delta Extra. CPUDT is a field in both BSIK and BSAK, but system does not fetch data from these tables. ) It is also no longer possible to subsequently activate this. In add, the record for leading ledger are not corrected extracted, but this issue is solved by note 2322627 (Extractor 0FI_ACDOCA_10 issues an incorrect SELECT statement. 0. It provides a modified extraction procedure (direct accessing of tables instead of accessing the records when updating). The pointer in this table can be changed using FM. 1 and earlier versions where the delta request does not fetch the delta data and we could also see that the delta queue is not updated. 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 In BW, the delta extraction for 0FI_GL_4 from the source system can be loaded as per the processchain or infopackage schedule but. Account type. I would like to give few inputs on this. 01. 2, see OSS note 551044 0FI_GL_4 writes the entries into the time stamp table BWOM2_TIMEST in the. Click more to access the full version on SAP for Me (Login required). The DataSources can then be. 0. Now we've got a question for. are there any differences between these two? I know for old version BW, 0FI_AR_30 supports remote c. After Image Delta: · FI line items are transferred from the source system in their final. About the 0FI_AR_4 / 0FI_AR_30 Datasource . 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. InfoSources. FI-TX. As a consequence the extracted records have all key. BSEG is a standard Financial Accounting Cluster Table in SAP FI application, which stores Accounting Document Segment data. Now i have a requirement to enhace it by adding few fields from BSEG and BKPF tables. Answer. About the 0FI_AP_4 / 0FI_AP_30 Datasources . BWFISAFETY - 1. About the 0EC_PCA_1 Datasource . (See also SAP Note 2383115. This DataSource extracts Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system. Step1: Append the Structure of Datasource 0FI_ACDOCA_10. Help for MM invoices table. 0FI_AP_4 and 0FI_TX_4 in any order you like. The communication structures of the former InfoSource 0FI_AP_3 and the new InfoSource 0FI_AP_4 are identical. 0FI_AP_4, and 0FI_TX_4 in any order. This DataSource extracts General Ledger Accounting line items from tables BKPF and BSEG in the source system. Is it ok if i load data using infosource 0FI_AP_4 or i nee. 0ASSET_AFAB_ATTR--0ASSET_AFAB. 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). For example, for VENDOR MASTER , Based on the requi. g 0FI_AP_4, etc) and compatible BI content (0FIAP_O03, 0FIAP_C03) and even a query (0FIAP_C02). In contrast to the InfoSource Accounts Payable: Transaction Figures (0FI_AP_1), it can produce delta figures and therefore can be used instead. For the General Ledger, 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). A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Performance enhancements might be available for data extraction. The delta process is related to the extraction of data from the general ledger (for example, 0FI_GL_4). 0. Prerequisites. To start the development we have to know the fields which are going to be enhanced and the base table for that fields. This means that only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the extract structure. I am loading data with "0FI_AP_4" datasource and want to load data up to the time that I am actually loading the delta. 0FI_AP_4 FB03 RBUKRS, BELNR, FISCPER 0FI_AR_4 FB03 RBUKRS, BELNR, FISCPER 0EC_PCA_1 KE5Z RVERS, KOKRS, RBUKRS, FISCPER, RPRCTR, RFAREA, RACCT. BWTAR. RSS Feed. Choose. 11 starting at 11 am CEST; 5 am EDT. Now we've got a question for 0FI_GL_4: The extractor considers all data from the tables FAGLFLEXA (or similar customer tables), BKPF, BSEG, and BSEG_ADD. Function Connect_RFC () dim retcd Set funcControl = CreateObject. 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: FI - Accounts Payable: 0FI_GL_4: General Ledger: Line Items with Delta Extraction: FI - General Ledger Accounting: 0FI_AA_11: FI. SAP Base tables for 0FI_AA_20 data source and not able to execute in RSA 3. Tables/ Tcodes to check the timestamp maintained for FI datasources. Relevancy Factor: 30. note 0410797. can you pls explain me how 0FI_GL_4 extractor works ? Full Load : Does the extractor takes data from base table using function module BWFID_GET_FIGL_ITEM ? I saw this function module in RS02 . Company Code BKRS BSIK 0FI_AP_4 - BUKRS. 22 p. com :. Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10 (Actual Data). It’s the reason for your troubles. Cost Centers: Actual Costs Delta Extract. Our objective is to enhance the DataSource 0FI_AA_11 (Transaction Data) with those attributes ATTR1 & ATTR2, but this DataSource doesn't have the Profit Center. Source structure: BKPF, BSEG. This information is extracted separately (InfoSources 0FI_AR_4 and 0FI_AP_4). On the SAP help, it's stated. Step by Step Solution . You can find detailed information on this data source (including source tables/fields, delta handling and extractor features) by searching for datasource 0FI_AA_11 in the SAP Online Help. In the simplest case, a key figure is a numeric field in a database table. 7805 Views. 0FI_AR_4: Customers: Line Items with Delta Extraction FI - Accounts Receivable: 3. Type of DataSource. Local Currency DMBTR BSIK 0FI_AP_4 - DMBTR. The migration from InfoSource 0FI_AR_3 to InfoSource 0FI_AR_4 is described in note 410797. Contents: Introduction. 4. Field Guide Insert 10. If I want enhance AP_4 with PO Number (EBELN) and Item Number(EBELP) from BSAK table what are the steps I should be doing. In order for the drill to source feature to function properly, you need to include in your mapping tables some columns from the ECC datasource. The safety interval is defined in table BWOM_SETTINGS.