SAP ABAP Table MCJLFZ (IS-PSD: Delivery Assignment (Item), 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

Basic Data

Table Category	INTTAB	Structure
Structure	MCJLFZ	Table Relationship Diagram
Short Description	IS-PSD: Delivery Assignment (Item), LIS Comm.Structure

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	LFNGNR	☐	LFNGNR	LFNGNR	NUMC	12	0	IS-M: Sequence Number for Delivery	JVTLFNG
3	NACHLFNGNR	☐	NACHLFNGNR	NUM2	NUMC	2	0	Sequence number of subsequent delivery
4	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
5	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
6	ETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
7	MENGEINZUO	☐	JMCMNGINZU	JSTMNGQUAN	QUAN	9	0	Schedule line quantity for each order supply (delivery item)
8	ETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
9	XINCLABHOL	☐	XINCLABHOL	XFELD	CHAR	1	0	Indicator: Includes pickup
10	.INCLUDE	☐				0	0	IS-PSD: LIS Comm.Structure, Del.Assgmt (Item) Addr.Determ.
11	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
12	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
13	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
16	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
17	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
18	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
19	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	*
20	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
21	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
22	XURPOS	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
23	POSGUELVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
24	POSGUELBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
25	AKT_B_LAND	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
26	NRM_B_LAND	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
27	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
28	KOKRS_POS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
29	KOSTL_L_PO	☐	KOSTL_L	KOSTL	CHAR	10	0	Debit Cost Center	*
30	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
31	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
32	IVWKNFREI	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	*
33	IVWKN_VDAT	☐	IVWKN_VERSDAT	IVWKN	CHAR	8	0	Audit Report Category ID of Order for Shipping Date	*
34	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
35	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
36	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	*
37	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	*
38	XIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
39	SBFREI	☐	SBFREI	USNAM	CHAR	12	0	Administrator responsible for free copies
40	XLIEFGP	☐	XLIEFGP	XFELD	CHAR	1	0	IS-M: Delivery to business partner
41	XLIEFBEZ	☐	XLIEFBEZ	XFELD	CHAR	1	0	IS-M: Delivery to a carrier route (reserve)
42	ETEEX	☐	ETEEX	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
43	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
44	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
45	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
46	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
47	XFAKTURA	☐	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
48	STAFO_ZUO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
49	WERBEART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
50	WERBEAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
51	WERBTRAEG	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	*
52	SACHPRAEM	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
53	PVAKNTGRP	☐	PVAKNTGRP	KTGRM	CHAR	2	0	Account Assignment Grouping for Edition	*
54	PVAKONGRP	☐	PVAKONGRP	JKONDM	CHAR	2	0	Condition Grouping for Edition	*
55	.INCLUDE	☐				0	0	IS-M/SD: Partner Field String for LIS Connection
56	GPNRAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
57	GPNRWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
58	GPNRRE	☐	GPNR_RE	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
59	GPNRRG	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*
60	GPNRVM	☐	GPVERM	GPNR	CHAR	10	0	Business Partner Sales Agent	*
61	PLZWE	☐	JMCPLZWE	PSTLZ	CHAR	10	0	Postal code in ship-to party address from order
62	PLZRE	☐	JMCPLZRE	PSTLZ	CHAR	10	0	Postal code in bill-to party address from order
63	KGSWE	☐	JMCKGSWE	KREISG_SCH	CHAR	15	0	District municip. key for ship-to party address from order	*
64	.INCLUDE	☐				0	0	IS-PSD: LIS Comm.Structure, Del.Assgt (Item) User Field Ref.
65	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	MCJLFZ	ETART	TJEP	ETART
2	MCJLFZ	ETENR	JKEP	ETENR
3	MCJLFZ	LFNGNR	JVTLFNG	LFNGNR
4	MCJLFZ	MANDT	T000	MANDT
5	MCJLFZ	POSNR	JKAP	POSNR
6	MCJLFZ	VBELN	JKAK	VBELN

History

Last changed by/on	SAP	20110901
SAP Release Created in