JKPA SAP (Sales Order: Partner) Table details

Dictionary Type: Table
Description: Sales Order: Partner




ABAP Code to SELECT data from JKPA
Related tables to JKPA
Access table JKPA




Table field list including key, data, relationships and ABAP select examples

JKPA is a standard SAP Table which is used to store Sales Order: Partner data and is available within R/3 SAP systems depending on the version and release level.

The JKPA table consists of various fields, each holding specific information or linking keys about Sales Order: Partner data available in SAP. These include VBELN (IS-M/SD: Publishing Sales Order), POSNR (Sales Order Item), JPARVW (IS-M: Business Partner Role), PARZA (IS-M: Partner Role Counter).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP JKPA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10JKAKALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6JKAPAPNR
JPARVWIS-M: Business Partner Role JPARVWCHAR2TJG39PARVWJPARVWJGR
PARZAIS-M: Partner Role Counter JPARZANUMC3JPARZA
GUELTIGVONDate from Which Partner Data in Sales Order is Valid JKPAVONDATS8DATUM
GUELTIGBISDate to Which Partner Data in Sales Order is Valid JKPABISDATS8DATUM
GPNRIS-M: Business Partner Key GPNRCHAR10JGTGPNRALPHAGPNRJGPMJG0
VERSERVGESIS-M: Service Company VERSERVGESCHAR10JGTVSGALPHAGPNRJGFMJG0G
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PARNRNumber of contact person PARNRNUMC10PARNRVPA
ADRNRIS-M: Address Number JADRNRCHAR10JGTSADRALPHAJADRNR
ADRESSVARIS-M: Address Variant ADRESSVARCHAR1ERSTADR
HERKIS-M: Use of Address HERKCHAR1HERK
PLZ_ORDERIS-M: Postal Code PLZ_ISPCHAR10PSTLZ
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
BEABLSTIS-M: Unloading Point BEABLSTCHAR10JRTBEABSTALPHABEABLSTBASMJV2
BANKSBank country key BANKSCHAR3T005LAND1BKL
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKNBank account number BANKNCHAR18BANKN
BKONTBank Control Key BKONTCHAR2BKONT
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
XEZERIndicator: Is there collection authorization ? XEZERCHAR1XFELD
ZLSCHIS-M: Payment Method JZLSCHCHAR1T042ZZLSCH
KREISG_SCHIS-M: District municipality key of ship-to party KGS_ORDERCHAR15Assigned to domainALPHAKREISG_SCH

Key field Non-key field



How do I retrieve data from SAP table JKPA using ABAP code

The following ABAP code Example will allow you to do a basic selection on JKPA to SELECT all data from the table
DATA: WA_JKPA TYPE JKPA.

SELECT SINGLE *
FROM JKPA
INTO CORRESPONDING FIELDS OF WA_JKPA
WHERE...

How to access SAP table JKPA

Within an ECC or HANA version of SAP you can also view further information about JKPA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!