Extraction SD Sales: Order Conditions (SAP Library - Enterprise Sales and Distribution)

Extraction SD Sales: Order Conditions

Technical name: 2LIS_11_VAKON

Technical Data

DataSource type	Transaction data
Application components	SD Sales (BW-BCT-SD-SLS)
Available from OLTP release	4.0B
Available from PlugIn release	PlugIn 2004_1
RemoteCube enabled	No
Delta enabled	Delta update is supported
Archivable	Yes
Verifiable	No

Prerequisites

Prerequisite for the use of the extractor is the R/3 core SAP Note 673964 or the corresponding support package.

For the R/3 Release 4.6c, SAP Note 726902 is a prerequisite, or support package SAPKIPZ141.

Use

With the Extraction SD Sales: Order Conditions structure, you can extract active condition lines that contribute to the pricing result of a order item to a BW system.

Delta Update

Delta update is supported.

Origin Fields of the Extraction Structure

Field in the Extraction Structure	Description of Field in the Extraction Structure	Origin Table	Field in the Origin Table
ROCANCEL	Indicator: Cancellation of the data record
VBELN	Sales and distribution document number	VBUK	VBELN
POSNR	Item number of the sales and distribution document	VBUP	POSNR
ABSTA	Rejection status of sales and distribution item	VBUP	UVPRS
UVPRS	Item incomplete regarding pricing	VBUP	UVPRS
AUART	Sales and distribution document type	VBAK	AUART
AUGRU	Order reason (reasons for process)	VBAK	AUGRU
BUKRS	Company code	VBAK	BUKRS
FAKSK	Billing type lock sales and distribution document	VBAK	FAKSK
HWAER	Local currency	VBAK	HWAER
KUNNR	Sold-to party	VBAK	KUNNR
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
STWAE	Statistics currency	VBAK	STWAE
VBTYP	Sales and distribution documents	VBAK	VBTYP
VKBUR	Sales office	VBAK	VKBUR
VKGRP	Sales group	VBAK	VKGRP
VKORG	Sales organization	VBAK	VKORG
VTWEG	Distribution channel	VBAK	VTWEG
ABGRU	Reason for rejection for offers and orders	VBAP	ABGRU
AEDAT	Date of last change	VBAP	AEDAT
BWAPPLNM	Application components	VBAP	BWAPPLNM
BWVORG	SAP BW transaction key	VBAP	BWVORG
EAN11	European article number (EAN)	VBAP	EAN11
ERDAT	Date on which the record was added	VBAP	ERDAT
ERNAM	Name of the person who added the object	VBAP	ERNAM
ERZET	System time	VBAP	ERZET
FAKSP	Billing block item	VBAP	FAKSP
KWMENG	Cumulated order quantity in sales units	VBAP	KWMENG
MATKL	Merchandise category	VBAP	MATKL
MATNR	Material number	VBAP	MATNR
MATWA	Material entered	VBAP	MATWA
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
PKUNRE	Bill-to party	VBAP	PKUNRE
PKUNRG	Payer	VBAP	PKUNRG
PKUNWE	Ship-to party	VBAP	PKUNWE
PRODH	Product hierarchy	VBAP	PRODH
PSTYV	Item type sales and distribution document	VBAP	PSTYV
PVRTNR	Sales representative	VBAP	PVRTNR
SPART	Division	VBAP	SPART
STADAT	Statistics date	VBAP	STADAT
STCUR	Translation exchange rate for statistics (exchange rate upon creation)	VBAP	STCUR
VRKME	Sales unit	VBAP	VRKME
WAERK	Currency of sales and distribution document	VBAP	WAERK
ZIEME	Target quantity unit of measure	VBAP	ZIEME
ZMENG	Target quantity in sales units	VBAP	ZMENG
BZIRK	Sales district	VBKD	BZIRK
FBUDA	Date of services rendered	VBKD	FBUDA
FKDAT	Billing date for billing index and print	VBKD	FKDAT
INCO1	Incoterms part 1	VBKD	INCO1
INCO2	Incoterms part 2	VBKD	INCO2
KDGRP	Customer group	VBKD	KDGRP
KTGRD	Account assignment group debitor	VBKD	KTGRD
KURSK	Exchange rate for pricing	VBKD	KURSK
KURSK_DAT	Translation date	VBKD	KURSK_DAT
PRSDT	Date for pricing and exchange rate	VBKD	PRSDT
WAKTION	Action	VBKD	WAKTION
KAPPL	Application	KOMV	KAPPL
KHERK	Condition origin	KOMV	KHERK
KINAK	Condition is inactive	KOMV	KINAK
KNTYP	Condition type: Freight, tax, basic price = revenue, price, retail value	KOMV	KNTYP
KOAID	Condition class	KOMV	KOAID
KSCHL	Condition type	KOMV	KSCHL
KSTAT	Condition is statistical	KOMV	KSTAT
KVARC	Condition for configuration	KOMV	KVARC
STUNR	Level number	KOMV	STUNR
VARCOND	Variant condition	KOMV	VARCOND
KWERT	Condition value	KOMV	KWERT
ZAEHK	Condition Count	KOMV	ZAEHK
WAERK_VBAK	Currency of sales and distribution document	VBAK	WAERK
SPARA	Division order header	VBAK	SPARA
VGTYP_AK	Sales and distribution document type of reference document in the order header	VBAK	VGTYP
PS_POSID	Work breakdown structure element (PSP element)	Field is determined	PS_POSID
PERIV	Fiscal year variant	T001	PERIV

Features of the Extractor

The key figures KWMENG, ZIEME and ZMENG are not suitable for reporting in BW. They may only be used for calculation purposes because these fields represent key figures on the item level.

There is a 1:n relation between items and conditions which could result in the key figures in the query having multiple values. For calculation purposes, however, it is necessary that these fields be added to the extraction structure.

During reorganization, this structure is formed below the order data (application 11) in the table MC11VA0KONSETUP.

This extractor is used to extract item conditions. Header conditions are not extracted.

Due to the increased data volume, loss in performance can occur, especially during reorganization. This can also affect the LIS update and the reorganization of LIS structures.

During reorganization of the order conditions, you should temporarily deactivate the other DataSources for application 11. See SAP Note 602260 for general procedures for reorganization.

The recommended update method is queued delta. The unserialized V3 update is offered as a selection in the Logistic Customizing Cockpit, but it is not suitable for extracting changes in the correct order. Thus it should never be selected.