SAP Table TVFPTZ

Tariff Zone Assignment for Postal Code Area

TVFPTZ (Tariff Zone Assignment for Postal Code Area) 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 TVFPTZ to other SAP tables.

TVFPTZ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
TDLNR Number of forwarding agent TDLNR LFA1 CHAR 10 0
VSART Shipping type VERSART T173 CHAR 2 0
LAND1 Country Key LAND1 T005 CHAR 3 0
FPSTLZ Postal Code PSTLZ CHAR 10 0
TPSTLZ Postal Code PSTLZ CHAR 10 0
TRFZN Tariff zone for shipment costs TRFZN TVFTZ CHAR 10 0

TVFPTZ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVFPTZ LAND1 TVFPTZ MANDT T005 Countries MANDT
TVFPTZ LAND1 TVFPTZ LAND1 T005 Countries LAND1
TVFPTZ MANDT TVFPTZ MANDT T000 Clients MANDT
TVFPTZ TDLNR TVFPTZ MANDT LFA1 Vendor Master (General Section) MANDT
TVFPTZ TDLNR TVFPTZ TDLNR LFA1 Vendor Master (General Section) LIFNR
TVFPTZ TPLST TVFPTZ MANDT TTDS Organizational Unit: Transportation Scheduling Point MANDT
TVFPTZ TPLST TVFPTZ TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
TVFPTZ TRFZN TVFPTZ MANDT TVFTZ Tariff Zones for Shipment Costs MANDT
TVFPTZ TRFZN TVFPTZ TRFZN TVFTZ Tariff Zones for Shipment Costs TRFZN
TVFPTZ VSART TVFPTZ VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
TVFPTZ VSART TVFPTZ MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT