DataSource 2LIS_02_SCL was enhanced by field WAMNG (PO item issued queantity), but it is not updated by delta load (value of the field is 0). MCSJ and MC$4 uses info structure S502 and S012 respectively. 2lis_02_scl and 2lis_02_itm - SAP Q&A Relevancy Factor: 1. 0A. goods tab > invoice number field. To have an understanding about BW DataSource 2LIS_02_SCL for deletion and un-deletion a Purchase Order Item. 0B (2LIS_02_SCL) and Offsetting Confirmation and Goods Receipt (2LIS_02_SGR). values. BW SD MM FI 数据源. 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). For more information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. AFS 3. This data source is used often. I am using 2LIS_02_SCL for to fill the data into 0PUR_C01 cube. Posted by spicehead-klj5bhfd on Mar 8th, 2004 at 11:20 AM. In the transfer rule, there is a coding to check on process key in 2LIS_02_SCL. Hi Fabio, No You cannot do a setup for 2LIS_02_ITM only, You can only do a setup for the whole 2LIS_02. This is regarding finding out the Extractor Logic (Fuction module ABAP logic ) for few of the standard extaractors fields in sap ecc side. Hi All, Can you please share your experience on the 2LIS_02_ACC data source setup. If any entries are available then trigger the equivalent Info. This is basically information relating to the delivery completed indicator, open quantity and planned delivery date or requested. MM-PUR: Purchase Data Account Level (2LIS_02_ACC) - /IMO/PUR_IS13. 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. KNTTP – Account Assignment Category The account assignment category determines the account assignment data for an item, such as cost center and account number. 2LIS_02_SCL not extracting field EKPO-LOEKZ. Logic of Datasource 0INFO_REC_ATTR . We deleted the inbound queues for 11. MM Data Sources Tables Purchasing. if anyone knows tcodes for runinng the set uptable to each data source separatley. 2lis_02_hdr. 2. Please help. i need to. populate Goods Receipt value and Invoice Receipt. before image; #; . infoobject are overwritten in the ODS. 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. 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 7. Load data InfoPackage 2LIS_02_CGR_INIT_R3. Pls reply needed urgent,i'm. Customer-Defined DataSource ® L. I am working with 2LIS_02_SCL. I am unable to figure out why this fields is not populated. Now I am doing it to extract the purchasing group relevant dataand filling up the Cube PUR_C04. We are executing a delta load from datasource 2LIS_02_SCL and it is. Now my user wants to add the following fields to the report. e: if ELIKZ = X , delivery completed else it is an open PO. Difference Between 2lis_02_itm & 2lis_02_scl. 5. 1)Deleted delta queue for ITM and SCL on DEV 2)Confirmed on BWP that no delta existed for SCL or ITMYou have the option to use the old and new method. Technical name: 2LIS_12_VCITM. I am trying to work with the standard Purchasing queries based on 0PUR_C01. 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). I have a problem with Queued Delta Update Method. Once the setup table filling is done. Dear All, When I am populating 0PUR_C01 using the InfoSource (2LIS_02_SCL) I am getting multiple entries like if I have one material record for an relevant P. But when we have an Invoice Receipt the 2lis_02_scl puts WEMNG and WERT field blank while REMNG and REWRT are populated correctly. delta upload. For more information, see the data source documentation. Released . For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. MC11V_0SSL: Extraction MD Sales: Order Delivery for DataSource 2LIS_11_V_SSL. Problem: We are using the 2LIS_02_SCL to get our purchasing order data. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. All the Key figures in datasource are getting populated , but BWEFFWR (order value) is not getting populated. If you want to update a further key figure from the InfoSource check, the key figure needs to be updated in overwrite or additive mode. And one question concerning purchase data. We have a standard datsource 2LIS_02_SCL for loading the Issued quantity WAMNG against PO. I'm having an issue with extractor 2LIS_02_SCL whereby the quantity field WEMNG is populated incorrectly after perform initialization, below are the activities being done so far: 4) LBWE activate datasource and included field MCEKET WEMNG (Received) After performing these steps, in RSA3, the qty display in field WEMNG doesn't match. Our task is instead of performing Initialization WITH data transfer by deleting data in corresponding data targets, By considering historical data and time it will take to. I can create correctly the init update but I have problems with the. Available from OLTP Release. A problem or project situation that affects project goals. Symptom. missing, lost, loss, 2lis, queue, delta, aim, aimd, abr, addd, newd, 2lis_02_acc, 2lis_02_cgr, 2lis_02_hdr, 2lis_02_itm, 2lis_02_scl, 2lis_02_scn, 2lis_02_sgr, 2lis. so I add field CHARG into that datasource. This DataSource provides information about the header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on. I need to load data into purchasing data cube (0PUR_C01) from two standard data sources: 2LIS_02_ITM and 2LIS_02_SCL. BUT. - Process Key 003:IR. 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 :. V . So every day I would have request with delta data. The extractor 2lis_02_scl is based in the tables EKET, EKKO and EKPO is possible to add a field from other table? I tryied to enhancement the extractor but is not possible. Among the fields that were appended are fields EKKO-BUKRS and EKPO-LOEKZ. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. I need a Report in Local Currency ie: USD only (US dollers), Here what I am getting in my Report is all different currencies . Step 2: In the table TCDOB put the table name in TABNAME field, you will get some name in OBJECT. Help. txt) or read online for free. Schedule Line Level: DataSource 2LIS_02_SCL -> InfoSource 2LIS_02_SCL -> DSO ZPUR_O02 (Schedule Line Level) -> InfoCube ZPUR_C01. Here Loekz field related data is completely not fetching from the above data sources partial data is able to get. ENDLOOP. The requirement of mine is to show the End-User Total Number of PO's ,Open POs and Closed PO's for Current and Previous Months. I also know that my InfoSources for this data are 2LIS_02_HDR, 2LIS_02_ITM, and 2LIS_02_SCL. The 2LIS_02_SGR provides the GR document number and 2LIS_06_INV the IR document number. In 2LIS_02_SCL i have 0CPPVLC (BWGEO), 0CPPVOC (BWGEOO), 0ORDER_val (BWEFFWR). But in BI 7. This field determines whether these values are from a purchasing order, goods receipt or an invoice. However in the S/4HANA system, table KONV is obsolete and replaced by table. Step two: Delete delta entries in RSA7. , EBELP Item and ETENR Schedule Line. 2016-01-05 02:11:55 NOT all Rows are received yet: 2LIS_02_SCL. If the information in this field relates to an event in the purchase order, the field is filled with the posting date of the purchase order. We have a reporting requirement to merge 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_03_BF and 0FI_GL_4 to report on Purchasing information, which includes POs, GRs, and Invoices. Technically, it is always possible to expose a standard SAP DataSource for the ODP-SAP replication by maintaining a corresponding entry in table ROOSATTR in the relevant source system with OLTPSOURCE = <Technical Name of DataSource> and EXPOSE_EXTERNAL = ‘X’. 3. Technical name: 2LIS_02_SGR. Technical Name. 2LIS_02_SCL extractor does not always fetch data from EKET table. At my client we implemented the PO Sch Extrc 2LIS_02_SCL and 2LIS_02_ITM. 2) can i map 0CPPVLC (BWGEO), instead of 0ORDER_val (BWEFFWR) in the transformation and in routine b/w data source and cube. than the dataset, see the documentation on the ACCEPTING PADDING andCheck the Records Now Similarly check for 2LIS_02_ITM and 2LIS_02_SCL Now Check in RSA7 (ECC) Check for the Data Source 2LIS_02_HDR. Dear Gurus, I have a requirement to extract Invoice Recipt Document number & Invoice date for every purchase order into BW. In the S/4HANA on-premise edition of SAP Commercial Project Management, the business object 'issue' is referred to as 'issue activity'. In BW- IF ITM is feeding an ODS already in BW, create an UPDATE rule into the ODS that SCL is feeding data into for that particular field. Why are the setup tables not filled?Our delta queue for 2LIS_02_ITM and 2LIS_02_SCL was deleted from R3 by mistake. Vendor Supply Information. Purchasing Data (Document Schedule Line Level) Technical name: 2LIS_02_SCL. In datasource 2LIS_02_SCL, there is only fields BWMNG - that represents quantity, BWGEO and BWGEO that represent values. VRTKZ – Distribution Indicator for Multiple Account. InfoSources 2LIS_12_VCHDR , 2LIS_12_VCITM , and 2LIS_12. ATTR . I look at SE11 for ' MC02M_0HDRSETUP ' and table contents gives 0 records. Transfer struct. BUDAT – Posting Date. g. Determine Industry Sector. Here Loekz field related data is completely not fetching from the above data sources partial data is able to get. When checking the OMJJ transaction, the 103 and 104 movement types are marked. 670313-BW: field NETPR for data source 2LIS_02_ITM and 2LIS_02_SCL . With this setting I have to take downtime in R/3. Vendor. As you konw, When R/3 system doesn't make any transaction data, we can fill the setup table. Comparing DataSource. Then use the function Activate and Schedule to start the process chain according to your scheduling options. 2LIS_02_ITM: Purchasing Data (Item Level) 2LIS_02_SCL: Purchasing Data (Schedule Line Level) 2LIS_02_ACC: Purchasing Data (Account Level) SAP delivers sample BEx queries on top of MultiProviders for the following areas: Procurement Value Analysis. I would like to hear from you on following issue. Lost while creating the. The IP for Purchasing (2LIS_02_SCL) started the job in ERP and the job did finish, but BW never received the message that the ERP job has been successful. 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. 2. eg: and comm_structure-cppvlc <> 0. I have some strange problem in R/3. 2LIS_02_SCL: Purchasing data (Schedule Line Level) MM - Materials Management: 5 : 2LIS_03_BF: Goods Movements From Inventory Management MM - Materials Management: 6 :. Comparing DataSource. Can you please guide me through! Thanks, Ram. To have an understanding about BW DataSource 2LIS_02_SCL for deletion and un-deletion a Purchase Order Item. The data of this extractor needs to be used to measure a supplier service sevel based upon single schedule lines. Is there any standard solution to extract. 2LIS_02_ITM and 2LIS_02_SCL datasources not only extract PO line items. I am currently have an issue with Received Qty of DataSource 2LIS_02_SCL. 2lis_02_s012. i. Comparing DataSource 2LIS_02_SGR to ME80FN. "Document data restriction" when filling setup table. 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. there is a possibility the records containing this date might be getting filtered based on some difefrent field filter. Please help me. 以下是SAP ECC中各主要数据源与描述. Also can i avoid using 2LIS_03_BF for GR's by enhancing 2LIS_02_SCL with MBLNR(GR doc no) from EKBE. the data is been. Use. collective update this end with a dump with the message MESSAGE_TYPE_X. By default, either of these does not capture changes to a transaction field in VL32N > Item > foreign trade/customs tab > Invoice accomp. 2LIS_02_SCL, 2LIS_02_ITM, 2LIS_02_HDR, OLI3BW, RSA3, BSTYP , KBA , BW-BCT-MM-PUR , BW only - Purchase , Problem . By default, this object is created according to the DataStore Object (advanced) template Data acquisition layer (including corporate memory). (II) Click on the maintanence tab, pull the fields from communication structure to extract structure based on reporting requirement. I have a requirement to enhance the datasource 2LIS_02_SCL with some custom fields, those custom fields were directly appended in the EKET table and these fields were moved to the Right hand side under the maintenance link in LBWE. My question is if anyone of you have come across this issue? If yes how was it resolved. Use. Complete customizing, LBWE setup and Delta initialisation was performed the. We have attached 3 source systems to our BW and 2 of them are working absolutely without problems. The following has all been done. e. Delta Update. Please help me. I am enhancing MC02M_SCL structure for purchasing 2lis_02_scl, I added the fields MENGE (quantity) posting date (BUDAT) and transaction value type VGABE. 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. 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. But still the data source 2LIS_02_SRV will not be visible in LBWE, but is activated & will be visible in RSA3. Data Modeling. The field 2lis_02_ITM-AKTWE give the good GR Quantity for services but do. ) 3. 7. <b>Table Field</b> eket -menge . in 2lis_02_scl and 2lis_02_itm Data Sources. I am using Key figure BWGEO BW:CValLocCrcy & BWGEOO BW: CValOrdCrcy with summation. Has searched many threads from the forum but unable to find perfect solution. Your LIS_SCl will contain the schedule line information that is if somebody wants schedule date wise e. TBSL: Posting Keys. DSO Will Not Activate after Transport with rc=8. O I am getting 5 Line entries of this material Hence if the original P. Kindly provide a solution for the below problem whcih i am facing with 2lis_02_itm and scl data sources. Activate ODS data 0PUR_DS03. Line 30 had been entered and totally delivered. 2LIS_02_SCL EKKO, EKBE,T001, T001W, EKET, EKPA. not ectract the good Invoice receipt quantity. If the information relates to a goods receipt or an invoice, the field is filled with the. Transaction LBWQ in ECC: MCEX02. The subtotal amounts are extracted in PO currency. Why? What am i missing out do i need to do any changes before i actiavte the in-active tables in LO-Cockpit. ALIEF - Number of Deliveries. We are using two PO extrctors 2LIS_02_ITM & 2LIS_02_SCL to load data, both are working fine. Industry key is also set and application component is also populating. Allocation – Confirmation with Schedule Line. I'm very familiar with delta loading process (and complete setup) for the logistics datasources like 2LIS_02_HDR, 2LIS_02_ITM and 2LIS_02_SCL. Billing Document Item Data SD -Sales and Distribution. The EKET (Purchasing Schedule Line) table doesn't have this. In my example, I focus on an potential alternative to the classic LIS DataSource 2LIS_02_ITM (MM Purchase Order Items): C_PurchaseOrderItemDEX is a released delta-enabled CDS extractor. Load data InfoPackage 2LIS_02_SCL_INIT_R3. Company code. 103 movement type in 2lis_02-scl. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_11_VAITM: Sales Document Item Data: SD - Sales and Distribution:Conventional method: Purchasing (2LIS_02_S012) New method: Purchasing Data (Document Item Level) (2LIS_02_ITM) and Purchasing Data (Document Schedule Line Level) (2LIS_02_SCL) Note. Strangely when we load data using delta mechanism, we are not getting the correct updated 'issued quantity' . Change the Standard variant to Released Views variant. Hello, I'm trying use the datasource 2LIS_02_ITM but the field BWVORG is comming empty. Help needed, with detailed step would. However, if I use MIGO to do a goods receipt on the already initialize-loaded PO's, no delta for 2LIS_02_SCL is. 2lis_02_itm . 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. If you choose the Header/Item Data view in the transaction ME80FN, you can compare the data in the following DataSource fields with the original document data in the ERP system: For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. There r 2 ways to get this data. then check in data target. But for 2LIS_02_SCL, i am not getting either 7. When I extract this data to PSA ONLY, the count is 19191. (table EKPA). But these datasource read data from EKKO,. Some key figures in the data source need to be updated in an additive process. 2LIS_02_SCL enhancement - SAP Q&A Relevancy Factor: 1. I know that For purchase order details we used 2 datasources 1. In the SAP S/4HANA Cloud system, choose the App Finder and search for the View Browser app. Udo. Check details in below T codes: BF11- check box required for BW. 1) what are the difference b/t them. Load data InfoPackage 2LIS_02_ITM_INIT_R3. This DSO is filled by the InfoSource MM-PUR: Purchase Data Item Level (2LIS_02_ITM) (/IMO/PUR_IS11) to provide general information on the principal agreement. - Normal purchasing order - BWVORG = 001. However after full loading, you notice. MC02M_0SCN Storage. You may choose to manage your own preferences. We implemented 0PUR_C01 (Purchasing Data) cube filled with 2LIS_02_ITM and 2LIS_02_SCL extractor. 0AF_COLOR. goods tab > invoice number field. Specifically I am looking at the BWVORG field. 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). The issue is related to the extraction. The 2LIS_02_SCL init. Technical name: 2LIS_02_SCL. - Process Key 002:GR. Here for this Info cube from another 2lis_02_itm datasource also data is coming. 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). The standard purchasing info objects in BW for storing the subtotals are 0SUBTOT_OC1 –. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management:. I initiated on 04/14 and after a week i. From the business content, in the update rule: 2LIS_02_SCL -> 0PUR_DS03. The incorrect situation consists in the following. I has chosen required request and has pressed button. Please do advise on the below questions. 2016-01-05 04:11:47 NOT all Rows are received yet: 2LIS_02_SCL. I went on with the assumption that SCL will capture all events that ITM captures except for Quotations and Contracts (Which my. Sep 26, 2012 at 05:47 AM. The system only calculates this delta if a purchase order item is completed. InfoSources 2LIS_12_VCHDR , 2LIS_12_VCITM , and 2LIS_12. Controlling 2LIS_03_BF MC03BF0SETUP. ) 2LIS_02_SCL & 2. Type . In transactions "RSA1" has gone to a bookmark "DataSources", has selected a datasource "2LIS_02_SCL" and has chosen from the contextual menu "Manage". cpquaou is mapped to BWMNG which is the PO quantity "not the OPEN PO. The account assignment category determines the account assignment data for an item, such as cost center and account number. I needed to analyse contents PSA of the table of a Datasource "2LIS_02_SCL". You can use this InfoSource to evaluate delivery services. I activated 2LIS_02_itm and SCL datasources in LO cockpit but, it is not prompting for a transport request. Use. My predecessor actually changed the standard definition of this. We are doing a delta update. Thaning you. MC02M_0SCLSETUP. Among the ORECRODMODE and STORNO, which is better option to be mapped with the. The Select Data Source page appears. Apparently these two fields are NOT updated in BW from a delta load. It would be really helpful to know the used tables for datasource 2LIS_02_ITM. load brings in goods receipt history and a starting GR $-value if quantities are partially received (0CPPVLC/0CPPVOC), and the 2LIS_02_SGR init. May 21, 2012 at 04:31 AM. Delivery Item . In the ERP system, information about the header data of a purchasing document is contained in the EKKO table ( Purchasing Document Header ). The following delta update is supported for this DataStore object: - Delta Update: ABR: Complete Delta with deletion flag Via Delta Queue (Cube-Comp) - Data Source: 2LIS_11_VAITM. Visit SAP Support Portal's SAP Notes and KBA Search. When i try with 2LIS_02_ITM ,2lis_02_scl and 2lis_02_hdr ,R3 returns correctly my records from the set-up table . MC02M_OSCL. ZPUR_C01) and modify with any from the header that is needed. Vote up 2 Vote down. 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. For more information, refer to the. Feb 04, 2011 at 01:37 AM. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials. Also, source field Document date is being assigned to the 0ENTRY_DATE field in the target DSO. I used the datasource 2LIS_02_SCL to get the purchase data . 1 Answer. When we do the reconciliation with MC$4, some. BW SD MM FI 数据源. 2016-01-05 02:12:26 NOT all Rows are received yet: 2LIS_02_SCL. 2LIS_02_SCL. 3: Open delivery quantity/value: 2LIS_12_VCSCL gives the delivery quantity. 1) what are the difference b/t them. It enables quick access to any data with a low amount of administrative effort and is especially useful for sophisticated scenarios with unpredictable query types, high data volume and high frequency of queries. J_3ABWEL_COLOR. Customer Group 10. I never used 2LIS_02_SGR, but following the documentation it gives returns data related for goods receipt. PSA in BW. Change the PO Qty from 32 to 40 and save the same. 2LIS_02_ITM (Field CHARG is BLANK in RSA3) Recently, I need Batch data for reporting related to Purchasing , fortunately there is field CHARG (Batch) in 2LIS_02_ITM. This counter determines the number of deliveries based on the GR document items. Visit. 2lis_02_scn. As per the BI content online documentation for an info source 2LIS_02_SCL, Set up table for purchasing application needs to be recreated. If you wish to use the new extraction method, you must make certain settings in Customizing for the OLTP system. I made my changes in the development environment and transported them to QA. Maintain your data source in LBWE, For this: (I) Inactivate the data source. LBWE u2013 activate in option 02 your datasource, follow the right sequence. ME23n – PO Qty. 1. J_3ADEPM. From this data source data is storing in two data targets 1. 2LIS_02_HDR EKKO, EKBE,T001, EKPA. We had at this point realised there is no Delta on the Purchase cube(New). Has searched many threads from the forum but unable to find perfect solution. I found the some information on this data source from the business content as follows. I add the following fields REMNG /REWRT/ WEMNG /WEWRT in the LO cockpit. for Infosource 2lis_02_scl - 10 : MCEKET: Purchasing Document Delivery Schedule MM - Purchasing Information System: Structure 11 : MC02M_0SCLSETUP: Storage BW Setup for MC02M_OSCL Logistics - Logistics Information System (LIS) Transparent Table 12 : TMCLVBW: Transaction Key for SAP BWWe consider to use 2LIS_02_SCL to extract schedule line data but after examining the data we got, a confused result occurs. The extractor works correctly till the good Receipt and fills WEMNG and WEWRT fields correctly. The process chain supports SAP R/3 standard systems as of Release 4. Data sources 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL. Now, all the extractor must be zero (0). you can get the records by running the extraction of 2LIS_02_SCL in RSA3. Comp. Purchsing Data Extraction through EKBEH table. Is there any standard solution to extract. Unfortunately data doesn't. The three others (2LIS_46_HED ; 2LIS_46_CFM ; 2LIS_46_GTM) are not showing any data : see attached picture issue. Delete the setup data (LBWG) 2. Change PO Qty For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. "6. Hi, I have activated and loaded data in datasource 2lis_02_scl. g. 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 4 : 2LIS_11_VAITM: Sales Document Item Data SD - Sales and Distribution: 5 : 0FI_GL_4: General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting: 6 : 2LIS_03_BX: Stock Initialization for Inventory Management MM - Materials. i did the setup using one purchase order no(of course I deleted the setup table before did it). 0SUP_PLANT (Supplying Plant) - populated from Structure Field Name. Enter the search text @Analytics. As per the BI content online documentation for an info source 2LIS_02_SCL, Set up table for purchasing application needs to be recreated. This may lead to the following: The system does not perform…The data sources 2lis_02_itm ,2lis_02_scl etc will have these tabels data . Process overview . Both the datasource do not have Material document number (BELNR) field. 2LIS_03_UM: Revaluations MM - Materials Management: 6. pdf), Text File (. This InfoSource contains the quantity that was delivered for each schedule line in a delivery item. Hence there are multiple records for one PO item with different 0PROCESSKEY. We have historical data for 2LIS_02_SCL loaded in PSA. Data sources 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_02_SCL. My client here does not use schedule lines. = I've been running a FULL Load from this data source with no problems. Once I do that, I am able to extract data for an info source 2LIS_02_SCL. V . but when I perform initialization of LIS table on R/3 side I make initial load to BW I can see that there is an. 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. I have to use two info sources called 2LIS_02_SCL and 2LIS_02_SGR in order to populate data in the cube. 0AF_GRDVAL. When I went to look at this, I see that 2LIS_02_S012 is listed as a conventional method and that using 2lis_02_ITM, 02_LIS_02_SCL is the new method. I tried to install it separately from BI Content but could not find transformation or transfer rule related to Cube 0PUR_C01. If the DataSources are from the LO cockpit, this push takes place either with a direct delta. For example, by comparing the planned and actual goods issue dates, you can determine which quantities were delivered on time. The additional field is not filled when you check the delivered data on BW side. 0SCHED_DATE is mapped to SCL_BEDAT in the correspondending data source 2LIS_02_SCL. I have some strange problem in R/3. This how 2LIS_03_BF /UM. Sep 16, 2009 at 06:26 PM. Situation: In the business content the update rule of 0PO_QTY is referencing the time characteristic 0SCHED_DATE for 0CALDAY. Block user to modify to modify purchase. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_CGR:. Symptom. 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 7. 0AF_DEPTM. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 5. The field is BADAT [Requisition (Request) Date]. docx), PDF File (.