KBA , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BC-BW , BW Service API , Problem Like I activated the datasources in LBWE than I intialised all datasources. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 25 : 0FI_GL_14 General Ledger (New): L in e Items Lead in g LedgerThis DSO is filled by the InfoSource Data Account Level (2LIS_02_ACC) (technical name: /IMO/PUR_IS13). MC02M_0HDR: Extraction Purchasing (Header) for DataSource 2LIS_02_HDR. 2LIS_02_ITM. This po was already loaded after initial creation. 7) 2LIS_03_BX. MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. 2LIS_02_ITM Purchase Order Items. The standard extractors 2LIS_06_INV and 2LIS_02_CGR brings data where this field is not extracted but taken into consideration in back end. I am using 2LIS_02_CGR extractor to extract ASN data and I see that only PO with ASN data against which there are GRN exists is extracted. I wanted to enhance the DataSource 2LIS_02_CGR, but it is saying we cant enhance it. 3. With CDS, data models are defined and consumed. 5. 2006 to 31. Based on DataSource: 2LIS_02_CGR. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 12 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13 : 2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management: 14 : 2LIS_02_ACC Purchasing Data (Account Level) MM -. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. Thanks. Skip to Content. please if any one could give me steps to extract the data into setup tables. 57 SP 06 and higher, this object is obsolete and has been replaced by Advanced DSO (ADSO) MM-PUR: Purchase Order Delivery (Items) - /IMO/D_PUR21. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: SAP Help, Wiki, Q&A and other resources for RSDRO302 "Fiscal year variant X1 not expected" when loading. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management:. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 21 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 22 : 2LIS_06_INV Extraction of Invoice Verification Data into BW MM - Materials Management: 23 : 2LIS_04_P_COMP Component View from PP/PP-PI PP -. After transport to production I see that while a few fields are unhidden a few are appearing as. If successful, 5. 2lis_02_sgr eket, ekbe, kkpo. Data for key figures like order quantity in the 2lis_02_itm data source (and also few other key figures) had been designed as addition in the update rule, therefore data for order quantity populates as negative when there is any update to the existing records. Am I missing any essential steps. Now how do I find the corresping infoobjects for these enhanced fields. x to 7. i am new to development . 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_02_SCN:. In RSA3 it shows 146 and in 0PUR_O01 it shows 146 as transferred and added as 93 . 2) 2LIS_02_ITM. EXTRACTOR PROBLEM. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. Indicator: Cancellation of data record. Empty the BW delta queues on R/3 by extraction to BW: Start prepare phase on R/3 including generation of shadow instance. How to enhance datasource 2LIS_02_S174 | SAP Community Relevancy Factor: 1. Please also specify what is the way to find out it. BW SD MM FI 常用 数据源. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 20 : 2LIS_04_P_COMP Component View from PP/PP-PI PP - Production Planning and Control: 21 : 2LIS_11_VASCL Sales Document Schedule L in e SD -. I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. I need the data of the original GR (the 103. Based on DataSource: 2LIS_02_CGR. 2LIS_02_ACC Purchas in g Data (Account Level) MM - Materials Management: Premium Member Only Results. For more information, see. When we do the reconciliation with MC$4, some. InfoSources. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 5 : 0MATERIAL_ATTR: Material Number Logistics - Logistics - General: 6 :. Allocation - Schedule Line with Goods Receipt. Symptom. But some of the. but when i fill the set up tables data is coming only itm and sgr but here in r/3 data is maintaing by the client can anybody help me why the data is not coming to cgr& scn. 2006 and do a test under rsa3, i only manage to see 1 record outa 50k records which is reported by the system. This DataStore Object integrates data on purchase order items based on the purchase order items from the InfoSource 2LIS_02_ITM and from the allocation structures 2LIS_02_SGR (allocation schedule line with goods receipt), 2LIS_02_CGR (allocation confirmation with goods receipt) and 2LIS_02_SCN (allocation schedule line with confirmation). We have extracted purchasing data using 2LIS_02_SCL and 2LIS_02_ITM datasources. e. Though after doing setup I find data coming correctly for. Hope it helps. I checked the. Alloc - Confirmation with GR (2LIS_02_CGR) - /IMO/PUR_IS22 . If successful, 3. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management. In SAP NetWeaver 7. Change the Standard variant to Released Views variant. 36. Then you will get your data. from 2LIS_02_ITM and CGR), newest data (with same EBELN and EBELP) from 2LIS_02_CGR to 0PUR_O01 will only update necessary field from CGR without replacing older data from 2LIS_02_ITM, like updating MATDOC without replacing. 4. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_11_VASTH: Sales Document Header Status: SD - Sales and Distribution: Table Fields related to S003BIWS TABLE FIELD Description; LO: Business Area: SAP Help, Wiki, Q&A and other resources for S003BIWSHit enter to search. I want to enhance the datasource 2LIS_02_S174, but when i try to enhance extract structure,its showing. 10) 2LIS_02_S013. Inbound deliveries are MM deliveries. Note. Allocation – Confirmation with Schedule Line. Logistics - General. We want to load data with the same DS from System B with 7. If vendor confirms 215 quantity for 1st schd. In RSA7 i purged or deleted the records and entry for this datasource. To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. i never tried to enhance this datasource its first time i am working on this. 2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management: 22 : 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 23 : 2LIS_11_VASTI Sales Document Item Status SD - Sales and Distribution: 24 : 0ME_ISM_SD_ORD_ITEM IS-M/SD: Subscription order Data - 25 : 2LIS_12_VCITM. Description. 2LIS_02_SCN. Hi Friends. Purchsing Data Extraction through EKBEH table. I checked the. 1. If successful, 3. 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. MM-PUR: Purchasing Document Header - /IMO/D_PUR10 . Due to some loads failed, we are doing re-init the loads. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 2lis_02_cgr ekbe, ekes, ekpo. 1. BalajiBut 0PUR_O01 is designed on 2lis_02_itm, 2lis_02_scl, 2lis_02_sgr and 2lis_02_cgr data sources. Skip to Content. I created the setup tables via "Purchasing - Perform Setup. problems with 2LIS_02_SCN and 2LIS_02_CGR. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_11_VAITM: Sales Document Item Data: SD - Sales and Distribution: 2LIS_12_VCITM: Delivery Item Data: SD - Sales and Distribution:I am loading 0PUR_O01 from 2LIS_02_ITM/SGR/CGR and SCN. If a ASN is generated without GRN then we are unable to fetch the same using 2LIS_02_CGR. Regards. In RSA7 , for the relevant datasources , I see 0 records. Load data InfoPackage 2LIS_02_SCN_INIT_R3. mm. Are there any particular procedures and precautions in using the above mentioned extractors. Once we get the above screen, we could specify the component (02, 11, etc…) and click on execute button. 2LIS_02_ITM 2LIS_02_HDR 2LIS_02_SCL. 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. I have set up the source systems in BW and created infopackages etc. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 23 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 24 : 2LIS_13_VDKON Billing Document Condition SD - Sales and Distribution: 25 : 0FI_GL_4 General Ledger: Line Items with Delta Extraction2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_13_VDITM: Billing Document Item Data:2lis 02 Cgr Data Source Tables Most important Database Tables for 2lis 02 Cgr Data Source # TABLE Description Application Table Type; 1 : MARA: General Material data: Logistics - Material Master: Transparent Table 2 : MARC: Plant data for Material Logistics - Material Master: Transparent Table 3 : VBAK: Sales Document: Header data:2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 7 : 2LIS_02_S011 Purchasing groups MM - Materials Management: 8 : 2LIS_02_S015 Subsequent Settlement: Evaluation MM - Materials Management: 9 : 2LIS_02_S013 Vendor Evaluation MM - Materials Management: 10 : 2LIS_11_VAITM Sales Document Item. 2lis_02_s011. S012 is a standard Data Collection Transparent Table in SAP Logistics application, which stores Purchasing data. After filling setup table using transaction OLI3BW, 2lis_02_srv still returns zero record in transaction RSA3. Logistics Information System (LIS) Data Collection. it will be great. 0PROCESSKEY. 2LIS_02_ACC Purchasing Data (Account Level) MM - Materials Management: 18 : 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 19 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 20 : 0CUST_SALES_ATTR Customer number2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_S013: Vendor Evaluation: MM - Materials Management: 2LIS_02_S174: Services: MM - Materials Management: 2LIS_03_S194: MRP: Business Info Warehouse: MM - Materials Management: Errors related to MC02M_0SCN ERRORThis is a customized Z- ODS purchased order item ODS in 3. MM-PUR: Purchasing Document Schedule Line - /IMO/D_PUR12 . here give the PO numbers, specify a name for the job run and execute. InfoObject. regards. 2LIS_02* OLI3BW RMCENEUA. 2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management: 16 : 2LIS_11_V_SSL Sales Document Order delivery: SD - Sales and Distribution: 17 :2LIS_02_SGR Produced Activity: delivery of Schedule Lines MM - Materials Management: 17 : 2LIS_02_CGR Produced Activity: delivery of Confirmations MM - Materials Management: 18 : 2LIS_08TRFKZ Shipment Costs at delivery Item Level SD - Sales and Distribution: 19 : 0ME_ISM_SD_DELIV_2 IS-M/SD: delivery (With Order Attributes) - 20 :. Vendor to Purchasing organsiation . Online Help Keyboard Shortcuts Feed Builder What’s new2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 7 : 2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management: 8 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 9 : 2LIS_11_VAITM Sales Document Item Data SD - Sales and. Document update is where the transaction (documents) are updated in the application tables. HI EXPERTS, when i am trying to activate datasource 2lis_02_cgr it says "Structure maintenance not provided for extraction structure MC02M_0CGR ->". 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 10 : 2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management: 11 : 2LIS_02_ACC Purchasing Data (Account Level) MM - Materials Management: 12 : 0PM_OM_OPA_2 Maintenance order s: Actual Costs by Means of. 2. 2LIS_02_SGR brings back a Process Key of 0 and no Schedule Line | SAP Community Relevancy Factor: 1. Comparing DataSource 2LIS_02_CGR to ME80FN. 2lis_03_bx. Header Data. Queries. InfoObjects: 0VENDOR. Inbound Deliveries comes into picture of Purchasing. Edited by: pannalde on Dec 2, 2010 6:03 AMEnglish (United States of America) English (Canada) English (United Kingdom) Arabic (العربية) Bulgarian (Български) Catalan (Català)Load data InfoPackage 2LIS_02_CGR_INIT_R3. Sales-Shipping Schedule Line Delivery: SD - Sales and Distribution: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_12_VCHDR: Delivery. It appears that the standard extractor does not cater to ALL field changes but only certain ones. 3. Vikram. so i think i have to use Schedule Line Counter (ETENR) to take the. 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_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_02_S012: Purchasing: MM - Materials Management: 2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management:Purchase Order Items . 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. Now when I click on Initialization >Fill Setup Tables >Perform Setup Purchasing, i get the following message at the status bar: ". Online Help Keyboard Shortcuts Feed Builder What’s new2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines MM - Materials Management: 14 : 2LIS_04_P_ARBPL: Work Center View from PP/PP-PI PP - Production Planning and Control: 15 : 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 16 : 0AU_PPC_CONF_1: PPS: Backflushes (goods Receipt, Scrap, RP. This InfoSource provides information about the allocation of confirmation quantities with schedule line quantities. "The alternative to do that is to add an append structure to the structure MC02M_0CGR , which is the extract structure for 2LIS_02_CGR. 0pur_o02 2lis_02_hdr,. 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. Return R/3 productive instance to users. No Data in 2LIS_02_CGR & 2LIS_02_SCN. To provide the functionality CDS views based. e. 9) 2LIS_03_UM. When the data has been brought across from R/3 data has come into the ODS. 2LIS_02_S011: Purchasing groups: MM - Materials Management: 2LIS_03_S198: Periodic plant stock: MM - Materials Management: Table Fields related to S194BIWS TABLE FIELD2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_04_P_COMP: Component View from PP/PP-PI: PP - Production Planning and Control: Authorization Objects related to MVERTrigger the delta manually for 2LIS_02_ITM | SAP Community Relevancy Factor: 1. The DSO provides insight into the delivery service of vendors by exploring deviations. Hello experts, I am working on LO cockpit - Purchasing area. 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: You can check the information about the goods receipt in the Purchase Order History view. Since maintaining the structure in LBWE is not allowed and also appending the structure in rsa6 is not possible either, I appended the field in SE11 to the MC02M_0CGR structure and have written a simple code in the mentioned BADI to fill the field( as I have always done). Deletion of the Setup Tables contents for specific applications in transaction LBWG. In purchase order , for line item , we have scheduled line item 1 and 2 as 200 qty, 500 qty respectively. 2LIS_02_CGR: MC02M_0CGRSETUP: BW-Rebuild for MC02M_0CGR Storage Purchasing: 2LIS_02_HDR: MC02M_0HDRSETUP: Storage BW Setup for MC02M_OHDR Purchasing: 2LIS_02_ITM: MC02M_0ITMSETUP Storage BW Setup for MC02M_OITM Purchasing: 2LIS_02_SCL: MC02M_0SCLSETUP: Storage BW Setup for. . 04. The purchasing document delivery schedule lines, such as schedule line number, delivery date, schedule line quantity, value of schedule line. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: Table Fields related to OLIB TABLE FIELDUse. 4) 2LIS_02_CGR. Online Help Keyboard Shortcuts Feed Builder What’s newThis DataStore Object integrates data on purchase order items based on the purchase order items from the InfoSource 2LIS_02_ITM and from the allocation structures 2LIS_02_SGR (allocation schedule line with goods receipt), 2LIS_02_CGR (allocation confirmation with goods receipt) and 2LIS_02_SCN (allocation schedule line with confirmation). 2LIS_02_SCL. 2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_13_VDKON: Billing Document Condition: SD - Sales and Distribution:Experience on MM Purchasing Data sources 2LIS 02 ITM, 2LIS 02 SGR, 2LIS 02 CGR, 2LIS 02 SCN, 2LIS 03 BF,2LIS 03 BX,2LIS 03 UM; Trained in HANA and submitted proof of concept to the client. 2lis_03_bf . I have added Reference table EKKO and Ref field. These indicators and key figures are based on the associated confirmation and goods receipt documents. 2lis_02_scl extract records with wrong posting date for Good Receipts. I'm trying to use datasource 2LIS_02_CGR in addition to 2LIS_02_ITM already in use. x)?2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_12_VCHDR: Delivery Header Data: SD - Sales and Distribution: Authorization Objects related to NRIV AUTHORIZATION OBJECTmm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_13_VDITM: Billing Document Item Data: SD - Sales and Distribution: Errors related to DRSEG ERROR Description;2LIS_02_CGR: Produced Activity: delivery of Confirmations MM - Materials Management: 10 : 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines. 2LIS_02_SCL. 0. I am not getting any data for 2LIS_02_CGR in RSA3 transaction in ECC. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. Why are the setup tables not filled? The Problem is, that the setup tables are not getting poulated. If successful, 3. I have a requirement where I have to add field EKGRP (from table EKKO) and field NETWR (from table EKPO) to Data Source 2LIS_02_CGR . Help. 2. 0MATERIAL. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. 2lis_03_bf mseg, mbew, mkpf. MM Data Sources Tables Purchasing. MultiProvider. If successful, 3. example:i loaded purchasing cubes by using lo datasources like (ex:2lis_02_item,2lis_02_scl ,2LIS_02_CGR etc. Comparing DataSource 2LIS_02_CGR to ME80FN. Using ProcessKey field, 2LIS_02_ITM and 2LIS_02_SCL also provide Goods Receipt (GR) data. 168. from 2LIS_02_ITM and CGR), newest data (with same EBELN and EBELP) from 2LIS_02_CGR to 0PUR_O01 will only update necessary field. Technical name: 2LIS_02_CGR. " 2LIS_02_CGR no data coming from the Extractor in RSA3 | SAP Community". 3. The 2 datasource aren't loading the same information. I have deleted the setup table (02) and filled setup table (OLI3BW) but not able to pull any records for data source 2LIS_02_CGR. Visit SAP Support Portal's SAP Notes and KBA Search. MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. 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. Plz advice me on what key fields to be finalized for these 3 DSOs and also advice other than this if there is any better way to design the flow. 2) Now you can selectively fill the setup tables for purchasing related datasources by the T-code OLI3BW. Data for key figures like order quantity in the 2lis_02_itm data source (and also few other key figures) had been designed as addition in the update rule, therefore data for order quantity populates as negative when there is any update to the existing records. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_12_VCITM: Delivery Item Data: SD - Sales and Distribution: 2LIS_11_VAITM:. 2LIS_02_SCL. i have one doubt. 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 17 : 2LIS_11_V_SCL: Sales-Shipping Allocation Schedule Line SD - Sales and Distribution: 18 :2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_11_VAKON: Sales Document Condition: SD - Sales and Distribution: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_17_I0CAUSE: Maintenance Notifications - Causes: PM - Plant Maintenance: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). I have already filled the set up tables for 02 application, and the other datasources like HDR and ITM have data. e. The Problem is, that the setup tables are not getting poulated. Goto LBWE transaction in R/3. Hi all! I have to initialize my BW data for the datasources: 2LIS_02_HDR 2LIS_02_ITM 2LIS_02_SCL 2LIS_02_S012 All my key figures are in "summation" mode, that means, no item should be loaded. how to extract the data. 33 Views. LBWE shows both extract structures (MC02M_0CGR and MC02M_0ITM) as active. 2lis_02_cgr . So for inbound deliveries you have to seek MM extractors. 2LIS_02_SCL datasource will give the GR values from EKBE table by considering the purchase documents from EKKO table for respective vendor. This counter determines the number of deliveries based on the GR document items. 2lis_12_vcitm doesn't pick up inbound deliveries, only outbound deliveres. I have added these fields EKGRP (Component Type BKGRP) and field NETWR (Component type BWERT). these. I m using datasource 2LIS_02_SCL to extract data from R3 using the Direct Delta procedure. MC02M_OITM. If successful, 3. There, you can compare the data in the DataSource fields with the original document data in SAP R/3 , such as: Purchasing Document Number (EBELN) Comparing DataSource 2LIS_02_SGR to ME80FN. 2LIS_02_SCL. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. I am new to Purchasing. Now what should be my approach for data model? If we don't have any standard cubes containing the line item, should I use the standard DSO as my first layer and build my own cube on top of it? Should it be 1 DSO 1 Cube and 1 Multiprovider?2LIS_02_SRV: Purchasing Data (External Services) MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: Table Fields related to OLIM TABLE FIELD2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: Table Fields related to MC12VC0ITM TABLE FIELD Description; VBEP: Single-Character Flag: LO: Business Area: Glossary/Terms related to MC12VC0ITM Cockpit CRM - Real-Time Decisioning. 2LIS_02_S013 is a LIS dataSource so you can't find it in LBWE, but you can find it in LBW0, go to LBW0 and give S013 Information structure and. 2lis_02_hdr. Deleted the Setup tables. 1) 2LIS_02_HDR. 2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management: 17 : 2LIS_04_P_ARBPL Work Center View from PP/PP-PI PP - Production Planning and. 0GR_QTY. The data is accurately updating the 0PUR_O01 Data Source. Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2. I have to extract data from 2lis_02_scl, 2lis_02_cgr and 2lis_02_sgr standard datasources. first i scheduled the init for 2lis_02_itm 2lis_02_hdr 2lis_02_scn 2lis_02_scl 2lis_02_cgr 2lis_02_2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 11 : 0NOTIFICATN_ATTR: notification Number QM - Quality Management: 12 :. DataStore object MM-PUR: Purchasing Document Item /IMO/D_PUR11 to provide all attributes of the purchase order item (such as material, vendor, plant, document category, and status). but not in. Description. The counted number depends on how often a material appears in a GR document. 5) 2LIS_02_SGR. Based on DataSource: 2LIS_02_SCN. - SAP Q&A Relevancy Factor: 2. Search for additional results. 0pur_o02 2lis_02_hdr, 0pur_o01 0pur_ds03 2lis_02_scl and 2lis_02_sgr. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_02_SCN:0PUR_O01 , BWVORG , 0PUR_C01 , 2LIS_02_ITM , 2LIS_02_SGR , 2LIS_02_CGR , 2LIS_02_SCN , KBA , BW-BCT-MM-PUR , BW only - Purchase , BW-WHM-DST-TRF , Transformation , Problem . 2LIS_02_CGR Allocation Confirmation with Goods Receipt. I am getting the repetitive values for the month from 01/2012 to 03/2012,even if there is no transaction for the previous month - Dec 2011 checked in ECC side & the values are not correct as per the mov type from 01/2012 to 03/2012 - 501( - values) & 502( + values) this value has to be highlighted for a. Follow RSS Feed Hi Friends, This Datasource is under Purchasing . I could find lot of documents for the steps for LO extraction. 2LIS_02_CGR . inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. The other datasource 2LIS_02_SGR is loading the Schedule Line with Goods Receipt from SAP tables EKET, EKBE and EKPO. ). Go to Maintainance. ) Can somebody knowledgable in the Purchasing Extarctors plese confirm this for me ? I am tyring to fill the setup tables for application 2LIS_02_* using tcode OLI3BW , but it is taking a lot of time to fill the data even if i enter selection document date for one year every time, i want to fill the setup tables separately for each data source. This DSO contains delivery related indicators and key figures for purchase order items. If successful, 3. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. BWA / BIA. But i need these realtime scenario so that i can try to understand the fields,tables and. I also need to know the data loading sequence for the following data source 2lis_02_HDR, 2lis_02_ITM, 2lis_02_SCL, 2li. Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions. x. You will find pool of objects there. 2) 2LIS_02_ITM. 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’. Queries . 2lis_02_sgr. 2LIS_02_SCN : I changed some fields like Text in a PO but the PO confirmation extractor is not generating a delta for the change. I want to set up the delta mechanism for 0PUR_C01 , OPUR_O01 , 0PUR_C08 , 0IC_C03 and 0COPC_C04 business content cubes. Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. Step three:. Based on DataSource: 2LIS_02_SGR. Purchasing 2LIS_02_HDR MC02M_0HDRSETUP Storage BW Setup for. BW/BI Accelarator is a tool that improves the performance of BW 7. 5. When I execute the RSA3 for different Datasources I can see data only in. 2lis_02_s012. 2LIS_02_SCN. 2lis_02_sgr. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. 9) 2LIS_03_UM. I did the setup for the Purchasing Module(02) in LBWG then OLI3BW. 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management:. 2lis_02_scn. MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. 2LIS_02_SCN Allocation Schedule Line with Confirmation. when do we enhance 2LIS_02ITM, 2LIS_02SCR, 2LIS_02SCN and 2LIS_02_CGR and with what FIELDS into 0PUR_C07,0PUR_C08 and 0PUR_C09 to evaluate the service levels. Why ITM shows 0 records in BW. 2LIS_02_ACC . About this page This is a preview of a SAP Knowledge Base Article. 0MM_PUR_VE_01. Hi Experts, I would like to create new DSOs on top of 3 purchasing DataSources 2LIS_02_SCN, 2LIS_02_SGR and 2LIS_02_CGR. It is field-based and contains all. 0CO_PC_ACT_03. Follow. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 22 : 2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution: 23 : 0MM_PUR_VE_01 Vendor evaluation MM - Materials Management: 24 : 2LIS_02_S015 Subsequent Settlement: Evaluation2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_11_VAITM: Sales Document Item Data:2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 12 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13 : 2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management: 14 : 2LIS_02_ACC Purchasing Data (Account Level) MM -. 2LIS_02_ITM . 2lis_03_bf . SAP TCode lbwg - Documentaion and other resources. 4. Step one: stop all postings in connected ERP system. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. cube 0pur_c10 2lis_02_scl and 2lis_02_sgr. 0. LBWE shows both extract structures (MC02M_0CGR and MC02M_0ITM) as active; Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2; Delete setup tables for application 02. 2LIS_12_VCHDR: Delivery Header Data: SD - Sales and Distribution: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management: 2LIS_03_BX: Stock. Can any of you please suggest how to get that ASN data for which no GRN is created. In fact, 2LIS_02_CGR is loading Confirmation with Goods Receipt from SAP tables EKBE, EKES, EKBE and EKPO. Purchasing document 4500000001, Item 0010, has the following schedule lines: Schedule line number (SCLNR) = 1. 6) 2LIS_02_SCN. 02 Purchasing 2LIS_02_ACC MC02M_0ACCSETUP Folder: BW Setup for. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. than the dataset, see the documentation on the ACCEPTING PADDING and Based on DataSource: 2LIS_02_SCN. The Key of the DSO is Purchasing Document Number and Purchasing line Item no (similar to Standard DSO 0PUR_O01 ). i can see in LBWE that the data source is active. This update is normally a synchronous update, i. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. ROCANCEL. The users are interested in below extractors 2LIS_02_HDR 2LIS_02_ITM 2LIS_02_SCL 2LIS_02_CGR 2LIS_02_SGR 2LIS_02_SCN. This object is obsolete. e. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 23 : 0ISCM_SUBACTIVITYUSED_TEXT Claims Management: DataSource for Activity used - 24 : 2LIS_06_INV. I am trying to add a couple of fields to extractor 2LIS_02_ITM. We deleted init and reinitialised with no success. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 2 : 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 3 : 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 4 : 2LIS_11_VAITM: Sales Document Item Data以下是SAP ECC中各主要数据源与描述. To bring this field MKPF-BLDAT into my data target, I have to enhance any of these Data Sources. The list contains only the following, 0CO_PC_ACT_02. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 7 : 2LIS_02_S174 Services MM - Materials Management: 8 : 2LIS_02_S015 Subsequent Settlement: Evaluation MM - Materials Management: 9 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 10 : 2LIS_02_ACC. for purchasing the application component is 02. 2LIS_03_UM OLIZBW RMCBNERP. 1. Loaded 0%. 0. 2LIS_03_BX MCNB RMCBINIT_BW. It returns also data for goods receipt and invoices if they exist. But for CGR and SGR it shows Zero though they are active in LBWE. 0MM_PUR_VE_02. 0CO_PC_ACT_05: Material Valuation: Prices MM - Materials Management: 14. 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. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. This InfoSource provides information about the confirmation quantities allocated with goods receipt quantities. 2LIS_02_CGR. 2. 0pur_c07 0pur_c08 0pur_c09 0pur_o02, 80pur_o01, 2lis_02_hdr 0srv_c01 2lis_02_s174 0pur_c04 2lis_02_s011,. When I look at the various extractors in BI, 2lis_02_cgr and 2_lis_02sgr both have the date as June 2nd. 2LIS_02_CGR. Load data InfoPackage 2LIS_02_CGR_INIT_R3.