SAP ABAP Table VIMPLA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIMPLA	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	WARPL	☑	WARPL	WARPL	CHAR	12	0	Maintenance Plan
3	ERKNZ	☑	ERKNZ	FLAG	CHAR	1	0	Creation indicator
4	AEKNZ	☑	AEKNZ	FLAG	CHAR	1	0	Change indicator
5	ERSDT	☑	EDATUM	DATUM	DATS	8	0	Date of creation
6	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	AEDAT	☑	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☑	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	WPTXT	☑	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
10	STRAT	☑	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
11	ABRHO	☑	ABRHO	ANZTA	NUMC	3	0	Scheduling Period
12	KUNUM	☑	KUNUM	KUNNR	CHAR	10	0	Customer Number
13	LTKNZ	☑	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
14	LVORM	☑	ABSTOP	XFELD	CHAR	1	0	Indicator: maintenance plan locked against calls
15	ANZPS	☑	ANZMPOS	WPPOS	NUMC	4	0	Number of maintenance items in the maintenance plan
16	ABNUM	☑	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
17	LANGU	☑	MPLANGU	SPRAS	LANG	1	0	Language key of the long text
18	VSPOS	☑	VERSCHPLUS	NUM3	NUMC	3	0	Shift Factor for Late Completion
19	VSNEG	☑	VERSCHNEG	NUM3	NUMC	3	0	Shift Factor for Early Completion
20	TOPOS	☑	TOLERPLUS	NUM3	NUMC	3	0	Tolerance for Late Completion (%)
21	TONEG	☑	TOLERNEG	NUM3	NUMC	3	0	Tolerance for Early Completion (%)
22	SFAKT	☑	SFAKT	SFAKT	DEC	3	2	Cycle modification factor
23	STICH	☑	TERMKNZ	TERMKNZ	CHAR	1	0	Scheduling indicator
24	TGOON	☑	TGON	NUM3	NUMC	3	0	Scheduling to reoccur when lead float reached
25	HORIZ	☑	HORIZONT	NUM3	NUMC	3	0	Call horizon for maintenance plan calls
26	HORIZ_DAYS	☑	HORIZONT	NUM3	NUMC	3	0	Call horizon for maintenance plan calls
27	HORIZ_QUALIFIER	☑	EAM_CC_CALLHORIZON_QUALIFIER	EAM_CC_CALLHORIZON_QUALIFIER	CHAR	1	0	Calculation Type of Call Horizon
28	ANDOR	☑	ANDOR	RADIO	CHAR	1	0	Indicator for OR or AND link
29	KNAUT	☑	KNZABR	FLAG	CHAR	1	0	Reserved
30	BEGRU	☑	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
31	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
32	MPTYP	☑	MPTYP	MPTYP	CHAR	2	0	Maintenance plan category	T399W
33	HUNIT	☑	HUNIT	MEINS	UNIT	3	0	Unit in scheduling interval
34	STADT	☑	STADT	DATUM	DATS	8	0	Start date
35	SZAEH	☑	SZAEHC	WZYKL	CHAR	22	0	Start counter reading
36	CALL_CONFIRM	☑	CALL_CONFIRM	CHAR1	CHAR	1	0	Only Create New Call Object After Completing Predecessor
37	PLAN_SORT	☑	PLAN_SORT	CHAR20	CHAR	20	0	Sort field for maintenance plans	T399G
38	FABKL	☑	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
39	PUFFP	☑	PUFF_VORL	NUM3	NUMC	3	0	Lead Float in Days
40	PUFFN	☑	PUFF_NACHL	NUM3	NUMC	3	0	Follow-up float in days
41	START_DATE	☑	DATE_START	DATUM	DATS	8	0	Start Date for Scheduling
42	START_TIME	☑	TIME_START	TIME	TIMS	6	0	Start Time for Scheduling
43	CALL_UPDATE_IND	☑	IND_CALL_UPDATE	XFELD	CHAR	1	0	Indicator for Adapting Basic Dates of Call Object
44	IND_MPLA_API	☑	IND_MPLA_API	IND_API	CHAR	2	0	Maintenance Plan Was Created/Changed by API
45	MCP_SF	☑	MCP_SF	MCP_SF	CHAR	1	0	Shift Factor for Multiple Counter Plan
46	WAPOS	☑	WAPOS	POSNU	CHAR	16	0	Maintenance item
47	WSTRA	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
48	WPPOS	☐	WPPOS	WPPOS	NUMC	4	0	Item in the maintenance plan
49	PSTXT	☐	POSTXT	TEXT40	CHAR	40	0	Item Short Text
50	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
51	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number
52	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
53	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
54	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
55	STATUS	☐	MPSTAT	FLAG	CHAR	1	0	Maintenance Item Status
56	WPGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
57	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
58	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
59	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
60	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
61	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
62	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
63	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
64	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition
65	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
66	INACT	☐	INACT	FLAG	CHAR	1	0	Indicator that maintenance item is inactive
67	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
68	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
69	IND_ABRVO	☐	IND_ABRVO	CHAR01	CHAR	1	0	Indicator showing settlement rule maintained
70	PSPEL	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
71	STD_NETZ	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
72	STD_AVO	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
73	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
74	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
75	MITYP	☐	MITYP	CHAR2	CHAR	2	0	Maintenance item category	T399P
76	BSTNR	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number
77	BSTPO	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number
78	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number
79	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
80	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
81	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element
82	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order
83	APFKT	☐	APFKT	AFAKT	DEC	3	0	Execution factor for whole task list
84	SCRRENTY	☐	SCREENTY	CHAR4	CHAR	4	0	SCREEN TYPE: for order-order category (see domain)
85	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
86	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
87	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
88	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
89	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
90	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number
91	TASK_DETERMINE	☐	TASK_DETERMINE	CHAR1	CHAR	1	0	Automatic task determination in the notification
92	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
93	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding
94	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding
95	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
96	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number
97	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type
98	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
99	TSTMP_BW	☐	TSTMP_BW_EXT	RKE_TSTMP	DEC	16	0	Time Stamp for BI Delta Extraction
100	NO_AUFRELKZ	☐	NO_AUFRELKZ	XFELD	CHAR	1	0	Do Not Release Immediately
101	DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number
102	CYCLESEQIND	☐	CYCLESETSEQ	NUMC2	NUMC	2	0	Cycle Set Sequence
103	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS
104	IND_MPOS_API	☐	IND_MPOS_API	IND_API	CHAR	2	0	Maintenance Item Was Created/Changed by API
105	POS_ERKNZ	☐	ERKNZ	FLAG	CHAR	1	0	Creation indicator
106	POS_AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
107	POS_ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
108	POS_ERSDT	☐	EDATUM	DATUM	DATS	8	0	Date of creation
109	POS_AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
110	POS_AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
111	POS_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
112	POS_LTKNZ	☐	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
113	POS_LANGU	☐	MPLANGU	SPRAS	LANG	1	0	Language key of the long text
114	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
115	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
116	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
117	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
118	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
119	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
120	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
121	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
122	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
123	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
124	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
125	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
126	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
127	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
128	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
129	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
130	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
131	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
132	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
133	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
134	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
135	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
136	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
137	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
138	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
139	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
140	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
141	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
142	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
143	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
144	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
145	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
146	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
147	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
148	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
149	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
150	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
151	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
152	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
153	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
154	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
155	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
156	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
157	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
158	IGSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
159	IAUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMPLA	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIMPLA	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	VIMPLA	ANLNR	ANLH	ANLN1	REF	C	CN
4	VIMPLA	ANLUN	ANLA	ANLN2	REF	C	CN
5	VIMPLA	AUART	T003O	AUART	REF	C	CN
6	VIMPLA	BAUTL	MARA	MATNR	REF	C	CN
7	VIMPLA	BEBER	T357	BEBER	REF	C	CN
8	VIMPLA	BEGRU	T370B	BEGRU	REF	C	CN
9	VIMPLA	BUKRS	T001	BUKRS	REF	C	CN
10	VIMPLA	DAUFN	AUFK	AUFNR	REF	C	CN
11	VIMPLA	EQUNR	EQUI	EQUNR	REF	C	CN
12	VIMPLA	FABKL	TFACD	IDENT	REF	C	CN
13	VIMPLA	GEWRK	CRID	OBJID	REF	C	CN
14	VIMPLA	GSBER	TGSB	GSBER
15	VIMPLA	IAUFNR	AUFK	AUFNR	REF	C	CN
16	VIMPLA	IGSBER	TGSB	GSBER	REF	C	CN
17	VIMPLA	ILART	T353I	ILART	REF	C	CN
18	VIMPLA	ILOAN	ILOA	ILOAN	REF	C	CN
19	VIMPLA	IWERK	T399I	IWERK	REF	C	CN
20	VIMPLA	KOKRS	TKA01	KOKRS	REF	C	CN
21	VIMPLA	KOSTL	CSKS	KOSTL	REF	C	CN
22	VIMPLA	LAUFN	AUFK	AUFNR	REF	C	CN
23	VIMPLA	MANDT	T000	MANDT	KEY	1	CN
24	VIMPLA	MITYP	T399P	MITYP
25	VIMPLA	MPTYP	T399W	MPTYP	KEY	1	CN
26	VIMPLA	PLAN_SORT	T399G	PLAN_SORT	KEY	1	CN
27	VIMPLA	PLNTY	TCA01	PLNTY	REF	C	CN
28	VIMPLA	POS_OBJNR	ONR00	OBJNR	REF	C	1
29	VIMPLA	PPSID	CRID	OBJID	REF	C	CN
30	VIMPLA	PRIOK	T356	PRIOK	REF	C	CN
31	VIMPLA	PROID	PRPS	PSPNR		C	CN
32	VIMPLA	QMART	TQ80	QMART
33	VIMPLA	QMNUM	QMEL	QMNUM
34	VIMPLA	SERMAT	MARA	MATNR
35	VIMPLA	SPART	TVTA	SPART	REF	1	CN
36	VIMPLA	STORT	T499S	STAND	REF	C	CN
37	VIMPLA	STRAT	T351	STRAT	KEY	1	CN
38	VIMPLA	SWERK	T001W	WERKS	REF	1	CN
39	VIMPLA	TPLNR	IFLOT	TPLNR	REF	C	CN
40	VIMPLA	VKBUR	TVKBZ	VKBUR	REF	1	CN
41	VIMPLA	VKGRP	TVBVK	VKGRP	REF	1	CN
42	VIMPLA	VKORG	TVKO	VKORG	REF	1	CN
43	VIMPLA	VTWEG	TVKOV	VTWEG	REF	1	CN
44	VIMPLA	WAERS	TCURC	WAERS
45	VIMPLA	WPGRP	T024I	INGRP	REF	C	CN
46	VIMPLA	WSTRA	T351	STRAT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in