SAP ABAP View JVVLFSTAT (IS-M/SD: Deliv.Assgmt (incl.Address) for Daily Del.Statistic)

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	JVVLFSTAT
Short Description	IS-M/SD: Deliv.Assgmt (incl.Address) for Daily Del.Statistic
Root table	JVTLFNG	IS-M/SD: Delivery/Home Delivery

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JVTLFNG	JVTLFNG
2	JVTLFZUO
3	JKEP
4	JKAP
5	JKPA
6	JGTSADR
7	JKAK
8	JKKD

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	JVTLFZUO	MANDT	JR	EQ			AND	0	0
3	JVTLFNG	LFNGNR	JL	EQ				0	0
4	JVTLFZUO	LFNGNR	JR	EQ			AND	0	0
5	JVTLFNG	NACHLFNGNR	JL	EQ				0	0
6	JVTLFZUO	NACHLFNGNR	JR	EQ			AND	0	0
7	JKEP	MANDT	JL	EQ				0	0
8	JVTLFZUO	MANDT	JR	EQ			AND	0	0
9	JKEP	VBELN	JL	EQ				0	0
10	JVTLFZUO	VBELN	JR	EQ			AND	0	0
11	JKEP	POSNR	JL	EQ				0	0
12	JVTLFZUO	POSNR	JR	EQ			AND	0	0
13	JKEP	ETENR	JL	EQ				0	0
14	JVTLFZUO	ETENR	JR	EQ			AND	0	0
15	JKAP	MANDT	JL	EQ				0	0
16	JKEP	MANDT	JR	EQ			AND	0	0
17	JKAP	VBELN	JL	EQ				0	0
18	JKEP	VBELN	JR	EQ			AND	0	0
19	JKAP	POSNR	JL	EQ				0	0
20	JKEP	POSNR	JR	EQ			AND	0	0
21	JKAP	MANDT	JL	EQ				0	0
22	JKPA	MANDT	JR	EQ			AND	0	0
23	JKAP	VBELN	JL	EQ				0	0
24	JKPA	VBELN	JR	EQ			AND	0	0
25	JKAP	POSNR	JL	EQ				0	0
26	JKPA	POSNR	JR	EQ			AND	0	0
27	JGTSADR	MANDT	JL	EQ				0	0
28	JKPA	MANDT	JR	EQ			AND	0	0
29	JGTSADR	ADRNR	JL	EQ				0	0
30	JKPA	ADRNR	JR	EQ			AND	0	0
31	JKAK	MANDT	JL	EQ				0	0
32	JKAP	MANDT	JR	EQ			AND	0	0
33	JKAK	VBELN	JL	EQ				0	0
34	JKAP	VBELN	JR	EQ			AND	0	0
35	JKAP	MANDT	JL	EQ				0	0
36	JKKD	MANDT	JR	EQ			AND	0	0
37	JKAP	VBELN	JL	EQ				0	0
38	JKKD	VBELN	JR	EQ			AND	0	0
39	JKAP	POSNR	JL	EQ				0	0
40	JKKD	POSNR	JR	EQ			AND	0	0
41	JVTLFNG	XLFTSFORTS		EQ	' '		AND	0	0
42	JKPA	JPARVW		EQ	'WE'		AND	0	0
43	JKPA	PARZA		EQ	'000'		AND	0	0
44	JVTLFZUO	ETART		NE	'TU'			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	VBELN	JVTLFZUO	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
5	POSNR	JVTLFZUO	POSNR		☐	APNR	☐	Sales Order Item
6	ETENR	JVTLFZUO	ETENR		☐	JAENR	☐	Sales Order Schedule Line
7	DRERZ	JVTLFNG	DRERZTAT		☐	DRERZTAT	☐	Actual Publication Delivered
8	PVA	JVTLFNG	PVATAT		☐	PVATAT	☐	Actual edition delivered
9	BEZUGSTYP	JVTLFNG	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
10	LFARTLOG	JVTLFNG	LFARTLOG		☐	LFARTLOG	☐	Logistical delivery type
11	ERSCHDAT	JVTLFNG	ERSCHDAT		☐	ERSCHDAT	☐	Publication Date
12	VAUSGB	JVTLFNG	VAUSGB		☐	VAUSGB	☐	Issue
13	BEILGAUSST	JVTLFNG	BEILGAUSST		☐	BEILGAUSST	☐	Insert Mix for Carrying Issue in Delivery
14	MBZART	JVTLFNG	MBZART		☐	MITBEZART	☐	Combination type of edition combined in mix type definition
15	KNDGRUPPE	JVTLFNG	KNDGRUPPE		☐	KNDGRUPPE	☐	IS-M: Customer Group
16	LFNGART	JVTLFNG	LFNGART		☐	LFNGART	☐	Type of Delivery
17	VERSANDDAT	JVTLFNG	VERSANDDAT		☐	VRSNDDATUM	☐	IS-M: Shipping Date
18	MENGEINZUO	JVTLFZUO	MENGEINZUO		☐	MENGEINZUO	☐	Sch.line qty in order-delivery assignment for partial susp.
19	ETART	JVTLFZUO	ETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
20	KONDA	JKKD	KONDA		☐	KONDA	☐	Price Group (Customer)
21	AEART	JKEP	AEART		☐	AEART_JSDK	☐	Order Change Type
22	LFMNGTSTAT	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
23	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
24	ETVORZEI	JKEP	ETVORZEI		☐	ETVORZEI	☐	Plus/Minus Sign for Schedule Line Quantity in Sales Order
25	JKPAVONDAT	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
26	JKPABISDAT	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
27	LAND1	JGTSADR	LAND1		☐	LAND1	☐	Country Key
28	REGIO	JGTSADR	REGIO		☐	REGIO	☐	Region (State, Province, County)

Maintenance Status

Access

☑   read only

☐   read and change

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

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in