SAP VFKP Shipment Costs: Item Data Table
Overview
VFKP is a standard SAP S/4HANA table that stores Shipment Costs: Item Data data. There are total 64 fields in the VFKP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VFKP belongs to Freight Processing (LE-TRA-FC) module and is located in the package Shipment costs (VTRA).
In addition, following links provide an overview of foreign key relationships, if any, that link VFKP to other SAP tables and standard CDS views available based on VFKP table in S/4HANA 2020.
Techincal Settings of VFKP
Below are technical details of the table VFKP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VFKP Fields
The following table gives you an overview of the fields available in VFKP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| FKNUM | Shipment Cost Number | FKNUM | VFKK | CHAR | 10 |
| FKPOS | Shipment costs item | FKPOS | NUMC | 6 | |
| FKPTY | Item category shipment costs | FKPTY | TVFT | CHAR | 4 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| NETWR | Net value in currency of shipment cost item | NETWR_P | CURR | 15 | |
| MWSBP | Tax amount in currency of shipment cost item | MWSBP_P | CURR | 13 | |
| WAERS | Currency of the Shipment Cost Item | WAERS_P | TCURC | CUKY | 5 |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| PRSDT | Pricing date | PRSDT_P | DATS | 8 | |
| BUDAT | Settlement date | BUDAT_P | DATS | 8 | |
| EXTI1 | External identification 1 Item | EXTI1_P | CHAR | 20 | |
| EXTI2 | External identification 2 Item | EXTI2_P | CHAR | 20 | |
| TPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 |
| VSART | Shipping type for shipment stage | VERSARTS | T173 | CHAR | 2 |
| KALSM | Pricing Procedure in Pricing | KALSMASD | T683 | CHAR | 6 |
| KNUMV | Number of the Document Condition | KNUMV | CHAR | 10 | |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | BKGRP | T024 | CHAR | 3 |
| EBELN | Purchasing Document Number | EBELN | * | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | * | NUMC | 5 |
| LBLNI | Entry Sheet Number | LBLNI | * | CHAR | 10 |
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 |
| TDLNR | Number of service agent | TDLNR_P | LFA1 | CHAR | 10 |
| RECHS | Invoicing party for shipment cost item | RECHST | LFA1 | CHAR | 10 |
| KURST | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| KOSTY | Cost type (shipment cost item) | KOSTY | CHAR | 1 | |
| REFTY | SD Document Category | VBTYPL | CHAR | 4 | |
| REBEL | Referenced document | REBEL | CHAR | 10 | |
| REPOS | Referenced document item | REPOS_P | NUMC | 6 | |
| POSTX | Description for reference | POSTX | CHAR | 40 | |
| KNTTP | Account Assignment Category | KNTTP | T163K | CHAR | 1 |
| BKLAS | Valuation Class | BWKLL | T025 | CHAR | 4 |
| STBER | Status of calculation (shipment costs item data) | STBER_P | CHAR | 1 | |
| DTBER | Date of calculation | DTBER | DATS | 8 | |
| UZBER | Time of calculation | UZBER | TIMS | 6 | |
| STFRE | Status of account determination | STFRE_P | CHAR | 1 | |
| DTFRE | Date of account determination | DTFRE | DATS | 8 | |
| UZFRE | Time of account assignment | UZFRE | TIMS | 6 | |
| STABR | Status of transfer (shipment costs item data) | STABR_P | CHAR | 1 | |
| DTABR | Date of settlement | DTABR_T | DATS | 8 | |
| UZABR | Time of settlement | UZABR | TIMS | 6 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZET | Time last change was made | AEZET | TIMS | 6 | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 |
| KSTAU | Cost distribution CO | KSTAU | CHAR | 1 | |
| TRFZNA | Tariff zone of point of departure | TRFZNA | TVFTZ | CHAR | 10 |
| TRFZNZ | Tariff zone of point of destination | TRFZNZ | TVFTZ | CHAR | 10 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| BASWR | Tax base amount | BASWR_P | CURR | 15 | |
| SLAND1_A | Tax country departure | SLAND1_A | T005 | CHAR | 3 |
| SLAND1_Z | Tax country destination | SLAND1_Z | T005 | CHAR | 3 |
| FKSTO | Shipment cost item already cancelled | FKSTO_P | CHAR | 1 | |
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | |
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | |
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | |
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | |
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | |
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VFKP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VFKP | BKLAS | : | T025 |
| VFKP | BUKRS | 1: CN | T001 |
| VFKP | EKGRP | 1: CN | T024 |
| VFKP | EKORG | 1: N | T024E |
| VFKP | FKNUM | 1: CN | VFKK |
| VFKP | FKPTY | 1: CN | TVFT |
| VFKP | KALSM | C: CN | T683 |
| VFKP | KNTTP | : | T163K |
| VFKP | KURST | C: CN | TCURV |
| VFKP | LOGSYS | : | TBDLS |
| VFKP | MANDT | 1: CN | T000 |
| VFKP | MWSKZ | : | T007A |
| VFKP | PARVW | 1: CN | TPAR |
| VFKP | RECHS | 1: CN | LFA1 |
| VFKP | SLAND1_A | : | T005 |
| VFKP | SLAND1_Z | : | T005 |
| VFKP | TDLNR | 1: CN | LFA1 |
| VFKP | TPLST | C: CN | TTDS |
| VFKP | TRFZNA | : | TVFTZ |
| VFKP | TRFZNZ | : | TVFTZ |
| VFKP | VSART | C: CN | T173 |
| VFKP | WAERS | 1: CN | TCURC |
| VFKP | WERKS | 1: N | T001W |