SAP ABAP Table MCJLFGB (IS-M/SD: Ref.Structure for MCJLFG 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	MCJLFGB	Table Relationship Diagram
Short Description	IS-M/SD: Ref.Structure for MCJLFG 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-M/SD: Delivery Header Data, LIS Communication Structure
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	LFNGNR	☐	LFNGNR	LFNGNR	NUMC	12	0	IS-M: Sequence Number for Delivery	*
6	NACHLFNGNR	☐	NACHLFNGNR	NUM2	NUMC	2	0	Sequence number of subsequent delivery
7	.INCLUDE	☐				0	0	IS-PSD: Internal Key for Delivery
8	LFNGART	☐	LFNGART	LFNGART	CHAR	1	0	Type of Delivery
9	.INCLUDE	☐				0	0	IS-M/SD: Key for Delivery and Drop-Off
10	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
11	BEILGAUSST	☐	BEILGAUSST	BEILGAUSST	NUMC	3	0	Insert Mix for Carrying Issue in Delivery	JVTBLGAUS
12	ANZEIGENAUSST	☐	ANZEIGENAUSST	ANZEIGENAUSST	NUMC	3	0	Ad Mix in Carrying Issue for a Delivery	JVTANZAUS
13	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
14	DRERZTAT	☐	DRERZTAT	DRERZ	CHAR	8	0	Actual Publication Delivered	JDTDRER
15	PVATAT	☐	PVATAT	PVA	CHAR	8	0	Actual edition delivered	JDTPVA
16	MEDIAISSUE	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
17	BEZIRKTAT	☐	BEZIRKTAT	BEZIRK	CHAR	10	0	Actual Carrier Route	JVTBEZIRK
18	GEOEINTAT	☐	GEOEINTAT	GEOEIN	CHAR	10	0	Actual Geographical Unit	JSTGEOEINH
19	BEABLST	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
20	VSAUSSTART	☐	VSAUSSTART	VSAUSSTART	CHAR	2	0	Shipping outsorting type	TJV09
21	LFBNRAUF	☐	LFBNRAUF	LIEFBARNR	CHAR	9	0	Order-related viability set	JVTLIEFBAR
22	LFBNRVBR	☐	LFBNRVBR	LIEFBARNR	CHAR	9	0	Distribution viability set	JVTLIEFBAR
23	LFARTTAT	☐	LFARTTAT	LIEFERART	CHAR	2	0	Actual delivery type (usually DT for dist.viability set)	TJV01
24	MBZART	☐	MITBEZART	MITBEZART	NUMC	1	0	Combination type of edition combined in mix type definition
25	KNDGRUPPE	☐	KNDGRUPPE	KDGRP	CHAR	2	0	IS-M: Customer Group	T151
26	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
27	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
28	VERSANDDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
29	VRSNDZTRGL	☐	VRSNDZTRGL	NUMC3	NUMC	3	0	IS-M: Time offset rule
30	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
31	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
32	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
33	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	*
34	LFARTLOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	*
35	BEZRUNDTAT	☐	BEZRUNDTAT	BEZRUNDE	CHAR	10	0	Actual Delivery Round	*
36	LFMENGE	☐	LIEFRMENG2	LIEFRMENG2	QUAN	9	0	Delivery quantity of edition
37	RESMNGPLAN	☐	RESMNGPLA2	JSTMNGQUAN	QUAN	9	0	Planned reserve quantity per delivery
38	WRBMNGPLAN	☐	WRBMNGPLA2	JSTMNGQUAN	QUAN	9	0	Planned quantity for promotional copies in a delivery
39	.INCLUDE	☐				0	0	IS-M/SD: LIS Comm.Structure, Additional Delivery Header Data
40	PVABEZEI10	☐	KBEZPVA	TEXT10	CHAR	10	0	Short text for edition
41	PVABERGRP1	☐	PVABERGRP1	PVABERGRP1	CHAR	10	0	Report group 1 - edition	*
42	PVABERGRP2	☐	PVABERGRP2	PVABERGRP2	CHAR	10	0	Report group 2 - edition	*
43	PVAPOVERKZ	☐	POVERKZ	POVERKZ	CHAR	8	0	IS-M: Postal distribution indicator
44	PVAIVWNR	☐	IVWNR	IVWNR	NUMC	10	0	Circulation Audit Report ID for Edition
45	PVAISPCNRO	☐	ISPCNROB	ISPCNROB	NUMC	6	0	ISPC Number of Object
46	PVAISPCNRT	☐	ISPCNRTO	ISPCNRTO	NUMC	2	0	ISPC Number of Sub-Object
47	VDZVERTRKZ	☐	JWBZVKENNZ	JWBZVKENNZ	CHAR	5	0	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)	*
48	PVARKAUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
49	PVARKPOSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
50	PVACOAUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	*
51	DRERZSPART	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	*
52	JAHRGANG	☐	JAHRGANG	JAHRGANG	NUMC	4	0	Year number of issue
53	NRIMJAHR	☐	NRIMJAHR	JNRIMJAHR	CHAR	4	0	Issue number (in year)
54	HEFTNUMMER	☐	HEFTNUM_VA	HEFTNUMMER	CHAR	9	0	Copy Number of Issue
55	ABHOLSTELL	☐	ABHOLSTELL	GPNR	CHAR	10	0	IS-M/SD: Customer Pickup Point	*
56	BUKRS	☐	VKBUK	BUKRS	CHAR	4	0	Company code of the sales organization	*
57	LIEF_LAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
58	ANZVAMO	☐	JMCANZVAMO	STMENGE	DEC	9	0	Number of issues in a month
59	ANZVATA	☐	JMCANZVATA	STMENGE	DEC	9	0	Number of issues in a day
60	ANZVAWO	☐	JMCANZVAWO	STMENGE	DEC	9	0	Number of issues in a week
61	ANZVABU	☐	JMCANZVABU	STMENGE	DEC	9	0	Number of issues in a posting period
62	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
63	ZUSTELLER	☐	JZUSTELLER	GPNR	CHAR	10	0	IS-M: Carrier	*
64	VSGZUSTLR	☐	VSGZUSTLR	GPNR	CHAR	10	0	IS-M/SD: Service Company to Which Carrier Belongs	*
65	.INCLUDE	☐				0	0	IS-PSD: LIS Comm.Structure - Header Deliv.Data, User Fields
66	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	MCJLFGB	ANZEIGENAUSST	JVTANZAUS	ANZEIGENAUSST	KEY	1	CN
2	MCJLFGB	BEABLST	JRTBEABST	BEABLST
3	MCJLFGB	BEILGAUSST	JVTBLGAUS	BEILGAUSST	KEY	1	CN
4	MCJLFGB	BEZIRKTAT	JVTBEZIRK	BEZIRK
5	MCJLFGB	BEZUGSTYP	JDTBEZTYP	BEZTYP
6	MCJLFGB	DRERZTAT	JDTDRER	DRERZ
7	MCJLFGB	GEOEINTAT	JSTGEOEINH	GEOEIN
8	MCJLFGB	KNDGRUPPE	T151	KDGRP
9	MCJLFGB	LFARTTAT	TJV01	LIEFERART
10	MCJLFGB	LFBNRAUF	JVTLIEFBAR	LIEFBARNR
11	MCJLFGB	LFBNRVBR	JVTLIEFBAR	LIEFBARNR
12	MCJLFGB	PVATAT	JDTPVA	PVA
13	MCJLFGB	VAUSGB	JDTVAUSGB	VAUSGB
14	MCJLFGB	VSAUSSTART	TJV09	VSAUSSTART

History

Last changed by/on	SAP	20110901
SAP Release Created in