SAP ABAP Table /CUM/VIAUF_AFVC_VIEW_STRUC (Internal View Structure on VIAUF_AFVC + CU Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /CUM/ORDER (Package) Compatible unit order maintenance

Basic Data

Table Category	INTTAB	Structure
Structure	/CUM/VIAUF_AFVC_VIEW_STRUC	Table Relationship Diagram
Short Description	Internal View Structure on VIAUF_AFVC + CU Data

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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
4	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
5	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
6	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
7	IPHAS	☐	PM_PHASE	PM_PHASE	CHAR	1	0	Maintenance Processing Phase
8	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
9	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
10	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
11	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
12	INGPR	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
13	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
14	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
15	ADDAT	☐	ADDAT	DATUM	DATS	8	0	PM Order: Reference Date
16	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
17	STORT	☐	AUFSTORT	AP_STAND	CHAR	10	0	Location	T499S
18	SOWRK	☐	AUFSOWRK	WERKS	CHAR	4	0	Location plant	T001W
19	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
20	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
21	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
22	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
23	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
24	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
25	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
26	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
27	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
28	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
29	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
30	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
31	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
32	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
33	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
34	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
35	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
36	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
37	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
38	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
40	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
41	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
42	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
43	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
44	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
45	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
46	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
47	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
48	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
49	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
50	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
51	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
52	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
53	SELKZ	☐	CO_SELKZ	CK_SELKZ	CHAR	1	0	Selection indicator for costing line items	TCK08
54	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
55	ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly	MARA
56	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
57	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
58	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
59	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
60	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
61	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
62	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
63	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
64	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
65	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
66	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
67	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
68	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
69	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
70	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
71	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
72	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
73	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
74	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
75	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
76	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
77	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
78	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
79	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
80	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
81	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
82	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
83	NTEND	☐	VORGABEEND2	VORGABEEND	DATS	8	0	Constraint for Finish of Activity (Basic)
84	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
85	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
86	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
87	ADRNRA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
88	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
89	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
90	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
91	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
92	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
93	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
94	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
95	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
96	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
97	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
98	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
99	ADUHR	☐	ADUHR	UZEIT	TIMS	6	0	Time of Reference Date
100	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
101	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
102	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	CSKS
103	/CUM/CMNUM	☐	/CUM/CMNUM	/CUM/CMNUM	CHAR	12	0	CU: Construction Measure Number
104	/CUM/CUGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)	/CUM/AFCU
105	CUGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
106	CU_ID	☐	/CUM/CU_ID	/CUM/CU_ID	CHAR	18	0	CU: Compatible Unit ID	*
107	PLNAL	☐	/CUM/PLNAL	ALTNR	CHAR	2	0	CU: Group Counter for Plant in Task List
108	CU_TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
109	CU_EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
110	SUPCUGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
111	PARCUGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
112	CUITXT	☐	/CUM/CUITXT	CHAR40	CHAR	40	0	CU: Description of Compatible Unit Instance
113	DESGUID	☐	/CUM/DESGUID	SYSUUID	RAW	16	0	CU: GUID of Design Document
114	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/CUM/VIAUF_AFVC_VIEW_STRUC	/CUM/CUGUID	/CUM/AFCU	CUGUID	KEY	1	CN
2	/CUM/VIAUF_AFVC_VIEW_STRUC	ANLZU	T357M	ANLZU
3	/CUM/VIAUF_AFVC_VIEW_STRUC	ARBEH	T006	MSEHI
4	/CUM/VIAUF_AFVC_VIEW_STRUC	ARBID	CRID	OBJID
5	/CUM/VIAUF_AFVC_VIEW_STRUC	ARTPR	T356A	ARTPR	REF	C	CN
6	/CUM/VIAUF_AFVC_VIEW_STRUC	AUART	T003O	AUART	REF	1	CN
7	/CUM/VIAUF_AFVC_VIEW_STRUC	AUFNR	AUFK	AUFNR	KEY	1	CN
8	/CUM/VIAUF_AFVC_VIEW_STRUC	BAUTL	MARA	MATNR	REF	C	CN
9	/CUM/VIAUF_AFVC_VIEW_STRUC	BEMOT	TBMOT	BEMOT
10	/CUM/VIAUF_AFVC_VIEW_STRUC	BNFPO	EBAN	BNFPO
11	/CUM/VIAUF_AFVC_VIEW_STRUC	BUKRS	T001	BUKRS
12	/CUM/VIAUF_AFVC_VIEW_STRUC	DAUME	T006	MSEHI
13	/CUM/VIAUF_AFVC_VIEW_STRUC	DAUNE	T006	MSEHI
14	/CUM/VIAUF_AFVC_VIEW_STRUC	EKGRP	T024	EKGRP
15	/CUM/VIAUF_AFVC_VIEW_STRUC	EKORG	T024E	EKORG
16	/CUM/VIAUF_AFVC_VIEW_STRUC	EQUNR	EQUI	EQUNR	REF	C	CN
17	/CUM/VIAUF_AFVC_VIEW_STRUC	INFNR	EINA	INFNR
18	/CUM/VIAUF_AFVC_VIEW_STRUC	INGPR	T024I	INGRP	REF	C	CN
19	/CUM/VIAUF_AFVC_VIEW_STRUC	ISTRU	MARA	MATNR
20	/CUM/VIAUF_AFVC_VIEW_STRUC	IWERK	T399I	IWERK	REF	C	CN
21	/CUM/VIAUF_AFVC_VIEW_STRUC	KOKRS	TKA01	KOKRS	REF	1	CN
22	/CUM/VIAUF_AFVC_VIEW_STRUC	KOSTV	CSKS	KOSTL		1	CN
23	/CUM/VIAUF_AFVC_VIEW_STRUC	KTSCH	T435	VLSCH
24	/CUM/VIAUF_AFVC_VIEW_STRUC	LIFNR	LFA1	LIFNR
25	/CUM/VIAUF_AFVC_VIEW_STRUC	LOGRP	T421	LOGRP
26	/CUM/VIAUF_AFVC_VIEW_STRUC	MANDT	T000	MANDT	KEY	1	CN
27	/CUM/VIAUF_AFVC_VIEW_STRUC	MATKL	T023	MATKL
28	/CUM/VIAUF_AFVC_VIEW_STRUC	MEINH	T006	MSEHI
29	/CUM/VIAUF_AFVC_VIEW_STRUC	OBJNR	ONR00	OBJNR
30	/CUM/VIAUF_AFVC_VIEW_STRUC	PRIOK	T356	PRIOK	REF	C	CN
31	/CUM/VIAUF_AFVC_VIEW_STRUC	QUALF	T423	QUALF
32	/CUM/VIAUF_AFVC_VIEW_STRUC	SAKTO	CSKA	KSTAR
33	/CUM/VIAUF_AFVC_VIEW_STRUC	SELKZ	TCK08	SELKZ
34	/CUM/VIAUF_AFVC_VIEW_STRUC	SERMAT	MARA	MATNR
35	/CUM/VIAUF_AFVC_VIEW_STRUC	SOWRK	T001W	WERKS	REF	1	CN
36	/CUM/VIAUF_AFVC_VIEW_STRUC	STEUS	T430	STEUS
37	/CUM/VIAUF_AFVC_VIEW_STRUC	STORT	T499S	STAND	REF	1	CN
38	/CUM/VIAUF_AFVC_VIEW_STRUC	SWERK	T001W	WERKS	REF	1	CN
39	/CUM/VIAUF_AFVC_VIEW_STRUC	TPLNR	IFLOT	TPLNR	REF	C	CN
40	/CUM/VIAUF_AFVC_VIEW_STRUC	TXTSP	T002	SPRAS
41	/CUM/VIAUF_AFVC_VIEW_STRUC	WAERS	TCURC	WAERS
42	/CUM/VIAUF_AFVC_VIEW_STRUC	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130603
SAP Release Created in	700