Start of Content Area

Dummy text Extraction of SD Billing Conditions  Locate the document in its SAP Library structure

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.

 

End of Content Area