Vendor Document Header Data

DataSource Transactional Data: 0DF_IS_DFS_63

This DataSource allows you to access the vendor document header data from the source system.

Technical Data

Application Component	ISDFPS BW Business Content (IS-DFS-BW)
Available as of Release	SAP Defense Forces & Public Security 6.10
Shipment	NW 2004s BI Content Add-On 3
Content Versions	There are no content versions.
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

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
`MANDT`	Client	`-`	`-`
`VBELN`	Delivery	`LIKP`	`VBELN`
`ERNAM`	Name of Person who Added the Object	`LIKP`	`ERNAM`
`ERZET`	Time Created	`LIKP`	`ERZET`
`ERDAT`	Date on Which the Record Was Created	`LIKP`	`ERDAT`
`VSTEL`	Shipping Point/Receiving Point	`LIKP`	`VSTEL`
`VKORG`	Sales Organization	`LIKP`	`VKORG`
`LFART`	Delivery Type	`LIKP`	`LFART`
`WADAT`	Planned Goods Movement Date	`LIKP`	`WADAT`
`LDDAT`	Loading Date	`LIKP`	`LDDAT`
`TDDAT`	Transportation Planning Date	`LIKP`	`TDDAT`
`LFDAT`	Delivery Date	`LIKP`	`LFDAT`
`KODAT`	Pick Date	`LIKP`	`KODAT`
`ABLAD`	Unloading Point	`LIKP`	`ABLAD`
`INCO1`	Incoterms (Part 1)	`LIKP`	`INCO1`
`INCO2`	Incoterms (Part 2)	`LIKP`	`INCO2`
`EXPKZ`	Export Indicator	`LIKP`	`EXPKZ`
`ROUTE`	Route	`LIKP`	`ROUTE`
`VBTYP`	SD Document Category	`LIKP`	`VBTYP`
`LPRIO`	Delivery Priority	`LIKP`	`LPRIO`
`VSBED`	Shipping Conditions	`LIKP`	`VSBED`
`BTGEW`	Total Weight	`LIKP`	`BTGEW`
`NTGEW`	Net Weight	`LIKP`	`NTGEW`
`GEWEI`	Weight Unit	`LIKP`	`GEWEI`
`VOLUM`	Volume	`LIKP`	`VOLUM`
`VOLEH`	Volume Unit	`LIKP`	`VOLEH`
`ANZPK`	Total Number of Packages in Delivery	`LIKP`	`ANZPK`
`BEROT`	Picked Items Location	`LIKP`	`BEROT`
`LFUHR`	Time of Inbound Delivery	`LIKP`	`LFUHR`
`LSTEL`	Loading Point	`LIKP`	`LSTEL`
`TRAGR`	Transportation Group	`LIKP`	`TRAGR`
`ROUTA`	Route	`LIKP`	`ROUTA`
`AEDAT`	Date of Last Change	`LIKP`	`AEDAT`
`BOLNR`	Bill of Lading	`LIKP`	`BOLNR`
`XABLN`	GR/GI Slip Number	`LIKP`	`XABLN`
`BLDAT`	Document Date in Document	`LIKP`	`BLDAT`
`WADAT_IST`	Actual Goods Movement Date	`LIKP`	`WADAT_IST`
`LIFEX`	External Identification of Delivery Note	`LIKP`	`LIFEX`
`HANDLE`	Worldwide Unique Key for LIKP-VBELN	`LIKP`	`HANDLE`
`DELTA`	Date	`-`	`—`

Extractor Logic

Description of the Key Figures:

The extractor provides the following key figures:

BTGEW: Total Weight
NTGEW: Net Weight
VOLUM: Volume
ANZPK: Total Number of Packages in Delivery

Extraction Logic:

The extractor provides unenriched and unmanipulated header data about deliveries from the LIKP table. Since the volume of item data for one vendor document header is sometimes very high, header and item data has not been combined into a single object in order to avoid larger redundancies in the header data.

The extractor supports a delta mechanism, which is based on a time stamp. A time stamp is derived from the creation date and change date of a data record. If there is no change date for a data record, the time stamp is derived from the creation date. Otherwise, it is always derived from the change date. This ensures that both new records and changed records are extracted with the next delta.