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

History

Last changed by/on	SAP	20110901
SAP Release Created in