SAP Table JKPAZ
Sales Order Item: Additional Planning Data
JKPAZ (Sales Order Item: Additional Planning Data) 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 JKPAZ to other SAP tables.
JKPAZ 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 | JKPA | CHAR | 2 | 0 | ||||||
| PARZA | IS-M: Partner Role Counter | JPARZA | NUMC | 3 | 0 | |||||||
| JKPAVON | Date from Which Partner Data in Sales Order is Valid | JKPAVON | DATS | 8 | 0 | |||||||
| GUELTIGVON | Valid From Date of Order-Del.Via.Assgmt for Sales Ord.Item | JKPAZVON | DATS | 8 | 0 | |||||||
| HOME_DEL_ELE | IS-M/SD: Home Delivery Alternation Element | HOME_DEL_ELE | CHAR | 8 | 0 | |||||||
| GUELTIGBIS | Valid To Date of Order-Deliv.Via.Assgmt for Sales Ord.Item | JKPAZBIS | DATS | 8 | 0 | |||||||
| BEZIRK | Carrier Route | BEZIRK | JVTBEZIRK | CHAR | 10 | 0 | ||||||
| GEOEIN | Number of Geographical Unit | GEOEIN | JSTGEOEINH | CHAR | 10 | 0 | ||||||
| LIEFERART | Delivery Type | LIEFERART | TJV01 | CHAR | 2 | 0 | ||||||
| LIEFBARNR | Sequence number for delivery/home delivery viability set | LIEFBARNR | JVTLIEFBAR | CHAR | 9 | 0 | ||||||
| HOME_DEL_GROUP | IS-M/SD: Home Delivery Alternation Group | HOME_DEL_GROUP | CHAR | 10 | 0 | |||||||
| XMAIN_ELE | IS-M/SD: Main Element in Home Delivery Alternation Group | XMAIN_ELE | CHAR | 1 | 0 |
Possible values
|
||||||
| X_MONTAG_HD | IS-M: Monday | X_MONTAG | CHAR | 1 | 0 |
Possible values
|
||||||
| X_DIENSTAG_HD | IS-M: Tuesday | X_DIENSTAG | CHAR | 1 | 0 |
Possible values
|
||||||
| X_MITTWOCH_HD | IS-M: Wednesday | X_MITTWOCH | CHAR | 1 | 0 |
Possible values
|
||||||
| X_DONNETAG_HD | IS-M: Thursday | X_DONNETAG | CHAR | 1 | 0 |
Possible values
|
||||||
| X_FREITAG_HD | IS-M: Friday | X_FREITAG | CHAR | 1 | 0 |
Possible values
|
||||||
| X_SAMSTAG_HD | IS-M: Saturday | X_SAMSTAG | CHAR | 1 | 0 |
Possible values
|
||||||
| X_SONNTAG_HD | IS-M: Sunday | X_SONNTAG | CHAR | 1 | 0 |
Possible values
|
||||||
| XDISPO | Indicator: relevant to planning | XDISPO | CHAR | 1 | 0 |
Possible values
|
||||||
JKPAZ foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKPAZ | BEZIRK | JKPAZ | BEZIRK | JVTBEZIRK | IS-M: Carrier Route (Generalization) | BEZIRK |
| JKPAZ | BEZIRK | JKPAZ | MANDT | JVTBEZIRK | IS-M: Carrier Route (Generalization) | MANDT |
| JKPAZ | GEOEIN | JKPAZ | MANDT | JSTGEOEINH | IS-M/SD: Geographical Unit | MANDT |
| JKPAZ | GEOEIN | JKPAZ | GEOEIN | JSTGEOEINH | IS-M/SD: Geographical Unit | GEOEIN |
| JKPAZ | JPARVW | JKPAZ | JPARVW | JKPA | Sales Order: Partner | JPARVW |
| JKPAZ | JPARVW | JKPAZ | PARZA | JKPA | Sales Order: Partner | PARZA |
| JKPAZ | JPARVW | JKPAZ | JKPAVON | JKPA | Sales Order: Partner | GUELTIGVON |
| JKPAZ | JPARVW | JKPAZ | MANDT | JKPA | Sales Order: Partner | MANDT |
| JKPAZ | JPARVW | JKPAZ | VBELN | JKPA | Sales Order: Partner | VBELN |
| JKPAZ | JPARVW | JKPAZ | POSNR | JKPA | Sales Order: Partner | POSNR |
| JKPAZ | LIEFBARNR | JKPAZ | MANDT | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | MANDT |
| JKPAZ | LIEFBARNR | JKPAZ | LIEFBARNR | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | LIEFBARNR |
| JKPAZ | LIEFERART | JKPAZ | LIEFERART | TJV01 | Delivery type for issue | LIEFERART |
| JKPAZ | LIEFERART | JKPAZ | MANDT | TJV01 | Delivery type for issue | MANDT |
| JKPAZ | MANDT | JKPAZ | MANDT | T000 | Clients | MANDT |
| JKPAZ | POSNR | JKPAZ | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKPAZ | POSNR | JKPAZ | POSNR | JKAP | Sales Order - Item Data | POSNR |
| JKPAZ | POSNR | JKPAZ | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKPAZ | VBELN | JKPAZ | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKPAZ | VBELN | JKPAZ | VBELN | JKAK | Sales Order Header Data | VBELN |
