Extraction SD Sales: Document Item Billing

DataSource Transactional Data: 2LIS_11_V_ITM

The structure Extraction SD Sales: Document Item Billing is used to extract open sales order values from SD order items to a BI system.

Technical Data

Application Component	SD Sales (BW-BCT-SD-SLS)
Available as of Release	SAP R/3 4.0
Shipment	PlugIn 2000_1
Content Versions	There are no content versions
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	Yes
Verifiable	No

Data Modeling

Delta Update

Note Note

The delta update is supported using the delta method ABR. Note that when a change is made to the sales document, a delta update occurs only if one or more fields in the extraction structure are affected by the change. You can find further information in SAP Note 576886.

End of the note.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`ROCANCEL`	Indicator: Cancellation of the data record	`Table of origin`	`Field of origin`
`ABGRU`	Reason for rejection for quotations and orders	`VBAP`	`ABGRU`
`ABSTA`	Rejection status of sales document item	`VBUP`	`ABSTA`
`ANZOAUPO`	Number of open order items
`BUKRS`	Company code	`VBAK`	`BUKRS`
`BZIRK`	Sales district	`VBKD`	`BZIRK`
`CHARG`	Batch number	`VBAP`	`CHARG`
`EAN11`	European article number (EAN)	`VBAP`	`EAN11`
`ERDAT`	Date on which record was added	`VBAP`	`ERDAT`
`FAKSK`	Billing type block sales and distribution document	`VBAK`	`FAKSK`
`FAKSP`	Billing block item	`VBAP`	`FAKSP`
`HWAER`	Local currency	`VBAK`	`HWAER`
`INCO1`	Incoterms 1	`VBKD`	`INCO1`
`INCO2`	Incoterms 2	`VBKD`	`INCO2`
`KDGRP`	Customer group	`VBKD`	`KDGRP`
`KUNNR`	Sold-to party	`VBAK`	`KUNNR`
`KURSK`	Pricing exchange rate	`VBKD`	`KURSK`
`KURSK_DAT`	Translation date	`VBKD`	`KURSK_DAT`
`KURST`	Exchange rate type	`VBAK`	`KURST`
`KVGR1`	Customer group 1	`VBAK`	`KVGR1`
`KVGR2`	Customer group 2	`VBAK`	`KVGR2`
`KVGR3`	Customer group 3	`VBAK`	`KVGR3`
`KVGR4`	Customer group 4	`VBAK`	`KVGR4`
`KVGR5`	Customer group 5	`VBAK`	`KVGR5`
`LFIMG_AVME`	Actual delivered quantity in sales units
`LIFSK`	Delivery note block document header	`VBAK`	`LIFSK`
`MATKL`	Merchandise category	`VBAP`	`MATKL`
`MATNR`	Material number	`VBAP`	`MATNR`
`MATWA`	Material entered	`VBAP`	`MATWA`
`MCBW_LFWRT`	BW: Delivery order value
`MCBW_NETPR_AVKM`	BW: Net price of order item sales units
`MCEX_APCAMPAIGN`	Campaign of referred sales order item for BI extraction	`VBKD`	`CAMPAIGN`
`MEINS`	Base unit	`VBAP`	`MEINS`
`MVGR1`	Material group 1	`VBAP`	`MVGR1`
`MVGR2`	Material group 2	`VBAP`	`MVGR2`
`MVGR3`	Material group 3	`VBAP`	`MVGR3`
`MVGR4`	Material group 4	`VBAP`	`MVGR4`
`MVGR5`	Material group 5	`VBAP`	`MVGR5`
`OAUME`	Open order quantity
`OAUWE`	Open net sales order value
`PERIV`	Fiscal year variant	`T001`	`PERIV`
`PKUNRE`	Bill-to party	`VBAP`	`PKUNRE`
`PKUNRG`	Payer	`VBAP`	`PKUNRG`
`PKUNWE`	Ship-to party	`VBAP`	`PKUNWE`
`POSNR`	Item number of the sales and distribution document	`VBUP`	`POSNR`
`PRODH`	Product hierarchy	`VBAP`	`PRODH`
`PS_POSID`	Work breakdown structure element (WBS element)	`VBAP/PRPS`	`PS_PSP_PNR/POSID`
`PSPDNR`	Forwarding agent	`VBAP`	`PSPDNR`
`PVRTNR`	Sales representative	`VBAP`	`PVRTNR`
`ROUTE`	Route	`VBAP`	`ROUTE`
`SHKZG`	Return item	`VBAP`	`SHKZG`
`SPARA`	Division order header	`VBAK`	`SPART`
`SPART`	Division	`VBAP`	`SPART`
`STADAT`	Statistics date	`VBAP`	`STADAT`
`STCUR`	Exchange rate for statistics (exchange rate upon creation)	`VBAP`	`STCUR`
`STWAE`	Statistics currency	`VBAK`	`STWAE`
`UMVKN`	Denominator for conversion of sales quantity into SKU	`VBAP`	`UMVKN`
`UMVKZ`	Numerator for conversion of sales quantity into SKU	`VBAP`	`UMVKZ`
`VBELN`	Sales and distribution document number	`VBUK`	`VBELN`
`VBTYP`	Sales document category	`VBAK`	`VBTYP`
`VKBUR`	Sales office	`VBAK`	`VKBUR`
`VKGRP`	Sales group	`VBAK`	`VKGRP`
`VKORG`	Sales organization	`VBAK`	`VKORG`
`VRKME`	Sales unit	`VBAP`	`VRKME`
`VSTEL`	Shipping point/goods receiving point	`VBAP`	`VSTEL`
`VTWEG`	Distribution channel	`VBAK`	`VTWEG`
`WAERK`	Currency of sales and distribution document	`VBAP`	`WAERK`
`WAKTION`	Action	`VBKD`	`WAKTION`
`WERKS`	Plant	`VBAP`	`WERKS`

Extractor Logic

The delivery relevance of the order item is crucial for extraction with the DataSource 2LIS_11_V_ITM. If the order item is not delivery-relevant, no data is extracted.

Fields that are calculated at runtime are not saved on the database, because their value is influenced by order- and delivery processing. This affects the two key figures Open Order Quantity (OAUME) and Open Order Value (OAUWE) in particular, as well as Actual Delivered Quantity (LFIMG_AVME) . The key figures Open Order Quantity and Open Order Value are established when creating an order and reduced by the delivery of order items. The key figure Actual Delivered Quantity is established by the creation of a delivery.

Example Example

With the creation of an order item, an open order quantity of 10 pieces is established. The item is then delivered, with a partial delivery of 6 pieces. The open order quantity is reduced by 6 pieces. An open order quantity of 4 pieces remains. The extractor delivers the following records:

1. Creation of order item:

ROCANCEL	VBELN	POSNR	OAUME	LFIMG_AVME
	4711	10	10	10

2. Delivery of order item:

ROCANCEL	VBELN	POSNR	OAUME	LFIMG_AVME
	4711	10	-6	6

End of the example.

After billing the values, an open order quantity of 4 pieces remains in the BI system. The update type Addition therefore determines the difference in billing between the order and the delivery for these key figures in DataStore objects. You can find further information in SAP Note 401919.

ROCANCEL - Cancellation of the data record

“Blank” - New data record or after image
“X ” - Cancellation of data record or before image
- Before image = State before changes were made to the data record
- After image = State after changes were made to the data record

Changes in the order and delivery are mapped by before- and after images.

The field ROCANCEL accepts the value “X” for before images and the value “Blank” for after images. The key figures of the before image are sent with reversed (as a rule, negative) signs.

Example Example

In the delivery, the delivered quantity is increased to 7 pieces:

ROCANCEL	VBELN	POSNR	OAUME	LFIMG_AVME
X	4711	10	-4	-6
	4711	10	3	7

The open order quantity of the order item is now 3 pieces.

End of the example.

For technical reasons, ROCANCEL =“R” cannot be sent in the case of billing extractors such as the DataSource 2LIS_11_V_ITM for deletion records (refer to SAP Note 426731). In the case of a deletion, an after image with a reversed sign is sent instead. This means that a created order item is not deleted from the DataStore, but rather the values of the key figures via billing are set to zero. You can find further information about the update of DataSource 2LIS_11_V_ITM in DataStore objects in SAP Note 440679.

Example Example

The delivery created above is deleted. The deletion of the delivery means that the open order quantity is completely re-established.

ROCANCEL	VBELN	POSNR	OAUME	LFIMG_AVME
	4711	10	7	-7

The following values now arise in the DataStore object via billing:

DataStore Object

VBELN

POSNR

OAUME

LFIMG_AVME

4711

<- Status before deletion of the delivery

4711

<- Status after deletion of the delivery

End of the example.

Note Note

If you call transaction RSA7, you can find records there that show the value “U” in the field ROCANCEL. These values are required for the conversion of deletion records in after images with reversed signs via the S-API. The values “V” and “W” also exist, and are likewise only used internally. These values should never occur in the BI system. This only happens if you have set all the key figures of the DataSource to non-reversible in transaction RSA6. These settings are not correct. You can find further information about the attributes of field ROCANCEL in SAP Note 757487.

End of the note.

If the order is also deleted, the following screen appears:

ROCANCEL	VBELN	POSNR	OAUME	LFIGM_AVME
	4711	10	-10	0

The following values arise in the DataStore object via billing:

DataStore Object	VBELN	POSNR	OAUME	LFIMG_AVME
	4711	10	10	7	<- Status before deletion of the order
	4711	10	0	0	<- Status after deletion of the order

The key figures of the item receive the value 0.

In a summarized form, the data in the Persistent Staging Area (PSA) for the order item appears as follows:

ROCANCEL	VBELN	POSNR	OAUME	LFIMG_AVME
	4711	10	10	0	Create order item
	4711	10	-6	6	Create delivery
X	4711	10	-4	-6	Change delivery before image
	4711	10	3	7	Change delivery after image
	4711	10	7	-7	Delete delivery
	4711	10	-10	0	Delete order item

Note Note

Note that only after images are extracted when creating and deleting the order or delivery. These data records deliver the values by which the key figure was changed - not, as perhaps expected, the last state of the key figure. In contrast to this, when changing the order or the delivery, both before- and after images are sent, which reflect the state of the order before and after the change. This enables you to identify changes to the delivery.

End of the note.

In contrast to DataSource 2LIS_11_VAITM, enhancements to the DataSource 2LIS_11_V_ITM are heavily restricted. Not all fields of the communication structures MCVBUK, MCVBUP, MCVBAK, MCVBAP, and MCVBKD are offered for enhancement in the Logistic Customizing Cockpit (LBWE). The reason for this is that the DataSource is updated for events VA (order) and VC (delivery). While all the information for filling the fields for event VA is available, not all necessary information is available in the extraction from the delivery (event VC). This would lead to the relevant fields for event VC not being filled.