Skip to Content
0
May 06, 2014 at 06:16 AM

Transferring VA05 Data to BW

317 Views

Hi,

For reporting we must transfer the data, listed below, to BW. It seems enough to use 2LIS_11_VASCL and 2LIS_11_V_SSL datasources because our keys on DSO are VBELN (Sales Document), POSNR (Item), ETENR (Schedule Line Number). However, KWMENG (Cumulative Order Quantity) and NETWR ( Net Value) is on 2LIS_11_VAITM datasource where ETENR does not exist. How can we integrate these fields on BW with three key fields?

VA05-EN BW SAP 2LIS_11_VAITM 2LIS_11_VASCL 2LIS_11_V_SSL Sales Document 0DOC_NUMBER VBELN 😊 😊 😊 Item (SD) 0S_ORD_ITEM POSNR 😊 😊 😊 Schedule Line Number 0SCHED_LINE ETENR 😔 😊 😊 Sales Document Type 0DOC_TYPE AUART 😊 😊 😔 Confirmed Quantity 0CONF_QTY BMENG 😔 😊 😊 Delivery Date 0DSDEL_DATE EDATU 😔 😊 😔 Billing block 0BILL_BLOCK FAKSK 😊 😊 😔 Sold-to party 0SOLD_TO KUNNR 😊 😊 😔 Exchange Rate 0EXCHG_RATE KURSK 😊 😊 😔 Order Quantity 0CML_OR_QTY KWMENG 😊 😔 😔 Material 0MATERIAL MATNR 😊 😊 😔 Net Value 0NET_VALUE NETWR 😊 😔 😔 Status 0DLV_STS LFSTA 😔 😔 😊 Goods Issue Date 0GI_DATE WADAT 😔 😊 😊 Plant 0PLANT WERKS 😊 😊 😔 Order quantity 0ORDER_QTY WMENG 😔 😊 😊 Pricing date 0PRICE_DATE PRSDT 😊 😊 😔 Created on 0CREATEDON ERDAT 😊 😊 😔