SAP VFSI Shipment Costs: Sub-item Data Table
Overview
VFSI is a standard SAP S/4HANA table that stores Shipment Costs: Sub-item Data data. There are total 28 fields in the VFSI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VFSI 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 VFSI to other SAP tables and standard CDS views available based on VFSI table in S/4HANA 2020.
Techincal Settings of VFSI
Below are technical details of the table VFSI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VFSI Fields
The following table gives you an overview of the fields available in VFSI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KNUMV | Number of the Document Condition | KNUMV | CHAR | 10 | |
| KPOSN | Shipment cost subitem | KPOSN_P | NUMC | 6 | |
| BERGL | Calculation Base | BERGL | CHAR | 1 | |
| VHART | Packaging Material Type | VHIART | TVTY | CHAR | 4 |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| POSNR | Item number of the SD document | POSNR | * | NUMC | 6 |
| NETWR | Net value of sub-item in currency of shipment cost item | NETWR_U | CURR | 15 | |
| MWSBP | Tax amount of sub-item in currency of shipment cost item | MWSBP_U | CURR | 13 | |
| NETPR | Net Price | NETPR | CURR | 11 | |
| 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 | |
| MPROK | Status manual price change | MPROK | CHAR | 1 | |
| KPEIN | Condition Pricing Unit | KPEIN | DEC | 5 | |
| KMEIN | Condition Unit | KMEIN | T006 | UNIT | 3 |
| UVPRS | Incomplete with respect to pricing | UVPRS | CHAR | 1 | |
| PRSOK | Pricing is OK | PRSOK | CHAR | 1 | |
| BASWR | Tax base amount | BASWR_P | CURR | 15 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | * | CHAR | 2 |
| GARVZ | Freight code set | GARVZ | TGAV | CHAR | 6 |
| GTART | Freight code | GTART | TGAR | CHAR | 12 |
| GTKLS | Freight class | GTKLS | CHAR | 12 | |
| ACTIV | Indicator: Subitem active | SCDSUBACT | CHAR | 1 |
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 VFSI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VFSI | GARVZ | : | TGAV |
| VFSI | GTART | : | TGAR |
| VFSI | KMEIN | C: CN | T006 |
| VFSI | MANDT | 1: CN | T000 |
| VFSI | VHART | C: CN | TVTY |