SAP Table JKEP
Sales Order: Schedule Line Data
JKEP (Sales Order: Schedule Line 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 JKEP to other SAP tables.
JKEP 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 | ||||||||
| ETENR | Sales Order Schedule Line | JAENR | NUMC | 4 | 0 | |||||||||
| GUELTIGVON | Date from Which Schedule Line in Sales Order is Valid | JKEPVON | DATS | 8 | 0 | |||||||||
| GUELTIGBIS | Date to Which Schedule Line in Sales Order is Valid | JKEPBIS | DATS | 8 | 0 | |||||||||
| ETEEX | IS-M: External Schedule Line Number | ETEEX_ISP | NUMC | 6 | 0 | |||||||||
| BEZPER | Service Type | BEZPER | TJD09 | CHAR | 5 | 0 | ||||||||
| ETART | Schedule Line Type for Internal Sales Order Schedule Line | ETART_ISP | TJEP | CHAR | 2 | 0 | ||||||||
| ZSKLS | Time slice classification for sales order | JZSKLS | CHAR | 1 | 0 |
Possible values
|
||||||||
| AEART | Order Change Type | AEART_JSDK | CHAR | 1 | 0 |
Possible values
|
||||||||
| XUREINT | Original schedule line in publishing sales order | XUREINT | CHAR | 1 | 0 |
Possible values
|
||||||||
| XTAGESBEZ | IS-M: Limited change relating to a specific date | XTAGESBEZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| ETENR_UR | Source Schedule Line | AENR_UR | JKEP | NUMC | 4 | 0 | ||||||||
| ETENR_VG | Preceding Schedule Line | AENR_VG | JKEP | NUMC | 4 | 0 | ||||||||
| ETMENGE | IS-M: Sales Order Schedule Line Quantity | ETMENGE | QUAN | 10 | 0 | |||||||||
| ETMEINS | IS-M: Sales Unit for Sales Order | ETMEINS | T006 | UNIT | 3 | 0 | ||||||||
| UNTMENGE | IS-M: Suspension quantity | UNTMENGE | QUAN | 10 | 0 | |||||||||
| RKMENGE | Number of complaint copies | RKMENGE | QUAN | 10 | 0 | |||||||||
| NLMENGE | Number of Copies for Subsequent Delivery | NLMENGE | QUAN | 10 | 0 | |||||||||
| ETVORZEI | Plus/Minus Sign for Schedule Line Quantity in Sales Order | ETVORZEI | CHAR | 1 | 0 |
Possible values
|
||||||||
| REMMG_PLAN | Expected returns | REMMG_PLAN | QUAN | 10 | 0 | |||||||||
| REMME_PLAN | IS-M: Unit of measure of expected returns | REMME_PLAN | T006 | UNIT | 3 | 0 | ||||||||
| KPOSN | Condition item number | KPOSN_ISP | NUMC | 6 | 0 | |||||||||
| NETWR | IS-M: Net price in document currency | NETWR_ISP | CURR | 15 | 2 | |||||||||
| MWSBP | Tax amount in document currency | MWSBP | CURR | 13 | 2 | |||||||||
| NETPR | Net price | NETPR | CURR | 11 | 2 | |||||||||
| KPEIN | Condition pricing unit | KPEIN | DEC | 5 | 0 | |||||||||
| KMEIN | Condition unit | KMEIN | T006 | UNIT | 3 | 0 | ||||||||
| SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRSOK | Pricing is OK | PRSOK | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRSBINDDAT | To-date for price fixing | PRSBINDDAT | DATS | 8 | 0 | |||||||||
| PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | 0 | |||||||||
| PRSPER | IS-M: Price Frequency | PRSPER | TJK03 | CHAR | 2 | 0 | ||||||||
| BZPERF | IS-M: Service Type for Billing | BEZPERFAKT | TJD09 | CHAR | 5 | 0 | ||||||||
| PRSMLT | IS-M: Numerator in conversion factor for frequencies | PRSMLT | DEC | 5 | 0 | |||||||||
| PRSDIV | IS-M: Denominator for frequency conversion factor | PRSDIV | DEC | 5 | 0 | |||||||||
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | 2 | |||||||||
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | 2 | |||||||||
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | 2 | |||||||||
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | 2 | |||||||||
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | 2 | |||||||||
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 | 2 | |||||||||
| XSTORNO | Indicator: Reversed | XJSTORNO | CHAR | 1 | 0 |
Possible values
|
||||||||
| ANZET | Number of Publication Dates | ANZET | DEC | 5 | 0 | |||||||||
| VAUSGB | Issue | VAUSGB | JDTVAUSGB | CHAR | 10 | 0 | ||||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||||
| LFARTLOG | Logistical delivery type | LFARTLOG | TJV01 | CHAR | 2 | 0 | ||||||||
| XAMOCREDIT | Complaint order - amount credited to liability account | XAMOCREDIT | CHAR | 1 | 0 |
Possible values
|
||||||||
| XAMO_ARCHIVED | IS-M/SD: Amortization Data on Cycle Activated | XAMO_ARCHIVED | CHAR | 1 | 0 |
Possible values
|
||||||||
JKEP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JKEP | BEZPER | JKEP | BEZPER | TJD09 | IS-M/SD: Service Type | BEZPER |
| JKEP | BEZPER | JKEP | MANDT | TJD09 | IS-M/SD: Service Type | MANDT |
| JKEP | BZPERF | JKEP | MANDT | TJD09 | IS-M/SD: Service Type | MANDT |
| JKEP | BZPERF | JKEP | BZPERF | TJD09 | IS-M/SD: Service Type | BEZPER |
| JKEP | ETART | JKEP | MANDT | TJEP | Sales Order: Schedule Line Types | MANDT |
| JKEP | ETART | JKEP | ETART | TJEP | Sales Order: Schedule Line Types | ETART |
| JKEP | ETENR_UR | JKEP | MANDT | JKEP | Sales Order: Schedule Line Data | MANDT |
| JKEP | ETENR_UR | JKEP | VBELN | JKEP | Sales Order: Schedule Line Data | VBELN |
| JKEP | ETENR_UR | JKEP | POSNR | JKEP | Sales Order: Schedule Line Data | POSNR |
| JKEP | ETENR_UR | JKEP | ETENR_UR | JKEP | Sales Order: Schedule Line Data | ETENR |
| JKEP | ETENR_VG | JKEP | VBELN | JKEP | Sales Order: Schedule Line Data | VBELN |
| JKEP | ETENR_VG | JKEP | POSNR | JKEP | Sales Order: Schedule Line Data | POSNR |
| JKEP | ETENR_VG | JKEP | ETENR_VG | JKEP | Sales Order: Schedule Line Data | ETENR |
| JKEP | ETENR_VG | JKEP | MANDT | JKEP | Sales Order: Schedule Line Data | MANDT |
| JKEP | ETMEINS | JKEP | MANDT | T006 | Units of Measurement | MANDT |
| JKEP | ETMEINS | JKEP | ETMEINS | T006 | Units of Measurement | MSEHI |
| JKEP | KMEIN | JKEP | MANDT | T006 | Units of Measurement | MANDT |
| JKEP | KMEIN | JKEP | KMEIN | T006 | Units of Measurement | MSEHI |
| JKEP | LFARTLOG | JKEP | MANDT | TJV01 | Delivery type for issue | MANDT |
| JKEP | LFARTLOG | JKEP | LFARTLOG | TJV01 | Delivery type for issue | LIEFERART |
| JKEP | MANDT | JKEP | MANDT | T000 | Clients | MANDT |
| JKEP | POSNR | JKEP | MANDT | JKAP | Sales Order - Item Data | MANDT |
| JKEP | POSNR | JKEP | VBELN | JKAP | Sales Order - Item Data | VBELN |
| JKEP | POSNR | JKEP | POSNR | JKAP | Sales Order - Item Data | POSNR |
| JKEP | PRSPER | JKEP | MANDT | TJK03 | IS-M/SD: Price Frequency | MANDT |
| JKEP | PRSPER | JKEP | PRSPER | TJK03 | IS-M/SD: Price Frequency | PRSPER |
| JKEP | REMME_PLAN | JKEP | MANDT | T006 | Units of Measurement | MANDT |
| JKEP | REMME_PLAN | JKEP | REMME_PLAN | T006 | Units of Measurement | MSEHI |
| JKEP | VAUSGB | JKEP | MANDT | JDTVAUSGB | IS-M/SD: Issues | MANDT |
| JKEP | VAUSGB | JKEP | VAUSGB | JDTVAUSGB | IS-M/SD: Issues | VAUSGB |
| JKEP | VBELN | JKEP | MANDT | JKAK | Sales Order Header Data | MANDT |
| JKEP | VBELN | JKEP | VBELN | JKAK | Sales Order Header Data | VBELN |
