SAP ABAP Table VIMPOS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIMPOS	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	WAPOS	☑	WAPOS	POSNU	CHAR	16	0	Maintenance item
3	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
4	WSTRA	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
5	WPPOS	☐	WPPOS	WPPOS	NUMC	4	0	Item in the maintenance plan
6	PSTXT	☐	POSTXT	TEXT40	CHAR	40	0	Item Short Text
7	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
8	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number
9	ERKNZ	☐	ERKNZ	FLAG	CHAR	1	0	Creation indicator
10	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERSDT	☐	EDATUM	DATUM	DATS	8	0	Date of creation
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
16	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
17	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
18	STATUS	☐	MPSTAT	FLAG	CHAR	1	0	Maintenance Item Status
19	LTKNZ	☐	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
20	WPGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
21	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
22	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
23	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
24	LANGU	☐	MPLANGU	SPRAS	LANG	1	0	Language key of the long text
25	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
26	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
27	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
28	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
29	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition
30	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
31	INACT	☐	INACT	FLAG	CHAR	1	0	Indicator that maintenance item is inactive
32	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
33	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
34	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
35	IND_ABRVO	☐	IND_ABRVO	CHAR01	CHAR	1	0	Indicator showing settlement rule maintained
36	PSPEL	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
37	STD_NETZ	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
38	STD_AVO	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
39	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
40	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
41	MITYP	☐	MITYP	CHAR2	CHAR	2	0	Maintenance item category	T399P
42	BSTNR	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number
43	BSTPO	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number
44	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number
45	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
46	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
47	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element
48	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order
49	APFKT	☐	APFKT	AFAKT	DEC	3	0	Execution factor for whole task list
50	SCRRENTY	☐	SCREENTY	CHAR4	CHAR	4	0	SCREEN TYPE: for order-order category (see domain)
51	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
52	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
53	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
54	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
55	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
56	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number
57	TASK_DETERMINE	☐	TASK_DETERMINE	CHAR1	CHAR	1	0	Automatic task determination in the notification
58	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
59	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding
60	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding
61	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
62	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number
63	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type
64	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
65	TSTMP_BW	☐	TSTMP_BW_EXT	RKE_TSTMP	DEC	16	0	Time Stamp for BI Delta Extraction
66	NO_AUFRELKZ	☐	NO_AUFRELKZ	XFELD	CHAR	1	0	Do Not Release Immediately
67	DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number
68	CYCLESEQIND	☐	CYCLESETSEQ	NUMC2	NUMC	2	0	Cycle Set Sequence
69	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS
70	IND_MPOS_API	☐	IND_MPOS_API	IND_API	CHAR	2	0	Maintenance Item Was Created/Changed by API
71	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
72	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
73	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
74	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
75	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
76	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
77	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
78	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
79	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
80	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
81	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
82	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
83	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
84	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
85	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
86	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
87	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
88	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
89	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
90	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
91	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
92	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
93	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
94	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
95	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
96	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
97	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
98	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
99	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
100	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
101	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
102	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
103	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
104	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
105	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
106	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
107	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
108	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
109	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
110	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
111	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
112	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
113	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
114	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
115	IGSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
116	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	VIMPOS	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIMPOS	ADRNR	ADRC	ADDRNUMBER	REF	1	CN
3	VIMPOS	ANLNR	ANLH	ANLN1	REF	C	CN
4	VIMPOS	ANLUN	ANLA	ANLN2	REF	C	CN
5	VIMPOS	AUART	T003O	AUART	REF	C	CN
6	VIMPOS	BAUTL	MARA	MATNR	REF	C	CN
7	VIMPOS	BEBER	T357	BEBER	REF	C	CN
8	VIMPOS	BUKRS	T001	BUKRS	REF	C	CN
9	VIMPOS	DAUFN	AUFK	AUFNR	REF	C	CN
10	VIMPOS	EQUNR	EQUI	EQUNR	REF	C	CN
11	VIMPOS	GEWRK	CRID	OBJID	REF	C	CN
12	VIMPOS	GSBER	TGSB	GSBER
13	VIMPOS	IAUFNR	AUFK	AUFNR	REF	C	CN
14	VIMPOS	IGSBER	TGSB	GSBER	REF	C	CN
15	VIMPOS	ILART	T353I	ILART	REF	C	CN
16	VIMPOS	ILOAN	ILOA	ILOAN	REF	C	CN
17	VIMPOS	IWERK	T399I	IWERK	REF	C	CN
18	VIMPOS	KOKRS	TKA01	KOKRS	REF	C	CN
19	VIMPOS	KOSTL	CSKS	KOSTL	REF	C	CN
20	VIMPOS	LAUFN	AUFK	AUFNR	REF	C	CN
21	VIMPOS	MANDT	T000	MANDT	KEY	1	CN
22	VIMPOS	MITYP	T399P	MITYP
23	VIMPOS	OBJNR	ONR00	OBJNR	REF	C	1
24	VIMPOS	PLNTY	TCA01	PLNTY	REF	C	CN
25	VIMPOS	PPSID	CRID	OBJID	REF	C	CN
26	VIMPOS	PRIOK	T356	PRIOK	REF	C	CN
27	VIMPOS	PROID	PRPS	PSPNR		C	CN
28	VIMPOS	QMART	TQ80	QMART
29	VIMPOS	QMNUM	QMEL	QMNUM
30	VIMPOS	SERMAT	MARA	MATNR
31	VIMPOS	SPART	TVTA	SPART	REF	1	CN
32	VIMPOS	STORT	T499S	STAND	REF	C	CN
33	VIMPOS	SWERK	T001W	WERKS	REF	1	CN
34	VIMPOS	TPLNR	IFLOT	TPLNR	REF	C	CN
35	VIMPOS	VKBUR	TVKBZ	VKBUR	REF	1	CN
36	VIMPOS	VKGRP	TVBVK	VKGRP	REF	1	CN
37	VIMPOS	VKORG	TVKO	VKORG	REF	1	CN
38	VIMPOS	VTWEG	TVKOV	VTWEG	REF	1	CN
39	VIMPOS	WAERS	TCURC	WAERS
40	VIMPOS	WARPL	MPLA	WARPL	REF	C	CN
41	VIMPOS	WPGRP	T024I	INGRP	REF	C	CN
42	VIMPOS	WSTRA	T351	STRAT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in