SAP Table EKPA
Partner Roles in Purchasing
EKPA (Partner Roles in Purchasing) 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 EKPA to other SAP tables.
EKPA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 | 0 | ||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||
| LTSNR | Vendor Subrange | LTSNR | WYT1 | CHAR | 6 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 | 0 | ||||||
| PARZA | Partner counter | PARZA | NUMC | 3 | 0 | |||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||
| LIFN2 | Reference to other vendor | LIFN2 | LFA1 | CHAR | 10 | 0 | ||||||
| DEFPA | Default Partner | DEFPA | CHAR | 1 | 0 |
Possible values
|
||||||
| HITYP | Hierarchy category: vendor hierarchy | HITYP_LH | CHAR | 1 | 0 | |||||||
| PARNR | Number of contact person | PARNR | NUMC | 10 | 0 | |||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
| PRFRE | Indicator: "relev. to price determination (vend. hierarchy) | PRFRE_LH | CHAR | 1 | 0 |
Possible values
|
||||||
| BOLRE | Indicator: vendor subject to subseq. settlement accounting | BOLRE | CHAR | 1 | 0 |
Possible values
|
||||||
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | 0 | |||||||
EKPA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EKPA | EBELN | EKPA | MANDT | EKKO | Purchasing Document Header | MANDT |
| EKPA | EBELN | EKPA | EBELN | EKKO | Purchasing Document Header | EBELN |
| EKPA | EBELP | EKPA | EBELN | EKPO | Purchasing Document Item | EBELN |
| EKPA | EBELP | EKPA | EBELP | EKPO | Purchasing Document Item | EBELP |
| EKPA | EBELP | EKPA | MANDT | EKPO | Purchasing Document Item | MANDT |
| EKPA | EKORG | EKPA | MANDT | T024E | Purchasing Organizations | MANDT |
| EKPA | EKORG | EKPA | EKORG | T024E | Purchasing Organizations | EKORG |
| EKPA | LIFN2 | EKPA | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| EKPA | LIFN2 | EKPA | LIFN2 | LFA1 | Vendor Master (General Section) | LIFNR |
| EKPA | LTSNR | EKPA | MANDT | WYT1 | Vendor Subrange | MANDT |
| EKPA | LTSNR | EKPA | LIFN2 | WYT1 | Vendor Subrange | LIFNR |
| EKPA | LTSNR | EKPA | LTSNR | WYT1 | Vendor Subrange | LTSNR |
| EKPA | MANDT | EKPA | MANDT | T000 | Clients | MANDT |
| EKPA | PARVW | EKPA | MANDT | TPAR | Business Partner: Functions | MANDT |
| EKPA | PARVW | EKPA | PARVW | TPAR | Business Partner: Functions | PARVW |
| EKPA | WERKS | EKPA | MANDT | T001W | Plants/Branches | MANDT |
| EKPA | WERKS | EKPA | WERKS | T001W | Plants/Branches | WERKS |
