SAP ABAP Table RJV08LFNG_SI (IS-M: Structure - Deliveries incl.AI)

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	RJV08LFNG_SI	Table Relationship Diagram
Short Description	IS-M: Structure - Deliveries incl.AI

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	SI_NUMMER	☐	ISM_SI_NUMMER	SI_NUMMER	CHAR	10	0	IS-M: Ad Insert Number
2	VAUSGBTRAE	☐	VAUSGBTRAE	VAUSGB	CHAR	10	0	Carrying issue	*
3	GW_DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	*
4	.INCLUDE	☐				0	0	IS-M/SD: Delivery/Home Delivery
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	LFNGNR	☐	LFNGNR	LFNGNR	NUMC	12	0	IS-M: Sequence Number for Delivery	*
7	NACHLFNGNR	☐	NACHLFNGNR	NUM2	NUMC	2	0	Sequence number of subsequent delivery
8	.INCLUDE	☐				0	0	IS-PSD: Internal Key for Delivery
9	LFNGART	☐	LFNGART	LFNGART	CHAR	1	0	Type of Delivery
10	.INCLUDE	☐				0	0	IS-M/SD: Key for Delivery and Drop-Off
11	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
12	BEILGAUSST	☐	BEILGAUSST	BEILGAUSST	NUMC	3	0	Insert Mix for Carrying Issue in Delivery	JVTBLGAUS
13	ANZEIGENAUSST	☐	ANZEIGENAUSST	ANZEIGENAUSST	NUMC	3	0	Ad Mix in Carrying Issue for a Delivery	JVTANZAUS
14	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
15	DRERZTAT	☐	DRERZTAT	DRERZ	CHAR	8	0	Actual Publication Delivered	JDTDRER
16	PVATAT	☐	PVATAT	PVA	CHAR	8	0	Actual edition delivered	JDTPVA
17	MEDIAISSUE	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
18	BEZIRKTAT	☐	BEZIRKTAT	BEZIRK	CHAR	10	0	Actual Carrier Route	JVTBEZIRK
19	GEOEINTAT	☐	GEOEINTAT	GEOEIN	CHAR	10	0	Actual Geographical Unit	JSTGEOEINH
20	BEABLST	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
21	VSAUSSTART	☐	VSAUSSTART	VSAUSSTART	CHAR	2	0	Shipping outsorting type	TJV09
22	LFBNRAUF	☐	LFBNRAUF	LIEFBARNR	CHAR	9	0	Order-related viability set	JVTLIEFBAR
23	LFBNRVBR	☐	LFBNRVBR	LIEFBARNR	CHAR	9	0	Distribution viability set	JVTLIEFBAR
24	LFARTTAT	☐	LFARTTAT	LIEFERART	CHAR	2	0	Actual delivery type (usually DT for dist.viability set)	TJV01
25	MBZART	☐	MITBEZART	MITBEZART	NUMC	1	0	Combination type of edition combined in mix type definition
26	KNDGRUPPE	☐	KNDGRUPPE	KDGRP	CHAR	2	0	IS-M: Customer Group	T151
27	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
28	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
29	VERSANDDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
30	VRSNDZTRGL	☐	VRSNDZTRGL	NUMC3	NUMC	3	0	IS-M: Time offset rule
31	SPLIT	☐	JVASPLIT	JVASPLIT	NUMC	6	0	IS-M: Issue mix
32	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
33	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
34	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
35	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
36	LFARTLOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	TJV01
37	LFMENGE	☐	LIEFRMENGE	LIEFRMENGE	DEC	9	0	Edition delivery quantity
38	BEZRUNDTAT	☐	BEZRUNDTAT	BEZRUNDE	CHAR	10	0	Actual Delivery Round	JVTRUNDE
39	RESMNGPLAN	☐	RESMNGPLAN	STMENGE	DEC	9	0	Planned reserve quantity per delivery
40	WRBMNGPLAN	☐	WRBMNGPLAN	STMENGE	DEC	9	0	Planned quantity for promotional copies in a delivery
41	NORMMNGIZU	☐	NORMMNGIZU	STMENGE	DEC	9	0	Actual Quantity of Standard Units in a Carrier's Delivery
42	NORMMNGIZG	☐	NORMMNGIZG	STMENGE	DEC	9	0	Actual Qty Standard Units in a Home Del. Company's Delivery
43	WRBMNGIZU	☐	WRBMNGIZU	STMENGE	DEC	9	0	Actual Quantity of Prom. Copies in a Carrier's Delivery
44	WRBMNGIZG	☐	WRBMNGIZG	STMENGE	DEC	9	0	Actual Quantity of Prom. Copies in a Del. Company's Delivery
45	XZUABRCHNG	☐	XZUABGRCHN	XFELD	CHAR	1	0	Indicator: Carrier Home Delivery Settlement Archived
46	XZGABRCHNG	☐	XZGABGRCHN	XFELD	CHAR	1	0	Indicator: SC Home Delivery Settlement Archived
47	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
48	XLISFORTS	☐	XJLISFORTS	XFELD	CHAR	1	0	Indicator: LIS update performed
49	XIVWFORTS	☐	XIVWFORTS	XFELD	CHAR	1	0	Indicator: Delivery data updated in circulation book
50	XINCLABHOL	☐	XINCLABHOL	XFELD	CHAR	1	0	Indicator: Includes pickup
51	XVERSVORLF	☐	XVERSVORLF	XFELD	CHAR	1	0	Initial shipping run carried out for inserts
52	XLFTSFORTS	☐	XLFTSFORTS	XFELD	CHAR	1	0	Daily delivery statistics updated
53	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
54	.INCLUDE	☐				0	0	Created-by data (maximum version)
55	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
56	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
57	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
58	ERFPROG	☐	ERFPROG	PROGRAMM	CHAR	40	0	Program Used to Create Object	*
59	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
60	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
61	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
62	AENPROG	☐	AENPROG	PROGRAMM	CHAR	40	0	Program that Made Last Change	*
63	XAMORTN_FIN	☐	XAMORTN_FIN	XFELD	CHAR	1	0	IS-M/SD: Amortization completed
64	XAMORTN_START	☐	XAMORTN_START	XFELD	CHAR	1	0	IS-M/SD: Amortization begun for delivery
65	BEILGAUSST_FIX	☐	JBEILGAUSST_FIX	XFELD	CHAR	1	0	IS-M/SD: Insert Mix Fixed
66	XAMORTN_NO	☐	XAMORTN_NOT_RELEVANT	XFELD	CHAR	1	0	IS-M/SD: Do Not Execute Amortization for Delivery

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJV08LFNG_SI	ANZEIGENAUSST	JVTANZAUS	ANZEIGENAUSST	KEY	1	CN
2	RJV08LFNG_SI	BEABLST	JRTBEABST	BEABLST	KEY	1	CN
3	RJV08LFNG_SI	BEILGAUSST	JVTBLGAUS	BEILGAUSST	REF	C	CN
4	RJV08LFNG_SI	BEZIRKTAT	JVTBEZIRK	BEZIRK	KEY	1	CN
5	RJV08LFNG_SI	BEZRUNDTAT	JVTRUNDE	RUNDE	REF	1	CN
6	RJV08LFNG_SI	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
7	RJV08LFNG_SI	DRERZTAT	JDTDRER	DRERZ	KEY	1	CN
8	RJV08LFNG_SI	DRUCKEREI	T001W	WERKS	KEY	1	CN
9	RJV08LFNG_SI	EKORG	T024E	EKORG	REF	C	CN
10	RJV08LFNG_SI	GEOEINTAT	JSTGEOEINH	GEOEIN	KEY	1	CN
11	RJV08LFNG_SI	KNDGRUPPE	T151	KDGRP	KEY	1	CN
12	RJV08LFNG_SI	LFARTLOG	TJV01	LIEFERART	REF	1	CN
13	RJV08LFNG_SI	LFARTTAT	TJV01	LIEFERART	KEY	1	CN
14	RJV08LFNG_SI	LFBNRAUF	JVTLIEFBAR	LIEFBARNR	KEY	1	CN
15	RJV08LFNG_SI	LFBNRVBR	JVTLIEFBAR	LIEFBARNR	KEY	1	CN
16	RJV08LFNG_SI	MANDT	T000	MANDT	KEY	1	CN
17	RJV08LFNG_SI	MEDIAISSUE	MARA	MATNR
18	RJV08LFNG_SI	PVATAT	JDTPVA	PVA	KEY	1	CN
19	RJV08LFNG_SI	STAFO	TMCB	STAFO	KEY	1	CN
20	RJV08LFNG_SI	VAUSGB	JDTVAUSGB	VAUSGB	KEY	1	CN
21	RJV08LFNG_SI	VKORG	TVKO	VKORG	REF	1	CN
22	RJV08LFNG_SI	VSAUSSTART	TJV09	VSAUSSTART
23	RJV08LFNG_SI	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in