Hope it helps. It looks like someone was changing the CGR structure and somehow damaged it or deactivated it. 0CO_PC_ACT_05: Material Valuation: Prices MM - Materials Management: 14. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view . 4. I m using datasource 2LIS_02_SCL to extract data from R3 using the Direct Delta procedure. Due to some loads failed, we are doing re-init the loads. To provide the functionality CDS views based extractors will be provided. The OLTP Source still has errors. The system therefore only executes a delta update for this DataSource if. 2LIS_02_SCL returns data for the purchase order on header item and schedule line level. To load into the setup tables, you need to have active structures. SAP BW Datasource : 2LIS_02_SCL - Purchasing Data (Schedule Line Level). I am new to Purchasing. I am trying to add a couple of fields to extractor 2LIS_02_ITM. This DSO (advanced) contains delivery related indicators and key figures for purchase order items. 02 Purchasing 2LIS_02_ACC MC02M_0ACCSETUP Folder: BW Setup for. If vendor confirms 215 quantity for 1st schd. S012. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. For SAP BW/4HANA, brand-new, ready-made content is delivered that uses the new objects, such as CompositeProviders, and is based on the simplified LSA++ architecture. 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. Could any one provide me the step-by-step to fill the setup table. 76 Views. In SAP NetWeaver 7. it will be great. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。. Once we execute, it would give us the below screen for confirmation. Then you will get your data. I want to ask something, in default transformation to 0PUR_O01 (i. 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:. Follow. 1. I tried deleting the setup table (LBWG) and tried again initialization (OLI3BW) but I cant see the data for. 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). Technical name: 2LIS_02_SGR. e. 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. 33 Views. 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. 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_03_um bkpf, mbew, qbew, ebew, bseg. Load data InfoPackage. Thanks. cube 0pur_c10 2lis_02_scl and 2lis_02_sgr. 2LIS_02* OLI3BW RMCENEUA. Help. 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. 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. InfoObject. i never tried to enhance this datasource its first time i am working on this. so i think i have to use Schedule Line Counter (ETENR) to take the. The process chain supports SAP R/3 standard systems as of Release 4. Relevancy Factor: 1. I could find lot of documents for the steps for LO extraction. 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. Comparing DataSource 2LIS_02_CGR to ME80FN. Tthere is no data for the 2LIS_02_CGR extractor in RSA3 T-Code, I would like to load the data and as per my understanding i need to fill the step table. ROCANCEL. 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. Supply Chain Management (SAP HANA-Optimized) Invoice Verification (SAP HANA-Optimized) Procurement (SAP HANA-Optimized) Prerequisites. 0. 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. 2LIS_02_ACC Purchas in g Data (Account Level) MM - Materials Management: Premium Member Only Results. 2006 and do a test under rsa3, i only manage to see 1 record outa 50k records which is reported by the system. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. 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. We have up and running data already, and we have just discovered one mistake that we've done. 2lis_02_scn. 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. 2LIS_02_SGR: Produced Activity: delivery of Schedule Lines MM - Materials Management: 21 : 2LIS_13_VDHDR: Billing Doc. 2LIS_02_ITM . If I migrate the DS, what happens with the datastaging from System A(Vers. Goto LBWE transaction in R/3. 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. 2lis_02_sgr eket, ekbe, kkpo inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. 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. 2LIS_02_SCN. 01. When I look at the various extractors in BI, 2lis_02_cgr and 2_lis_02sgr both have the date as June 2nd. 8) 2LIS_03_BF. issue with EKBE and 2lis_02_scl enhancement. Inventory Management (SAP HANA-Optimized) Production Planning and Controlling (SAP HANA-Optimized). e. I am not getting any data for 2LIS_02_CGR in RSA3 transaction in ECC. If successful, 5. 0MM_PUR_VE_01. 2lis_02_s012. Click ‘Yes’ to proceed further. 0pur_o02 2lis_02_hdr, 0pur_o01 0pur_ds03 2lis_02_scl and 2lis_02_sgr. Skip to Content. DataSource working, but concept obsolete in S/4 DataSource working, but concept obsolete in S/4. In bw Iam doing init schedule in purchasing. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. Header Data SD - Sales and Distribution: 22 :. x technology. 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 :. 8) 2LIS_03_BF. 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. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。. 2lis_03_bf . I have added these fields EKGRP (Component Type BKGRP) and field NETWR (Component type BWERT). I am having a strange issue that a few of the custom fields of data sources are coming as hidden after transport to production. 3. 0RECORDMODE. I am not using the BI. Thanks and regards. If successful, 3. 2) 2LIS_02_ITM. We are about to delete setup tables for purchase (02) component and refill the setup tables. 2LIS_02_SCL EKKO, EKBE,T001, T001W, EKET, EKPA. ALIEF - Number of Deliveries. Return R/3 productive instance to users. regards. 0CALDAY. 2lis_03_bf mseg, mbew, mkpf. In RSA7 i purged or deleted the records and entry for this datasource. In fact, 2LIS_02_CGR is loading Confirmation with Goods Receipt from SAP tables EKBE, EKES, EKBE and EKPO. 2lis_03_bf . Are there any particular procedures and precautions in using the above mentioned extractors. Characteristics. I did the setup for the Purchasing Module(02) in LBWG then OLI3BW. 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. Technical name: 2LIS_02_CGR. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_03_UM: Revaluations: MM - Materials Management. for purchasing the application component is 02. If. Indicator: Cancellation of data record. . 175 Views. This InfoSource provides information about the confirmation quantities allocated with goods receipt quantities. Why ITM shows 0 records in BW. In RSA3 it shows 146 and in 0PUR_O01 it shows 146 as transferred and added as 93 . I checked the. 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 : 0FI_GL_14 General Ledger (New): Line Items Leading Ledger FI - General Ledger Accounting: 19 : 2LIS_03_BX Stock Initialization for Inventory. 2lis_02_itm . 2LIS_02_SCL. 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). mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 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. 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. 5 version. e. 2lis_02_scn. Technical Name: 0PUR_O01. DataStore Objects. Appreciate your help. 2LIS_02_CGR Allocation Confirmation with Goods Receipt. sanjeev. 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. 1. 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’. 2lis_02_sgr eket, ekbe, kkpo. 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 discussions!DataSources: 2LIS_02_ITM. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 2. 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. 1) Use T-code LBWE to delete setup tables. 36. Run the collective run so all the data are sent into the delta queue. If successful, 6. 0MATERIAL. Load data InfoPackage 2LIS_02_CGR_INIT_R3. Also the datasource is active in LBWE. 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 -. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. 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_02_CGR: Produced Activity: Delivery of confirmation s MM - Materials Management: 5 : 2LIS_02_SCN: Produced Activity: confirmation of Schedule Lines. Delivery date (SCLDT)= 01. 2LIS_02_CGR no data coming from the Extractor in RSA3. 5. 2. Additional Information DataSource working, but concept obsolete in S/4. 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. 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. Quantity ordered (SCLQTY) = 20. Prerequisites The following master data must be loaded before loading the transactional data into this DSO because the master data is read during the transformation:2LIS_02_CGR Allocation Confirmation with Goods Receipt. Queries. 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. 2LIS_02_SCN. HI EXPERTS, when i am trying to activate datasource 2lis_02_cgr it says "Structure maintenance not provided for extraction structure MC02M_0CGR ->". The active aggregate. please if any one could give me steps to extract the data into setup tables. MC02M_0CGR Storage. enabled:true in the Search box and press Enter. Change the Standard variant to Released Views variant. For more information, see. 4) 2LIS_02_CGR. MM-PUR: Purchasing Document Item - /IMO/D_PUR11 . 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). BW/BI Accelarator is a tool that improves the performance of BW 7. ) 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. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 12. Visit SAP Support Portal's SAP Notes and KBA Search. Load data InfoPackage 2LIS_02_SGR_INIT_R3. Activate ODS data 0PUR_DS03. SAP Community Network Wiki - SAP NetWeaver Business Warehouse - Step by Step Enhance your Datasource. 5. How to enhance datasource 2LIS_02_S174 | SAP Community Relevancy Factor: 1. ROCANCEL. 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. Activate ODS data 0PUR_DS03. The 2 datasource aren't loading the same information. 04. 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. 2lis_02_cgr ekbe, ekes, ekpo. Load data InfoPackage 2LIS_02_ITM_INIT_R3. BW process key should not be in key when you are using : 2LIS_02_SGR and 2LIS_02_CGR. 2LIS_02_ITM 2LIS_02_HDR 2LIS_02_SCL. There is no other common. We want to load data with the same DS from System B with 7. This update is normally a synchronous update, i. "6. 2LIS_02_CGR . Please help me out. I look at SE11 for ' MC02M_0HDRSETUP ' and table contents gives 0 records. I could find lot of documents for the steps for LO extraction. 5. 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. This counter determines the number of deliveries based on the GR document items. If successful, 6. 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. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. Hello experts, I am working on LO cockpit - Purchasing area. So for inbound deliveries you have to seek MM extractors. 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. MM-PUR: Purchase Order Delivery (Items) - /IMO/D_PUR21. I am not using the BI. CompositeProvider . The problem is with datasource 2LIS_02_SCN, it is generating records with reversal indicator =R and it deletes the existing PO item in ODS. Pls pour your suggestions ASAP. (However both EKET & EKBE have entries. 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. Document update is where the transaction (documents) are updated in the application tables. Now when I click on Initialization >Fill Setup Tables >Perform Setup Purchasing, i get the following message at the status bar: ". If you click that dropdown you will find the tables for your Datasource. Using ProcessKey field, 2LIS_02_ITM and 2LIS_02_SCL also provide Goods Receipt (GR) data. Step one: stop all postings in connected ERP system. But some of the. 2) Now you can selectively fill the setup tables for purchasing related datasources by the T-code OLI3BW. I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. Hit enter to search. The Key of the DSO is Purchasing Document Number and Purchasing line Item no (similar to Standard DSO 0PUR_O01 ). Please give your valuable inputs in this regard. Technical name: 2LIS_02_CGR. The datasource is active in RSA6 and its structure is also active in LBWE. x. I have already filled the set up tables for 02 application, and the other datasources like HDR and ITM have data. 0CO_PC_ACT_03. MultiProvider. This data source is used often. 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. There, you can compare the data in the DataSource fields with the original document data in SAP R/3, such as: Design and developed data model for Key performance indicators such as delivery Performance to Customer by quantity, drop ship visibility on purchase order using 2lis_02_itm, 2lis_02_SCN, 2lis_02. I want to set up the delta mechanism for 0PUR_C01 , OPUR_O01 , 0PUR_C08 , 0IC_C03 and 0COPC_C04 business content cubes. Billing Document Item Data SD -Sales and Distribution. 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:. While 3 of them [ITM, SGR and SCL] are extracting data, the 2 mentioned in the subject line do not extract any data. The purchase order exists in APO in the form of an order. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. We deleted init and reinitialised with no success. To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. Help. ). 2LIS_02_CGR Produced Activity: delivery of Confirmations MM - Materials Management: 27 : 0ASSET_ATTR_TEXT Asset Subnumber with Description FI - Asset Accounting: 28 :2LIS_03_BX: Stock Initialization for Inventory Management: MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_12_VCHDR: Delivery Header Data: SD - Sales and Distribution: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials. 137 Views. BWVORG is always hard-coded to '01' or '05' for these extractors. 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. Load data InfoPackage 2LIS_02_SCL_INIT_R3. 2LIS_02_ITM: Purchas in g Data (Item Level) MM - Materials Management: 3 : 2LIS_03_BF: Goods Movements From in ventory Management MM - Materials Management: 4 :. 2lis_02_hdr. 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. 2. 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. MC02M_0HDR: Extraction Purchasing (Header) for DataSource 2LIS_02_HDR. 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. I'm trying to use datasource 2LIS_02_CGR in addition to 2LIS_02_ITM already in use. If a ASN is generated without GRN then we are unable to fetch the same using 2LIS_02_CGR. This InfoCube does not have completion indicator so we thought of including ODS. Note. Header Data. 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. Sales-Shipping Schedule Line Delivery: SD - Sales and Distribution: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_12_VCHDR: Delivery. 3. 1) 2LIS_02_HDR. inventory 2lis_03_bx stock tables, mcha, mara, t001, t001w, calculated from mbew, ebew, qbew. These indicators and key figures are based on the associated confirmation and goods receipt documents. Inbound Deliveries comes into picture of Purchasing. Relevancy Factor: 2. LBWE shows both extract structures (MC02M_0CGR and MC02M_0ITM) as active. MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR. Though after doing setup I find data coming correctly for. We load data with Datasource 2LIS_02_CGR from System A with 3. Your membership also includes exclusive access to all premium content, hundreds of thousands of SAP resources, search functionality, and more. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource Produced Activity: Delivery of Schedule Lines ( 2LIS_02_SGR ). 2lis_02_cgr . I have checked in my system and there is already data in the tables EKET, EKES, EKBE. Please help me out. Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions. They need some Z fields appended to the extractors also, which I have done. Follow. But some of the. 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 . Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2. dear all, anyone has experiance using this extractor 2LIS_02_CGR? after i fill up the setup table, datas are still not updated. Note. 0. InfoObjects: 0VENDOR. In the ERP system, information about the header data of a purchasing document is contained in the EKKO table ( Purchasing Document Header ). . 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. There, you can compare the data in the DataSource fields with the original document data in. 2LIS_02_ITM Purchase Order Items. example:i loaded purchasing cubes by using lo datasources like (ex:2lis_02_item,2lis_02_scl ,2LIS_02_CGR etc. 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. 5 version. 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. 80. Search for additional results. Vendor to Purchasing organsiation . 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. 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. 11) 2LIS_02_S015. 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. as the data in that dataset. 2lis_02_acc, 2lis_02_cgr, 2lis_02_hdr, 2lis_02_itm, 2lis_02_scl, 2lis_02_scn, 2lis_02_sgr, 2lis_03_bf, 2lis_03_bx, 2lis_03_um, 2lis_04_p_arbpl, 2lis_04_p_arbpl_20. Q1. Vendor to Purchasing organsiation . 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). 0PO_QTY. Alloc - Confirmation with GR (2LIS_02_CGR) - /IMO/PUR_IS22 . 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). 1. Hi Friends. The next MAJOR release of SAP S/4HANA Enterprise. MC02M_0SCL: Extraction Purchasing (Schedule Line) for DataSource 2LIS_02_SCL. 6) 2LIS_02_SCN. x queries on InfoCubes. If successful, 9. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. 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 :. 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:. This DSO (advanced) contains replicated goods receipt information for purchasing document schedule line data. these. Based on DataSource: 2LIS_02_SGR. The content was built around the Layered Scalable Architecture (LSA) approach. This DataStore object (advanced) serves as the staging and corporate memory DSO for the DataSource Purchasing Data (Schedule Line Level) (2LIS_02_SCL). So OLI3BW will not fill the Purchase related setup tables. 4. Comparing DataSource 2LIS_02_CGR to ME80FN. Problem: Setup tables are not getting populated for 2lis_02_hdr, 2lis_02_item. 0. Skip to Content. The values of BWVORG do not apply to extractors 2LIS_02_SGR, 2LIS_02_SCN or 2LIS_02_CGR. I did the setup for the Purchasing Module (02) in LBWG then OLI3BW. The item data such as material, purchase order quantity, order unit, net price, and so on. With CDS, data models are defined and consumed. 12) 2LIS_02_S174. " 2LIS_02_CGR no data coming from the Extractor in RSA3 | SAP Community". Characteristics. i can see in LBWE that the data source is active. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13. 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. 2. how to extract the data. Step three:. 2LIS_02_SCL. We are about to delete setup tables for purchase (02) component and refill the setup tables. Inbound deliveries are MM deliveries. 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. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 5 : 0MATERIAL_ATTR: Material Number Logistics - Logistics - General: 6 :. Skip to Content. 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 -. Note: PO item is not deleted in R/3 and still it sends. 2) 2LIS_02_ITM. 6. These indicators and key figures are based on the associated confirmation and goods receipt documents. As per the discussions in this forum it is because EKES is empty. So 2LIS_02_SCL gives more informations. 0pur_c07 0pur_c08 0pur_c09 0pur_o02, 80pur_o01, 2lis_02_hdr 0srv_c01 2lis_02_s174 0pur_c04 2lis_02_s011,. Load data InfoPackage 80PUR_DS03_FULL_DATAMART-7. 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中各主要数据源与描述. Note that if you change a purchasing document, the system only takes into consideration the data that is relevant for extraction. In SAP NetWeaver 7. 0PROCESSKEY. When i try with 2LIS_02_ITM ,2lis_02_scl and 2lis_02_hdr ,R3 returns correctly my records from the set-up table . 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 :. The new content combines the capabilities of SAP HANA and SAP BW/4HANA for the most optimal solution. RSS Feed. I have tried migrating the transformation repeatedly , it gets imported with return code 0. MC02M_OITM. 2lis_02_sgr. 0MM_PUR_VE_02. Purchasing document 4500000001, Item 0010, has the following schedule lines: Schedule line number (SCLNR) = 1. About this page This is a preview of a SAP Knowledge Base Article. 776', 9999)#临时存储的值.