SAP ABAP Table JVTLFNG (IS-M/SD: Delivery/Home Delivery)

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	TRANSP	Transparent table
Transparent table	JVTLFNG	Table Relationship Diagram
Short Description	IS-M/SD: Delivery/Home Delivery

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
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	MARA
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	SPLIT	☐	JVASPLIT	JVASPLIT	NUMC	6	0	IS-M: Issue mix
28	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
29	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
30	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
31	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
32	LFARTLOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	TJV01
33	LFMENGE	☐	LIEFRMENGE	LIEFRMENGE	DEC	9	0	Edition delivery quantity
34	BEZRUNDTAT	☐	BEZRUNDTAT	BEZRUNDE	CHAR	10	0	Actual Delivery Round	JVTRUNDE
35	RESMNGPLAN	☐	RESMNGPLAN	STMENGE	DEC	9	0	Planned reserve quantity per delivery
36	WRBMNGPLAN	☐	WRBMNGPLAN	STMENGE	DEC	9	0	Planned quantity for promotional copies in a delivery
37	NORMMNGIZU	☐	NORMMNGIZU	STMENGE	DEC	9	0	Actual Quantity of Standard Units in a Carrier's Delivery
38	NORMMNGIZG	☐	NORMMNGIZG	STMENGE	DEC	9	0	Actual Qty Standard Units in a Home Del. Company's Delivery
39	WRBMNGIZU	☐	WRBMNGIZU	STMENGE	DEC	9	0	Actual Quantity of Prom. Copies in a Carrier's Delivery
40	WRBMNGIZG	☐	WRBMNGIZG	STMENGE	DEC	9	0	Actual Quantity of Prom. Copies in a Del. Company's Delivery
41	XZUABRCHNG	☐	XZUABGRCHN	XFELD	CHAR	1	0	Indicator: Carrier Home Delivery Settlement Archived
42	XZGABRCHNG	☐	XZGABGRCHN	XFELD	CHAR	1	0	Indicator: SC Home Delivery Settlement Archived
43	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
44	XLISFORTS	☐	XJLISFORTS	XFELD	CHAR	1	0	Indicator: LIS update performed
45	XIVWFORTS	☐	XIVWFORTS	XFELD	CHAR	1	0	Indicator: Delivery data updated in circulation book
46	XINCLABHOL	☐	XINCLABHOL	XFELD	CHAR	1	0	Indicator: Includes pickup
47	XVERSVORLF	☐	XVERSVORLF	XFELD	CHAR	1	0	Initial shipping run carried out for inserts
48	XLFTSFORTS	☐	XLFTSFORTS	XFELD	CHAR	1	0	Daily delivery statistics updated
49	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
50	.INCLUDE	☐				0	0	Created-by data (maximum version)
51	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
52	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
53	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
54	ERFPROG	☐	ERFPROG	PROGRAMM	CHAR	40	0	Program Used to Create Object	*
55	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
56	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
57	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
58	AENPROG	☐	AENPROG	PROGRAMM	CHAR	40	0	Program that Made Last Change	*
59	XAMORTN_FIN	☐	XAMORTN_FIN	XFELD	CHAR	1	0	IS-M/SD: Amortization completed
60	XAMORTN_START	☐	XAMORTN_START	XFELD	CHAR	1	0	IS-M/SD: Amortization begun for delivery
61	BEILGAUSST_FIX	☐	JBEILGAUSST_FIX	XFELD	CHAR	1	0	IS-M/SD: Insert Mix Fixed
62	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	JVTLFNG	ANZEIGENAUSST	JVTANZAUS	ANZEIGENAUSST	KEY	1	CN
2	JVTLFNG	BEABLST	JRTBEABST	BEABLST	KEY	1	CN
3	JVTLFNG	BEILGAUSST	JVTBLGAUS	BEILGAUSST	REF	C	CN
4	JVTLFNG	BEZIRKTAT	JVTBEZIRK	BEZIRK	KEY	1	CN
5	JVTLFNG	BEZRUNDTAT	JVTRUNDE	RUNDE	REF	1	CN
6	JVTLFNG	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
7	JVTLFNG	DRERZTAT	JDTDRER	DRERZ	KEY	1	CN
8	JVTLFNG	DRUCKEREI	T001W	WERKS	KEY	1	CN
9	JVTLFNG	EKORG	T024E	EKORG	REF	C	CN
10	JVTLFNG	GEOEINTAT	JSTGEOEINH	GEOEIN	KEY	1	CN
11	JVTLFNG	KNDGRUPPE	T151	KDGRP	KEY	1	CN
12	JVTLFNG	LFARTLOG	TJV01	LIEFERART	REF	1	CN
13	JVTLFNG	LFARTTAT	TJV01	LIEFERART	KEY	1	CN
14	JVTLFNG	LFBNRAUF	JVTLIEFBAR	LIEFBARNR	KEY	1	CN
15	JVTLFNG	LFBNRVBR	JVTLIEFBAR	LIEFBARNR	KEY	1	CN
16	JVTLFNG	MANDT	T000	MANDT	KEY	1	CN
17	JVTLFNG	MEDIAISSUE	MARA	MATNR
18	JVTLFNG	PVATAT	JDTPVA	PVA	KEY	1	CN
19	JVTLFNG	STAFO	TMCB	STAFO	KEY	1	CN
20	JVTLFNG	VAUSGB	JDTVAUSGB	VAUSGB	KEY	1	CN
21	JVTLFNG	VKORG	TVKO	VKORG	REF	1	CN
22	JVTLFNG	VSAUSSTART	TJV09	VSAUSSTART
23	JVTLFNG	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in