SAP ABAP Table VJAUFK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VJAUFK	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number
3	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	STAT	☑	J_STATUS	J_STATUS	CHAR	5	0	Object status
5	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
6	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
7	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
8	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
11	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
12	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
13	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
14	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
15	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
16	GAMNG	☐	GAMNG	MENG13	QUAN	13	3	Total order quantity
17	GMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
19	INACT	☐	J_INACT	J_INACT	CHAR	1	0	Indicator: Status Is Inactive
20	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
21	MAUFNR	☐	MAUFNR	AUFNR	CHAR	12	0	Number of superior order
22	PRODNET	☐	CO_PRODNET	KREUZ	CHAR	1	0	Indicator: Order is part of collective order
23	LEAD_AUFNR	☐	CO_LAUFNR	AUFNR	CHAR	12	0	Leading order in current processing	AUFK
24	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
25	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
26	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
27	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
28	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VJAUFK	AUART	T003O	AUART	REF	1	CN
2	VJAUFK	DISPO	T024D	DISPO	REF	1	CN
3	VJAUFK	FEVOR	T024F	FEVOR
4	VJAUFK	GMEIN	T006	MSEHI	KEY	1	CN
5	VJAUFK	KDAUF	VBUK	VBELN
6	VJAUFK	KDPOS	VBUP	POSNR
7	VJAUFK	LEAD_AUFNR	AUFK	AUFNR
8	VJAUFK	MANDT	T000	MANDT	KEY	1	CN
9	VJAUFK	MATNR	MARA	MATNR	REF	1	CN
10	VJAUFK	OBJNR	ONR00	OBJNR	REF	1	1
11	VJAUFK	PROJN	PRPS	PSPNR	REF	C	CN
12	VJAUFK	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in