SAP Table VFPA
Partner for Shipment Costs
VFPA (Partner for Shipment Costs) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VFPA to other SAP tables.
VFPA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | 0 | |||||||||||||||||||
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | 0 | |||||||||||||||||||
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 | 0 | ||||||||||||||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||||||||||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||||||||||||
| PARNR | Number of contact person | PARNR | NUMC | 10 | 0 | |||||||||||||||||||
| ADRNR | Address | ADRNR | CHAR | 10 | 0 | |||||||||||||||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||||||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||
| ADRDA | Address indicator | ADRDA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 | 0 | ||||||||||||||||||
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | 0 | |||||||||||||||||||
| KNREF | Customer description of partner (plant, storage location) | KNREF | CHAR | 30 | 0 | |||||||||||||||||||
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||||||||||||||
| HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | 0 | |||||||||||||||||||
VFPA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VFPA | HITYP | VFPA | MANDT | THIT | Customer Hierarchy Types | MANDT |
| VFPA | HITYP | VFPA | HITYP | THIT | Customer Hierarchy Types | HITYP |
| VFPA | KUNNR | VFPA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| VFPA | KUNNR | VFPA | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| VFPA | LAND1 | VFPA | LAND1 | T005 | Countries | LAND1 |
| VFPA | LAND1 | VFPA | MANDT | T005 | Countries | MANDT |
| VFPA | LIFNR | VFPA | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| VFPA | LIFNR | VFPA | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| VFPA | LZONE | VFPA | MANDT | TZONE | Customers: Regional zones | MANDT |
| VFPA | LZONE | VFPA | LAND1 | TZONE | Customers: Regional zones | LAND1 |
| VFPA | LZONE | VFPA | LZONE | TZONE | Customers: Regional zones | ZONE1 |
| VFPA | MANDT | VFPA | MANDT | T000 | Clients | MANDT |
| VFPA | PARVW | VFPA | MANDT | TPAR | Business Partner: Functions | MANDT |
| VFPA | PARVW | VFPA | PARVW | TPAR | Business Partner: Functions | PARVW |
