i can see in LBWE that the data source is active. InfoSources. But some of the. 5. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 2lis_02_s012. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 0. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. 0. DataSource: 2LIS_02_SCL; Some key figures in the data source need to be updated in. Goto LBWE transaction in R/3. Visit SAP Support Portal's SAP Notes and KBA Search. The Key of the DSO is Purchasing Document Number and Purchasing line Item no (similar to Standard DSO 0PUR_O01 ). 12) 2LIS_02_S174. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community! Not yet a member on the new home? Join today and start participating in. 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. 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 . LBWE for 2LIS_02_CGR and 2LIS_02_SGR. 2LIS_02_SCN extract incorrect information when the vendor confirms more/less quantities than schedule quantity. 2) 2LIS_02_ITM. 6) 2LIS_02_SCN. At the moment everything seems to be working fine (I ve changed quantities and prices in PO, added new line items to existing ones, created new PO and updated them successfully to BW), except that if I try to delete a line item from an existing PO, I get no new record in my delta queue so the change is. 1) 2LIS_02_HDR. 1: 2LIS_02_ITM (X Records) 2: 2LIS_02_SCN (0 Records) 3: 2LIS_02_SGR (X Records) 4: 2LIS_02_CGR (0 Records) All 4 Data Sources have been converted from 3. Iam using data sources 2LIS_02_SCN and 2LIS_11_VAITM and in both I have added a few extra fields to the extract structure. 2lis_02_cgr ekbe, ekes, ekpo. This InfoSource provides information about the allocation of confirmation quantities with schedule line quantities. This DSO (advanced) contains replicated goods receipt information for purchasing document schedule line data. dear all, anyone has experiance using this extractor 2LIS_02_CGR? after i fill up the setup table, datas are still not updated. Sachin. Document update is where the transaction (documents) are updated in the application tables. 2) 2LIS_02_ITM. But i need these realtime scenario so that i can try to understand the fields,tables and. 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. is any necessary to load data from DataSource like 2LIS_02_S012,2LIS_02_S011,2LIS_02_S174,2LIS_02_S015,2LIS_02_S013. 2LIS_02_SGR. 0CALDAY. On top of this, setup table was filled, but I see no data for 2lis_02_itm. When does it happen that 2LIS_02_ITM does not add. I checked in RSA3 and the set up tables all the above datasources have records. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. RSS Feed. Comparing DataSource 2LIS_02_CGR to ME80FN. 2LIS_02_ACC . Features of Extractor This DataSource provides information about: the header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on the item data. 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 . To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. Purchasing 2LIS_02_CGR MC02M_0CGRSETUP BW-Rebuild for. I want to ask something, in default transformation to 0PUR_O01 (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. 2lis_02_sgr. Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. example:i loaded purchasing cubes by using lo datasources like (ex:2lis_02_item,2lis_02_scl ,2LIS_02_CGR etc. MC02M_OITM. 5) 2LIS_02_SGR. ) 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. If successful, 6. 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. 0PROCESSKEY. 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. e. 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. 0CO_PC_ACT_03. Hi Can anybody tell me the table name for the datasource 2LIS_02_SCL. "MM-PUR: Purchase Data Header (2LIS_02_HDR) - /IMO/PUR_IS10. So for inbound deliveries you have to seek MM extractors. but not in. Vendor to Purchasing organsiation . 02 Purchasing 2LIS_02_ACC MC02M_0ACCSETUP Folder: BW Setup for. 2LIS_02_ITM 2LIS_02_HDR 2LIS_02_SCL. sadaNo data in 2LIS_02_CGR. 1. It is field-based and contains all. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!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_HDR: Purchasing Data (Header Level) MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management:2LIS_12_VCSCL: Sales-Shipping Schedule Line Delivery: SD - Sales and Distribution: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_11_VAITM: Sales Document Item Data: SD - Sales and Distribution: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials. 6. The values of BWVORG do not apply to extractors 2LIS_02_SGR, 2LIS_02_SCN or 2LIS_02_CGR. If successful, 3. 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. 2lis_02_scn. 7) 2LIS_03_BX. I have checked in my system and there is already data in the tables EKET, EKES, EKBE. Q1. 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. The data is accurately updating the 0PUR_O01 Data Source. 3) 2LIS_02_SCL. I am not using the BI2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management:. MM-PUR: Purchase Order Delivery (Items) - /IMO/D_PUR21. q2. Regards. Due to some loads failed, we are doing re-init the loads. If you click that dropdown you will find the tables for your Datasource. i have one doubt. Message was edited by: subba rao. Header Data2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 11 : 2LIS_03_UM Revaluations MM - Materials Management: 12 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13 : 2LIS_45_VDLST IS - 14 : 2LIS_02_S013 Vendor Evaluation2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI - Accounts Payable: 2LIS_05_QVUDN: Inspection Lot/Usage Decision: QM - Quality Management: Authorization Objects related to EKKN AUTHORIZATION OBJECT DescriptionSAP Database Tables. The datasource is active in RSA6 and its structure is also active in LBWE. Enter the search text @Analytics. 5. I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. About this page This is a preview of a SAP Knowledge Base Article. 0RECORDMODE. In SAP NetWeaver 7. 265. 2lis_02_s012. 2LIS_02_SGR brings back a Process Key of 0 and no Schedule Line | SAP Community Relevancy Factor: 1. Click ‘Yes’ to proceed further. In comparison with DataStore object MM-PUR: Purchase Document Schedule Line (/IMO/D_PUR12), the purchase order delivery DSO provides the goods receipt value and quantity based on the posted goods receipt date. 0CO_PC_ACT_04. "First Solution : enhance 2LIS_02_ITM to have Schedule line date. any advice. 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_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. 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. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 15 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 16 : 2LIS_04_P_COMP Component View from PP/PP-PI PP - Production Planning and Control: 17 : 2LIS_01_S001 CustomerA New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!2LIS_02_ACC Purchasing data (Account Level) MM - Materials Management: 28 : 0PM_OM_OPA_2. Load data InfoPackage 2LIS_02_ITM_INIT_R3. 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. InfoObjects: 0VENDOR. " 2LIS_02_CGR no data coming from the Extractor in RSA3 | SAP Community". Logistics - General. But for CGR and SGR it shows Zero though they are active in LBWE. Hi all, i filled the setup tables for purchasing in r/3. The Problem is, that the setup tables are not getting poulated. Symptom. Based on DataSource: 2LIS_02_SGR. EXTRACTOR PROBLEM. After completing the setup table in RSA3 i could find records for ITM and SCL. 2LIS_02_CGR Produced Activity: Delivery of Con fi rmations MM - Materials Management: 19 : 2LIS_02_S011 Purchasing groups MM - Materials Management: 20 : 2LIS_13_VDHDR Billing Doc. 2LIS_13_VDITM: Billing Document Item Data: SD - Sales and Distribution: 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management: 2LIS_11_VASCL:. I have a Item in a Purchasing Document which has no Open Quantity in R/3 since weeks but in BW the datasource shows me still 5 open quantities. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management. Inbound Deliveries comes into picture of Purchasing. In other words, what is the difference between the GR data. 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_BX: Stock Initialization for Inventory Management: MM - Materials Management: Errors related to MRKO ERROR2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 26 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 27 : 2LIS_11_VASTH Sales Document Header Status SD - Sales and Distribution: 28 : 0COORDER_ATTR Order number CO - Overhead Cost Orders: 29 :. 4. I'm trying to use datasource 2LIS_02_CGR in addition to 2LIS_02_ITM already in use. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 16 : 2LIS_11_V_ITM Sales-Shipping Allocation Item Data SD - Sales and Distribution: 17 : 0TCTSYSID BW Metadata: BW System - 18 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 19 : 2LIS_12_VCITM. 2LIS_02_ACC Purchasing Data (Account Level) MM - Materials Management: 11 : 2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management: 12 :2lis_02_cgr . 36. 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. 2lis_03_bf . 2lis_02_cgr ekbe, ekes, ekpo. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. Load data InfoPackage 2LIS_02_SGR_INIT_R3. Open View Browser app from the search results. 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. Sales Document Schedule Line SD - Sales and Distribution: 22 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 23 : 0PROFIT_CTR_ATTR Profit center Enterprice. mm. Now whenever the ROCANCEL = R comes for Datasource 2LIS_02_SCN it overwrites data of fields mapped from all other 3 datasources in DSO active table. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. Description. 175 Views. when i am loading purchasing data by using lo extraction i have problem with datasource 2LIS_02_SCN and 2LIS_02_CGR. 4. Load data InfoPackage. 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 -. MM Data Sources Tables Purchasing. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 5 : 0MATERIAL_ATTR: Material Number Logistics - Logistics - General: 6 :. 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 0FI_GL_14: General Ledger (New): Line Items Leading Ledger: FI - General Ledger Accounting: 2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines:MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR. After filling setup table using transaction OLI3BW, 2lis_02_srv still returns zero record in transaction RSA3. 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. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. I need the data of the original GR (the 103. Even if we enhance these 2 extractors with BEWTP field, it will only bring values for invoice and good receipt, We want all the data from EKBE table for all values of BEWTP. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. e. To provide the functionality CDS views based extractors will be provided. The content was built around the Layered Scalable Architecture (LSA) approach. 2LIS_02_SGR. 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. Now when I click on Initialization >Fill Setup Tables >Perform Setup Purchasing, i get the following message at the status bar: ". S012. Use. Queries . 2lis_02_sgr, 2lis_02_cgr and 2lis_02_scn. I have tried migrating the transformation repeatedly , it gets imported with return code 0. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 0FI_GL_4: General Ledger: Line Items with Delta Extraction: FI - General Ledger Accounting: 2LIS_12_VCHDR: Delivery Header Data: SD - Sales and Distribution: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_01_S001: Customer: SD - Sales and Distribution: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced. need to exctract data from r/3 for re-evaluations using 2lis_03_um to bw Relevancy Factor: 1. Technical name: 2LIS_02_CGR. Hi Friends. setup table MC02M_0CGRSETUP is empty and. 0. sanjeev. I checked the. I have added these fields EKGRP (Component Type BKGRP) and field NETWR (Component type BWERT). 2lis_03_bf mseg, mbew, mkpf. Also the datasource is active in LBWE. The new content combines the capabilities of SAP HANA and SAP BW/4HANA for the most optimal solution. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13. Ensure that this counter only counts. Skip to Content. The OLTP Source still has errors. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. 2LIS_02_ITM Purchase Order Items. here give the PO numbers, specify a name for the job run and execute. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 10 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 11 : 0CO_PC_01 Cost Object Controlling: Plan/Actual Data CO - Product Cost Controlling: 12 : 0UC_SALES_STATS_01In the SAP S/4HANA Cloud system, choose the App Finder and search for the View Browser app. 2. 2lis_02_s011. 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. 8) 2LIS_03_BF. I am trying to add a couple of fields to extractor 2LIS_02_ITM. Load data InfoPackage 2LIS_02_ITM_INIT_R3. I want to ask something, in default transformation to 0PUR_O01 (i. Hit enter to search. Load data InfoPackage 2LIS_02_SCL_INIT_R3. Can any of you please suggest how to get that ASN data for which no GRN is created. 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). 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. 2LIS_02_SGR. Step two: Delete delta entries in RSA7. I am not using the BI. Load data InfoPackage 2LIS_02_CGR_INIT_R3. 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). 4) 2LIS_02_CGR. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. This InfoCube does not have completion indicator so we thought of including ODS. While 3 of them [ITM, SGR and SCL] are extracting data, the 2 mentioned in the subject line do not extract any data. 2LIS_02_CGR Allocation Confirmation with Goods Receipt. Technical name: 2LIS_02_CGR. In RSA7 , for the relevant datasources , I see 0 records. Purchsing Data Extraction through EKBEH table. 4. 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. Note. Technical name: 2LIS_02_SGR. 01. In RSA7 i purged or deleted the records and entry for this datasource. 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). i never tried to enhance this datasource its first time i am working on this. RSS Feed. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 34 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 35 : 2LIS_11_VASTH Sales Document Header Status SD - Sales and Distribution: 36 : 2LIS_18_I0NOTIF service Notifications - 37 :2LIS_02_CGR: Produced Activity: Delivery of Confir mat ions MM - Materials Management: 8 : 2LIS_02_SCN: Produced Activity: Confir mat ion of Schedule Lines. - SAP Q&A Relevancy Factor: 2. SAP Community Network Wiki - SAP NetWeaver Business Warehouse - Step by Step Enhance your Datasource. HI EXPERTS, when i am trying to activate datasource 2lis_02_cgr it says "Structure maintenance not provided for extraction structure MC02M_0CGR ->". Hey Gurus, i have a problem with DS 2LIS_02_CGR Allocation - Confirmation with Goods Receipt. Hi All, I am facing a problem in which, for some of the Purchase order's the confirmation Quantity is not getting updated to the Data source 2lis_02_CGR, where the confirmation quantity is comming from EKES table and th Filed is MENGE ,In LBWQ no entry for MCEX02 exist. 1. 3. 33 Views. 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. 2LIS_02_SCL. 2lis_02_scl. The list contains only the following, 0CO_PC_ACT_02. If successful, 6. To bring this field MKPF-BLDAT into my data target, I have to enhance any of these Data Sources. ROCANCEL. x to 7. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource Produced Activity: Delivery of Schedule Lines ( 2LIS_02_SGR ). 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. MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. 3) 2LIS_02_SCL. My question is, can one use just these two extractors and ignore exclusive GR extractors like 2LIS_02_CGR and 2LIS_02_SGR? The user does not care about Confirmations. 2LIS_02_SCL : MC02M_0SCLSETUP : Storage BW Setup for MC02M_OSCL : Purchasing : 2LIS_02_SCN : MC02M_0SCNSETUP : BW-Rebuild for MC02M_0SCN Storage : Purchasing : 2LIS_02_SGR : MC02M_0SGRSETUP : BW-Rebuild for MC02M_0SGR Storage : 03: Inventory Controlling : 2LIS_03_BF : MC03BF0SETUP : Save BW Reorganization for MC03BF0 : Inventory Controlling. Change the Standard variant to Released Views variant. 2LIS_02_S174: Services: MM - Materials Management: Authorization Objects related to S011 AUTHORIZATION OBJECT Description Application ;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_VCSCL: Sales-Shipping Schedule Line Delivery: SD - Sales and Distribution: 2LIS_02_SCL: Purchasing Data (Schedule Line Level)2lis_02_cgr ekbe, ekes, ekpo. If successful, 3. Comparing DataSource 2LIS_02_CGR to ME80FN. So for inbound deliveries you have to seek MM extractors. 0. My problem is that, some of the 0PUR_O01u2019s characteristics are not mapped with the extractors fields like :. Relevancy Factor: 2. BW process key should not be in key when you are using : 2LIS_02_SGR and 2LIS_02_CGR. MC02M_0ACC. zero records pulled in Data source 2LIS_02_CGR - SAP Q&A Relevancy Factor: 1. so i think i have to use Schedule Line Counter (ETENR) to take the. 1. first i filled setup table and then check the data with t code:RSA3 i got zero records for above two data sources remaing datasources get the records. 2481829 - S4TWL - Fashion Season Conversion. I am not using the BI. Why SGR, SCN and CGR show 0 records in RSA3. 2LIS_02_SCL. 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. please if any one could give me steps to extract the data into setup tables. Could any one provide me the step-by-step to fill the setup table. than the dataset, see the documentation on the ACCEPTING PADDING and Based on DataSource: 2LIS_02_SCN. The counted number depends on how often a material appears in a GR document. Currently i working with application 02 and i am using ITM, SCL, CGR and SGR datasources for Purchasing. I have already filled the set up tables for 02 application, and the other datasources like HDR and ITM have data. It appears that the standard extractor does not cater to ALL field changes but only certain ones. regards. 2LIS_03_BF OLI1BW RMCBNEUA. 5) 2LIS_02_SGR. Activate ODS data 0PUR_O01. 2lis_03_bf mseg, mbew, mkpf. 2LIS_02_SGR: Produced Activity: delivery of Schedule Lines MM - Materials Management: 21 : 2LIS_13_VDHDR: Billing Doc. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. 2LIS_02_CGR. 137 Views. 5 version. Go to Maintainance. MC02M_OHDR. I have set up the source systems in BW and created infopackages etc. DataStore object MM-PUR: Purchasing Document Item /IMO/PUR_D11 to provide all attributes of the purchase order item (such as material, vendor, plant, document category, and status). 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_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: FI -. When I execute the RSA3 for different Datasources I can see data only in. The 2 datasource aren't loading the same information. ). Note: PO item is not deleted in R/3 and still it sends. 2LIS_02_CGR: Produced Activity: Delivery of confirmation s MM - Materials Management: 5 : 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 6 : 2LIS_02_SCN: Produced Activity: confirmation of Schedule Lines MM - Materials Management: 7 : 2LIS_04_P_COMP Component View from PP/PP-PI PP - Production. Here it will ask for application component. I went into the SE11 and added fields to an append structure on MC02M_0ITM (activated everything). 4 BI Content 7. RSA3 shows 991 , when I load into 0PUR_C01 , it shows transferred as 958 and added as 0. . 0pur_c07 0pur_c08 0pur_c09 0pur_o02, 80pur_o01, 2lis_02_hdr 0srv_c01 2lis_02_s174 0pur_c04 2lis_02_s011,. If the target area is longer or shorter . issue with EKBE and 2lis_02_scl enhancement. Indicator: Cancellation of data record. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. 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)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. 2lis_02_itm . We have extracted purchasing data using 2LIS_02_SCL and 2LIS_02_ITM datasources. 2lis_02_sgr. cube 0pur_c10 2lis_02_scl and 2lis_02_sgr. 3. 2. If you have records in rsa/3 retry the process not from olibw3 but from SBIW--> you have to delete first the setup table to populate them. 2lis_02_scn. 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. 8. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_ITM: Purchasing Data (Item Level) MM - Materials Management: 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:ODS keys are Purchase order number and item. Field in DataSource. Purchasing 2LIS_02_ITM MC02M_0ITMSETUP Storage BW Setup for. It looks like someone was changing the CGR structure and somehow damaged it or deactivated it. I activated the 0PUR_O01 ods , activated the datasources and when I ran rsa3 I see 0 records for all 3 and for 2lis_02_itm i see 1190 records but when i load this into BW , it shows transferred as 1190 and added as 0. 2. Choose. 2LIS_02_SCN. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!SAP Documentation. Load data InfoPackage 2LIS_02_CGR_INIT_R3. After transport to production I see that while a few fields are unhidden a few are appearing as. I have added Reference table EKKO and Ref field. anand2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: Premium Member Only Results. 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. 2LIS_02_HDR: Purchasing Data (Header Level) 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: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials. If successful, 3. Header Data SD - Sales and Distribution: 21 : 2LIS_02_S013 Vendor Evaluation MM - Materials Management: 22 : 2LIS_02_S0122LIS_02_ITM Purchase Order Items. 2lis_02_scl. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 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. Empty the BW delta queues on R/3 by extraction to BW: Start prepare phase on R/3 including generation of shadow instance. 2lis_03_bf . To prevent the exception, note the following: A dataset can only be imported to a target area with the same structure . 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. I have to extract data from 2lis_02_scl, 2lis_02_cgr and 2lis_02_sgr standard datasources. So OLI3BW will not fill the Purchase related setup tables. 2LIS_02_CGR. 2LIS_02_ITM . Therefore the DS should be migrated from 3. Appreciate your help. 2lis_02_hdr. In comparison with DataStore object MM-PUR: Purchase Document Schedule Line (/IMO/D_PUR12), the purchase order delivery DSO provides the goods receipt value and quantity based on the posted goods receipt date. Did you check if you have data in source system FORN that datasources?2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 5 : 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 6 :. Pls try extractors of procurement 2lis_02_scl, 2lis_02_sgr, 2lis_02_cgr. Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2. 2lis_02_sgr eket, ekbe, kkpo. Hope it helps. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: Table Fields related to OLIE TABLE FIELD Description; FOUND 'X'/'': Found/not Found: Glossary/Terms related to OLIE Fill BW - Warehouse Management. 0CO_PC_ACT_06. Purchasing 2LIS_02_HDR MC02M_0HDRSETUP Storage BW Setup for. Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. "MCEX_UPDATE_02_V1" "(FORM)", or declared in the procedure's RAISING clause. 2LIS_02_SCL datasource will give the GR values from EKBE table by considering the purchase documents from EKKO table for respective vendor. 2LIS_02_CGR no data coming from the Extractor in RSA3. Transaction event type has the values 1 to 8, I am comparing the keys EBELN and EBELP from structure. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. Am I missing any essential steps. Hi Friends. Help. (However both EKET & EKBE have entries. these. 2LIS_02_SCN Allocation Schedule Line with Confirmation. If successful, 5. The latest version of SAP S/4HANA Enterprise Management Edition is 1511 Feature Pack Stack 02 [ FPS02] – released in May 2016. 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. Pls pour your suggestions ASAP. Though after doing setup I find data coming correctly for.