SAP VTPA Shipping Partner Table

Overview

VTPA is a standard SAP S/4HANA table that stores Shipping Partner data. There are total 20 fields in the VTPA table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VTPA belongs to Transportation (LE-TRA) module and is located in the package SD R/3 transport processing (VTR).

In addition, following links provide an overview of foreign key relationships, if any, that link VTPA to other SAP tables and standard CDS views available based on VTPA table in S/4HANA 2020.

Techincal Settings of VTPA

Below are technical details of the table VTPA

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VTPA Fields

The following table gives you an overview of the fields available in VTPA

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
VBELNSales and Distribution Document NumberVBELNCHAR10
POSNRItem number of the SD documentPOSNRNUMC6
PARVWPartner FunctionPARVWCHAR2
KUNNRCustomer NumberKUNNRCHAR10
LIFNRAccount Number of Vendor or CreditorLIFNRCHAR10
PERNRPersonnel NumberPERNR_DNUMC8
PARNRNumber of contact personPARNRNUMC10
ADRNRAddressADRNRCHAR10
ABLADUnloading PointABLADCHAR25
LAND1Country/Region KeyLAND1CHAR3
ADRDAAddress indicatorADRDACHAR1
XCPDKIndicator: Is the account a one-time account?XCPDKCHAR1
HITYPCustomer hierarchy typeHITYP_KHCHAR1
PRFRERelevant for price determination IDPRFRECHAR1
BOKREIndicator: Customer Is Rebate-RelevantBOKRECHAR1
HISTUNRLevel number within hierarchyHISTUNRNUMC2
KNREFCustomer description of partner (plant storage location)KNREFCHAR30
LZONETransportation zone to or from which the goods are deliveredLZONECHAR10
HZUORAssignment to HierarchyHZUORNUMC2

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTPA

Other References