Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table VTRLP

Delivery in Shipment: Item

VTRLP (Delivery in Shipment: Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VTRLP to other SAP tables.

VTRLP table fields

Field Data element Checktable Datatype Length Decimals Possible values
VBELN
Sales and Distribution Document Number
 VBELN
CHAR
 10 0
POSNR
Item number of the SD document
 POSNR VBUP
NUMC
 6 0
POSEX
Item Number of the Underlying Purchase Order
 POSEX
CHAR
 6 0
MATNR
Material Number
 MATNR MARA
CHAR
 18 0
MATWA
Material entered
 MATWA MARA
CHAR
 18 0
IDNKD
Material Number Used by Customer
 MATNR_KU
CHAR
 35 0
ARKTX
Short text for sales order item
 ARKTX
CHAR
 40 0
WERKS
Plant
 WERKS_D T001W
CHAR
 4 0
LGORT
Storage Location
 LGORT_D T001L
CHAR
 4 0
VTWEG
Distribution Channel
 VTWEG
CHAR
 2 0
SPART
Division
 SPART
CHAR
 2 0
VKBUR
Sales Office
 VKBUR
CHAR
 4 0
CHARG
Batch Number
 CHARG_D
CHAR
 10 0
SERNR
BOM explosion number
 SERNR
CHAR
 8 0
HERKL
Country of origin of the material
 HERKL T005
CHAR
 3 0
HERKR
Region of origin of material (non-preferential origin)
 HERKR
CHAR
 3 0
STAWN
Commodity Code/Import Code Number for Foreign Trade
 STAWN
CHAR
 17 0
BRGEW
Gross weight
 BRGEW_15
QUAN
 15 3
NTGEW
Net weight
 NTGEW_15
QUAN
 15 3
GEWEI
Weight Unit
 GEWEI T006
UNIT
 3 0
LFIMG
Actual quantity delivered (in sales units)
 LFIMG
QUAN
 13 3
VRKME
Sales unit
 VRKME T006
UNIT
 3 0
MBDAT
Material Staging/Availability Date
 MBDAT
DATS
 8 0
VBELN_VAUF
Order
 VBELN_VAUF VBUK
CHAR
 10 0
POSNR_VAUF
Sales Document Item
 POSNR_VA VBUP
NUMC
 6 0
AUDAT_VAUF
Sales order date
 AUDAT_VAUF
DATS
 8 0
BSTDK
Customer purchase order date
 BSTDK
DATS
 8 0
BSTNK
Customer purchase order number
 BSTNK
CHAR
 20 0
BSTZD
Purchase order number supplement
 BSTZD
CHAR
 4 0
IHREZ
Your Reference
 IHREZ
CHAR
 12 0
INCO1
Incoterms (Part 1)
 INCO1 TINC
CHAR
 3 0
INCO2
Incoterms (Part 2)
 INCO2
CHAR
 28 0
INCO1_BEZ
Incoterm description
 INCO1_BEZ
CHAR
 30 0
TDNAME
Name
 TDOBNAME
CHAR
 70 0
UEPOS
Higher-level item in bill of material structures
 UEPOS
NUMC
 6 0
VOLUM
Volume
 VOLUM_15
QUAN
 15 3
VOLEH
Volume unit
 VOLEH
UNIT
 3 0
EAN11
International Article Number (EAN/UPC)
 EAN11
CHAR
 18 0
EXART
Business Transaction Type for Foreign Trade
 EXART
CHAR
 2 0
EXART_BEZ
Description
 BEZEI20
CHAR
 20 0
GRWRT
Statistical value for foreign trade
 GRWRT
CURR
 13 2
VGBEL
Document number of the reference document
 VGBEL
CHAR
 10 0
VGPOS
Item number of the reference item
 VGPOS
NUMC
 6 0
VGTYP
Activity or element category
 VGTYP
CHAR
 3 0
SORTKRI
Sort Criterion
 SORTKRI
CHAR
 20 0
LGMNG
Actual quantity delivered in stockkeeping units
 LGMNG
QUAN
 13 3
KCMENG
Cumulative batch quantity of all split items (in StckUnit)
 KCMENG
QUAN
 15 3
MEINS
Base Unit of Measure
 MEINS
UNIT
 3 0
UECHA
Higher-Level Item of Batch Split Item
 UECHA
NUMC
 6 0
KCBRGEW
Cumulative gross weight of all batch split items
 KCBRGEW
QUAN
 15 3
KCNTGEW
Cumulative net weight of all batch split items
 KCNTGEW
QUAN
 15 3
KCGEWEI
Weight unit for weight of all batch split items
 KCGEWEI
UNIT
 3 0
KCVOLUM
Cumulative volume of all batch split items
 KCVOLUM
QUAN
 15 3
KCVOLEH
Volume Unit for Volume of all Batch Split Items
 KCVOLEH
UNIT
 3 0
KNUMH_CH
Number of condition record from batch determination
 KNUMH_CH
CHAR
 10 0
UMVKZ
Numerator (factor) for conversion of sales quantity into SKU
 UMVKZ
DEC
 5 0
UMVKN
Denominator (Divisor) for Conversion of Sales Qty into SKU
 UMVKN
DEC
 5 0
CUOBJ
Configuration
 CUOBJ_VA
NUMC
 18 0
CUOBJ_CH
Internal object number of the batch classification
 CUOBJ_CH
NUMC
 18 0
SHKZG
Returns Item
 SHKZG_VA
CHAR
 1 0
PCKPF
Packing control
 PCKPF
CHAR
 1 0
ABRVW
Usage Indicator
 ABRVW
CHAR
 3 0
ABART
Release type
 ABART
CHAR
 1 0
ABRLI
Internal delivery schedule number
 ABRLI
NUMC
 4 0
AESKD
Customer Engineering Change Status
 AESKD
CHAR
 17 0
EMPST
Receiving point
 EMPST
CHAR
 25 0
ABTNR
Department number
 ABTNR
CHAR
 4 0
POSAR
Item type
 POSAR
CHAR
 1 0
PSTYV
Delivery item category
 PSTYV_VL TVLP
CHAR
 4 0
TPREL
Indicator: Relevance for transport of deliv. item categories
 TPREL
CHAR
 1 0
KZWI1
Subtotal 1 from pricing procedure for condition
 KZWI1
CURR
 13 2
KPEIN
Condition pricing unit
 KPEIN
DEC
 5 0
KMEIN
Condition unit
 KMEIN
UNIT
 3 0
NETPR
Net price
 NETPR
CURR
 11 2
NETWR
Net Value in Document Currency
 NETWR
CURR
 15 2
ANZSN
Number of serial numbers
 ANZSN
INT4
 10 0
AKTNR
Promotion
 WAKTION
CHAR
 10 0
SUGRD
Reason for material substitution
 SUGRD
CHAR
 4 0
SUDRU
Original entry will be printed
 SUDRU
CHAR
 1 0
VBRST
Customer point of consumption
 VBRST
CHAR
 14 0
USR01_VBLB
Additional data field 1 for delivery schedules
 USR01_D
CHAR
 35 0
USR02_VBLB
Additional data field 2 for delivery schedules
 USR02_D
CHAR
 35 0
USR03_VBLB
Additional data field 3 for delivery schedules
 USR03_D
CHAR
 35 0
USR04_VBLB
Additional data field 4 for delivery schedules
 USR04_D
CHAR
 10 0
USR05_VBLB
Additional data field 5 for delivery schedules
 USR05_D
CHAR
 10 0
PREFE
Preference indicator in export/import
 PREFE
CHAR
 1 0
LABNK
Customer number for forecast / JIT dlv. sched.
 LABNK
CHAR
 17 0
ABRDT
Delivery Schedule Date
 ABRDT
DATS
 8 0
KZUMW
Environmentally Relevant
 KZUMW
CHAR
 1 0
PROFL
Dangerous Goods Indicator Profile
 ADGE_PROFL
CHAR
 3 0
IDGPA
Relevant for Dangerous Goods Documents
 ADGE_IDGPA
CHAR
 1 0
IDGCH
Relevant for Dangerous Goods Checks
 ADGE_IDGCH
CHAR
 1 0
DGNTGEW
Dangerous goods - net weight
 ADGE_NTGEW
QUAN
 15 3
DGBRGEW
Dangerous Goods - Gross Weight
 ADGE_BRGEW
QUAN
 15 3
DGGEWEI
Weight Unit
 GEWEI
UNIT
 3 0
DGVOLUM
Dangerous goods - volume
 ADGE_VOLUM
QUAN
 15 3
DGVOLEH
Volume unit
 VOLEH
UNIT
 3 0
DGARAND
Exemption
 ADGE_KARN
CHAR
 1 0
DGREPQU
Indicator: Reportable quantity
 ADGE_IRQA
CHAR
 1 0
DGPULIM
Packed Under 450 l
 ADGE_IPUL
CHAR
 1 0
DGPAS
Listed Goods
 ADGE_PAS
CHAR
 1 0
DGMDDAT
Selection date dangerous goods master data
 ADGE_MDDAT
DATS
 8 0
BSTKD
Customer purchase order number
 BSTKD
CHAR
 35 0
BSARK
Customer purchase order type
 BSARK
CHAR
 4 0
BSTKD_E
Ship-to Party's Purchase Order Number
 BSTKD_E
CHAR
 35 0
BSTDK_E
Ship-to party's PO date
 BSTDK_E
DATS
 8 0
BSARK_E
Ship-to party purchase order type
 BSARK_E
CHAR
 4 0
IHREZ_E
Ship-to party character
 IHREZ_E
CHAR
 12 0
POSEX_E
Item Number of the Underlying Purchase Order
 POSEX_E
CHAR
 6 0
VBKLT
SD document indicator
 VBKLT
CHAR
 1 0
MATKL
Material Group
 MATKL
CHAR
 9 0
MTART
Material Type
 MTART
CHAR
 4 0
PRODH
Product hierarchy
 PRODH_D
CHAR
 18 0
QMNUM
Notification No
 QMNUM
CHAR
 12 0
QMDAT
Date of Notification
 QMDAT
DATS
 8 0
MSR_ID
Process Identification Number
 MSR_PROCESS_ID
CHAR
 10 0
MSR_ITEM
Item Number
 MSR_PROCESS_ITEM
NUMC
 6 0
RMA_CUSTOMER
Customer RMA Number
 MSR_CRMA_NR
CHAR
 20 0
MSR_RET_REASON
Return Reason
 MSR_RETURNS_REASON
CHAR
 3 0
MSR_RET_REASON_TEXT
Return Reason Description
 MSR_RET_REASON_TEXT
CHAR
 60 0
MSR_MAT_RECEIVED
Material Received
 MSR_MATERIAL_RECEIVED
CHAR
 1 0
MSR_FU_CODE
Follow-Up Activity Code
 MSR_FU_CODE
CHAR
 4 0
MSR_FU_CODE_TEXT
Follow-Up Activity Description
 MSR_FU_CODE_TEXT
CHAR
 60 0
MSR_FORW_VENDOR
Account Number of Vendor or Creditor
 LIFNR
CHAR
 10 0
MSR_FWV_TITLE
Form-of-Address Key
 AD_TITLE
CHAR
 4 0
MSR_FWV_ADDRNUM
Address number
 AD_ADDRNUM
CHAR
 10 0
MSR_FWV_NAME1
Name 1
 AD_NAME1
CHAR
 40 0
MSR_FWV_NAME2
Name 2
 AD_NAME2
CHAR
 40 0
MSR_FWV_NAME3
Name 3
 AD_NAME3
CHAR
 40 0
MSR_FWV_NAME4
Name 4
 AD_NAME4
CHAR
 40 0
MSR_FWV_STREET
Street
 AD_STREET
CHAR
 60 0
MSR_FWV_PO_BOX
PO Box
 AD_POBX
CHAR
 10 0
MSR_FWV_PO_BOX_LOC
PO Box city
 AD_POBXLOC
CHAR
 40 0
MSR_FWV_CITY_CODE2
City PO box code (City file)
 AD_CIT2NUM
CHAR
 12 0
MSR_FWV_COUNTRY
Country Key
 LAND1
CHAR
 3 0
MSR_FWV_LANGU
Language Key
 SPRAS
LANG
 1 0
MSR_FWV_POST_CODE1
City postal code
 AD_PSTCD1
CHAR
 10 0
MSR_FWV_CITY1
City
 AD_CITY1
CHAR
 40 0
MSR_FWV_CITY2
District
 AD_CITY2
CHAR
 40 0
MSR_FWV_REGION
Region (State, Province, County)
 REGIO
CHAR
 3 0
RMA_VENDOR
Vendor RMA Number
 MSR_VRMA_NR
CHAR
 20 0
MSR_REFUND_CODE
Returns Refund Code
 MSR_RETURNS_REFUND_CODE
CHAR
 3 0
MSR_REFUND_CODE_TEXT
Refund Code Description
 MSR_REFUND_CODE_TEXT
CHAR
 60 0
MSR_FORW_PLANT1
Plant
 WERKS_D
CHAR
 4 0
MSR_PLANT1_TXT
Name
 NAME1
CHAR
 30 0
MSR_FORW_PLANT2
Plant
 WERKS_D
CHAR
 4 0
MSR_PLANT2_TXT
Name
 NAME1
CHAR
 30 0
MSR_FORW_PLANT3
Plant
 WERKS_D
CHAR
 4 0
MSR_PLANT3_TXT
Name
 NAME1
CHAR
 30 0
DUMMY
Dummy function in length 1
 DUMMY
CHAR
 1 0
/BEV1/EMMVGR1
Material group 1
 MVGR1
CHAR
 3 0
/BEV1/EMMVGR2
Material group 2
 MVGR2
CHAR
 3 0
/BEV1/EMMVGR3
Material group 3
 MVGR3
CHAR
 3 0
/BEV1/EMMVGR4
Material group 4
 MVGR4
CHAR
 3 0
/BEV1/EMMVGR5
Material group 5
 MVGR5
CHAR
 3 0
/BEV1/EMNEUPOS
Item number of the SD document
 POSNR
NUMC
 6 0
BWTAR
Valuation Type
 BWTAR_D
CHAR
 10 0
PROSA
ID for material determination
 PROSA
CHAR
 1 0
XCHAR
Batch management indicator (internal)
 XCHAR
CHAR
 1 0
BWART
Movement Type (Inventory Management)
 BWART
CHAR
 3 0
MFRGR
Material freight group
 MFRGR
CHAR
 8 0
GARVZ
Freight code set
 GARVZ TGAV
CHAR
 6 0
GTART
Freight code
 GTART TGAR
CHAR
 12 0
GTKLS
Freight class
 GTKLS
CHAR
 12 0
GSBER
Business Area
 GSBER TGSB
CHAR
 4 0
PAOBJNR
Profitability Segment Number (CO-PA)
 RKEOBJNR
NUMC
 10 0
PRCTR
Profit Center
 PRCTR
CHAR
 10 0
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
 PS_PSP_PNR
NUMC
 8 0
AUFNR
Order Number
 AUFNR AUFK
CHAR
 12 0
KZVBR
Consumption Posting
 KZVBR
CHAR
 1 0
KOSTL
Cost Center
 KOSTL CSKS
CHAR
 10 0
KOKRS
Controlling Area
 KOKRS TKA01
CHAR
 4 0
UEPVW
ID for higher-level item usage
 UEPVW
CHAR
 1 0
MAGRV
Material Group: Packaging Materials
 MAGRV
CHAR
 4 0
ERDAT
Date on Which Record Was Created
 ERDAT
DATS
 8 0
LADGR
Loading Group
 LADGR
CHAR
 4 0
TRAGR
Transportation Group
 TRAGR
CHAR
 4 0
FKREL
Relevant for Billing
 FKREL
CHAR
 1 0
KZFME
ID: Leading unit of measure for completing a transaction
 KZFME
CHAR
 1 0
KCMENGVME
Cumulative batch quantity of all split items in sales units
 KCMENG_VME
QUAN
 15 3
VBELV
Originating document
 VBELV
CHAR
 10 0
POSNV
Originating item
 POSNV
NUMC
 6 0
VBTYV
SD document category
 VBTYP
CHAR
 1 0
/CWM/LFIMG
Actual Delivered Quantity in Parallel Unit of Measure
 /CWM/LFIMG
QUAN
 13 3
/CWM/LFIME
CWM Delivery Unit of Measure
 /CWM/LFIME
UNIT
 3 0
OIGDOCTYP
SD document category
 VBTYP
CHAR
 1 0
OIGLD_ITM
TD-F Load/discharge quantity assignment item
 OIG_LDITM
NUMC
 4 0
OIGVEH_NR
Vehicle Sequence Number in Shipment
 OIG_VEHNR
NUMC
 3 0
OIGLDOCNUM
TD document number
 OIG_DOCNR
CHAR
 10 0
OIGLPOSNR
TD-F load-relevant document item number for assignment
 OIG_LITEM
NUMC
 6 0
OIGLDOCTYP
SD document category
 VBTYP
CHAR
 1 0
OIGKNOTL
TD-F - loading point
 OIG_KNOTL
CHAR
 10 0
OIGKNOTD
TD-F - discharge point
 OIG_KNOTD
CHAR
 10 0
OIGSHNUMBE
TD shipment number
 OIG_SHNUM
CHAR
 10 0
OIGMAT_ITM
TD material item sequence number
 OIG_MATITM
NUMC
 3 0
OIGVOLUMA
Volume of the item
 VOLUM_AP
QUAN
 15 3
OIGVOLEHA
Volume unit
 VOLEH T006
UNIT
 3 0
CMETH
Quantity Conversion Method
 OIB_CMETH
CHAR
 1 0
OIGLLIFNR
Vendor Account Number
 ELIFN
CHAR
 10 0
OIGLADRNR
Address
 ADRNR
CHAR
 10 0
OIGLADRDA_LF
Address indicator
 ADRDA
CHAR
 1 0
OIGLWERKS
Plant
 WERKS_D
CHAR
 4 0
OIGLLGORT
Storage Location
 LGORT_D
CHAR
 4 0
OIGLVSTEL
Shipping Point/Receiving Point
 VSTEL
CHAR
 4 0
OIGLLSTEL
Loading Point
 LSTEL
CHAR
 2 0
OIGLLGNUM
Warehouse Number / Warehouse Complex
 LGNUM
CHAR
 3 0
OIGLLGTOR
Door for Warehouse Number
 LGTOR
CHAR
 3 0

VTRLP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTRLP AUFNR SYST MANDT AUFK
Order master data
 MANDT
VTRLP AUFNR VTRLP AUFNR AUFK
Order master data
 AUFNR
VTRLP GARVZ VTRLP GARVZ TGAV
Freight Code Sets
 GARVZ
VTRLP GARVZ SY MANDT TGAV
Freight Code Sets
 MANDT
VTRLP GEWEI SYST MANDT T006
Units of Measurement
 MANDT
VTRLP GEWEI VTRLP GEWEI T006
Units of Measurement
 MSEHI
VTRLP GSBER SYST MANDT TGSB
Business Areas
 MANDT
VTRLP GSBER VTRLP GSBER TGSB
Business Areas
 GSBER
VTRLP GTART SY MANDT TGAR
Freight Codes
 MANDT
VTRLP GTART VTRLP GARVZ TGAR
Freight Codes
 GARVZ
VTRLP GTART VTRLP GTART TGAR
Freight Codes
 GTART
VTRLP HERKL VTRLP HERKL T005
Countries
 LAND1
VTRLP HERKL SYST MANDT T005
Countries
 MANDT
VTRLP INCO1 SYST MANDT TINC
Customers: Incoterms
 MANDT
VTRLP INCO1 VTRLP INCO1 TINC
Customers: Incoterms
 INCO1
VTRLP KOKRS SYST MANDT TKA01
Controlling Areas
 MANDT
VTRLP KOKRS VTRLP KOKRS TKA01
Controlling Areas
 KOKRS
VTRLP KOSTL SYST MANDT CSKS
Cost Center Master Data
 MANDT
VTRLP KOSTL VTRLP KOKRS CSKS
Cost Center Master Data
 KOKRS
VTRLP KOSTL VTRLP KOSTL CSKS
Cost Center Master Data
 KOSTL
VTRLP KOSTL VTRLP AUDAT_VAUF CSKS
Cost Center Master Data
 DATBI
VTRLP LGORT VTRLP WERKS T001L
Storage Locations
 WERKS
VTRLP LGORT VTRLP LGORT T001L
Storage Locations
 LGORT
VTRLP LGORT SYST MANDT T001L
Storage Locations
 MANDT
VTRLP MATNR SYST MANDT MARA
General Material Data
 MANDT
VTRLP MATNR VTRLP MATNR MARA
General Material Data
 MATNR
VTRLP MATWA SYST MANDT MARA
General Material Data
 MANDT
VTRLP MATWA VTRLP MATWA MARA
General Material Data
 MATNR
VTRLP OIGVOLEHA SY MANDT T006
Units of Measurement
 MANDT
VTRLP OIGVOLEHA VTRLP OIGVOLEHA T006
Units of Measurement
 MSEHI
VTRLP POSNR SYST MANDT VBUP
Sales Document: Item Status
 MANDT
VTRLP POSNR VBUK VBELN VBUP
Sales Document: Item Status
 VBELN
VTRLP POSNR VTRLP POSNR VBUP
Sales Document: Item Status
 POSNR
VTRLP POSNR_VAUF VTRLP POSNR_VAUF VBUP
Sales Document: Item Status
 POSNR
VTRLP POSNR_VAUF SYST MANDT VBUP
Sales Document: Item Status
 MANDT
VTRLP POSNR_VAUF VTRLP VBELN_VAUF VBUP
Sales Document: Item Status
 VBELN
VTRLP PSTYV SY MANDT TVLP
Deliveries: Item Categories
 MANDT
VTRLP PSTYV VTRLP PSTYV TVLP
Deliveries: Item Categories
 PSTYV
VTRLP VBELN_VAUF SYST MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
VTRLP VBELN_VAUF VTRLP VBELN_VAUF VBUK
Sales Document: Header Status and Administrative Data
 VBELN
VTRLP VRKME VTRLP VRKME T006
Units of Measurement
 MSEHI
VTRLP VRKME SYST MANDT T006
Units of Measurement
 MANDT
VTRLP WERKS SYST MANDT T001W
Plants/Branches
 MANDT
VTRLP WERKS VTRLP WERKS T001W
Plants/Branches
 WERKS