You need to fix this and then reactivate the structure. DataSource 2LIS_02_HDR contains data still to be transferred. In SAP NetWeaver 7. issue with EKBE and 2lis_02_scl enhancement. So OLI3BW will not fill the Purchase related setup tables. There are many routines associated with these datasources which are updating the fields in 0PUR_O01. Technical name: 2LIS_02_SCN. Note: PO item is not deleted in R/3 and still it sends. When the data has been brought across from R/3 data has come into the ODS. 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. This also referenced in the Note 684465. 6. 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. To provide the functionality CDS views based. I could find lot of documents for the steps for LO extraction. Hello experts, I am working on LO cockpit - Purchasing area. 0. 1. 6. The datasource is active in RSA6 and its structure is also active in LBWE. Billing Document Item Data SD -Sales and Distribution. In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view . 2LIS_02_CGR: Produced Activity: Delivery of confirmation s MM - Materials Management: 5 : 2LIS_02_SCN: Produced Activity: confirmation of Schedule Lines. Now when I click on Initialization >Fill Setup Tables >Perform Setup Purchasing, i get the following message at the status bar: ". I'm trying to use datasource 2LIS_02_CGR in addition to 2LIS_02_ITM already in use. InfoObjects: 0COMPL_DEL (Delivery Indicator) 0PDLV_QTY (Actual Quantity Delivered). SAP TCode lbwg - Documentaion and other resources. 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中各主要数据源与描述. MM-PUR: Purchase Order Delivery (Items) - /IMO/PUR_D21. I did the setup for the Purchasing Module (02) in LBWG then OLI3BW. BW/BI Accelarator is a tool that improves the performance of BW 7. 3. EXTRACTOR PROBLEM. I have to extract data from 2lis_02_scl, 2lis_02_cgr and 2lis_02_sgr standard datasources. I dont know the flow, Business process associated. The values of BWVORG do not apply to extractors 2LIS_02_SGR, 2LIS_02_SCN or 2LIS_02_CGR. please if any one could give me steps to extract the data into setup tables. here i am loading data 0pur_c07 cube there 4 DS data is coming to ods and then cube ds are 2lis_02_itm & 2lis_02_sgr & cgr,scn. I could find lot of documents for the steps for LO extraction. Gain access to this content by becoming a Premium Member. Return R/3 productive instance to users. 2LIS_02_SCL. If successful, 3. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!SAP Documentation. I m using datasource 2LIS_02_SCL to extract data from R3 using the Direct Delta procedure. It returns also data for goods receipt and invoices if they exist. Based on DataSource: 2LIS_02_CGR. S012. 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. There is no other common. 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. 2006 to 31. i have to extract data from r/3 for re-evaluations. these. 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. any advice. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. 2LIS_02_CGR Allocation Confirmation with Goods Receipt. 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 20 : 2LIS_04_P_COMP Component View from PP/PP-PI PP - Production Planning and Control: 21 : 2LIS_11_VASCL Sales Document Schedule L in e SD -. These indicators and key figures are based on the associated confirmation and goods receipt documents. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. 1. 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). SAP BW Datasource : 2LIS_02_SCL - Purchasing Data (Schedule Line Level). x to 7. I did the setup for the Purchasing Module(02) in LBWG then OLI3BW. S012 is a standard Data Collection Transparent Table in SAP Logistics application, which stores Purchasing data. 0CALDAY. 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). I am not using the BI. 0. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 7 : 2LIS_02_S174 Services MM - Materials Management: 8 : 2LIS_02_S015 Subsequent Settlement: Evaluation MM - Materials Management: 9 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 10 : 2LIS_02_ACC. Experienced in BI-IP (Integrated Planning) tool - development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions. MM-PUR: Purchasing Document Header - /IMO/D_PUR10 . 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). 2lis_02_scn. Therefore the DS should be migrated from 3. 0CO_PC_ACT_05. When we do the reconciliation with MC$4, some. If successful, 6. 3) 2LIS_02_SCL. 2lis_02_sgr. x. e. 8) 2LIS_03_BF. Skip to Content. 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. I have installed the Purchasing cubes from business content and with it 5 Data/InfoSources. 2lis_03_bf . 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. 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:. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 5 : 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: 6 :. x to 7. The system therefore only executes a delta update for this DataSource if. There, you can compare the data in the DataSource fields with the original document data in SAP R/3 , such as: Purchasing Document Number (EBELN) Comparing DataSource 2LIS_02_SGR to ME80FN. 137 Views. 12) 2LIS_02_S174. In RSA3 it shows 146 and in 0PUR_O01 it shows 146 as transferred and added as 93 . 2LIS_02_CGR, 2lis_02_scn and 2lis_02_cgr. 12) 2LIS_02_S174. 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. Follow. 0CO_PC_ACT_04. 2LIS_02_SCN. Delivery date (SCLDT)= 01. 168. "First Solution : enhance 2LIS_02_ITM to have Schedule line date. BalajiBut 0PUR_O01 is designed on 2lis_02_itm, 2lis_02_scl, 2lis_02_sgr and 2lis_02_cgr data sources. 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. 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. 2LIS_02_SCL. If successful, 6. 2LIS_02_SGR. 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. But some of the. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. 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. 2LIS_02_SCL: Purchasing Data (Schedule Line Level) MM - Materials Management: SAP Help, Wiki, Q&A and other resources for RSDRO302 "Fiscal year variant X1 not expected" when loading. On this way you could also enable ODP extraction for obsolete SAP standard. 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. 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_SGR: Produced Activity: Delivery of Schedule Lines: MM - Materials Management: 2LIS_02_HDR: Purchasing Data (Header Level) 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. 2lis_03_bf mseg, mbew, mkpf. Hi Friends. 2LIS_03_BX MCNB RMCBINIT_BW. After transport to production I see that while a few fields are unhidden a few are appearing as. 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:. 1. I need to build cube bringing data from above datasources. 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. Based on DataSource: 2LIS_02_SGR. MC02M_0ACC. I have already filled the set up tables for 02 application, and the other datasources like HDR and ITM have data. 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. 2LIS_02_ACC: Purchasing Data (Account Level) MM - Materials Management: 2LIS_03_BF: Goods Movements From Inventory Management: MM - Materials Management: 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM -. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。. Note that if you change a purchasing document, the system only takes into consideration the data that is relevant for extraction. Marco. Comparing DataSource 2LIS_02_CGR to ME80FN. 10) 2LIS_02_S013. 0CO_PC_ACT_03. 8. 0MM_PUR_VE_02. 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. Allocation - Schedule Line with Goods Receipt. I was trying to activate the standard cube, While searching for the DataSource 2LIS_03_BX, i could not find it in the list. 2LIS_02_SGR Allocation Schedule Line with Goods Receipt. Document update is where the transaction (documents) are updated in the application tables. Technical name: 2LIS_02_CGR. 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. Why SGR, SCN and CGR show 0 records in RSA3. 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. If successful, 3. To get purchase requisition from 0PUR_O01, I create new transformation from 2LIS_02_SCL to 0PUR_O01. enabled:true in the Search box and press Enter. If successful, 5. BW Meta data: InfoObject - 30 : 2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 31 : 2LIS_11_VASTI Sales Document Item Status SD - Sales and Distribution: 32 : 0ARTICLE_ATTR Article. 2LIS_02_SCL. I look at SE11 for ' MC02M_0HDRSETUP ' and table contents gives 0 records. 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. Both datasources 2LIS_02_CGR and 2LIS_02_ITM are active and shown in RSA2. 0. 7. I created the setup tables via "Purchasing - Perform Setup. CompositeProvider . In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 13. I have tried migrating the transformation repeatedly , it gets imported with return code 0. DataSource: 2LIS_02_SCL; Some key figures in the data source need to be updated in. 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). 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. x technology. Amine. Then save, check and activate the process chain and provide information, where applicable, about which server the process chain should be scheduled on. MC02M_0HDR: Extraction Purchasing (Header) for DataSource 2LIS_02_HDR. Once we get the above screen, we could specify the component (02, 11, etc…) and click on execute button. MM Data Sources Tables Purchasing. Choose. 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). cube 0pur_c10 2lis_02_scl and 2lis_02_sgr. We have data sources 2LIS_02_ITM, 2LIS_02_CGR, 2LIS_02_SCR and 2LIS_02_SGR activated and up and running delta properly. Inbound deliveries are MM deliveries. Sachin. Hey Gurus, i have a problem with DS 2LIS_02_CGR Allocation - Confirmation with Goods Receipt. 2lis_02_cgr . 2lis_02_scl. cube 0pur_c10 2lis_02_scl and 2lis_02_sgr. 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. Activate ODS data 0PUR_DS03. Follow. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines. 2lis_02_scl. 2. if anyone knows tcodes for runinng the set uptable to each data source separatley. 4. setup table MC02M_0ITMSETUP is filled and test with RSA3 for 2LIS_02_ITM Returns records. 2lis_02_hdr. The vendor sends the following confirmation: Confirmation category (EBTYP) = SN – Shipping Notification. Vendor to Purchasing organsiation . i have one doubt. BW SD MM FI 常用 数据源. I went into the SE11 and added fields to an append structure on MC02M_0ITM (activated everything). This counter determines the number of deliveries based on the GR document items. problems with 2LIS_02_SCN and 2LIS_02_CGR | SCN Relevancy Factor: 1. 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. SAP Community Network Wiki - SAP NetWeaver Business Warehouse - Step by Step Enhance your Datasource. sanjeev. MM-PUR: Purchasing Document Schedule Line - /IMO/D_PUR12 . If successful, 3. So for inbound deliveries you have to seek MM extractors. If I migrate the DS, what happens with the datastaging from System A(Vers. 3. "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. The other datasource 2LIS_02_SGR is loading the Schedule Line with Goods Receipt from SAP tables EKET, EKBE and EKPO. I wanted to enhance the DataSource 2LIS_02_CGR, but it is saying we cant enhance it. You will find pool of objects there. 2006 and do a test under rsa3, i only manage to see 1 record outa 50k records which is reported by the system. They need some Z fields appended to the extractors also, which I have done. But i need these realtime scenario so that i can try to understand the fields,tables and functiionality. 2. 0. i never tried to enhance this datasource its first time i am working on this. 2lis_02_sgr eket, ekbe, kkpo. it will be great. 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. On top of this, setup table was filled, but I see no data for 2lis_02_itm. "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. This InfoSource provides information about the allocation of confirmation quantities with schedule line quantities. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines: MM - Materials Management: 2LIS_11_VAITM: Sales Document Item Data: SD - Sales and Distribution: 0FI_AP_4: Vendors: Line Items with Delta Extrcation: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_ARBPL Work Center View from PP/PP-PI PP -. Technical name: 2LIS_02_SGR. 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. Whereas 2LIS_02_SGR transferred and added records. Vendor to Purchasing organsiation . Transaction code to delete setup table is LBWG. 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. This DSO contains delivery related indicators and key figures for purchase order items. Activate ODS data 0PUR_O01. In other words, what is the difference between the GR data. 11) 2LIS_02_S015. When I execute the RSA3 for different Datasources I can see data only in. 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 -. To take advantage of SAP HANA for application development, SAP introduced a new data modeling infrastructure known as core data services. 2LIS_02_SCL returns data for the purchase order on header item and schedule line level. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_S012: Purchasing: MM - Materials Management: 2LIS_02_SCN:. Skip to Content. 中都找不到，在提取结构中也没有发现。 在2lis_02_acc 中找到了交货单，没有记录，所以认为不是在这个数据源。. 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 . 0PROCESSKEY. InfoObject. 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_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. Logistics - General. For more information, see. Note. 4) 2LIS_02_CGR. MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR. 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. If successful, 4. MC02M_0ITM: Extraction Purchasing (Item) for DataSource 2LIS_02_ITM. 776', 9999)#临时存储的值. 2lis_02_s011. I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. DataSource working, but concept obsolete in S/4 DataSource working, but concept obsolete in S/4. Hope it helps. such as material, purchase order quantity, order unit, net price, and so on In the Update column for extract structure BW, choose Inactive to activate the extract structures that you want to use: MC02M_0ACC: Extraction Purchasing (Account) for DataSource 2LIS_02_ACC MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR 2LIS_02_SCL: Purchasing Data Schedule Line; 2LIS_02_ACC: Purchasing Data Accounting; 2LIS_02_SCN: Purchasing Data Confirmation of Schedule Lines; 2LIS_02_SGN: Purchasing Data Delivery of Schedule Lines; 2LIS_02_CGR: Purchasing Data Produced Activity: Delivery of Confirmations; 2LIS_06_INV: Invoice Verification Data; 2LIS_03_BX: Stock. MC02M_0CGR: Produced Activity: Delivery of Confirmations Maintenance for Data Source 2LIS_02_CGR. 2LIS_02_SGR brings back a Process Key of 0 and no Schedule Line | SAP Community Relevancy Factor: 1. We are about to delete setup tables for purchase (02) component and refill the setup tables. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations MM - Materials Management: 30 : 2LIS_17_I3HDR: Plant maintenance orders: PM - Plant Maintenance: 31 :304. 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). 7) 2LIS_03_BX. 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. CM MM-PUR: Alloc - Confirmation with GR (2LIS_02_CGR) - /IMO/CMPUR22 . 2lis_03_bf . 2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management: 16 : 2LIS_11_V_SSL Sales Document Order delivery: SD - Sales and Distribution: 17 :2LIS_02_SGR Produced Activity: delivery of Schedule Lines MM - Materials Management: 17 : 2LIS_02_CGR Produced Activity: delivery of Confirmations MM - Materials Management: 18 : 2LIS_08TRFKZ Shipment Costs at delivery Item Level SD - Sales and Distribution: 19 : 0ME_ISM_SD_DELIV_2 IS-M/SD: delivery (With Order Attributes) - 20 :. 1) 2LIS_02_HDR. Comparing DataSource 2LIS_02_CGR to ME80FN. 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 :. I created the setup tables via "Purchasing - Perform Setup", but only 3 setup. 方便各位开发顾问查询. 3. 2LIS_02_CGR. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. Q1. how to extract the data. 2LIS_03_BF OLI1BW RMCBNEUA. But i need these realtime scenario so that i can try to understand the fields,tables and. 0GR_QTY. when i am loading purchasing data by using lo extraction i have problem with datasource 2LIS_02_SCN and 2LIS_02_CGR. 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. As per the discussions in this forum it is because EKES is empty. than the dataset, see the documentation on the ACCEPTING PADDING and Based on DataSource: 2LIS_02_SCN. please any one help me. 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. I tried deleting the setup table (LBWG) and tried again initialization (OLI3BW) but I cant see the data for. Regards. This DSO (advanced) contains replicated goods receipt information for purchasing document schedule line data. Can some one tell me ,2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 21 : 2LIS_08TRTK Shipment: Header Data SD - Sales and Distribution: 22 : 2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management: 23 : 2LIS_06_INV Extraction of Invoice Verification Data into BW2LIS_02_CGR . dataextraction. 2lis_03_um bkpf, mbew, qbew, ebew, bseg. 2LIS_02_CGR no data coming from the Extractor in RSA3 | SAP Community. 5. Use. 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:. 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. 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. x queries on InfoCubes. Logistics Information System (LIS) Data Collection. 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. Appreciate your help. LBWE for 2LIS_02_CGR and 2LIS_02_SGR. RSA3 shows 991 , when I load into 0PUR_C01 , it shows transferred as 958 and added as 0. sadaNo data in 2LIS_02_CGR. Vikram. mm purchasing datasources ods 0pur_o01 2lis_02_itm, 2lis_02_sgr, 2lis_02_cgr, 2lis_02_scn. 265. 4) 2LIS_02_CGR. Now I'm trying to add GR entered on field to 2lis_02_cgr. Message was edited by: subba rao. 2LIS_02_CGR: Produced Activity: Delivery of Confirmations: MM - Materials Management: 2LIS_02_SCN: Produced Activity: Confirmation of Schedule Lines:. Help. 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. "6. 5. Inbound Deliveries comes into picture of Purchasing. 2lis_03_bf mseg, mbew, mkpf. MM-PUR: Purchasing Document Item - /IMO/D_PUR11 . 2LIS_02_CGR. q2. 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. Now how do I find the corresping infoobjects for these enhanced fields. Delivery time (SCLTM) = 12:00:00. About this page This is a preview of a SAP Knowledge Base Article. The new content combines the capabilities of SAP HANA and SAP BW/4HANA for the most optimal solution. Empty the BW delta queues on R/3 by extraction to BW: Start prepare phase on R/3 including generation of shadow instance. 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 :. ALIEF - Number of Deliveries. This InfoCube does not have completion indicator so we thought of including ODS. Using ProcessKey field, 2LIS_02_ITM and 2LIS_02_SCL also provide Goods Receipt (GR) data. 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). 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 :. 1. 2LIS_02_SGR. Thanks and regards. Loaded 0%. 2LIS_02_SCL. For further information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL. 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. Hey, the transcation code to rum PUR setup table is OLI3, not OLI3BW. Queries. DataStore Objects. 2LIS_02_CGR Allocation Confirmation with Goods Receipt. In RSA7 , for the relevant datasources , I see 0 records. 0. Search for additional results. Load data InfoPackage 2LIS_02_SCL_INIT_R3. 4 BI Content 7. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Field in DataSource. Please help me out. I am not using the BI. but not in. Use. 2LIS_02_SCN extract incorrect information when the vendor confirms more/less quantities than schedule quantity. Click more to access the full version on SAP for Me (Login required). 2LIS_02_S013: Vendor Evaluation MM - Materials Management:2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management: 22 : 2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution: 23 : 2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management: 24 : 2LIS_13_VDHDR Billing Doc.