Then save the PO. Type . 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. <i>Note : I do no selection in my infopackage. For more information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. InfoSource. 2lis_02_scn. Customer-Defined DataSource ® L. Relevancy Factor: 2. But when we have an Invoice Receipt the 2lis_02_scl puts WEMNG and WERT field blank while REMNG and REWRT are populated correctly. If successful, 3. Please suggest me the ideal way to complete this task. Requires; Object Type. 0AF_COLOR. Application Component. Record count in RSA3 and PSA is different. The logic says: umren EQ 0. ie: EUR, JPY, USD,INR and all other country currencies. DSO Will Not Activate after Transport with rc=8. My question is: can we delete/fill setup table without any impact on Delta load? we have a Process Chain that every day load 2LIS data from R3 to BW so our idea is to. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。 2lis_06_inv 有reference 这个字段，但内容值对不上。Purchasing (application 02): 2LIS_02_ITM. Technical Data. Help needed, with detailed step would. fields in 2LIS_02_SCL. Because it is possible to post a goods receipt with a posting date (EKBE-BUDAT) that lies before or after the document creation date (EKBE-CPUDT), the creation date of the goods receipt document (GR document) plays an important role in the quantity. InfoSources 2LIS_12_VCHDR , 2LIS_12_VCITM , and 2LIS_12. If you click that dropdown you will find the tables for your Datasource. Based on DataSource: 2LIS_02_SGR. Reorganization for. We have attached 3 source systems to our BW and 2 of them are working absolutely without problems. So 2LIS_02_SCL gives more informations. Search for additional results. Hence we have developed a new Info cube which needs to have data from 2LIS_02_SCL and 2LIS_02_SCL (which is already delta enabled). 0 there is a data source called 2LIS_06_Inv which provides data from all these data sources. The following jobs move the data from the outbound queue to BW. Settings: Purchasing. FAQ: Setup table filling with 2LIS* extractors. Load data InfoPackage 2LIS_02_SGR_INIT_R3. ALIEF - Number of Deliveries. The same field BUDAT is being assigned to 0FISCPER with rule type Time Characteristic as well. I am still finding out which of these extractor needs to be modified. I need to load data into purchasing data cube (0PUR_C01) from two standard data sources: 2LIS_02_ITM and 2LIS_02_SCL. Step one: stop all postings in connected ERP system. For e. I have enhanced the extract structure of 2LIS_02_SCL (MC02M_0SCL) to include a field from the standard pool in transaction LBWE. There is a standard SAP DSO 0PUR_DS03 which is getting data from 2LIS_02_SCL. 2016-01-05 02:12:26 NOT all Rows are received yet: 2LIS_02_SCL. Technical Name. And below I am giving the job log details of ODS activation. PSA in BW. The information under these fields are dependent from the information of field BWVORG (BW transaction key). Open View Browser app from the search results. The outbound queue is filled for the following queues in the. Search for additional results. AFS Elementary Field Color /AFS/BWEL_COLOR. 2LIS_02_SCL returns data for the purchase order on header item and schedule line level. "Document data restriction" when filling setup table. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. Once the setup table filling is done. If any entries are available then trigger the equivalent Info. 1. Key Fields;2lis_02_acc, 2lis_02_cgr, 2lis_02_hdr, 2lis_02_itm, 2lis_02_scl, 2lis_02_scn, 2lis_02_sgr, 2lis_03_bf, 2lis_03_bx, 2lis_03_um, 2lis_04_p_arbpl, 2lis_04_p_arbpl_20. But these datasource read data from EKKO,. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Sep 16, 2009 at 06:26 PM. Marco. Vendor Supply Information. As you konw, When R/3 system doesn't make any transaction data, we can fill the setup table. Hi Fabio, No You cannot do a setup for 2LIS_02_ITM only, You can only do a setup for the whole 2LIS_02. Currently, when I load the Setup table for Purchase application, I don't have any record for that kind of purchase order though I have standart PO. Request or instruction from a purchasing organization to a vendor (external supplier) or a plant to deliver a certain quantity of a product or to perform certain services at a certain point in time. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource Purchasing Data (Schedule Line Level) (2LIS_02_SCL). However, when. Line 40 had been entered. You will find that value of "LOEKZ" of. However after full loading, you notice that more schedule line records are extracted by Datasource 2LIS_02_SCL. Similarly Now Check for the Data Source 2LIS_02_ITM Now Check for the Data Source 2LIS_02_SCL Go to Tcode SM13 (update Request) Go to ME21N (creating Purchase Order) Go to SMQ1 (Queue Status). We have extracted purchasing data using 2LIS_02_SCL and 2LIS_02_ITM datasources. This DSO is filled by InfoSource MM-PUR: Purchase Data Schedule Line Level (2LIS_02_SCL) (/IMO/PUR_IS12) to provide contract and scheduling agreement call-offs. Purchasing 2LIS_02_SCN MC02M_0SCNSETUP BW-Rebuild for. By default, either of these does not capture changes to a transaction field in VL32N > Item > foreign trade/customs tab > Invoice accomp. Based on DataSource: 2LIS_02_SCN. As I can see, for every Purchase Order Item I get three records: - one record for the last Invoice Receipt (with Posting date of invoice receipt in BUDAT field) - one record for the last Goods Receipt (with Posting date of goods receipt in BUDAT field) - one record for something else. LIS_ITM is meant for item level information e. About this page This is a preview of a SAP Knowledge Base Article. Our users are complaining, because they expect it to match up. Problem: Setup tables are not getting populated for 2lis_02_hdr, 2lis_02_item. DataSource . The details are as below:RSA3 for 2LIS_02_ITM,2LIS_02_SCL , 2LIS_03_BX, 2LIS_03_UM shows data but it does not get updated to the cube ( 0PUR_C01, 0IC_C03). Tables for 2LIS_02_ITM. I don' t understand because there are many records in EKPO and EKET for STO (document range. The Posting date (BUDAT) from the 2LIS_02_SCL is being assigned to 0CALDAY with the rule type specified as Time Characteristic. 2lis_02_sgr. 2. MC11V_0SSL: Extraction MD Sales: Order Delivery for DataSource 2LIS_11_V_SSL. th einfo object may be the same but there is a big diffrence . There I see data only for some extractors (2LIS_46_SCL and 2LIS_46_ITM) : see attached picture issue-gtm-01. We have a standard datsource 2LIS_02_SCL for loading the Issued quantity WAMNG against PO. In combination with the InfoSources Purchasing Data (Document Header Level) and Purchasing Data (Document Item Level), the InfoSource Purchasing Data (Document Schedule Line Level) supplies the basic data for analyses of purchasing documents. As per the solution design, we need to enhance the 2LIS_02_SCL extractor with 3 fields from the EBAN by looking up the purchasing document. Transaction LBWQ in ECC: MCEX02. This is basically information relating to the delivery completed indicator, open quantity and planned delivery date or requested. I activated 2LIS_02_itm and SCL datasources in LO cockpit but, it is not prompting for a transport request. This counter determines the number of deliveries based on the GR document items. As I can see, for every Purchase Order Item I get three records: - one record for the last Invoice Receipt (with Posting date of invoice receipt in BUDAT field) - one record for the last Goods Receipt (with Posting date of goods receipt in BUDAT field) - one record for something else. I need a Report in Local Currency ie: USD only (US dollers), Here what I am getting in my Report is all different currencies . Some are transparent, some are reference, but there are one or two that stand out here. Extractor 2LIS_02_SCL --> behaviour when ELIKZ is set. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Hello, gurus. Bei Einkaufsbelegen, die in einer anderen als der Hauswährung angelegt wurden oder zu denen Belege wie z. If successful, 6. From this data source data is storing in two data targets 1. WKURS - Währungskurs. of DataSources 2LIS_02_SCL, 2LIS_02_ITM, 2LIS_03_BF, 2LIS_03_UM, 2LIS_40_REVAL are not filled. 1 - System standard fields. but I need only in USD(US dollers) For these I followed the steps like thisLBWQ entires not loaded to RSA7 after RMBWV302 run - 2LIS_02_SCL ok to ITM. We are doing a delta update. Choose. In R/3- Enhance the SCL extractor by adding the ZZ. Hi, I am working on the Procurement area and will be setting up the 2LIS_02 extractors (HDR, ITM, SCL and ACC). 2016-01-05 02:11:46 rqState 9: Reported complete by SAP, id: 17. Check the PO in ME23n for Order qty. The information under these fields are dependent from the information of field BWVORG (BW transaction key). I am loading the data form the 2LIS_02_SCL datasource to the DSO in BI. Then save the PO. I made my changes in the development environment and transported them to QA. SBIW > Application specific datasources> Logistics > Settings for. If successful, 5. MM-PUR: Purchase Data Schedule Lines (2LIS_02_SCL) - /IMO/CMPUR12. When I check with RSA3 I've got a lot of. The Data Lake page appears. 但是系统字段：交货单号（ ekbe-belnr ），参考凭证号（ekbe-xblnr ）没有。如果不做增强， 在其它数据源上是否有这二个字段？我找了采购，销售的都没有这二个字段，可能我还没有找对，麻烦各位高人帮指点。 谢谢. Here Loekz field related data is completely not fetching from the above data sources partial data is able to get. doc / . 2 LIS_02_HDR (Purchasing Document Header Level Data) 2LIS_02_ITM (Purchasing Document Item Level Data) 2LIS_02_SCL (Purchasing Document Schedule Line Level Data) Step 1 : Log on to Sap R/3 Ecc System. We now decided to load Purchase (Old), Purchase (New) and Article Logistics cubes using 2LIS_02_SCL with the same Info Package. e: if ELIKZ = X , delivery completed else it is an open PO. txt) or read online for free. The values can be seen in EKPO table but I am not sure this would be the source for extractor 2LIS_02_ITM becuase, when I run setup table or extract. A total of 9 records are dropped while extraction from R3 to BI. On RSA 3 when i check out the extraction for the PO, i find that there are 2 extra (-)negative records (ROCANCEL='R') for the. This extractor also brings data from Goods receipts and Invoice Receipts which typically come from EKBE table. as the data in that dataset. 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 7. This is to keep data that is depending on each other consistent. Transaction event type has the values 1 to 8, I am comparing the keys EBELN and EBELP from structure. Now we realize that processkeys 010 are missing but 2LIS_02_ITM catches these. I now am trying to get publishing back on track. here give the PO numbers, specify a name for the job run and execute. I have already maintain datasource 2LIS_02_ITM through LBWE. Same problem i got for Cube 0PUR_C01, for same datasource only i. 2. Extraction job in R3 is unable to extract any data, so it . I'm trying to reconcile a record produced by the 2LIS_02_SCL datasource back to the base R/3 tables. oss note 353042-Howto: Activate transaction key (PROCESSKEY) may also useful. J_3ASIZE. J_3ASIZE. 3. It's almost impossible to fill the setup table. 2lis_03_bf . Dear Gurus, I have a requirement to extract Invoice Recipt Document number & Invoice date for every purchase order into BW. When i execute the extractor in RSA3 the data is populated, If any standard field is changed then it is. I have a question. here give the PO numbers, specify a name for the job run and execute. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_11_V_ITM: Sales-Shipping Allocation Item Data: SD - Sales and Distribution: 2LIS_11_VASCL: Sales Document Schedule Line: SD - Sales and Distribution: Tables related to 2LIS_13_VDITM TABLE Description Application ; VBRP:The key column for BW is “Sub tot”. Hello, while testing extraction of 2LIS_02_ITM and 2LIS_02_SCL (rsa3), the system tells me ""0 data records selected"" even when I did everything before correctly: - LBWE - activation and set of direct delta - set application active indicator - customize industry sector - deleting setup tables - creating the statistics from the historical data. I am trying to fill up the SETUP tables. Step 001 started (program RSODSACT1, variant &0000000060772, user ID U6X9539) Activation is running: Data target ZP2_PSCL, from 1,572,117 to 1,572,117. Job for collective update stopped (LBWE) 4. Why are the setup tables not filled?The data is not updated into the upur_c01 cube . ALIEF - Number of Deliveries This counter determines the number of deliveries based on the GR document items. 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: Messages related to MCBO MESSAGE Description;. It would be really helpful to know the used tables for datasource 2LIS_02_ITM. However, before replicating to the BW on HANA system connected, I checked data in S4 via RSA3. 2LIS_13_VDITM. Timeout type: TimeoutData, Extractor: 2LIS_02_SCL" On the screenshot from the Publisher below all tasks in the group are from SAP ERP system except SAP Extractor Group_A_002 ZBI_NEW_PILOT DELTA, which. Vote up 2 Vote down. However after full loading, you notice. The Info Package which indicates that an x amount of records were transferred but not received, got a timeout and was restarted just to bring in zero records in the delta. For more information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. "Hi, we need to track the modifiations of the PARVW (Role Partner) when it is changed in a Purchasing document. This could be a viable solution? Do you have any document in order to configurate it? I tested it in RSA3 but no data retreived. First time in the Initial update and seond time in the delta update. Data Modeling. x flow. Follow the below steps to get the lost delta, will be useful for any loads. 2lis_02_scl. MM. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 5 : 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 6 :. Kindly suggest any Solution. there will be a second record in 2LIS_02_SCL. I am trying to work with the standard Purchasing queries based on 0PUR_C01. 以下是SAP ECC中各主要数据源与描述. I created a PO with Qty 100 on 03/28/2007 and perfroemd GR on the same day for Qty of 25. Thanks. Inventory Controlling (application 03): 2LIS_03_BX. 2LIS_02_ITM and 2LIS_02_SCL. BNKA: Master Records of banks. This field determines whether these values are from a purchasing order, goods receipt or. Process overview . I used rsa3 to validate these 2 fields against EKET table, the Received Qty is not correct. But the extractors 2lis_02_scl and 2lis_02_hdr don't load the PARVW field; and when the PARVW field is changed in a Purchasing document, the modification date is not updated. 2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management: 20 : 2LIS_03_UM Revaluations MM - Materials Management: 21 : 2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management: 22 : 2LIS_13_VDKON Billing Document Condition SD - Sales and Distribution: 23 :2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 3 : 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 4 :. I have reviewed SAP note 684465 with the list of values BWVORG for purchasing. 2LIS_02_SCL enhancement - SAP Q&A Relevancy Factor: 1. If successful, 3. 1) Add the custom fields to the Communication structure (MCEKET - for Schedule lines) using the APPEND Structure in SE11. g for one item 001 u have quantity 90PC. I have a question. 2LIS_03_BF. (BANFN) and. We have historical data for 2LIS_02_SCL loaded in PSA. From the business content, in the update rule: 2LIS_02_SCL -> 0PUR_DS03. In 7. Situation: In the business content the update rule of 0PO_QTY is referencing the time characteristic 0SCHED_DATE for 0CALDAY. But for 2LIS_02_SCL, i am not getting either 7. The problem is that instead of sending over the Doc Value Amounts found in the EKBE table, SAP is doing a calculation based on the the local currency. This DataSource provides the BW with data from the Sales area and supplies the InfoSource 2AF_SD_SHP_1 with data. Data Modeling. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. when checked the data by RSA3 , I found the system generated mass data(2400 records) . Expand in hierarchy structure node Logistics application – 12: LE Shipping BW – Extract structures. e, The new DataStore object of Invoice Verification (0LIV_DS01) is supplied with data by the new DataSource 2LIS_06_INV, whereas previously the relevant invoice. Below is the logic. Hope this helps. Your LIS_SCl will contain the schedule line information that is if somebody wants schedule date wise e. Therefore, the values for PO Qty, GR Qty and Invoice Qty (and their corresponding value KF's) appear to be. If you choose the Delivery Schedule Lines view in the transaction ME80FN, you can compare the data in the DataSource fields with the original document data in SAP R/3, such as: · Purchasing Document Number (EBELN) · Item Number of Purchasing Document (EBELP) · Item delivery date (SCLDT)Technical name: 2LIS_02_SCL. MM-PUR: Purchase Data Schedule Lines (2LIS_02_SCL) - /IMO/PUR_IS12. Is there any standard solution to extract. infoobject are overwritten in the ODS. In the migrated Transformation between InfoSource 2LIS_02_ITM and DSO ZPUR_O01 (Position) I have two rule groups. 2LIS_06_INV: Extraction of Invoice Verification Data into BWThis DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource Purchasing Data (Schedule Line Level) (2LIS_02_SCL). 1) Go to the RSA6 (Find ur datasource 2LIS_02_ITM double click on it ) 2) Double click on the extract structure 3) You will see extract structuter then you can see the append structure at the top left click onit 4) Give. Assuming, you would like to use the new method, the process would be like this: RSA5 u2013 Source system; activate these datasources 2LIS_02_ITM and 2LIS_02_SCL. One or more purchasing documents or items are not extracted either by a full load or a delta loads using some of the following DataSources: 2LIS_02_ACC, 2LIS_02_CGR, 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_02_SCN, 2LIS_02_SGR. Keyfigures 0ORDER_VAl and 0INVCD_AMNT are in Addition mode. I have thought to create a new ODS to upload information from this DS 2LIS_02_SCL, and fill data in two steps: Infopackage A: Full Update. I am working with 2LIS_02_SCL. We deleted the inbound queues for 11. I have loaded data into 0PUR_DS03 from datasource 2LIS_02_SCL , I have done the Initiail load successfully and also the delta load successfully (receive the new data into 0PUR_DS03) >> It's OK. i. I ran OLI3BW to fill the set-up tables and tried with RSA3 (no selections) and it returned 0 records for 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. This InfoSource contains the structure to provide purchase accounting data on item level into the EDW Core Layer. and he has managed to laod data using full upload without. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. Logic of Datasource 0INFO_REC_ATTR . In other words, you can change the existing layout (such as add or hide fields and columns, change the sort sequence, add subtotals, set filters), save the. To have an understanding about BW DataSource 2LIS_02_SCL for deletion and un-deletion a Purchase Order Item. 2016-01-05 02:12:57 NOT all Rows are received yet: 2LIS_02_SCL I did Enhance 2LIS_02_SCL with Material doc and Item number from EKBE. if you put EKET then it brings up. there is a routine for the PO open quantity 0BO_QTY as follows: RESULT = COMM_STRUCTURE-cpquaou * COMM_STRUCTURE-numerator / COMM_STRUCTURE-denomintr. Comparing DataSource. 0. Affected REMOTE SUBSCRIPTIONS: SUB_VT_2LIS_03_BF, SUB_VT_2LIS_13_VDITM, SUB_VT_2LIS_02_ITM, SUB_VT_2LIS_13_VDHDR, SUB_VT_2LIS_02_SCL, SUB_VT_2LIS_12_VCITM, SUB_VT_1_CO_PA_CHEMICALS, SUB_VT_2LIS_11_VAKON, SUB_VT_2LIS_11_VAITM, SUB_VT_2LIS_11_VAHDR,. 2LIS_02_ITM EKKO, EKBE,T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K,. RemoteCube Compatibility. But it is fetching 0 data with green status. SAP. RSS Feed. Strangely when we load data using delta mechanism, we are not getting the correct updated 'issued quantity' . Among the ORECRODMODE and STORNO, which is better option to be mapped with the. do not extract the good Invoice receipt quantity for each purchase order. 2LIS_02_SCL : Purchasing data schedule line level 2LIS_02_SCN : Produced Activity : confirmation of schedule Lines 2LIS_02_HDR : Produced Activity : Delivery of schedule lines 2LIS_02_HDR : Produced Activity : Delivery Confirmation Purchasing Standard Info Cube and DSO Info cube 0PUR_C01 Purchasing Data. I tried pulling the data from R/3. 7. "MCEX_UPDATE_02_V1" "(FORM)", or declared in the procedure's RAISING clause. Hi all, I ran OLI3BW to fill the set-up tables and tried with RSA3 (no selections) and it returned 0 records for 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. Then use the function Activate and Schedule to start the process chain according to your scheduling options. SAP Library - ProcurementIn case of LO Extractors, (2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL in my case), if we have to do full upload, do we still need to run the setup in R/3. We need to delete and fill setup table for 2LIS_02_SCL because we have changed a rule in Trasformation so we need to reload some data in our ODS (all KF are in Overwrite). We are using two PO extrctors 2LIS_02_ITM & 2LIS_02_SCL to load data, both are working fine. O transormation between the Datasource and DSO, ROCANCEL field needs to be mapped to the either the 0RECORDMODE or STORNO to identify the delta records. It would be fine if 2LIS_02_SGR provided the amounts (a left outer join of the. populate Goods Receipt value and Invoice Receipt. Explanation of Note 578471 - Deleted positions in BW and statistics . . MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. enabled:true in the Search box and press Enter. Ramarao. Subsequently it was found that changes to these fields using an append and ABAP is not. When i try with 2LIS_02_ITM ,2lis_02_scl and 2lis_02_hdr ,R3 returns correctly my records from the set-up table . ) 2LIS_02_SCL & 2. AFS 3. The standard purchasing info objects in BW for storing the subtotals are 0SUBTOT_OC1 –. i need to. Load data InfoPackage 2LIS_02_ITM_INIT_R3. LE key figures for the delivery item: This InfoSource contains information that relates to the delivery item, such as delivery quantity in sales units or delivery quantity in the base unit of measure. Solution : Prerequisite: Make sure all your datasources are active in LBWE. where this is using a standard datasource 2LIS_02_ITM and 2LIS_02_scl and i have acitvated this standard cube 0pur_c01. I have some strange problem in R/3. I am currently have an issue with Received Qty of DataSource 2LIS_02_SCL. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. eg: and comm_structure-cppvlc <> 0. Technical name: 2LIS_02_SCN. Here Loekz field related data is completely not fetching from the above data sources partial data is able to get. I created an ODS object with the following fields as a key. I am activating structure. docx), PDF File (. Name. When i try with 2LIS_02_ITM ,2lis_02_scl and 2lis_02_hdr ,R3 returns correctly my records from the set-up table . The field is BADAT [Requisition (Request) Date]. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 2LIS_13_VDKON:. Reason: In customizing cockpit, tcode LBWE, the following EVENTS can be found for application 02: 02: Purchasing -> extract structure MC02M_0SCL . ) 3. Activate ODS data 0PUR_DS03. 2LIS_02_SCL. The data are transfered correctly (maybe!) from Extraction Queue to Delta Queue (daily, the amount of data is almost 1000 a day). Comparing DataSource. MC02M_OSCL. The purchase order exists in APO in the form of an order. As you are aware that some fields of the standard extractors gets derived via Calulation (SAP derived logic ) . V . 0AF_GRDVAL. In 2LIS_02_SCL i have 0CPPVLC (BWGEO), 0CPPVOC (BWGEOO), 0ORDER_val (BWEFFWR). Go to Maintainance. 0SCHED_DATE is mapped to SCL_BEDAT in the correspondending data source 2LIS_02_SCL. Follow RSS Feed Hi all, I want to find out the Table Field names for the for the below InfoObjects of DataSource 2LIS_02_SCL (Purchasing Schedule Line Items): 1. All of my changes propogated; the DSOs are now write-optimized;. With this setting I have to take downtime in R/3. apart from process key is there any. I am extracting purchasing data into BW using datasource 2LIS_02_SCL into ODS 0PUR_DS03. A problem or project situation that affects project goals. If you need reporting characteristics from the Purchase Order header data (2LIS_02_HDR), you can copy the 0PUR_C01 InfoCube into a custom name (e. Hi gurus, We Enhanced 2LIS_02_HDR and 2LIS_02_ITM Datasources to include account assignment (Cost center/Order/WBS element/Account). you can get the records by running the extraction of 2LIS_02_SCL in RSA3. before image; #; . MCEX03. We are using the BW DataSource 2LIS_02_SCL from the LO Cockpit and have added these two fields from the Customizing cockpit (LBWE): WAMNG WEMNG. This doubt came to my mind because, in the past LIS extractors were used in this project 2LIS_02_S012 ( not by me but my predecessor). Available from OLTP Release. Situation 2. Also can i avoid using 2LIS_03_BF for GR's by enhancing 2LIS_02_SCL with MBLNR(GR doc no) from EKBE. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials. The other datasource 2LIS_02_SGR is loading the Schedule Line with Goods Receipt from SAP tables EKET, EKBE and EKPO. In 2LIS_02_SCL i have 0CPPVLC (BWGEO), 0CPPVOC (BWGEOO), 0ORDER_val (BWEFFWR). 2LIS_02_SCL and _ITM Purchasing Cube 0PUR_C01. MC02M_0SCN Storage. That is the way SAP provides extractor fields. I am currently extracting PO Schedule Line Data from using 2lis_02_scl data source and I see there is a mismatch between ERP and BW regarding the Goods Receipt Quantity (movement type 103 is also included in BW). 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable:2LIS_02_SCL - Fields for PLIWK (Supplying Plant), PLIEF (Partner Vendor) & PWLIF (Good Supplier) 344 Views. The account assignment category determines the account assignment data for an item, such as cost center and account number. Due to some reason we have to fill up set up table for Purchasing (2LIS_02_ITM and 2LIS_02_SCL) again: These tasks have to been done: 1. 2lis_45* oliabw rmceneub Document update is where the transaction (documents) are updated in the application tables. I am using standard extractor 2LIS_13_VDITM and 2LIS_02_SCL. Then try to load the Setup Tables again with Transaction OLI3BW or navigate from Transaction SBIW >. 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2 : 0CO_OM_OPA_6: Orders: Actual Costs Using Delta Extraction CO - Overhead Cost Orders: 3 :. This how 2LIS_03_BF /UM. e. The counted number depends on how often a material appears in a GR document. ekpo -meins . 1. This counter determines the number of deliveries based on the GR document items. Hi i need to enhance the extractor 2LIS_02_SCL with MKPF-BLDAT or EKBE-BLDAT, but i don't know how to add this field, because the Purchasing Document (EBELN) and EBELP aren't unique key to enter in this table (they could have more material document with different BLDAT). Genrally BWMNG is mapped with 0CPQUAOU. "6. I also know that my InfoSources for this data are 2LIS_02_HDR, 2LIS_02_ITM, and 2LIS_02_SCL.