SAP ABAP View JRVLFGABLG (Read Drop-Offs Using Delivery/Delivery Viability Set)

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

View Type	D	Database View
Database View	JRVLFGABLG
Short Description	Read Drop-Offs Using Delivery/Delivery Viability Set
Root table	JVTLFNG	IS-M/SD: Delivery/Home Delivery

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JVTLFNG	JVTLFNG
2	JRTLFGABLG
3	JRTABLG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JVTLFNG	MANDT	JL	EQ				0	0
2	JRTLFGABLG	MANDT	JR	EQ			AND	0	0
3	JVTLFNG	LFNGNR	JL	EQ				0	0
4	JRTLFGABLG	LFNGNR	JR	EQ			AND	0	0
5	JVTLFNG	NACHLFNGNR	JL	EQ				0	0
6	JRTLFGABLG	NACHLFNGNR	JR	EQ			AND	0	0
7	JRTABLG	MANDT	JL	EQ				0	0
8	JRTLFGABLG	MANDT	JR	EQ			AND	0	0
9	JRTABLG	ABLGNR	JL	EQ				0	0
10	JRTLFGABLG	ABLGNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JVTLFNG	MANDT		☐	MANDT	☐	Client
2	LFNGNR	JVTLFNG	LFNGNR		☐	LFNGNR	☐	IS-M: Sequence Number for Delivery
3	NACHLFNGNR	JVTLFNG	NACHLFNGNR		☐	NACHLFNGNR	☐	Sequence number of subsequent delivery
4	LFBNRAUF	JVTLFNG	LFBNRAUF		☐	LFBNRAUF	☐	Order-related viability set
5	LFBNRVBR	JVTLFNG	LFBNRVBR		☐	LFBNRVBR	☐	Distribution viability set
6	VERSANDDAT	JVTLFNG	VERSANDDAT		☐	VRSNDDATUM	☐	IS-M: Shipping Date
7	ABLGNR	JRTLFGABLG	ABLGNR		☐	ABLGNR	☐	IS-M: Internal Number of Drop-Off
8	VAUSGB	JRTABLG	VAUSGB		☐	VAUSGB	☐	Issue
9	BEZUGSTYP	JRTABLG	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
10	DRERZTAT	JRTABLG	DRERZTAT		☐	DRERZTAT	☐	Actual Publication Delivered
11	PVATAT	JRTABLG	PVATAT		☐	PVATAT	☐	Actual edition delivered
12	BEZIRKTAT	JRTABLG	BEZIRKTAT		☐	BEZIRKTAT	☐	Actual Carrier Route
13	GEOEINTAT	JRTABLG	GEOEINTAT		☐	GEOEINTAT	☐	Actual Geographical Unit
14	BEABLST	JRTABLG	BEABLST		☐	BEABLST	☐	IS-M: Unloading Point
15	VSAUSSTART	JRTABLG	VSAUSSTART		☐	VSAUSSTART	☐	Shipping outsorting type
16	ROUTE	JRTABLG	ROUTE		☐	ISPROUTE	☐	Truck Route - Media
17	LFARTLOG	JRTABLG	LFARTLOG		☐	LFARTLOG	☐	Logistical delivery type
18	NETZ	JRTABLG	NETZ		☐	JNETZ	☐	IS-M: Network for postal shipping
19	VKORG	JRTABLG	VKORG		☐	VKORG	☐	Sales Organization
20	DRUCKEREI	JRTABLG	DRUCKEREI		☐	JWERK	☐	Plant
21	ERSCHDAT	JVTLFNG	ERSCHDAT		☐	ERSCHDAT	☐	Publication Date
22	VRSNDPLAN	JRTABLG	VRSNDPLAN		☐	VRSNDPLAN	☐	IS-M: Internal Number of Shipping Schedule
23	GEBINDEART	JRTABLG	GEBINDEART		☐	GEBINDEART	☐	IS-M: Container Type
24	BEILGAUSST	JRTABLG	BEILGAUSST		☐	BEILGAUSST	☐	Insert Mix for Carrying Issue in Delivery
25	BEZRUNDTAT	JRTABLG	BEZRUNDTAT		☐	BEZRUNDTAT	☐	Actual Delivery Round
26	XINCLABHOL	JRTABLG	XINCLABHOL		☐	XINCLABHOL	☐	Indicator: Includes pickup
27	XBUNDE	JRTABLG	XBUNDE		☐	JXBUNDLES	☐	Bundles exist for drop-off
28	VOLLPAKETE	JRTABLG	VOLLPAKETE		☐	VOLLPAKETE	☐	IS-M: Number of Full Bundles
29	PKTTEILER	JRTABLG	PKTTEILER		☐	PKTTEILER	☐	Bundle Divider in Units
30	MENGSPITZE	JRTABLG	MENGSPITZE		☐	MENGSPITZE	☐	IS-M: Number of issues in odd bundle
31	XMANUELLSP	JRTABLG	XMANUELLSP		☐	XMANUELLSP	☐	IS-M: Pack odd bundle manually
32	NEXTABLGNR	JRTABLG	NEXTABLGNR		☐	NEXT_ABLG	☐	IS-M: Pointer to next common drop-off
33	TRAGABLGNR	JRTABLG	TRAGABLGNR		☐	TRAG_ABLG	☐	IS-M: Pointer to carrying drop-off or preceding mixed DO
34	NUMBEABLST	JRTABLG	NUMBEABLST		☐	NUMBEABLST	☐	IS-M: Number of unloading point for truck route
35	XFIRSTABL	JRTABLG	XFIRSTABL		☐	XFIRSTABL	☐	IS-M: First unloading point in carrier route for carrier
36	SPITABLGNR	JRTABLG	SPITABLGNR		☐	SPITABLGNR	☐	IS-M: Pointer to drop-off with odd bundle (internal)
37	XSPITZE	JRTABLG	XSPITZE		☐	XSPITZE	☐	IS-M: Unloading point for odd bundle

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in