SAP ABAP Table MCJKEPB (IS-PSD: Ref.Structure for MCJKEPB for LIS Function Module)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	MCJKEPB	Table Relationship Diagram
Short Description	IS-PSD: Ref.Structure for MCJKEPB for LIS Function Module

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

History

Last changed by/on	SAP	20110901
SAP Release Created in