SAP ABAP Table MCJLFZB (IS-PSD: Ref.Structure for MCJLFZ 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	MCJLFZB	Table Relationship Diagram
Short Description	IS-PSD: Ref.Structure for MCJLFZ for LIS Function Module

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

History

Last changed by/on	SAP	20110901
SAP Release Created in