SAP ABAP Table VIORD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIORD	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	AUFK
3	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
4	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
5	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
6	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
7	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
8	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
9	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
10	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
11	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
12	APGRP	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	T024A
13	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
14	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
15	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
16	ANING	☐	ANING	USNAM	CHAR	12	0	Name of Person Reponsible for System
17	GAUZT	☐	GAUZT	FLTP	FLTP	16	16	Planned downtime in hours
18	GAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
19	ANLBD	☐	ANLBD	DATUM	DATS	8	0	Date until which the system is available
20	ANLVD	☐	ANLVD	DATUM	DATS	8	0	Date from which the system is available
21	ANLBZ	☐	ANLBZ	UHRZT	TIMS	6	0	Time until which the system is available
22	ANLVZ	☐	ANLVZ	UHRZT	TIMS	6	0	Time from Which System is Available
23	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
24	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
25	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
26	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
27	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
28	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
29	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
30	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	T352R
31	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
32	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
33	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
34	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
35	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
36	HISDA	☐	HISDA	DATUM	DATS	8	0	PM request: History date
37	AKKNZ	☐	AKKNZ	AKKNZ	CHAR	1	0	Order Category Indicator Plant Maintenance
38	PLKNZ	☐	AUF_PLKNZ	AUF_PLKNZ	CHAR	1	0	Maintenance order planning indicator
39	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
40	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
41	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
42	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
43	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
44	RSUPG	☐	RSUPG	XFIELD	CHAR	1	0	Upgrade Order Indicator
45	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
46	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
47	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
48	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
49	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
50	REFNR	☐	AUFREFNR	AUFNR	CHAR	12	0	Reference order number	AUFK
51	ERNAM	☐	AUFERFNAM	USNAM	CHAR	12	0	Entered by
52	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
53	AENAM	☐	AUFAENAM	USNAM	CHAR	12	0	Last changed by
54	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
55	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
56	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
57	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
58	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
59	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
60	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
61	CCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key
62	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
63	STORT	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
64	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
65	ASTKZ	☐	AUFSTKZ	XFELD	CHAR	1	0	Identifier for statistical order
66	WAERS	☐	AUFWAERS	WAERS	CUKY	5	0	Order Currency	TCURC
67	STDAT	☐	AUFSTDAT	DATUM	DATS	8	0	Date of last status change
68	IDAT1	☐	AUFIDAT1	DATUM	DATS	8	0	Release date
69	IDAT2	☐	AUFIDAT2	DATUM	DATS	8	0	Technical completion date
70	IDAT3	☐	AUFIDAT3	DATUM	DATS	8	0	Close date
71	OBJID	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
72	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
73	PLGKZ	☐	PLGKZ	XFELD	CHAR	1	0	Identifier for planning with line items
74	KVEWE	☐	KVEWE	KVEWE	CHAR	1	0	Usage of the Condition Table	T681V
75	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
76	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	T683
77	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
78	ABKRS	☐	AUFABKRS	AKREIS	NUMC	2	0	Processing group	TKO08
79	KSTAR	☐	AUFKSTAR	KSTAR	CHAR	10	0	Settlement cost element	CSKB
80	KOSTL	☐	AUFKOSTL	KOSTL	CHAR	10	0	Cost center for basic settlement	CSKS
81	SETNM	☐	AUFSETNM	SETNR	CHAR	12	0	Allocation set
82	CYCLE	☐	ST_KOSTL	KOSTL	CHAR	10	0	Cost center to which costs are actually posted	CSKS
83	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
84	SEQNR	☐	AUFSEQNR	SQNR	NUMC	4	0	Sequence number	*
85	USER4	☐	AUFUSER4	AUFUSER4	CURR	11	2	Estimated total costs of order
86	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
87	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
88	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
89	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
90	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
91	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
92	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
93	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
94	PLINT	☐	PLINT	XFELD	CHAR	1	0	Indicator for Integrated Planning
95	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
96	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
97	AUFEX	☐	AUFEX	AUFEX	CHAR	20	0	External order number
98	IVPRO	☐	IM_PROFIL	IM_PROFIL	CHAR	6	0	Investment measure profile	TAPRF
99	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
100	FLG_MLTPS	☐	CO_MLTPS	KREUZ	CHAR	1	0	Order with multiple items
101	ABUKR	☐	IM_ABUKRS	BUKRS	CHAR	4	0	Requesting company code	T001
102	SIZECL	☐	IM_SIZECL	SIZECL	CHAR	2	0	Scale of investment objects	TAIF5
103	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
104	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
105	KSTEMPF	☐	CO_KSTEMPF	CO_KSTEMPF	CHAR	1	0	Indicator: Direct cost collector
106	ZSCHM	☐	PS_ZSCHM	PS_ZSCHM	CHAR	7	0	Interest Profile for Project/Order Interest Calculation	TPI01
107	PKOSA	☐	PKOSA_D	AUFNR	CHAR	12	0	Cost collector for production process PROCNR	*
108	ANFAUFNR	☐	AUFANFNR	AUFNR	CHAR	12	0	Requesting order	AUFK
109	PROCNR	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process	*
110	PROTY	☐	CKML_PROZESS_TYP	CKML_PROZESS_TYP	CHAR	4	0	Process Category (Procurement/Consumption)	*
111	RSORD	☐	RSORD	XFELD	CHAR	1	0	Refurbishment order indicator (PM)
112	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
113	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
114	ERFZEIT	☐	CO_INS_TIME	UZEIT	TIMS	6	0	Time created
115	AEZEIT	☐	CO_CHG_TIME	UZEIT	TIMS	6	0	Changed at
116	CSTG_VRNT	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	*
117	COSTESTNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
118	VERAA_USER	☐	VERAA_USER	XUBNAME	CHAR	12	0	Person Responsible for CO Internal Order	USR02
119	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
120	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
121	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
122	OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
123	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
124	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
125	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
126	/CUM/INDCU	☐	/CUM/INDCU	FLAG	CHAR	1	0	CU: Order is Used for Compatible Units
127	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
128	/CUM/AUEST	☐	/CUM/AUEST	FLAG	CHAR	1	0	CU: Automatic Copy of Estimated Costs
129	/CUM/DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number	*
130	VAPLZ	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
131	WAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	*
132	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIORD	ABGSL	TKKAA	ABGSL	REF	C	CN
2	VIORD	ABKRS	TKO08	ABKRS	REF	1	CN
3	VIORD	ABUKR	T001	BUKRS		1	CN
4	VIORD	ANFAUFNR	AUFK	AUFNR	REF	1	CN
5	VIORD	ANLZU	T357M	ANLZU	REF	C	CN
6	VIORD	APGRP	T024A	FEVOR	REF	C	CN
7	VIORD	ARTPR	T356A	ARTPR	REF	C	CN
8	VIORD	AUART	T003O	AUART	REF	1	CN
9	VIORD	AUFNR	AUFK	AUFNR	KEY	1	CN
10	VIORD	AWSLS	TKV01	AWSLS	REF	C	CN
11	VIORD	BAUTL	MARA	MATNR	REF	C	CN
12	VIORD	BEMOT	TBMOT	BEMOT
13	VIORD	BUKRS	T001	BUKRS	REF	1	CN
14	VIORD	CYCLE	CSKS	KOSTL		1	CN
15	VIORD	EQUNR	EQUI	EQUNR	REF	C	CN
16	VIORD	ETYPE	T8JG	ETYPE	REF	C	CN
17	VIORD	FERC_IND	FERC_C7	IND	REF
18	VIORD	FUNC_AREA	TFKB	FKBER
19	VIORD	GAUEH	T006	MSEHI	REF	C	CN
20	VIORD	GEWRK	CRID	OBJID	REF	C	CN
21	VIORD	GSBER	TGSB	GSBER	REF	1	CN
22	VIORD	ILART	T353I	ILART	REF	C	CN
23	VIORD	ILOAN	ILOA	ILOAN	REF	C	CN
24	VIORD	INGPR	T024I	INGRP	REF	C	CN
25	VIORD	IVPRO	TAPRF	IVPRO	REF	C	CN
26	VIORD	IWERK	T399I	IWERK	REF	C	CN
27	VIORD	IZWEK	T087I	IZWEK		1	CN
28	VIORD	JV_JIBCL	T8J6A	CLASS	REF	C	CN
29	VIORD	JV_JIBSA	T8J6C	SUBCLASS	REF	C	CN
30	VIORD	KALSM	T683	KALSM	REF	1	CN
31	VIORD	KAPPL	T681A	KAPPL	REF	1	CN
32	VIORD	KDAUF	VBUK	VBELN		1	CN
33	VIORD	KOKRS	TKA01	KOKRS	REF	1	CN
34	VIORD	KOSTL	CSKS	KOSTL		1	CN
35	VIORD	KOSTV	CSKS	KOSTL		1	CN
36	VIORD	KSTAR	CSKB	KSTAR		1	CN
37	VIORD	KUNUM	KNA1	KUNNR	REF	C	CN
38	VIORD	KVEWE	T681V	KVEWE	REF	1	CN
39	VIORD	LAUFN	AUFK	AUFNR	REF	C	CN
40	VIORD	LOGSYSTEM	TBDLS	LOGSYS	REF	1	CN
41	VIORD	MANDT	T000	MANDT	KEY	1	CN
42	VIORD	OBJNR	ONR00	OBJNR	REF	1	1
43	VIORD	OBKNR	SER00	OBKNR
44	VIORD	PRCTR	CEPC	PRCTR		1	CN
45	VIORD	PRIOK	T356	PRIOK	REF	C	CN
46	VIORD	PSPEL	PRPS	PSPNR	REF	C	CN
47	VIORD	QMNUM	QMEL	QMNUM	REF	C	CN
48	VIORD	RECID	T8JJ	RECID	REF	C	CN
49	VIORD	REFNR	AUFK	AUFNR	REF	1	CN
50	VIORD	REVNR	T352R	REVNR	REF	C	CN
51	VIORD	SCREENTY	TQBT	SCREENTY
52	VIORD	SERMAT	MARA	MATNR
53	VIORD	SIZECL	TAIF5	SIZECL		1	CN
54	VIORD	SOWRK	T001W	WERKS	REF	1	CN
55	VIORD	STORT	T499S	STAND	REF	1	CN
56	VIORD	TXJCD	TTXJ	TXJCD
57	VIORD	UMWKZ	T087K	UMWKZ		1	CN
58	VIORD	VERAA_USER	USR02	BNAME
59	VIORD	VNAME	T8JV	VNAME	REF	C	CN
60	VIORD	WAERS	TCURC	WAERS	REF	1	CN
61	VIORD	WARPL	MPLA	WARPL	REF	C	CN
62	VIORD	WERKS	T001W	WERKS	REF	1	CN
63	VIORD	ZSCHM	TPI01	ZSCHM	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in