SAP table EKPA (Partner Roles in Purchasing)
SAP table EKPA has 8 primary key fields being MANDT,EBELN,EBELP,EKORG,LTSNR,WERKS,PARVW,PARZA.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| EBELN | Purchasing Document Number | CHAR | 10 | 0 | EKKO | EBELN | |
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EKPO | EBELP | |
| EKORG | Purchasing organization | CHAR | 4 | 0 | T024E | EKORG | |
| LTSNR | Supplier Subrange | CHAR | 6 | 0 | WYT1 | LTSNR | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| PARVW | Partner Function | CHAR | 2 | 0 | TPAR | PARVW | |
| PARZA | Partner counter | NUMC | 3 | 0 | PARZA | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| LIFN2 | Reference to other supplier | CHAR | 10 | 0 | LFA1 | LIFN2 | |
| DEFPA | Default Partner | CHAR | 1 | 0 | DEFPA | ||
| HITYP | Hierarchy Category: Supplier Hierarchy | CHAR | 1 | 0 | HITYP_LH | ||
| PARNR | Number of Contact Person | NUMC | 10 | 0 | PARNR | ||
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| PRFRE | Indicator: "relev. to price determination (vend. hierarchy) | CHAR | 1 | 0 | PRFRE_LH | ||
| BOLRE | Indicator: supplier subject to subseq. settlement accounting | CHAR | 1 | 0 | BOLRE | ||
| HISTUNR | Level number within hierarchy | NUMC | 2 | 0 | HISTUNR | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |
EKPA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EKPA | EBELN | EKKO | Purchasing Document Header | EBELN |
| 1 EKPA | EBELP | EKPO | Purchasing Document Item | MANDT |
| 1 EKPA | EBELP | EKPO | Purchasing Document Item | EBELN |
| 0 EKPA | EKORG | T024E | Purchasing Organizations | EKORG |
| 1 EKPA | LIFN2 | LFA1 | Supplier Master (General Section) | MANDT |
| 1 EKPA | LIFN2 | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 EKPA | LTSNR | WYT1 | Vendor Subrange | MANDT |
| 0 EKPA | LTSNR | WYT1 | Vendor Subrange | LIFNR |
| 0 EKPA | LTSNR | WYT1 | Vendor Subrange | LTSNR |
| 1 EKPA | MANDT | T000 | Clients | MANDT |
| 0 EKPA | PARVW | TPAR | Business Partner: Functions | PARVW |
| 1 EKPA | WERKS | T001W | Plants/Branches | WERKS |