SAP ABAP View VSAUFK ("Order Selection by Status")

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KAUF (Package) Cost Accounting, Orders

Basic Data

View Type	D	Database View
Database View	VSAUFK
Short Description	"Order Selection by Status"
Root table	JEST	Individual Object Status

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JEST	JEST
2	ONR00
3	ONROR
4	AUFK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ONR00	MANDT	JL	EQ				0	0
2	JEST	MANDT	JR	EQ			AND	0	0
3	ONR00	OBJNR	JL	EQ				0	0
4	JEST	OBJNR	JR	EQ			AND	0	0
5	ONR00	MANDT	JL	EQ				0	0
6	ONROR	MANDT	JR	EQ			AND	0	0
7	ONR00	OBJNR	JL	EQ				0	0
8	ONROR	OBJNR	JR	EQ			AND	0	0
9	AUFK	MANDT	JL	EQ				0	0
10	ONROR	MANDT	JR	EQ			AND	0	0
11	AUFK	AUFNR	JL	EQ				0	0
12	ONROR	AUFNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JEST	MANDT		☐	MANDT	☐	Client
2	OBJNR	JEST	OBJNR		☐	J_OBJNR	☐	Object number
3	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
4	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
5	AUFNR	ONROR	AUFNR		☐	AUFNR	☐	Order Number
6	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
7	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
8	KTEXT	AUFK	KTEXT		☐	AUFTEXT	☐	Description
9	BUKRS	AUFK	BUKRS		☐	BUKRS	☐	Company Code
10	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
11	GSBER	AUFK	GSBER		☐	GSBER	☐	Business Area
12	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
13	ASTKZ	AUFK	ASTKZ		☐	AUFSTKZ	☐	Identifier for statistical order
14	WAERS	AUFK	WAERS		☐	AUFWAERS	☐	Order Currency
15	ASTNR	AUFK	ASTNR		☐	AUFASTNR	☐	Order status
16	VOGRP	AUFK	VOGRP		☐	AUFSPSET	☐	Group of disallowed transactions
17	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag

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