SAP ABAP View V_LVVOR_REQ (List VAS orders with reference document)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ LE-WM-VAS (Application Component) Value-Added Services
     ⤷ LXVAS (Package) Value Added Services

Basic Data

View Type	D	Database View
Database View	V_LVVOR_REQ
Short Description	List VAS orders with reference document
Root table	LVVOR	VAS orders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LVVOR	LVVOR
2	LVVRO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LVVOR	MANDT	JL	EQ				0	0
2	LVVRO	MANDT	JR	EQ			AND	0	0
3	LVVOR	LGNUM	JL	EQ				0	0
4	LVVRO	LGNUM	JR	EQ			AND	0	0
5	LVVOR	VORID	JL	EQ				0	0
6	LVVRO	VORID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LVVOR	MANDT		☐	MANDT	☐	Client
2	LGNUM	LVVOR	LGNUM		☐	LEINT_LGNUM	☐	Warehouse Number
3	VORID	LVVOR	VORID		☐	LXVAS_VORID	☐	VAS Order
4	DOCNR	LVVRO	DOCNR		☐	LEINT_DOCNR	☐	Reference Document
5	DOCIT	LVVRO	DOCIT		☐	LXHME_DOCIT	☐	Reference Document Item
6	DOCTY	LVVRO	DOCTY		☐	LXHME_DOCTY	☐	Reference Document Type
7	WRKST	LVVOR	WRKST		☐	LXHME_WRKST	☐	Work Center
8	STORD	LVVOR	STORD		☐	LXVAS_STORD	☐	VAS Order Status
9	PACKNR	LVVOR	PACKNR		☐	LXHME_PACKNR	☐	Unique Internal Packing Object Number
10	PIID	LVVOR	PIID		☐	LEINT_PIID	☐	VAS Template
11	WCSEQ	LVVOR	WCSEQ		☐	LXVAS_WCSEQ	☐	Work Center Sequence
12	ACTSQ	LVVOR	ACTSQ		☐	LXVAS_ACTSQ	☐	VAS Template Sequence
13	ACTDU	LVVOR	ACTDU		☐	LXVAS_ACTDU	☐	Actual duration of VAS order
14	BILLB	LVVOR	BILLB		☐	LXVAS_BILLB	☐	Business Partner (Customer or Vendor) to be Billed
15	CRETS	LVVOR	CRETS		☐	LXHME_CRETS	☐	Record Creation Time Stamp
16	CREUN	LVVOR	CREUN		☐	LXHME_CREUN	☐	Created By
17	UPDTS	LVVOR	UPDTS		☐	LXHME_UPDTS	☐	Record Update Time Stamp
18	UPDUN	LVVOR	UPDUN		☐	LXHME_UPDUN	☐	Last Modified by
19	UPSTS	LVVOR	UPSTS		☐	LXHME_UPSTS	☐	Status Update Time Stamp
20	WORKR	LVVOR	WORKR		☐	LXHME_WORKR	☐	Last Status Modified By
21	PROCO	LVVRO	PROCO		☐	LXVAS_PROCESSED	☐	Reference Document Checked for VAS Requirements
22	EXEMT	LVVOR	EXEMT		☐	LXVAS_EXEMT	☐	VAS Execution Method

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