SAP ABAP Table MCJKEP (IS-PSD: Return/Complaint Schedule Line, LIS Comm.Structure)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCJKEP | Table Relationship Diagram |
Short Description | IS-PSD: Return/Complaint Schedule Line, LIS Comm.Structure |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Sales Order: Schedule Line Data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | VBELN | AVNR | AVNR | CHAR | 10 | 0 | IS-M/SD: Publishing Sales Order | JKAK | |
4 | POSNR | APNR | APNR | NUMC | 6 | 0 | Sales Order Item | JKAP | |
5 | ETENR | JAENR | AENR | NUMC | 4 | 0 | Sales Order Schedule Line | * | |
6 | GUELTIGVON | JKEPVON | DATUM | DATS | 8 | 0 | Date from Which Schedule Line in Sales Order is Valid | ||
7 | GUELTIGBIS | JKEPBIS | DATUM | DATS | 8 | 0 | Date to Which Schedule Line in Sales Order is Valid | ||
8 | ETEEX | ETEEX_ISP | ETEEX | NUMC | 6 | 0 | IS-M: External Schedule Line Number | ||
9 | BEZPER | BEZPER | BEZPER | CHAR | 5 | 0 | Service Type | TJD09 | |
10 | ETART | ETART_ISP | ETART_ISP | CHAR | 2 | 0 | Schedule Line Type for Internal Sales Order Schedule Line | TJEP | |
11 | ZSKLS | JZSKLS | JZSKLS | CHAR | 1 | 0 | Time slice classification for sales order | ||
12 | AEART | AEART_JSDK | AEART_JSDK | CHAR | 1 | 0 | Order Change Type | ||
13 | XUREINT | XUREINT | XFELD | CHAR | 1 | 0 | Original schedule line in publishing sales order | ||
14 | XTAGESBEZ | XTAGESBEZ | XFELD | CHAR | 1 | 0 | IS-M: Limited change relating to a specific date | ||
15 | ETENR_UR | AENR_UR | AENR | NUMC | 4 | 0 | Source Schedule Line | JKEP | |
16 | ETENR_VG | AENR_VG | AENR | NUMC | 4 | 0 | Preceding Schedule Line | JKEP | |
17 | ETMENGE | ETMENGE | MENGGPOS | QUAN | 10 | 0 | IS-M: Sales Order Schedule Line Quantity | ||
18 | ETMEINS | ETMEINS | MEINS | UNIT | 3 | 0 | IS-M: Sales Unit for Sales Order | T006 | |
19 | UNTMENGE | UNTMENGE | MENGGPOS | QUAN | 10 | 0 | IS-M: Suspension quantity | ||
20 | RKMENGE | RKMENGE | MENGGPOS | QUAN | 10 | 0 | Number of complaint copies | ||
21 | NLMENGE | NLMENGE | MENGGPOS | QUAN | 10 | 0 | Number of Copies for Subsequent Delivery | ||
22 | ETVORZEI | ETVORZEI | VORZEI | CHAR | 1 | 0 | Plus/Minus Sign for Schedule Line Quantity in Sales Order | ||
23 | REMMG_PLAN | REMMG_PLAN | MENGGPOS | QUAN | 10 | 0 | Expected returns | ||
24 | REMME_PLAN | REMME_PLAN | MEINS | UNIT | 3 | 0 | IS-M: Unit of measure of expected returns | T006 | |
25 | KPOSN | KPOSN_ISP | NUM6 | NUMC | 6 | 0 | Condition item number | ||
26 | NETWR | NETWR_ISP | WERTV8 | CURR | 15 | 2 | IS-M: Net price in document currency | ||
27 | MWSBP | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
28 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
29 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
30 | KMEIN | KMEIN | MEINS | UNIT | 3 | 0 | Condition Unit | T006 | |
31 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
32 | PRSOK | PRSOK | XFELD | CHAR | 1 | 0 | Pricing is OK | ||
33 | PRSBINDDAT | PRSBINDDAT | DATUM | DATS | 8 | 0 | To-date for price fixing | ||
34 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
35 | PRSPER | PRSPER | PRSPER | CHAR | 2 | 0 | IS-M: Price Frequency | TJK03 | |
36 | BZPERF | BEZPERFAKT | BEZPER | CHAR | 5 | 0 | IS-M: Service Type for Billing | TJD09 | |
37 | PRSMLT | PRSMLT | PRSMLT | DEC | 5 | 0 | IS-M: Numerator in conversion factor for frequencies | ||
38 | PRSDIV | PRSDIV | PRSDIV | DEC | 5 | 0 | IS-M: Denominator for frequency conversion factor | ||
39 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
40 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
41 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
42 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
43 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
44 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
45 | XSTORNO | XJSTORNO | XFELD | CHAR | 1 | 0 | Indicator: Reversed | ||
46 | ANZET | ANZET | ANZET | DEC | 5 | 0 | Number of Publication Dates | ||
47 | VAUSGB | VAUSGB | VAUSGB | CHAR | 10 | 0 | Issue | JDTVAUSGB | |
48 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
49 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
50 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
51 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
52 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
53 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
54 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
55 | LFARTLOG | LFARTLOG | LIEFERART | CHAR | 2 | 0 | Logistical delivery type | TJV01 | |
56 | XAMOCREDIT | XAMOCREDIT | XFELD | CHAR | 1 | 0 | Complaint order - amount credited to liability account | ||
57 | XAMO_ARCHIVED | XAMO_ARCHIVED | XFELD | CHAR | 1 | 0 | IS-M/SD: Amortization Data on Cycle Activated | ||
58 | .INCLUDE | 0 | 0 | IS-M/SD: Partner Field String for LIS Connection | |||||
59 | GPNRAG | GPAG | GPNR | CHAR | 10 | 0 | Business Partner: Sold-to Party | * | |
60 | GPNRWE | GPNR_WE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Ship-to Party | * | |
61 | GPNRRE | GPNR_RE | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | * | |
62 | GPNRRG | GPNR_RG | GPNR | CHAR | 10 | 0 | IS-M: Payer Business Partner | * | |
63 | GPNRVM | GPVERM | GPNR | CHAR | 10 | 0 | Business Partner Sales Agent | * | |
64 | PLZWE | JMCPLZWE | PSTLZ | CHAR | 10 | 0 | Postal code in ship-to party address from order | ||
65 | PLZRE | JMCPLZRE | PSTLZ | CHAR | 10 | 0 | Postal code in bill-to party address from order | ||
66 | KGSWE | JMCKGSWE | KREISG_SCH | CHAR | 15 | 0 | District municip. key for ship-to party address from order | * | |
67 | .INCLUDE | 0 | 0 | IS-PSD: LIS Comm.Structure, Additional Schedule Line Data | |||||
68 | LIEFBEZIRK | JMCBEZIRKE | BEZIRK | CHAR | 10 | 0 | Carrier route for each return/complaint sched.line | * | |
69 | LIEFGEOEIN | JMCGEOEINE | GEOEIN | CHAR | 10 | 0 | Geographical unit for each return/complaint schedule line | * | |
70 | LIEF_LAND | ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | * | |
71 | ERSCHDAT | ERSCHDAT | DATUM | DATS | 8 | 0 | Publication Date | ||
72 | JAHRGANG | JAHRGANG | JAHRGANG | NUMC | 4 | 0 | Year number of issue | ||
73 | NRIMJAHR | NRIMJAHR | JNRIMJAHR | CHAR | 4 | 0 | Issue number (in year) | ||
74 | HEFTNUMMER | HEFTNUM_VA | HEFTNUMMER | CHAR | 9 | 0 | Copy Number of Issue | ||
75 | ETMNGNF | JMCETMNGNF | MENGGPOS | QUAN | 10 | 0 | Schedule Line Quantity for Subsequent Schedule Line | ||
76 | ETMNGVG | JMCETMNGVG | MENGGPOS | QUAN | 10 | 0 | Schedule Line Quantity for Previous Schedule Line | ||
77 | ETMENGE2 | JMC_ETMNG2 | JMC_MENGE2 | QUAN | 16 | 2 | Quantity in sales order schedule line w/part.subs.weighting | ||
78 | ETMNGNF2 | JMCETMGNF2 | JMC_MENGE2 | QUAN | 16 | 2 | Quantity for subsequent schedule line with partial sub.wting | ||
79 | ETMNGVG2 | JMCETMGVG2 | JMC_MENGE2 | QUAN | 16 | 2 | Quantity of preceding sched.line with partial subs.weighting | ||
80 | .INCLUDE | 0 | 0 | IS-PSD: LIS Comm.Structure - Schedule Line, User Data | |||||
81 | DUMMYUSR | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCJKEP | BEZPER | TJD09 | BEZPER | |||
2 | MCJKEP | BZPERF | TJD09 | BEZPER | |||
3 | MCJKEP | ETART | TJEP | ETART | |||
4 | MCJKEP | ETENR_UR | JKEP | ETENR | |||
5 | MCJKEP | ETENR_VG | JKEP | ETENR | |||
6 | MCJKEP | ETMEINS | T006 | MSEHI | |||
7 | MCJKEP | KMEIN | T006 | MSEHI | |||
8 | MCJKEP | LFARTLOG | TJV01 | LIEFERART | |||
9 | MCJKEP | MANDT | T000 | MANDT | |||
10 | MCJKEP | POSNR | JKAP | POSNR | |||
11 | MCJKEP | PRSPER | TJK03 | PRSPER | |||
12 | MCJKEP | REMME_PLAN | T006 | MSEHI | |||
13 | MCJKEP | VAUSGB | JDTVAUSGB | VAUSGB | |||
14 | MCJKEP | VBELN | JKAK | VBELN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |