SAP ABAP View VJAUFK (View "Order on Status")

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

View Type	D	Database View
Database View	VJAUFK
Short Description	View "Order on Status"
Root table	AUFK	Order master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFK	AUFK
2	AFPO
3	AFKO
4	JEST

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AUFK	MANDT		☐	MANDT	☐	Client
2	AUFNR	AUFK	AUFNR		☐	AUFNR	☐	Order Number
3	OBJNR	AUFK	OBJNR		☐	J_OBJNR	☐	Object number
4	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
5	POSNR	AFPO	POSNR		☐	CO_POSNR	☐	Order item number
6	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
7	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
8	KTEXT	AUFK	KTEXT		☐	AUFTEXT	☐	Description
9	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
10	GSTRS	AFKO	GSTRS		☐	CO_GSTRS	☐	Scheduled start
11	GLTRS	AFKO	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
12	FTRMS	AFKO	FTRMS		☐	CO_FTRMS	☐	Scheduled release date
13	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
14	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
15	APRIO	AFKO	APRIO		☐	CO_APRIO	☐	Order priority
16	GAMNG	AFKO	GAMNG		☐	GAMNG	☐	Total order quantity
17	GMEIN	AFKO	GMEIN		☐	MEINS	☐	Base Unit of Measure
18	MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
19	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
20	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
21	MAUFNR	AFKO	MAUFNR		☐	MAUFNR	☐	Number of superior order
22	PRODNET	AFKO	PRODNET		☐	CO_PRODNET	☐	Indicator: Order is part of collective order
23	LEAD_AUFNR	AFKO	LEAD_AUFNR		☐	CO_LAUFNR	☐	Leading order in current processing
24	GLTRI	AFKO	GLTRI		☐	CO_GLTRI	☐	Actual finish date
25	GLTRP	AFKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
26	KDAUF	AFPO	KDAUF		☐	CO_KDAUF	☐	Sales order number
27	KDPOS	AFPO	KDPOS		☐	CO_KDPOS	☐	Sales order item
28	PROJN	AFPO	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS 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	20130529
SAP Release Created in