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:. 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. Step one: stop all postings in connected ERP system. I checked in RSA3 and the set up tables all the above datasources have records. Symptom. If successful, 4. BW SD MM FI 常用 数据源. 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. I could find lot of documents for the steps for LO extraction. If I migrate the DS, what happens with the datastaging from System A(Vers. About this page This is a preview of a SAP Knowledge Base Article. Once we get the above screen, we could specify the component (02, 11, etc…) and click on execute button. Inventory Management (SAP HANA-Optimized) Production Planning and Controlling (SAP HANA-Optimized). 2LIS_02_SGR. Hi Friends. 2LIS_02_CGR. So for inbound deliveries you have to seek MM extractors. 2lis_02_scl. if the update. 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. 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 -. x to 7. 2lis_02_scn. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_12_VCITM: Delivery Item Data: SD - Sales and Distribution: 2LIS_11_VAITM:. 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. example:i loaded purchasing cubes by using lo datasources like (ex:2lis_02_item,2lis_02_scl ,2LIS_02_CGR etc. I have tried migrating the transformation repeatedly , it gets imported with return code 0. But i need these realtime scenario so that i can try to understand the fields,tables and. As I said when I create / activate a DTP for 2LIS_02_ITM Data source in QA it deletes the transformation. 2LIS_02_ITM 2LIS_02_HDR 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:. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. I have checked in my system and there is already data in the tables EKET, EKES, EKBE. Dear all, To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. Skip to Content. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. 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. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. Hope it helps. Activate ODS data 0PUR_DS03. 2LIS_02_ITM. As per the discussions in this forum it is because EKES is empty. When I loaded to BW , 2LIS_02_ITM transferred some records but added 0 Records. Please help me out. 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. 0MM_PUR_VE_01. 2lis_02_sgr. Change the Standard variant to Released Views variant. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。. please any one help me. 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. No Data in 2LIS_02_CGR & 2LIS_02_SCN. Description. This DSO (advanced) contains delivery related indicators and key figures for purchase order items. Hey, the transcation code to rum PUR setup table is OLI3, not OLI3BW. 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 -. 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 purchase order exists in APO in the form of an order. 2lis_02_s011. 0. Load data InfoPackage 2LIS_02_ITM_INIT_R3. 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. 8) 2LIS_03_BF. 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. 0GR_QTY. e. anand2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: Premium Member Only Results. If successful, 3. The purchasing document delivery schedule lines, such as schedule line number, delivery date, schedule line quantity, value of schedule line. MC02M_OITM. 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. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. 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). Regards. There is no other common. 2LIS_02_S174 Services MM - Materials Management: 24 : 2LIS_03_S196 Goods movement: Plant MM - Materials Management: 25 : 2LIS_02_S013 Vendor Evaluation2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines: MM - Materials Management: 2LIS_02_SCN:. I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. This DSO (advanced) contains replicated goods receipt information for purchasing document schedule line data. So, how can I bring this field into my data Target? Has anyone got same type of requirement or Please provide me some inputs to resolve this. To prevent the exception, note the following: A dataset can only be imported to a target area with the same structure . MM-PUR: Purchasing Document Header - /IMO/D_PUR10 . 0. 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. 2lis_02_scl extract records with wrong posting date for Good Receipts. 2LIS_02* OLI3BW RMCENEUA. 265. I look at SE11 for ' MC02M_0HDRSETUP ' and table contents gives 0 records. 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). Hit enter to search. Taxes: Line items by Means of Delta Extraction FI - General Ledger Accounting: 30 : 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 31 : 0CO_OM_NWA_2 Delta extraction:. Header Data. 2LIS_03_BF OLI1BW RMCBNEUA. I dont know the flow, Business process associated. 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. You would like to use BW data source 2LIS_02_SRV, but in SAP note 1250820, it says BW data source 2LIS_02_SRV can not be activated and maintained in transaction LBWE (LO Data Extraction: Customizing Cockpit). The Key of the DSO is Purchasing Document Number and Purchasing line Item no (similar to Standard DSO 0PUR_O01 ). 9) 2LIS_03_UM. 2lis_02_sgr, 2lis_02_cgr and 2lis_02_scn. 1) Go to the RSA6 (Find ur datasource 2LIS_02_ITM double click on it ) 2) Double click on the extract structure 3) You will see extract structuter then you can see the append structure at the top left click onit 4) Give the name of the structure 5) Enter the NEW field starting with "ZXXXXX" 6) Save it 7) Go to Cmod and then create a project 8) The assign components. 2lis_02_cgr . 2LIS_02_CGR: Produced Activity: Delivery of confirmation s MM - Materials Management: 6 : 2LIS_02_SCN: Produced Activity: confirmation of Schedule Lines MM - Materials Management: 7 : 0UC_CM_NCL_CS01: Process Statistics for Move-In/Out: Not Explained - 8 : 0INFO_REC_ATTR: Number of Purchasing Info RecordIf the SCN structure is anything like the CGR structure, then neither will load. In RSA7 i purged or deleted the records and entry for this datasource. 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. 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 . these. SAP. I want to ask something, in default transformation to 0PUR_O01 (i. 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. 5. Pls pour your suggestions ASAP. MM-PUR: Purchasing Document Schedule Line - /IMO/D_PUR12 . Use. . sanjeev. BW SD MM FI 数据源. 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. 33 Views. 0CO_PC_ACT_05: Material Valuation: Prices MM - Materials Management: 14. The datasource is active in RSA6 and its structure is also active in LBWE. I am not getting any data for 2LIS_02_CGR in RSA3 transaction in ECC. Vendor to Purchasing organsiation . 12. 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. Due to some loads failed, we are doing re-init the loads. To provide the functionality CDS views based. Technical name: 2LIS_02_SCN. 2LIS_02_SCL returns data for the purchase order on header item and schedule line level. I want to set up the delta mechanism for 0PUR_C01 , OPUR_O01 , 0PUR_C08 , 0IC_C03 and 0COPC_C04 business content cubes. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management. 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. 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. 11) 2LIS_02_S015. i have one doubt. When the data has been brought across from R/3 data has come into the ODS. Hi Gurus , Can anyone help me explain the use of the 2lis_02_CGR and 2lis_02_SCN. Load data InfoPackage 2LIS_02_HDR_INIT_R3. 5. The DSO provides insight into the delivery service of vendors by exploring deviations. If successful, 6. Help. To provide the functionality CDS views based extractors will be provided. Deleted the Setup tables. Note. 2LIS_02_SCL EKKO, EKBE,T001, T001W, EKET, EKPA. Why are the setup tables not filled? The Problem is, that the setup tables are not getting poulated. Follow. I'm trying to use datasource 2LIS_02_CGR in addition to 2LIS_02_ITM already in use. Technical Name: 0PUR_O01. 2lis_02_scl. 3. Inbound Deliveries comes into picture of Purchasing. 0MM_PUR_VE_02. After filling setup table using transaction OLI3BW, 2lis_02_srv still returns zero record in transaction RSA3. 2LIS_03_UM OLIZBW RMCBNERP. But for CGR and SGR it shows Zero though they are active in LBWE. 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. The header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on. 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. 2LIS_04_PEMATNR Repetitive Manufacturing mat erial View PP - Production Planning and Control: 16 : 0CO_PC_ACT_1 Actual Costing/ mat erial Ledger2LIS_02_SGR Produced Activity: Delivery of Schedule Lines MM - Materials Management: 27 : 2LIS_13_VDHDR Billing Doc. Why ITM shows 0 records in BW. Delivery time (SCLTM) = 12:00:00. It is field-based and contains all. 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 am not using the BI. 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_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:. 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. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. Note that if you change a purchasing document, the system only takes into consideration the data that is relevant for extraction. Follow. ) 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. InfoObjects: 0VENDOR. I did the setup for the Purchasing Module(02) in LBWG then OLI3BW. 2lis_03_bf . I went into the SE11 and added fields to an append structure on MC02M_0ITM (activated everything). ). DataSource working, but concept obsolete in S/4 DataSource working, but concept obsolete in S/4. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 12. 2) Now you can selectively fill the setup tables for purchasing related datasources by the T-code OLI3BW. If successful, 3. I am trying to add a couple of fields to extractor 2LIS_02_ITM. 4) 2LIS_02_CGR. DataStore Objects. 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 -. Help. I have added Reference table EKKO and Ref field. I checked the. 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. e. I created the setup tables via "Purchasing - Perform Setup", but only 3 setup. 2LIS_02_ACC . problems with 2LIS_02_SCN and 2LIS_02_CGR | SCN Relevancy Factor: 1. 2. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. InfoSources. x queries on InfoCubes. 0pur_c07 0pur_c08 0pur_c09 0pur_o02, 80pur_o01, 2lis_02_hdr 0srv_c01 2lis_02_s174 0pur_c04 2lis_02_s011,. 2. Visit SAP Support Portal's SAP Notes and KBA Search. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!SAP Documentation. RSS Feed. Allocation - Schedule Line with Goods Receipt. 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. SAP Community Network Wiki - SAP NetWeaver Business Warehouse - Step by Step Enhance your Datasource. 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. 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. 2LIS_02_SCN . 0CO_PC_ACT_07. MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR. Gain access to this content by becoming a Premium Member. Based on DataSource: 2LIS_02_CGR. 2. 2lis_02_sgr eket, ekbe, kkpo. If successful, 9. 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. 0. 2LIS_02_CGR: Produced Activity: Delivery of confirmation s MM - Materials Management: 5 : 2LIS_02_SCN: Produced Activity: confirmation of Schedule Lines. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 2LIS_02_HDR: Purchasing Data (Header Level) MM - Materials Management: 0CO_OM_CCA_1: Cost centers: Costs and allocations: CO - Cost Center Accounting:. 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. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. MM Data Sources Tables Purchasing. I could find lot of documents for the steps for LO extraction. It returns also data for goods receipt and invoices if they exist. Problem: Setup tables are not getting populated for 2lis_02_hdr, 2lis_02_item. For more information, see. Based on DataSource: 2LIS_02_SCN. 0PROCESSKEY. In SAP NetWeaver 7. Whereas 2LIS_02_SGR transferred and added records. Hi All, Can anyone explain me where do I need to check to see from which (underlying) tables is the Data Source (Example: <b>2LIS_02_CGR</b> ) getting data from?Hit enter to search. 2LIS_45* OLIABW RMCENEUB. We have extracted purchasing data using 2LIS_02_SCL and 2LIS_02_ITM datasources. 2LIS_02_CGR Allocation Confirmation with Goods Receipt. If. 2LIS_02_ITM. g i do a setup from 1. They need some Z fields appended to the extractors also, which I have done. Follow RSS Feed Hi Friends, This Datasource is under Purchasing . 0. 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. Click more to access the full version on SAP for Me (Login required). 0pur_o02 2lis_02_hdr,. 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. (However both EKET & EKBE have entries. Are there any particular procedures and precautions in using the above mentioned extractors. 4. 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: 2LIS_13_VDITM: Billing Document 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_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_13_VDITM: Billing Document Item Data:2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SGR: Produced Activity: Delivery of Schedule Lines: MM - Materials Management: Authorization Objects related to S032 AUTHORIZATION OBJECT Description Application ; J_1IRG23D: Authorisation object for Depo Transactions:extractor 2LIS_02_CGR. If successful, 3. Message was edited by: subba rao. 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. ROCANCEL. zero records pulled in Data source 2LIS_02_CGR - SAP Q&A Relevancy Factor: 1. dataextraction. BW/BI Accelarator is a tool that improves the performance of BW 7. it will be great. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. Could any one provide me the step-by-step to fill the setup table. Regards, Prem. SAP BW/4HANA Business Content delivers this field-based DataStore Object (advanced) as a first persistence layer of data replicated into a SAP BW/4HANA data warehouse. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. setup table MC02M_0CGRSETUP is empty and. We are about to use the below Purchasing extractors: 2LIS_02_HDR. Technical name: 2LIS_02_CGR. ALIEF - Number of Deliveries. The OLTP Source still has errors. Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions. 2lis_03_bf mseg, mbew, mkpf. 6) 2LIS_02_SCN. 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). Follow. Load data InfoPackage 2LIS_02_ITM_INIT_R3. Header Data SD - Sales and Distribution: 21 : 2LIS_02_S013 Vendor Evaluation MM - Materials Management: 22 : 2LIS_02_S0122LIS_02_ITM Purchase Order Items. The item data such as material, purchase order quantity, order unit, net price, and so on. Note. 2LIS_02_SGR. Load data InfoPackage 2LIS_02_CGR_INIT_R3. 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. Characteristics. 2LIS_02_ITM . Thanks. This InfoSource provides information about the confirmation quantities allocated with goods receipt quantities. 168. 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. 2LIS_02_CGR no data coming from the Extractor in RSA3 | SAP Community. 5 version. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 5 : 2LIS_04_PEMATNR: Repetitive Manufacturing Material View PP - Production Planning and Control: 6 : 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 7 : 2LIS_44_POSREC: POS Data: receipt Data IS - Retail: 8 :2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 16 : 2LIS_11_VAKON Sales Document Condition SD - Sales and Distribution: 17 :. 76 Views. 4. Load data InfoPackage 2LIS_02_CGR_INIT_R3. 2lis_03_bf mseg, mbew, mkpf. The vendor sends the following confirmation: Confirmation category (EBTYP) = SN – Shipping Notification. 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. 4 BI Content 7. 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 . BWVORG is always hard-coded to '01' or '05' for these extractors. 0pur_o02 2lis_02_hdr, 0pur_o01 0pur_ds03 2lis_02_scl and 2lis_02_sgr. 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. 3. Therefore the DS should be migrated from 3. Then use the function Activate and Schedule to start the process chain according to your scheduling options. Use 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. So for inbound deliveries you have to seek MM extractors. I have to extract data from 2lis_02_scl, 2lis_02_cgr and 2lis_02_sgr standard datasources. 12) 2LIS_02_S174. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. BWA / BIA. We are about to delete setup tables for purchase (02) component and refill the setup tables. 137 Views. 2) 2LIS_02_ITM. Based on DataSource: 2LIS_02_SGR. 2LIS_02_SCL [Purchaseing data Schedule Line level]EKKO, EKBE, T001, T001W, EKET, EKPA. 0CO_PC_ACT_04. Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2. The datasource is active in RSA6 and its structure is also active in LBWE. enabled:true in the Search box and press Enter. To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. 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 Produced Activity: Delivery of Confirmations MM - Materials Management: 11 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 12 : 2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution: 13 : 0FI_GL_4 General Ledger: Line Items with Delta ExtractionThe users are interested in below extractors 2LIS_02_HDR 2LIS_02_ITM 2LIS_02_SCL 2LIS_02_CGR 2LIS_02_SGR 2LIS_02_SCN. For more information, see. mm. if anyone knows tcodes for runinng the set uptable to each data source separatley. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. The 2 datasource aren't loading the same information. 1) 2LIS_02_HDR. Comparing DataSource 2LIS_02_CGR to ME80FN. 4 BI Content 7. 5. Here are the 25 most used bw_datasources in SAP Bw datasource Description Functional Area 2LIS_03_BF Goods Movements From Inventory MM - Materials Management Management 2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management 2LIS_03_BX Stock. ROCANCEL. 2lis_02_s011. 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. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. After completing the setup table in RSA3 i could find records for ITM and SCL. Load data InfoPackage 80PUR_DS03_FULL_DATAMART-7. CM MM-PUR: Alloc - Confirmation with GR (2LIS_02_CGR) - /IMO/CMPUR22 . After all the fixes were done we can think (did the same kind of fix for all 3), 2lis_02_itm refuse to send us any delta records. Pls try extractors of procurement 2lis_02_scl, 2lis_02_sgr, 2lis_02_cgr. MM-PUR: Alloc - Schedule Line with GR (2LIS_02_SGR) - /IMO/CMPUR20. 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 :. 01. MM-PUR: Purchase Order Delivery (Items) - /IMO/D_PUR21. Now how do I find the corresping infoobjects for these enhanced fields. If successful, 5. Transaction event type has the values 1 to 8, I am comparing the keys EBELN and EBELP from structure. I wanted to enhance the DataSource 2LIS_02_CGR, but it is saying we cant enhance it. "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. Delivery date (SCLDT)= 01. 3) 2LIS_02_SCL. 2LIS_02_SGR. If successful, 3. This InfoCube does not have completion indicator so we thought of including ODS. 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. This counter determines the number of deliveries based on the GR document items. 0pur_o02 2lis_02_hdr,. Header Data SD - Sales and Distribution: 22 :. SAP BW Datasource : 2LIS_02_SCL - Purchasing Data (Schedule Line Level). "Hi Gurus, Can anyone advice me on the loading sequence for the following data sources 2lis_02_HDR, 2lis_02_ITM, 2lis_02_SCL, 2lis_02_ SGR, 2lis_02_ CGR, 2lis_02_SCN Thanks in advance2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 13 : 2LIS_12_VCITM Delivery Item Data SD - Sales and Distribution: 14 : 2LIS_04_P_MATNR Material View from PP/PP-PI PP - Production Planning and Control: 15 : 2LIS_11_VASCL Sales Document Schedule LineInbound deliveries are MM deliveries.