SAP Table
TVFT Shipment Cost Item Categories
SAP table TVFT has 2 primary key fields being MANDT,FKPTY.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TVFT columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyFKPTY | 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 | ||||||||||
|
|||||||||||||||
| 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 | ||||||||||
|
|||||||||||||||
| ABREL | Relevant for settlement | CHAR | 1 | 0 | ABREL | ||||||||||
|
|||||||||||||||
| BESER | Purchase Order Generation | CHAR | 1 | 0 | BESER | ||||||||||
|
|||||||||||||||
/ Relationships
TVFT foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TVFT | DATAB | TVFTR | Rules for Date Determination for Shipment Costing | MANDT |
| TVFT | DATAB | TVFTR | Rules for Date Determination for Shipment Costing | TRULE |
| TVFT | DATPR | TVFTR | Rules for Date Determination for Shipment Costing | MANDT |
| TVFT | DATPR | TVFTR | Rules for Date Determination for Shipment Costing | TRULE |
| TVFT | FCGRP | TVFCG | Item Procedure Group for Shipment Costs | MANDT |
| TVFT | FCGRP | TVFCG | Item Procedure Group for Shipment Costs | FCGRP |
| TVFT | KNTTP | T163K | Account Assignment Categories in Purchasing Document | MANDT |
| TVFT | KNTTP | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
| TVFT | PARVW | TPAR | Business Partner: Functions | PARVW |