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
Possible values
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
Possible values
A
General ledger account
B
Sequence: Delivery, order
C
Sequence: Delivery, order, G/L account
ABREL
Relevant for settlement
CHAR
1
0
ABREL
Possible values
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
Possible values
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