SAP table LIKP (SD Document: Delivery Header Data)

SAP table LIKP 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 T000 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 T171 BZIRK
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
VKORG Sales Organization CHAR 4 0 TVKO VKORG
LFART Delivery Type CHAR 4 0 TVLK 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 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
EXPKZ Export indicator CHAR 1 0 EXPKZ
ROUTE Route CHAR 6 0 TVRO ROUTE
FAKSK Billing Block in SD Document CHAR 2 0 TVFS FAKSK
LIFSK Delivery Block (Document Header) CHAR 2 0 TVLS LIFSK
VBTYP 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)
KNFAK Customer Factory Calendar CHAR 2 0 TFACD 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 TPRIO LPRIO
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
KUNNR Ship-to Party CHAR 10 0 KNA1 KUNWE
KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
KDGRP Customer Group CHAR 2 0 T151 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 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 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 TVLG GRULG
LSTEL Loading Point CHAR 2 0 TVLA LSTEL
TRAGR Transportation Group CHAR 4 0 TTGR TRAGR
FKARV Proposed billing type for a delivery-related billing doc. CHAR 4 0 TVFK FKARV
FKDAT Billing Date DATS 8 0 FKDAT
PERFK Invoice Dates (Calendar Identification) CHAR 2 0 TFACD PERFK
ROUTA Route CHAR 6 0 TVRO ROUTE
STAFO Update Group for statistics update CHAR 6 0 STAFO
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 T683 KALSM_D
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
VKBUR Sales office CHAR 4 0 TVBUR 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 TQCOM COMMN
STWAE Statistics Currency CUKY 5 0 TCURC 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 T300 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 TVKO VKOIV
VTWIV Distribution channel for intercompany billing CHAR 2 0 TVTW VTWIV
SPAIV Division for intercompany billing CHAR 2 0 TSPA SPAIV
FKAIV Billing type for intercompany billing CHAR 4 0 TVFK FKAIV
PIOIV Date for intercompany billing CHAR 2 0 TFACD PIOIV
FKDIV Billing Date for Intercompany Billing DATS 8 0 FKDIV
KUNIV Customer number for intercompany billing CHAR 10 0 KNA1 KUNIV
KKBER Credit control area CHAR 4 0 T014 KKBER
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
GRUPP Customer Credit Group CHAR 4 0 GRUPP_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 T024B SBGRP_CM
CTLPC Credit Management: Risk Category CHAR 3 0 T691A CTLPC_CM
CMWAE Currency key of credit control area CUKY 5 0 TCURC 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 TVTY 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 TTSG TRSPG
TPSID ID for External Transport System CHAR 5 0 TQCOM TPSID
LIFEX External Identification of Delivery Note CHAR 35 0 LIFEX
TERNR Order Number CHAR 12 0 AUFK AUFNR
KALSM_CH Search Procedure for Batch Determination CHAR 6 0 T683 KALSMA_CH
KLIEF Correction delivery CHAR 1 0 KLIEF
KALSP Shipping: Pricing procedure CHAR 6 0 T683 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 VALW AULWE
WERKS Receiving Plant for Deliveries CHAR 4 0 T001W EMPFW
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
ABSSC Payment Guarantee Procedure CHAR 6 0 T691M 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 T30B LGTOR
LGBZO Staging Area for Warehouse Complex CHAR 10 0 T30C LGBZO
AKWAE Currency key for letter-of-credit procg in foreign trade CUKY 5 0 TCURC 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 TDGC5 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
TCODE Transaction Code CHAR 20 0 TCODE
VSART Shipping Type CHAR 2 0 T173 VSARTTR
TRMTYP Means of Transport CHAR 40 0 MARA TRMTYP
SDABW Special Processing Indicator CHAR 4 0 TVSAK 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
SPE_PRO_NUMBER Partner Identification : Progressive Identification Number CHAR 35 0 /SPE/PRO_NUMBER
LOC_GUID Akkreditiv (GUID) RAW 16 0 LOC_GUID16
SPE_BILLING_IND EWM Billing Indicator CHAR 1 0 /SPE/DE_BILLING_IND
No Invoice Before Goods Issue
A Direct Billing (Immediately Billing and Printing)
B Wait for Billing Request
PRINTER_PROFILE Description of Print Profile CHAR 10 0 DRUCK_PROFIL_ID
MSR_ACTIVE Advanced Returns Management Active CHAR 1 0 MSR_ACTIVE
Adv. Returns Is Not Active
X Adv. Returns Is Active
PRTNR Confirmation number NUMC 10 0 PRTNR
STGE_LOC_CHANGE Temporary Change of Storage Locations in Delivery CHAR 1 0 SHP_STGE_LOC_CHANGE
No Storage Location Change
A Storage Location Change Requested
B Storage Location Change Reversed
TM_CTRL_KEY Control Key for Document Transfer to TM CHAR 4 0 TM_CTRL_KEY
DLV_SPLIT_INITIA Delivery Split Initiator CHAR 1 0 DLV_SPLIT_INITIATOR
Last Save was not triggered by a Delivery Split
1 Delivery Split was triggered by Dialog Transaction VLSP
2 Delivery Split was triggered by EWM
3 Delivery Split was triggered by a Service Call
DLV_VERSION Delivery Version NUMC 4 0 DLV_VERSION
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
GTS_VORPA Type of Previous Document CHAR 10 0 VORPA
GTS_VORNU Number of Previous Document CHAR 25 0 VORNU
GTS_EXPVZ Mode of Transport at the Border (Intrastat) CHAR 1 0 EXPVZ
GTS_PORTI Port/Airport CHAR 4 0 /ECRS/PORTI
ITM_EXPVZ Mode of Transport at the Border CHAR 2 0 TVTR /SAPSLL/EXPVZ
ITM_STGBE Origin of Means of Transport when Crossing the Border CHAR 3 0 T005 STGBE
ITM_KZGBE Identifier for Means of Transport crossing the Border CHAR 30 0 KZGBE
ITM_VYGID Cross-Border Conveyance Reference ID CHAR 35 0 /SAPSLL/VYGID
ITM_IEVER Inland Mode of Transport CHAR 2 0 TVTR /SAPSLL/IEVER
ITM_STABE Country of Origin of the Means of Transport at Departure CHAR 3 0 T005 STABE
ITM_KZABE Identification for the Means of Transport Inland CHAR 30 0 KZABE
HANDOVERLOC Location for a physical handover of goods CHAR 10 0 HANDOVER_LOC
HANDOVERDATE Handover Date at the Handover Location DATS 8 0 HANDOVER_DATE
HANDOVERTIME Handover time at the handover location TIMS 6 0 HANDOVER_TIME
HANDOVERTZONE Time Zone of Handover Location CHAR 6 0 * HANDOVER_TIMEZONE
BESTK Delivery Confirmation Status (All Items) CHAR 1 0 BESTK
CMPSC Status of Credit Check Against Maximum Document Value CHAR 1 0 CMPSC
CMPSD Status of Credit Check Against Terms of Payment CHAR 1 0 CMPSD
CMPSI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPSJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
CMPSK Status of Credit Check Against Payment Card Authorization CHAR 1 0 CMPSK
CMPS_CM Status of Credit Check SAP Credit Management CHAR 1 0 CMPS_CM
CMPS_TE Status of Technical Error SAP Credit Management CHAR 1 0 CMPS_TE
CMGST Overall Status of Credit Checks CHAR 1 0 CMGST
Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
FKIVK Intercompany Billing Status (All Items) CHAR 1 0 FKIVK
FKSTK Delivery-Related Billing Status (All Items) CHAR 1 0 FKSTK
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
HDALL Inbound delivery header not yet complete (on Hold) CHAR 1 0 /SPE/INB_HDALL
HDALS At least one of ID items not yet complete (on Hold) CHAR 1 0 /SPE/INB_HDALS
KOQUK Status of Pick Confirmation CHAR 1 0 KOQUK
KOSTK Picking Status/Putaway Status (All Items) CHAR 1 0 KOSTK
LVSTK Status of Warehouse Management Activities (All Items) CHAR 1 0 LVSTK
PDSTK POD Status on Header Level CHAR 1 0 PDSTK
PKSTK Packing Status (All Items) CHAR 1 0 PKSTK
SPE_TMPID Temporary inbound delivery CHAR 1 0 /SPE/TMPID
Real (non temporary) delivery
1 Temp.ID is waiting for acknowledgement for changing ID
2 Temp.ID is waiting for acknowledgement for deleting ID
3 Temp.ID is waiting for acknowledgement for purging ID
4 Temp.ID is waiting for ackn. to delete caused by redirecting
SPSTG Overall Block Status (Header) CHAR 1 0 SPSTG
TRSTA Transportation Planning Status (Header) CHAR 1 0 TRSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
UVALL Incompletion Status (Header) CHAR 1 0 UVALL_UK
UVALS Incompletion Status (All Items) CHAR 1 0 UVALL_SU
UVFAK Billing Incompletion Status (Header) CHAR 1 0 UVFAK_UK
UVFAS Billing Incompletion Status (All Items) CHAR 1 0 UVFAK_SU
UVPAK Packing Incompletion Status (Header) CHAR 1 0 UVPAK_UK
UVPAS Packing Incompletion Status (All Items) CHAR 1 0 UVPAK_SU
UVPIK Picking/Putaway Incompletion Status (Header) CHAR 1 0 UVPIK_UK
UVPIS Picking/Putaway Incompletion Status (All Items) CHAR 1 0 UVPIK_SU
UVVLK Delivery Incompletion Status (Header) CHAR 1 0 UVVLK_UK
UVVLS Delivery Incompletion Status (All Items) CHAR 1 0 UVVLS_SU
UVWAK Goods Movement Incompletion Status (Header) CHAR 1 0 UVWAK_UK
UVWAS Goods Movement Incompletion Status (All Items) CHAR 1 0 UVWAK_SU
VESTK Handling Unit Placed in Stock CHAR 1 0 VESTK
No shipping unit put away in WM for delivery
X At least one shipping unit put away in WM for delivery
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
WBSTK Goods Movement Status (All Items) CHAR 1 0 WBSTK
UVK01 Customer reserves 1: Header status CHAR 1 0 UVK01
UVK02 Customer reserves 2: Header status CHAR 1 0 UVK02
UVK03 Customer reserves 3: Header status CHAR 1 0 UVK03
UVK04 Custmer reserves 4: Header status CHAR 1 0 UVK04
UVK05 Customer reserves 5: Header status CHAR 1 0 UVK05
UVS01 Customer reserves 1: Sum of all items CHAR 1 0 UVS01
UVS02 Customer reserves 2: Sum of all items CHAR 1 0 UVS02
UVS03 Customer reserves 3: Sum of all items CHAR 1 0 UVS03
UVS04 Customer reserves 4: Sum of all items CHAR 1 0 UVS04
UVS05 Customer reserves 5: Sum of all items CHAR 1 0 UVS05
TOTAL_PCSTA Total Product Marketability Check Status CHAR 1 0 TDD_TOTAL_PCSTA_LE
TOTAL_DGSTA Total Dangerous Goods Check Status CHAR 1 0 TDD_TOTAL_DGSTA_LE
TOTAL_SDSSTA Total Safety Data Sheet Check Status CHAR 1 0 TDD_TOTAL_SDSSTA_LE
TOTAL_ARC_STATUS Excise Tax Total ARC Status (on Delivery Header Level) CHAR 1 0 ET_TOTAL_ARC_STATUS
ICO_FKIVK Intercompany Billing Status (All Items) CHAR 1 0 ICO_FKIVK
TOTAL_EMCST Embargo Status (All Items) CHAR 1 0 TDD_TOTAL_EMCST
TOTAL_SLCST Screening Status (All Items) CHAR 1 0 TDD_TOTAL_SLCST
TOTAL_LCCST Legal Control Status CHAR 1 0 TDD_TOTAL_LCCST
/SAPMP/LBASK DTUC Status CHAR 1 0 /SAPMP/LBASTAT
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_KEY Incoterm Location 1 - Place of Destination RAW 16 0 /SCMTMS/INC_LOC_1_KEY
INCO3_KEY Incoterm Location 2 - Place of Delivery RAW 16 0 /SCMTMS/INC_LOC_2_KEY
INCO4_KEY Incoterm - Deviating Place of Destination RAW 16 0 /SCMTMS/INC_DEV_PLACE_DEST_KEY
OID_EXTBOL External bill of lading CHAR 16 0 OID_EXTBOL
OID_MISCDL Miscellaneous delivery number CHAR 16 0 OID_MISCDL
EXT_BUS_SYST_ID External Business System ID CHAR 60 0 SD_EXT_BUS_SYST_ID
SITKZ_DB Specification for Issuing Valuated Stock in Transit CHAR 1 0 SITKZ
1 GI from Issuing Valuated SiT to Receiving Valuated SiT
2 GI from Issuing Valuated SiT to Receiving Plant
3 SO-Related GI from Issuing Valuated Stock in Transit
C Correction posting for issuing stock in transit
I Goods Receipt for Inbound Delivery from Receiving Val. SiT
N Not Relevant
R GI for return outbound delivery to Receiving Valuated SiT
X GI from Issuing Plant to Receiving Valuated Stock in Transit
TM_ADV_SHIP_RECV Advanced Shipping and Receiving Relevance CHAR 1 0 /SCMTMS/ADV_SHP_RECV_RLV
Not Relevant
1 Relevant for Advanced Shipping and Receiving
TM_WHSE_EXEC Warehouse Execution Status CHAR 1 0 LE_TM_WHSE_EXEC
Not Relevant
1 Delivery is blocked for Warehouse Execution
2 Delivery is released for Warehouse Execution
3 Delivery is in Warehouse Processing
4 Delivery is ready for Shipping
TM_WHSE_BLOCK Warehouse Execution Block CHAR 2 0 LE_TM_WHSE_BLOCK
Not blocked
10 In Transportation Planning
20 Not GTS compliant
LGLC_LIC_IND Legal Control License Indicator CHAR 1 0 TDD_LGLC_LIC_IND
CORR_IND Quantity Correction After Goods Receipt in Advanced SR CHAR 1 0 LE_TM_CORR_IND
No Quantity Correction
X Quantity Correction
DUMMY_DELIVERY_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
/BEV1/LULEINH Loading Units NUMC 8 0 /BEV1/LULEINH
/BEV1/RPFAESS Number Category 1 DEC 7 0 /BEV1/RPFAESSER
/BEV1/RPKIST Number Category 2 DEC 7 0 /BEV1/RPKISTEN
/BEV1/RPCONT Number Category 3 DEC 7 0 /BEV1/RPONTAIN
/BEV1/RPSONST Number Category 4 DEC 7 0 /BEV1/RPSONST
/BEV1/RPFLGNR Loading Sequence Number in the Tour NUMC 5 0 /DSD/RP_SEQUENCENR
IDT_CUR_EVTLOC Last Notified Point of the Route from Tracking CHAR 10 0 * IDT_CUR_EVTLOC
IDT_CUR_EVTQUA Indicates Arrival or Departure at the Current Point CHAR 1 0 IDT_CUR_EVTQUA
IDT_CUR_EVTTST Event Time Stamp for the Tracking Message at Current Point DEC 15 0 IDT_CUR_EVTTST
IDT_CUR_ESTLOC Base Point for Time Estimation from Tracking CHAR 10 0 * IDT_CUR_ESTLOC
IDT_CUR_ESTQUA Arrival/Departure for Time Estimation CHAR 1 0 IDT_CUR_ESTQUA
IDT_CUR_ESTTST Base Date for Estimation of the Delivery Date in Tracking DEC 15 0 IDT_CUR_ESTTST
IDT_CUR_WRKQUA Various Qualifiers of the Tracking Entry CHAR 10 0 IDT_CUR_WRKQUA
IDT_PRE_EVTLOC Prior Route Point From Tracking CHAR 10 0 * IDT_PRE_EVTLOC
IDT_PRE_EVTQUA Indicates the Arrival and Departure at Prior Point CHAR 1 0 IDT_PRE_EVTQUA
IDT_PRE_EVTTST Event Time Stamp for the Tracking Message at Prior Point DEC 15 0 IDT_PRE_EVTTST
IDT_PRE_ESTLOC Prior Base Point for Time Estimation from Tracking CHAR 10 0 * IDT_PRE_ESTLOC
IDT_PRE_ESTQUA Arrival/Departure for Time Estimation CHAR 1 0 IDT_PRE_ESTQUA
IDT_PRE_ESTTST Base Date for Estimation of the Delivery Date in Tracking DEC 15 0 IDT_PRE_ESTTST
IDT_PRE_WRKQUA Various Qualifiers of the Prior Tracking Entry CHAR 10 0 IDT_PRE_WRKQUA
IDT_REF_ESTLOC Reference Point for Time Estimation from Tracking CHAR 10 0 * IDT_REF_ESTLOC
IDT_REF_ESTQUA Indicates Arrival/Departure at the Reference Point CHAR 1 0 IDT_REF_ESTQUA
IDT_REF_ESTTST Base Date for Estimation of the Delivery Date in Tracking DEC 15 0 IDT_REF_ESTTST
IDT_FIRM_LFDAT Commitment Level of Delivery Date and Time CHAR 2 0 IDT_FIRM_LFDAT
IDT_DOCNUM IDoc number NUMC 16 0 EDI_DOCNUM
BORGR_GRP Inbound Dely Group: Multi-Level Goods Receipt Automotive CHAR 35 0 BORGR_GRP
KBNKZ Kanban Indicator CHAR 1 0 KBNKZ
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
Z Scheduling Agreement for JIT calls
FSH_TRANSACTION Transaction Number CHAR 10 0 FSH_TRANSACTION
FSH_VAS_LAST_ITEM Last VAS Item Number NUMC 5 0 FSH_VAS_LAST_ITEM
FSH_VAS_CG Value-Added Services Customer Group CHAR 3 0 FSH_VAS_CG_D
RFM_PSST_GROUP PSST Group CHAR 10 0 RFM_PSST_GROUP_ID
EXT_ACT_DATE_TOCD External Actual Transfer of Control Date DEC 15 0 EXT_ACT_DATE_TOCD
EXT_PLAN_DATE_TOCD External Planned Transfer of Control Date DEC 15 0 EXT_PLAN_DATE_TOCD
EXT_TZONE_TOCD Time zone for external Transfer of Control Date CHAR 6 0 * EXT_TZONE_TOCD
INT_ACT_DATE_TOCD Internal Actual Transfer of Control Date DEC 15 0 INT_ACT_DATE_TOCD
INT_PLAN_DATE_TOCD Internal Planned Transfer of Control Date DEC 15 0 INT_PLAN_DATE_TOCD
INT_TZONE_TOCD Time zone for internal Transfer of Control Date CHAR 6 0 * INT_TZONE_TOCD
JIT_RLVNT JIT-Relevant CHAR 1 0 NJIT_RELVNT

LIKP foreign key relationships

Table Field Check Table Check Field
0 LIKP ABSSC T691M Payment guarantee procedure MANDT
0 LIKP ABSSC T691M Payment guarantee procedure ABSSC
1 LIKP AKWAE TCURC Currency Codes MANDT
1 LIKP AKWAE TCURC Currency Codes WAERS
0 LIKP AULWE VALW Delivery Plan: Definition of Route Schedule MANDT
0 LIKP AULWE VALW Delivery Plan: Definition of Route Schedule AULWE
1 LIKP BZIRK T171 Customers: Sales Districts MANDT
1 LIKP BZIRK T171 Customers: Sales Districts BZIRK
0 LIKP CMWAE TCURC Currency Codes MANDT
0 LIKP CMWAE TCURC Currency Codes WAERS
1 LIKP CTLPC T691A Credit management risk categories CTLPC
1 LIKP CTLPC T691A Credit management risk categories KKBER
0 LIKP FAKSK TVFS Billing: Reasons for Blocking FAKSP
1 LIKP FKAIV TVFK Billing: Document Types MANDT
1 LIKP FKAIV TVFK Billing: Document Types FKART
0 LIKP FKARV TVFK Billing: Document Types MANDT
0 LIKP FKARV TVFK Billing: Document Types FKART
1 LIKP GEWEI T006 Units of Measurement MANDT
1 LIKP GEWEI T006 Units of Measurement MSEHI
0 LIKP GRULG TVLG Routes: Weight Groups for Deliveries GRULG
1 LIKP INCO1 TINC Customers: Incoterms INCO1
0 LIKP INCOV TINCV Incoterms Versions MANDT
0 LIKP INCOV TINCV Incoterms Versions INCOV
1 LIKP ITM_EXPVZ TVTR Routes: Modes of Transport MANDT
1 LIKP ITM_EXPVZ TVTR Routes: Modes of Transport VKTRA
0 LIKP ITM_IEVER TVTR Routes: Modes of Transport MANDT
0 LIKP ITM_IEVER TVTR Routes: Modes of Transport VKTRA
1 LIKP ITM_STABE T005 Countries MANDT
1 LIKP ITM_STABE T005 Countries LAND1
0 LIKP ITM_STGBE T005 Countries MANDT
0 LIKP ITM_STGBE T005 Countries LAND1
1 LIKP KALSM T683 Pricing procedures KAPPL
1 LIKP KALSM T683 Pricing procedures KALSM
0 LIKP KALSM_CH T683 Pricing procedures KAPPL
0 LIKP KALSM_CH T683 Pricing procedures KALSM
1 LIKP KALSP T683 Pricing procedures KAPPL
1 LIKP KALSP T683 Pricing procedures KALSM
0 LIKP KDGRP T151 Customers: Customer Groups MANDT
0 LIKP KDGRP T151 Customers: Customer Groups KDGRP
1 LIKP KKBER T014 Credit control areas KKBER
0 LIKP KNKLI KNA1 General Data in Customer Master MANDT
0 LIKP KNKLI KNA1 General Data in Customer Master KUNNR
1 LIKP KUNAG KNA1 General Data in Customer Master MANDT
1 LIKP KUNAG KNA1 General Data in Customer Master KUNNR
0 LIKP KUNIV KNA1 General Data in Customer Master MANDT
0 LIKP KUNIV KNA1 General Data in Customer Master KUNNR
1 LIKP KUNNR KNA1 General Data in Customer Master MANDT
1 LIKP KUNNR KNA1 General Data in Customer Master KUNNR
0 LIKP LFART TVLK Delivery Types MANDT
0 LIKP LFART TVLK Delivery Types LFART
1 LIKP LGBZO T30C WM Materials Staging Zones MANDT
1 LIKP LGBZO T30C WM Materials Staging Zones LGNUM
1 LIKP LGBZO T30C WM Materials Staging Zones LGBZO
0 LIKP LGNUM T300 WM Warehouse Numbers MANDT
0 LIKP LGNUM T300 WM Warehouse Numbers LGNUM
1 LIKP LGTOR T30B WM Gates MANDT
1 LIKP LGTOR T30B WM Gates LGNUM
1 LIKP LGTOR T30B WM Gates LGTOR
0 LIKP LIFSK TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 LIKP LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 LIKP LPRIO TPRIO Customers: Delivery Priorities LPRIO
0 LIKP MANDT T000 Clients MANDT
1 LIKP PROLI TDGC5 DG: Dangerous Goods Management Profile for SD Documents MANDT
1 LIKP PROLI TDGC5 DG: Dangerous Goods Management Profile for SD Documents PROLI
0 LIKP ROUTA TVRO Routes MANDT
0 LIKP ROUTA TVRO Routes ROUTE
1 LIKP ROUTE TVRO Routes MANDT
1 LIKP ROUTE TVRO Routes ROUTE
0 LIKP SBGRP T024B Credit management: Credit representative groups MANDT
0 LIKP SBGRP T024B Credit management: Credit representative groups KKBER
1 LIKP SDABW TVSAK Special Processing Indicator SDABW
0 LIKP SPAIV TSPA Organizational Unit: Sales Divisions MANDT
0 LIKP SPAIV TSPA Organizational Unit: Sales Divisions SPART
1 LIKP STWAE TCURC Currency Codes MANDT
1 LIKP STWAE TCURC Currency Codes WAERS
0 LIKP TERNR AUFK Order master data AUFNR
1 LIKP TRAGR TTGR Delivery Scheduling: Transportation Groups TRAGR
0 LIKP TRATY TVTY Packaging Material Types MANDT
0 LIKP TRATY TVTY Packaging Material Types TRATY
1 LIKP TRMTYP MARA General Material Data MANDT
1 LIKP TRMTYP MARA General Material Data MATNR
0 LIKP TRSPG TTSG Shipment Blocking Reason MANDT
1 LIKP VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 LIKP VKOIV TVKO Organizational Unit: Sales Organizations MANDT
0 LIKP VKOIV TVKO Organizational Unit: Sales Organizations VKORG
1 LIKP VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 LIKP VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 LIKP VOLEH T006 Units of Measurement MANDT
0 LIKP VOLEH T006 Units of Measurement MSEHI
1 LIKP VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 LIKP VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 LIKP VSBED TVSB Shipping Conditions MANDT
0 LIKP VSBED TVSB Shipping Conditions VSBED
1 LIKP VSTEL TVST Organizational Unit: Shipping Points MANDT
1 LIKP VSTEL TVST Organizational Unit: Shipping Points VSTEL
0 LIKP VTWIV TVTW Organizational Unit: Distribution Channels MANDT
0 LIKP VTWIV TVTW Organizational Unit: Distribution Channels VTWEG
1 LIKP WAERK TCURC Currency Codes MANDT
1 LIKP WAERK TCURC Currency Codes WAERS
0 LIKP WERKS T001W Plants/Branches MANDT
0 LIKP WERKS T001W Plants/Branches WERKS