SAP table BAPIDLVHDR (BAPI Structure Delivery Header Analog LIKP)

SAP table BAPIDLVHDR has 2 primary key fields being MANDT,VBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
VBELN Delivery CHAR 10 0 VBELN_VL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
ERDAT Date on which the record was created DATS 8 0 ERDAT
BZIRK Sales District CHAR 6 0 BZIRK
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
VKORG Sales Organization CHAR 4 0 VKORG
LFART Delivery Type CHAR 4 0 LFART
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
KZAZU Order Combination Indicator CHAR 1 0 KZAZU_D
WADAT Planned Goods Movement Date DATS 8 0 WADAK
LDDAT Loading Date DATS 8 0 LDDAT
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
LFDAT Delivery Date DATS 8 0 LFDAT_V
KODAT Picking Date DATS 8 0 KODAT
ABLAD Unloading Point CHAR 25 0 ABLAD
INCO1 Incoterms (Part 1) CHAR 3 0 INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
EXPKZ Export indicator CHAR 1 0 EXPKZ
ROUTE Route CHAR 6 0 ROUTE
FAKSK Billing Block in SD Document CHAR 2 0 FAKSK
LIFSK Delivery Block (Document Header) CHAR 2 0 LIFSK
VBTYP SD document category CHAR 1 0 VBTYP
Revenue canceled/new view (temporary)
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Accounting Document (Temporary)
, Shipment Document
- Accounting Document (Temporary)
. Service Notification
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
: Service Order
A Inquiry
a Shipment costs
b CRM Opportunity
B Quotation
C Order
c Unverified delivery
D Item proposal
d Trading Contract
e Allocation table
E Scheduling agreement
f Additional Billing Documents
F Scheduling agreement with external service agent
G Contract
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
H Returns
i Goods receipt
I Order w/o charge
J Delivery
j JIT call
k Agency Document
K Credit memo request
L Debit memo request
M Invoice
N Invoice canceled
n Reserved
O Credit memo
o Reserved
P Debit memo
p Goods Movement (Documentation)
q Reserved
Q WMS transfer order
R Goods movement
r TD Transport (only IS-Oil)
S Credit memo canceled
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
T Returns delivery for order
U Pro forma invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
V Purchase Order
W Independent reqts plan
w Reservation (Only IS-Oil)
X Handling unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
^ Reserved
| Reserved
~ Revenue canceled (temporary)
§ Revenue Recognition/New View (Temporary)
KNFAK Customer Factory Calendar CHAR 2 0 KNFAK
TPQUA not currently in use CHAR 1 0 TPQUA
TPGRP not currently in use CHAR 2 0 TPGRP
LPRIO Delivery Priority NUMC 2 0 LPRIO
VSBED Shipping Conditions CHAR 2 0 VSBED
KUNNR Ship-to Party CHAR 10 0 KUNWE
KUNAG Sold-to Party CHAR 10 0 KUNAG
KDGRP Customer Group CHAR 2 0 KDGRP
STZKL Not Currently in Use DEC 3 2 STZKL
STZZU not currently in use DEC 3 0 STZZU
BTGEW Total Weight QUAN 15 3 GSGEW
NTGEW Net weight QUAN 15 3 NTGEW_15
GEWEI Weight Unit UNIT 3 0 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 VOLEH
ANZPK Total Number of Packages in Delivery NUMC 5 0 ANZPK
BEROT Picked Items Location CHAR 20 0 BEROT
LFUHR Time of delivery TIMS 6 0 LFUHR
GRULG Weight Group for Delivery CHAR 4 0 GRULG
LSTEL Loading Point CHAR 2 0 LSTEL
TRAGR Transportation Group CHAR 4 0 TRAGR
FKARV Proposed billing type for a delivery-related billing doc. CHAR 4 0 FKARV
FKDAT Billing Date DATS 8 0 FKDAT
PERFK Invoice Dates (Calendar Identification) CHAR 2 0 PERFK
ROUTA Route CHAR 6 0 ROUTE
STAFO Update Group for statistics update CHAR 6 0 STAFO
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 KALSM_D
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
WAERK SD Document Currency CUKY 5 0 WAERK
VKBUR Sales office CHAR 4 0 VKBUR
VBEAK Shipping processing time for the entire document DEC 6 2 VBEAK
ZUKRL Combination criteria for delivery CHAR 40 0 DZUKRL
VERUR Distribution delivery CHAR 35 0 VERUR_VL
COMMN Communication number for Q-API interface CHAR 5 0 COMMN
STWAE Statistics Currency CUKY 5 0 STWAE
STCUR Exchange rate for statistics DEC 9 5 STCUR
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 LGNUM
LISPL Delivery Within one Warehouse CHAR 1 0 LNSPL_LIKP
Delivery split by warehouse number not set
A Delivery is for single warehouse
B Delivery is not for single warehouse
VKOIV Sales Organization for Intercompany Billing CHAR 4 0 VKOIV
VTWIV Distribution channel for intercompany billing CHAR 2 0 VTWIV
SPAIV Division for intercompany billing CHAR 2 0 SPAIV
FKAIV Billing type for intercompany billing CHAR 4 0 FKAIV
PIOIV Date for intercompany billing CHAR 2 0 PIOIV
FKDIV Billing Date for Intercompany Billing DATS 8 0 FKDIV
KUNIV Customer number for intercompany billing CHAR 10 0 KUNIV
KKBER Credit control area CHAR 4 0 KKBER
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNKLI
GRUPP Customer Credit Group CHAR 4 0 GRUPP_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 SBGRP_CM
CTLPC Credit Management: Risk Category CHAR 3 0 CTLPC_CM
CMWAE Currency key of credit control area CUKY 5 0 WAERS_CM
AMTBL Released credit value of the document CURR 15 2 AMTBL_CM
BOLNR Bill of Lading CHAR 35 0 BOLNR
LIFNR Vendor's account number CHAR 10 0 ELIFN
TRATY Means-of-Transport Type CHAR 4 0 TRATY
TRAID Means of Transport ID CHAR 20 0 TRAID
CMFRE Release date of the document determined by credit management DATS 8 0 CMFRE
CMNGV Next date DATS 8 0 CMNGV
XABLN Goods Receipt/Issue Slip Number CHAR 10 0 XABLN
BLDAT Document Date in Document DATS 8 0 BLDAT
WADAT_IST Actual Goods Movement Date DATS 8 0 WADAT_IST
TRSPG Shipment Blocking Reason CHAR 2 0 TRSPG
TPSID ID for External Transport System CHAR 5 0 TPSID
LIFEX External Identification of Delivery Note CHAR 35 0 LIFEX
TERNR Order Number CHAR 12 0 AUFNR
KALSM_CH Search Procedure for Batch Determination CHAR 6 0 KALSMA_CH
KLIEF Correction delivery CHAR 1 0 KLIEF
KALSP Shipping: Pricing procedure CHAR 6 0 KALSP
KNUMP Number of document condition - pricing CHAR 10 0 KNUMP
NETWR Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
AULWE Route Schedule CHAR 10 0 AULWE
WERKS Receiving Plant for Deliveries CHAR 4 0 EMPFW
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
ABSSC Payment Guarantee Procedure CHAR 6 0 ABSSCHE_CM
KOUHR Picking Time (Local Time, with Reference to a Plant) TIMS 6 0 KOUHR
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TIMS 6 0 TDUHR
LDUHR Loading Time (Local Time Relating to a Shipping Point) TIMS 6 0 LDUHR
WAUHR Time of Goods Issue (Local, Relating to a Plant) TIMS 6 0 WAUHR
LGTOR Door for Warehouse Number CHAR 3 0 LGTOR
LGBZO Staging Area for Warehouse Complex CHAR 10 0 LGBZO
AKWAE Currency key for letter-of-credit procg in foreign trade CUKY 5 0 AKWAE
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
AKPRZ Depreciation percentage for financial document processing DEC 5 2 AKPRZ
PROLI Dangerous Goods Management Profile in SD Documents CHAR 3 0 ADGE_PROLI
XBLNR Reference Document Number CHAR 25 0 XBLNR_LIKP
HANDLE Worldwide unique key for LIKP-VBELN CHAR 22 0 TSEGGUID_LIKP
TSEGFL Time segment exists CHAR 1 0 TSEGEXISTS
TSEGTP Event group time segment delivery header CHAR 10 0 TSEGTPLLIK
TZONIS Time zone of delivering location CHAR 6 0 TSEGZONISS
TZONRC Time zone of recipient location CHAR 6 0 TSEGZONREC
CONT_DG Indicator: Document contains dangerous goods CHAR 1 0 ADGE_NCDG
VERURSYS Distribution delivery: Original system CHAR 10 0 VERURSYS
KZWAB Indicator for controlling goods movement CHAR 1 0 KZWAB
Standard goods movement before Release 4.0C
D Goods movement in the decentralized system
I Goods movement in the integrated system
VLSTK Distribution Status (Decentralized Warehouse Processing) CHAR 1 0 VLSTK
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
TCODE Transaction Code CHAR 20 0 TCODE
VSART Shipping Type CHAR 2 0 VSARTTR
TRMTYP Means of Transport CHAR 18 0 TRMTYP18
SDABW Special Processing Indicator CHAR 4 0 SDABW
VBUND Company ID CHAR 6 0 VBUND
XWOFF Calculation of val. open CHAR 1 0 XWOFF
DIRTA Automatic TO Creation Immediately After TR Generation CHAR 1 0 LVS_DIRTA
PRVBE Production Supply Area CHAR 10 0 PRVBE
FOLAR Delivery Type CHAR 4 0 LFART
PODAT Date (Proof of Delivery) DATS 8 0 PODAT
POTIM Confirmation Time TIMS 6 0 POTIM
VGANZ Number of Delivery Items with Precedessor in Other System INT4 10 0 SHP_VGANZ
IMWRK Delivery has Status 'In Plant' CHAR 1 0 IMWRK
SPE_LOEKZ Document deletion indicator CHAR 1 0 LOEKZ_BK
SPE_LOC_SEQ Sequence of Intermediate Locations in Returns Process CHAR 3 0 /SPE/RET_LOC_SEQ_D
SPE_ACC_APP_STS Delivery Confirmation Status CHAR 1 0 /SPE/RET_ACC_APP_STS
No Confirmation Expected
A Confirmation Expected via ICH Portal w/o Error Publ.
B Confirmation Expected via Dealer EDI system w/o Error Publ.
C Confirmation Received
D Confirmation Expected via ICH Portal with Error Publ.
E Confirmation Expected via EDI system with Error Publ.
SPE_SHP_INF_STS Shipment Information Status CHAR 1 0 /SPE/RET_SHP_INF_STS
No Shipment Information Expected
A Shipment Information Expected
C Shipment Information Received
SPE_RET_CANC Returns: Flag showing that an ASN is cancelled CHAR 1 0 /SPE/RET_CANC
SPE_WAUHR_IST Time of Goods Issue (Local, Relating to a Plant) TIMS 6 0 WAUHR
SPE_WAZONE_IST Time Zone CHAR 6 0 TZNZONE
SPE_REV_VLSTK Distribution Status (Decentralized Warehouse Processing) CHAR 1 0 VLSTK
Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
SPE_LE_SCENARIO Scenario Logistic Execution CHAR 1 0 /SPE/LE_SCENARIO
Normal
1 Maintenance Delivery
2 ICSL (Intercompany Sales Process)
3 ICST (Intercompany Stock Transfer)
4 SFSV (Sell from Stock with VSIT)
A Transportation Cross-Docking
B Production Supply Delivery
C CRM Order as Predecessor for Unchecked Delivery
D POD (Proof of Delivery) - Correction Delivery
E ID Handling
F Production Consumption Delivery
G Repetitive Manufacturing
H Kanban Replenishment
I Additional Item Discrepancy
J Goods Receipt for Production/Process Orders
K Kit-to-Stock Delivery (Out- and Inbound)
L Advanced Returns Delivery
M Posting Change Request
N Follow-Up (Scrapping or Putaway)
O Counter Returns Delivery
P Posting Change for Repair Order
Q Send Back to Customer
R CRM Complaint as Predecessor for Returns Delivery
S STO (Stock Transfer Order)
T TPOP (Third Party Order Processing)
U Replenishment Delivery with Add. Items
V Direct Delivery to Another Plant
W Direct Delivery to an External Customer
X Delivery for unplanned GM with reference to PP order
Y Returns Delivery not to be distributed to EWM
SPE_ORIG_SYS Original System Type CHAR 1 0 /SPE/INB_ORIGIN_SYS
SPE_CHNG_SYS Last Changer's System Type CHAR 1 0 /SPE/INB_CHNG_SYS
SPE_GEOROUTE Description of a Geographical Route CHAR 10 0 /SPE/DE_ROUTE_ID
SPE_GEOROUTEIND Change Indicator for the Route CHAR 1 0 /SPE/DE_ROUTE_IND
Route Not Yet Determined
C Route Determined by System
M Route Predefined Manually
SPE_CARRIER_IND Change Indicator for the Carrier CHAR 1 0 /SPE/DE_CARRIER_IND
SPE_GTS_REL Goods Traffic Type CHAR 2 0 /SPE/DE_LEG_GTS_CODE
SPE_GTS_RT_CDE Route Code for SAP Global Trade Services CHAR 10 0 /SPE/DE_ROUTE_GTS_CODE
SPE_REL_TMSTMP Release Time Stamp DEC 15 0 /SPE/DE_RELEASE_TMSTMP
SPE_UNIT_SYSTEM Measurement Unit System CHAR 10 0 /SPE/DE_UNIT_SYSTEM
SPE_INV_BFR_GI Invoice Creation Before Goods Issue CHAR 1 0 /SPE/INV_BFR_GI
Not allowed
A Not Allowed Except for Export Processes
B Route Dependent
C Mandatory
D Allowed But not Mandatory
SPE_QI_STATUS Status of Quality Inspection for Returns Deliveries CHAR 1 0 /SPE/RET_QI_STATUS
Not Relevant for Quality Inspection
A Relevant for Quality Inspection
B Quality Inspection Started
C Quality Inspection Completed
SPE_RED_IND SPE indicator if redirecting has occured CHAR 1 0 /SPE/RED_IND
No redirecting has occured
1 Redirecting started in ERP
SAKES SAP Global Trade Services: Storage Status of Delivery CHAR 1 0 GTS_SAKES
Not Relevant
A Relevant
B Delivery is in Storage
C Storage is Completed
D Temporary Storage Was Completed Manually
SPE_LIFEX_TYPE Type of External Identification CHAR 1 0 /SPE/DE_LIFEX_TYPE
SPE_TTYPE Means of Transport CHAR 10 0 /SPE/TTYPE
INCOV Incoterms Version CHAR 4 0 INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
TRMTYP_LONG Means of Transport CHAR 40 0 TRMTYP40
VBTYP_LONG SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)