SAP ABAP View JKVLFNGEV (IS-M/SD: Delivery Assignments (incl.address) for Ret.Orders)

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	JKVLFNGEV
Short Description	IS-M/SD: Delivery Assignments (incl.address) for Ret.Orders
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	JVTLIEFBAR
9	JDTPVA

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	JVTLIEFBAR	MANDT	JL	EQ				0	0
36	JVTLFNG	MANDT	JR	EQ			AND	0	0
37	JVTLIEFBAR	LIEFBARNR	JL	EQ				0	0
38	JVTLFNG	LFBNRAUF	JR	EQ			AND	0	0
39	JDTPVA	MANDT	JL	EQ				0	0
40	JKAP	MANDT	JR	EQ			AND	0	0
41	JDTPVA	DRERZ	JL	EQ				0	0
42	JKAP	DRERZ	JR	EQ			AND	0	0
43	JDTPVA	PVA	JL	EQ				0	0
44	JKAP	PVA	JR	EQ			AND	0	0
45	JKPA	JPARVW		EQ	'WE'		AND	0	0
46	JKPA	PARZA		EQ	'000'		AND	0	0
47	JVTLFNG	AUARTGRP		EQ	'2'		AND	0	0
48	JVTLFNG	MBZART		NE	'3'		AND	0	0
49	JKEP	AEART		NE	'+'			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	DRERZTAT	JVTLFNG	DRERZTAT		☐	DRERZTAT	☐	Actual Publication Delivered
8	PVATAT	JVTLFNG	PVATAT		☐	PVATAT	☐	Actual edition delivered
9	LFARTTAT	JVTLFNG	LFARTTAT		☐	LFARTTAT	☐	Actual delivery type (usually DT for dist.viability set)
10	ERSCHDAT	JVTLFNG	ERSCHDAT		☐	ERSCHDAT	☐	Publication Date
11	KDGRP	JVTLFNG	KNDGRUPPE		☐	KNDGRUPPE	☐	IS-M: Customer Group
12	VKORG	JVTLFNG	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	JVTLFNG	VTWEG		☐	VTWEG	☐	Distribution Channel
14	AUARTGRP	JVTLFNG	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
15	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
16	AG_GPNR	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
17	SPARTDRERZ	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
18	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
19	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
20	AEART	JKEP	AEART		☐	AEART_JSDK	☐	Order Change Type
21	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
22	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
23	ETENR_VG	JKEP	ETENR_VG		☐	AENR_VG	☐	Preceding Schedule Line
24	JKPAVONDAT	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
25	JKPABISDAT	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
26	ADRESSVAR	JKPA	ADRESSVAR		☐	ADRESSVAR	☐	IS-M: Address Variant
27	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
28	WE_GPNR	JKPA	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
29	LAND1	JGTSADR	LAND1		☐	LAND1	☐	Country Key
30	PVA_TXT	JDTPVA	BEZEI10		☐	KBEZPVA	☐	Short text for edition
31	BEZUGSTYP	JVTLFNG	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
32	DRUCKEREI	JVTLFNG	DRUCKEREI		☐	JWERK	☐	Plant
33	LFARTLOG	JVTLFNG	LFARTLOG		☐	LFARTLOG	☐	Logistical delivery type
34	LIEFBARNR	JVTLFNG	LFBNRVBR		☐	LFBNRVBR	☐	Distribution viability set
35	BEZIRK	JVTLFNG	BEZIRKTAT		☐	BEZIRKTAT	☐	Actual Carrier Route
36	GEOEIN	JVTLFNG	GEOEINTAT		☐	GEOEINTAT	☐	Actual Geographical Unit

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