SAP ABAP Table VSAUFK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VSAUFK	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	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
3	STAT	☑	J_STATUS	J_STATUS	CHAR	5	0	Object status
4	INACT	☐	J_INACT	J_INACT	CHAR	1	0	Indicator: Status Is Inactive
5	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
12	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
13	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
14	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
15	ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status
16	VOGRP	☐	AUFSPSET	VOGRP	CHAR	4	0	Group of disallowed transactions
17	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VSAUFK	AUART	T003O	AUART	REF	1	CN
2	VSAUFK	AUFNR	AUFK	AUFNR	REF	1	1
3	VSAUFK	BUKRS	T001	BUKRS	REF	1	CN
4	VSAUFK	GSBER	TGSB	GSBER	REF	1	CN
5	VSAUFK	KOKRS	TKA01	KOKRS	REF	1	CN
6	VSAUFK	MANDT	T000	MANDT	KEY	1	CN
7	VSAUFK	OBJNR	ONR00	OBJNR	KEY	1	CN
8	VSAUFK	WAERS	TCURC	WAERS	REF	1	CN
9	VSAUFK	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in