Extraction of SD Billing Conditions (SAP Library - Enterprise Sales and Distribution)

Extraction of SD Billing Conditions

Technical name: 2LIS_13_VDKON

Technical Data

DataSource type	Transaction data
Application components	BW-BCT-SD-BIL
Available from OLTP release	4.0 B
Delivery with	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.

Use

With the Extraction SD Billing Conditions structure, you can extract active condition lines that contribute to the pricing result of a billing 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	VBUK	POSNR
AEDAT	Date of last change	VBRK	AEDAT
BUKRS	Company code	VBRK	BUKRS
BZIRK	Sales district	VBRK	BZIRK
FKART	Billing type	VBRK	FKART
FKDAT	Billing date for billing index and print	VBRK	FKDAT
FKTYP	Billing type	VBRK	FKTYP
HWAER	Local currency	VBRK	HWAER
KDGRP	Customer group	VBRK	KDGRP
KUNAG	Sold-to party	VBRK	KUNAG
KUNRG	Payer	VBRK	KUNRG
KURRF	Exchange rate for FI postings	VBRK	KURRF
STWAE	Statistics currency	VBRK	STWAE
VBTYP	Sales and distribution documents	VBRK	VBTYP
VKORG	Sales organization	VBRK	VKORG
VTWEG	Distribution channel	VBRK	VTWEG
WAERK	Currency of sales and distribution document	VBRK	WAERK
AKTNR	Action	VBRP	AKTNR
AUBEL	Sales and distribution document	VBRP	AUBEL
AUPOS	Sales and distribution document item	VBRP	AUPOS
BONUS	Bonus group	VBRP	BONUS
BWAPPLNM	Application components	VBRP	BWAPPLNM
BWVORG	SAP BW transaction key	VBRP	BWVORG
EAN11	European article number (EAN)	VBRP	EAN11
ERDAT	Date on which the record was added	VBRP	ERDAT
ERNAM	Name of the person who added the object	VBRP	ERNAM
FBUDA	Date of services rendered	VBRP	FBUDA
FKIMG	Amount actually billed	VBRP	FKIMG
KORKS	Controlling area	VBRP	KORKS
KOSTL	Cost center	VBRP	KOSTL
KURSK	Exchange rate for pricing	VBRP	KURSK
KURSK_DAT	Translation date	VBRP	KURSK_DAT
KVGR1	Customer group 1	VBRP	KVGR1
KVGR2	Customer group 2	VBRP	KVGR2
KVGR3	Customer group 3	VBRP	KVGR3
KVGR4	Customer group 4	VBRP	KVGR4
KVGR5	Customer group 5	VBRP	KVGR5
MATKL	Merchandise category	VBRP	MATKL
MATNR	Material number	VBRP	MATNR
MATWA	Material entered	VBRP	MATWA
MVGR1	Material group 1	VBRP	MVGR1
MVGR2	Material group 2	VBRP	MVGR2
MVGR3	Material group 3	VBRP	MVGR3
MVGR4	Material group 4	VBRP	MVGR4
MVGR5	Material group 5	VBRP	MVGR5
PKUNRE	Bill-to party	VBRP	PKUNRE
PKUNWE	Ship-to party	VBRP	PKUNWE
POSAR	Item type	VBRP	POSAR
PRODH	Product hierarchy	VBRP	PRODH
PROVG	Commission group	VBRP	PROVG
PRSDT	Date for pricing and exchange rate	VBRP	PRSDT
PSPDNR	Forwarding agent	VBRP	PSPDNR
PSTYV	Item type sales and distribution document	VBRP	PSTYV
PVRTNR	Sales representative	VBRP	PVRTNR
SPARA	Division order header	VBRP	PVRTNR
SPART	Division	VBRP	SPART
STADAT	Statistics date	VBRP	STADAT
VGBEL	Document number of the reference document	VBRP	VGBEL
VGPOS	Item number of the reference business item	VBRP	VGPOS
VKBUR	Sales office	VBRP	VKBUR
VKGRP	Sales group	VBRP	VKGRP
VRKME	Sales unit	VBRP	VRKME
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
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 figure FKIMG is not suitable for reporting in BW. It may only be used for calculation purposes because this field represents a key figure on the item level. There is a 1:n relation between item and condition which would result in the key figure in the query having multiple values. For calculation purposes, however, it is necessary that this field be added to the extraction structure.

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

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 VS 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.