SAP Table VTTPVB

Shipment Item for Logging

VTTPVB (Shipment Item for Logging) 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 VTTPVB to other SAP tables.

VTTPVB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TKNUM Shipment Number TKNUM VTTK CHAR 10 0
TPNUM Shipment item TPNUM NUMC 4 0
VBELN Delivery VBELN_VL VBUK CHAR 10 0
TPRFO Itinerary of shipment items TPRFO NUMC 4 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
PKSTA There are Packed Deliveries Dependent on Shipping PKSTA_VTTP CHAR 1 0
X Yes
NULL No
KZHULFG Indicator: Delivery Items for HUs Generated KZHULFG CHAR 1 0
X Yes
NULL No
UPDKZ Update indicator UPDKZ_D CHAR 1 0
NAME1 Name 1 NAME1_GP CHAR 35 0
LAND1 Country Key LAND1 CHAR 3 0
ORT01 City ORT01_GP CHAR 35 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
LSTEL Loading Point LSTEL CHAR 2 0
KUNWE Ship-to party KUNWE CHAR 10 0
ABLAD Unloading Point ABLAD CHAR 25 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
WERKSBEZ Name NAME1 CHAR 30 0
LGOBE Description of Storage Location LGOBE CHAR 16 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KZLFETS IndIcator: First Shipment for a Delivery KZLFETS CHAR 1 0
X Yes
NULL No
OIGDOCTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
OIGPOSNR Item number of the SD document POSNR NUMC 6 0

VTTPVB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTTPVB MANDT VTTPVB MANDT T000 Clients MANDT
VTTPVB TKNUM VTTPVB MANDT VTTK Shipment Header MANDT
VTTPVB TKNUM VTTPVB TKNUM VTTK Shipment Header TKNUM
VTTPVB VBELN VTTPVB MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VTTPVB VBELN VTTPVB VBELN VBUK Sales Document: Header Status and Administrative Data VBELN