1. Home
  2. Resources
  3. SAP Tables
  4. VTPA - Shipping Partner

SAP Table VTPA

Shipping Partner

VTPA (Shipping Partner) 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 VTPA to other SAP tables.

VTPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
PARVW Partner Function PARVW CHAR 2 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
PERNR Personnel Number PERNR_D NUMC 8 0
PARNR Number of contact person PARNR NUMC 10 0
ADRNR Address ADRNR CHAR 10 0
ABLAD Unloading Point ABLAD CHAR 25 0
LAND1 Country Key LAND1 CHAR 3 0
ADRDA Address indicator ADRDA CHAR 1 0
NULL No address exists
A Address from master data
B Address entered in document manually
C Address entered in document manually / dependent on 'B'
D ADRC address from master data
E ADRC address entered in document manually
F ADRC address entered in document manually / dep. on 'E' doc.
G Private address from master data
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
HITYP Customer hierarchy type HITYP_KH CHAR 1 0
PRFRE Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
BOKRE Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Yes
NULL No
HISTUNR Level number within hierarchy HISTUNR NUMC 2 0
KNREF Customer description of partner (plant, storage location) KNREF CHAR 30 0
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
HZUOR Assignment to Hierarchy HZUOR NUMC 2 0