SAP Table JKKD
Sales Order: Business Data
JKKD (Sales Order: Business 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 JKKD to other SAP tables.
JKKD 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 | ||||||||||||||||||||
| KONDA | Price group (customer) | KONDA | T188 | CHAR | 2 | 0 | ||||||||||||||||||||
| KDGRP | Customer group | KDGRP | T151 | CHAR | 2 | 0 | ||||||||||||||||||||
| PLTYP | Price list type | PLTYP | T189 | CHAR | 2 | 0 | ||||||||||||||||||||
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 | 0 | ||||||||||||||||||||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | 0 | |||||||||||||||||||||
| PERFK | Invoice dates (calendar identification) | PERFK | TJG61 | CHAR | 2 | 0 | ||||||||||||||||||||
| PERRL | Invoice list schedule (calendar identification) | PERRL | TJG61 | CHAR | 2 | 0 | ||||||||||||||||||||
| MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9 | 5 | |||||||||||||||||||||
| VALTG | Additional value days | VALTG | NUMC | 2 | 0 | |||||||||||||||||||||
| VALDT | Fixed value date | VALDT | DATS | 8 | 0 | |||||||||||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||||||||||
| KTGRD | Account assignment group for this customer | KTGRD | TVKT | CHAR | 2 | 0 | ||||||||||||||||||||
| KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9 | 5 | |||||||||||||||||||||
| STCUR | Exchange rate for statistics | STCUR | DEC | 9 | 5 | |||||||||||||||||||||
| FKPER | Billing Frequency | FKPER | TJK01 | CHAR | 2 | 0 | ||||||||||||||||||||
| ZAHLW | Billing method | JZAHLW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| PRBAS | Price Basis | PRBAS_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| PRBAS_VK | Price Basis for Shipping Costs | PRBAS_VK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XFKKOMP | Indicator: Perform Billing in Full for Billing Period | XFKKOMP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XFKENDE | Indicator: Billing at end of calculation | XFKENDE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FBUDA | Date on which services rendered | FBUDA | DATS | 8 | 0 | |||||||||||||||||||||
| POPER | Posting period | POPER | NUMC | 3 | 0 | |||||||||||||||||||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||||||||||||||||||||
| JUEBART | IS-M: Transfer Type | JUEBART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XRECHDRUCK | IS-M: Print Invoice | XRECHDRUCK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XFKRUECK | IS-M: Retroactive Billing of Period Already Billed | XFKRUECK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XSEPFKPOS | Separate billing document for order item | XSEPFKPOS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| XKINKASSO | IS-M: Payment by field collector | XKINKASSO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FKDATVSYST | 'Billed to' Date in Legacy System | FKDATVSYST | DATS | 8 | 0 | |||||||||||||||||||||
| XFAKT_ARC | Archived billing documents exist for order item | XFAKT_ARC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| RCODE | IS-M/SD: Rate Code | RATE_CODE | TJKRRC | CHAR | 4 | 0 | ||||||||||||||||||||
| XAUTO_REN | IS-M/SD: Customer Requests Automatic Renewal | XAUTO_REN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| STCEG_L | Tax Destination Country | LAND1TX | T005 | CHAR | 3 | 0 | ||||||||||||||||||||
| STBFREI | Type of Tax Exemption | JSTBFREI | TJFSB | CHAR | 2 | 0 | ||||||||||||||||||||
| XNORENEWAL | IS-M/SD: No Further Renewal Required | XNORENEWAL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | 0 | |||||||||||||||||||||
| XPAYMODE_FIX | IS-M/SD: Payment Arrangement in Order Fixed | XPAYMODE_FIX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| DUEDAY | IS-M/SD: Renewals, Due Day | DUEDAY | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||
| PRSANZP | IS-M: Number of Periods to Which Offer Refers | PRSANZP_OFFER | DEC | 8 | 0 | |||||||||||||||||||||
| MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | 0 | |||||||||||||||||||||
JKKD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKKD | FKPER | JKKD | MANDT | TJK01 | IS-M/SD: Billing Frequency | MANDT |
| JKKD | FKPER | JKKD | FKPER | TJK01 | IS-M/SD: Billing Frequency | FKPER |
| JKKD | INCO1 | JKKD | INCO1 | TINC | Customers: Incoterms | INCO1 |
| JKKD | INCO1 | JKKD | MANDT | TINC | Customers: Incoterms | MANDT |
| JKKD | KDGRP | JKKD | MANDT | T151 | Customers: Customer Groups | MANDT |
| JKKD | KDGRP | JKKD | KDGRP | T151 | Customers: Customer Groups | KDGRP |
| JKKD | KONDA | JKKD | MANDT | T188 | Conditions: Groups for Customer Classifications | MANDT |
| JKKD | KONDA | JKKD | KONDA | T188 | Conditions: Groups for Customer Classifications | KONDA |
| JKKD | KTGRD | JKKD | MANDT | TVKT | Customers: Account Assignment Groups | MANDT |
| JKKD | KTGRD | JKKD | KTGRD | TVKT | Customers: Account Assignment Groups | KTGRD |
| JKKD | MANDT | JKKD | MANDT | T000 | Clients | MANDT |
| JKKD | PERFK | JKKD | MANDT | TJG61 | IS-M/SD: Billing Calendar for BP | MANDT |
| JKKD | PERFK | JKKD | PERFK | TJG61 | IS-M/SD: Billing Calendar for BP | IDENT |
| JKKD | PERRL | JKKD | MANDT | TJG61 | IS-M/SD: Billing Calendar for BP | MANDT |
| JKKD | PERRL | JKKD | PERRL | TJG61 | IS-M/SD: Billing Calendar for BP | IDENT |
| JKKD | PLTYP | JKKD | MANDT | T189 | Conditions: Price List Categories | MANDT |
| JKKD | PLTYP | JKKD | PLTYP | T189 | Conditions: Price List Categories | PLTYP |
| JKKD | POSNR | JKKD | POSNR | JKAP | Sales Order - Item Data | POSNR |
| JKKD | POSNR | JKKD | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKKD | POSNR | JKKD | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKKD | RCODE | JKKD | MANDT | TJKRRC | IS-M/SD: Rate code | MANDT |
| JKKD | RCODE | JKKD | RCODE | TJKRRC | IS-M/SD: Rate code | RCODE |
| JKKD | STBFREI | JKKD | MANDT | TJFSB | IS-M/SD: Type of Tax Exemption | MANDT |
| JKKD | STBFREI | JKKD | STBFREI | TJFSB | IS-M/SD: Type of Tax Exemption | STBFREI |
| JKKD | STCEG_L | JKKD | MANDT | T005 | Countries | MANDT |
| JKKD | STCEG_L | JKKD | STCEG_L | T005 | Countries | LAND1 |
| JKKD | VBELN | JKKD | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKKD | VBELN | JKKD | VBELN | JKAK | Sales Order Header Data | VBELN |
