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 |