SAP VFPA Partner for Shipment Costs Table
Overview
VFPA is a standard SAP S/4HANA table that stores Partner for Shipment Costs data. There are total 20 fields in the VFPA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VFPA 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 VFPA to other SAP tables and standard CDS views available based on VFPA table in S/4HANA 2020.
Techincal Settings of VFPA
Below are technical details of the table VFPA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VFPA Fields
The following table gives you an overview of the fields available in VFPA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| POSNR | Item number of the SD document | POSNR | * | NUMC | 6 |
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| PARNR | Number of contact person | PARNR | NUMC | 10 | |
| ADRNR | Address | ADRNR | * | CHAR | 10 |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| ADRDA | Address indicator | ADRDA | CHAR | 1 | |
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | |
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 |
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | |
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | |
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | |
| KNREF | Customer description of partner (plant storage location) | KNREF | CHAR | 30 | |
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 |
| HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 |
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 VFPA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VFPA | HITYP | C: CN | THIT |
| VFPA | KUNNR | C: CN | KNA1 |
| VFPA | LAND1 | C: CN | T005 |
| VFPA | LIFNR | C: CN | LFA1 |
| VFPA | LZONE | : | TZONE |
| VFPA | MANDT | 1: CN | T000 |
| VFPA | PARVW | 1: CN | TPAR |