SAP table TVFT (Shipment Cost Item Categories)

SAP table TVFT has 2 primary key fields being MANDT,FKPTY.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FKPTY Item category shipment costs CHAR 4 0 FKPTY
FCGRP Item determination procedure group CHAR 4 0 TVFCG FCGRP
PARVW Partner function for the transportation service agent CHAR 2 0 TPAR PARVW_P
KSTAU Cost distribution CO CHAR 1 0 KSTAU
A Shipment costs item
B Delivery
C Delivery item
DATPR Automatic proposal of pricing date CHAR 4 0 TVFTR DATPR_T
DATAB Automatic proposal of settlement date CHAR 4 0 TVFTR DATAB_T
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
HERCO Origin of CO assignments CHAR 1 0 HERCO
A General ledger account
B Sequence: Delivery, order
C Sequence: Delivery, order, G/L account
ABREL Relevant for settlement CHAR 1 0 ABREL
not relevant for settlement
A relevant for settlement (delivery costs)
X relevant for settlement (G/L account)
BESER Purchase Order Generation CHAR 1 0 BESER
Do not generate purchase order
A Generate purchase order for validity period of 1 day
B Generate purchase order for validity period of 1 week
C Generate purchase order for validity period of 1 month

TVFT foreign key relationships

Table Field Check Table Check Field
0 TVFT DATAB TVFTR Rules for Date Determination for Shipment Costing MANDT
0 TVFT DATAB TVFTR Rules for Date Determination for Shipment Costing TRULE
1 TVFT DATPR TVFTR Rules for Date Determination for Shipment Costing MANDT
1 TVFT DATPR TVFTR Rules for Date Determination for Shipment Costing TRULE
0 TVFT FCGRP TVFCG Item Procedure Group for Shipment Costs MANDT
0 TVFT FCGRP TVFCG Item Procedure Group for Shipment Costs FCGRP
1 TVFT KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 TVFT KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 TVFT PARVW TPAR Business Partner: Functions PARVW