Extraction SD Sales: Document Header

DataSource Transactional Data: 2LIS_11_VAHDR

The structure Extraction SD Sales: Document Header is used to extract header information from SD orders and quotations (but not requests) 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
`APOPLANNED`	Planning in APO
`ANGDT`	Quotation/request valid from	`VBAK`	`ANGDT`
`ANZAU`	Number of orders
`AUART`	Sales document type	`VBAK`	`AUART`
`AUGRU`	Order reason (reason for transaction)	`VBAK`	`AUGRU`
`BNDDT`	Binding period of quotation for service performance (valid to)	`VBAK`	`BNDDT`
`BUKRS`	Company code	`VBAK`	`BUKRS`
`ERDAT`	Date on which record was added	`VBAK`	`ERDAT`
`FAKSK`	Billing type block 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`
`LIFSK`	Delivery note block document header	`VBAK`	`LIFSK`
`PERIV`	Fiscal year variant	`T001`	`PERIV`
`PVRTNR`	Sales representative	`VBAK`	`PVRTNR`
`SPARA`	Division order header	`VBAK`	`SPART`
`STWAE`	Statistics currency	`VBAK`	`STWAE`
`VBELN`	Sales and distribution document number	`VBUK`	`VBELN`
`VBTYP`	Sales document category	`VBAK`	`VBTYP`
`VDATU`	Requested delivery date	`VBAK`	`VDATU`
`VGTYP_AK`	Sales document category of reference document in the order header	`VBAK`	`VGTYP`
`VKBUR`	Sales office	`VBAK`	`VKBUR`
`VKGRP`	Sales group	`VBAK`	`VKGRP`
`VKORG`	Sales organization	`VBAK`	`VKORG`
`VTWEG`	Distribution channel	`VBAK`	`VTWEG`
`WAERK`	Currency of sales and distribution document	`VBAK`	`WAERK`

Extractor Logic

Field VDATU has the same name as Update Date for Statistics Update for DataSources 2LIS_11_VAITM and 2LIS_11_VASCL. In 2LIS_11_VAHDR however, the field VDATU contains the sold-to party's Requested Delivery Date.

If you need a field that can take over the Update Date for Statistics Update function, proceed as described in SAP Note 719603.

ROCANCEL - Cancellation of the data record

This field can have the following values:

“Blank” - new data record or after image
“X ” - Cancellation of data record or before image
“R” - Deletion of data record