SAP Table JKPA
Sales Order: Partner
JKPA (Sales Order: Partner) 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 JKPA to other SAP tables.
JKPA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||
| VBELN | IS-M/SD: Publishing Sales Order | AVNR | JKAK | CHAR | 10 | 0 | ||||||||||||||||||||||
| POSNR | Sales Order Item | APNR | JKAP | NUMC | 6 | 0 | ||||||||||||||||||||||
| JPARVW | IS-M: Business Partner Role | JPARVW | TJG39 | CHAR | 2 | 0 | ||||||||||||||||||||||
| PARZA | IS-M: Partner Role Counter | JPARZA | NUMC | 3 | 0 | |||||||||||||||||||||||
| GUELTIGVON | Date from Which Partner Data in Sales Order is Valid | JKPAVON | DATS | 8 | 0 | |||||||||||||||||||||||
| GUELTIGBIS | Date to Which Partner Data in Sales Order is Valid | JKPABIS | DATS | 8 | 0 | |||||||||||||||||||||||
| GPNR | IS-M: Business Partner Key | GPNR | JGTGPNR | CHAR | 10 | 0 | ||||||||||||||||||||||
| VERSERVGES | IS-M: Service Company | VERSERVGES | JGTVSG | CHAR | 10 | 0 | ||||||||||||||||||||||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||||||||||||||||
| PARNR | Number of contact person | PARNR | NUMC | 10 | 0 | |||||||||||||||||||||||
| ADRNR | IS-M: Address Number | JADRNR | JGTSADR | CHAR | 10 | 0 | ||||||||||||||||||||||
| ADRESSVAR | IS-M: Address Variant | ADRESSVAR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| HERK | IS-M: Use of Address | HERK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| PLZ_ORDER | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | 0 | |||||||||||||||||||||||
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| BEABLST | IS-M: Unloading Point | BEABLST | JRTBEABST | CHAR | 10 | 0 | ||||||||||||||||||||||
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||
| BANKL | Bank Keys | BANKK | CHAR | 15 | 0 | |||||||||||||||||||||||
| BANKN | Bank account number | BANKN | CHAR | 18 | 0 | |||||||||||||||||||||||
| BKONT | Bank Control Key | BKONT | CHAR | 2 | 0 | |||||||||||||||||||||||
| BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | 0 | |||||||||||||||||||||||
| XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||
| ZLSCH | IS-M: Payment Method | JZLSCH | T042Z | CHAR | 1 | 0 | ||||||||||||||||||||||
| KREISG_SCH | IS-M: District municipality key of ship-to party | KGS_ORDER | CHAR | 15 | 0 | |||||||||||||||||||||||
JKPA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKPA | ADRNR | JKPA | ADRNR | JGTSADR | IS-M: Extended Address Management | ADRNR |
| JKPA | ADRNR | JKPA | MANDT | JGTSADR | IS-M: Extended Address Management | MANDT |
| JKPA | BANKS | JKPA | MANDT | T005 | Countries | MANDT |
| JKPA | BANKS | JKPA | BANKS | T005 | Countries | LAND1 |
| JKPA | BEABLST | JKPA | MANDT | JRTBEABST | IS-M/SD: Unloading Point | MANDT |
| JKPA | BEABLST | JKPA | BEABLST | JRTBEABST | IS-M/SD: Unloading Point | BEABLST |
| JKPA | GPNR | JKPA | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
| JKPA | GPNR | JKPA | GPNR | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
| JKPA | JPARVW | JKPA | MANDT | TJG39 | IS-M/SD: Business Partner Roles | MANDT |
| JKPA | JPARVW | JKPA | JPARVW | TJG39 | IS-M/SD: Business Partner Roles | JPARVW |
| JKPA | MANDT | JKPA | MANDT | T000 | Clients | MANDT |
| JKPA | POSNR | JKPA | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKPA | POSNR | JKPA | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKPA | POSNR | JKPA | POSNR | JKAP | Sales Order - Item Data | POSNR |
| JKPA | VBELN | JKPA | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKPA | VBELN | JKPA | VBELN | JKAK | Sales Order Header Data | VBELN |
| JKPA | VERSERVGES | JKPA | MANDT | JGTVSG | IS-M/SD: Service Companies | MANDT |
| JKPA | VERSERVGES | JKPA | VERSERVGES | JGTVSG | IS-M/SD: Service Companies | VERSERVGES |
| JKPA | ZLSCH | JKPA | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
| JKPA | ZLSCH | JKPA | BANKS | T042Z | Payment Methods for Automatic Payment | LAND1 |
| JKPA | ZLSCH | JKPA | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |
