SAP ABAP View JVVAUFZUO (IS-M/SD: Read Orders for Standard Delivery Exception)

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	JVVAUFZUO
Short Description	IS-M/SD: Read Orders for Standard Delivery Exception
Root table	JVTLFZUO	IS-M/SD: Assignment of Delivery to Schedule Line

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JVTLFZUO	JVTLFZUO
2	JKAP
3	JKEP
4	JKPA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAP	MANDT	JL	EQ				0	0
2	JVTLFZUO	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JVTLFZUO	VBELN	JR	EQ			AND	0	0
5	JKAP	POSNR	JL	EQ				0	0
6	JVTLFZUO	POSNR	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	JKPA	MANDT	JR	EQ			AND	0	0
17	JKAP	VBELN	JL	EQ				0	0
18	JKPA	VBELN	JR	EQ			AND	0	0
19	JKAP	POSNR	JL	EQ				0	0
20	JKPA	POSNR	JR	EQ			AND	0	0
21	JKPA	JPARVW		EQ	'WE'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JVTLFZUO	MANDT		☐	MANDT	☐	Client
2	LFNGNR	JVTLFZUO	LFNGNR		☐	LFNGNR	☐	IS-M: Sequence Number for Delivery
3	NACHLFNGNR	JVTLFZUO	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	MENGEINZUO	JVTLFZUO	MENGEINZUO		☐	MENGEINZUO	☐	Sch.line qty in order-delivery assignment for partial susp.
8	ETART	JVTLFZUO	ETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
9	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
10	PVA	JKAP	PVA		☐	PVA	☐	Edition
11	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
12	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
13	ETVORZEI	JKEP	ETVORZEI		☐	ETVORZEI	☐	Plus/Minus Sign for Schedule Line Quantity in Sales Order
14	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
15	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
16	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
17	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
18	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
19	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
20	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
21	XLIEFBEZ	JKAP	XLIEFBEZ		☐	XLIEFBEZ	☐	IS-M: Delivery to a carrier route (reserve)
22	JPARVW	JKPA	JPARVW		☐	JPARVW	☐	IS-M: Business Partner Role
23	GUELTIGVON	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
24	GUELTIGBIS	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
25	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
26	ADRESSVAR	JKPA	ADRESSVAR		☐	ADRESSVAR	☐	IS-M: Address Variant
27	BZTYP_AUFT	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
28	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
29	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element

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	20110901
SAP Release Created in