SAP table VIMPOS (Generated Table for View)

SAP table VIMPOS has 2 primary key fields being MANDT,WAPOS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WAPOS Maintenance item CHAR 16 0 WAPOS
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
WSTRA Maintenance Strategy CHAR 6 0 T351 STRAT
WPPOS Item in the maintenance plan NUMC 4 0 WPPOS
PSTXT Item Short Text CHAR 40 0 POSTXT
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
OBKNR Object list number INT8 19 0 OBJKNR
ERKNZ Creation Indicator CHAR 1 0 ERKNZ
AEKNZ Change indicator CHAR 1 0 AEKNZ
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERSDT Date of creation DATS 8 0 EDATUM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
STATUS Maintenance Item Status CHAR 1 0 MPSTAT
LTKNZ Long Text Indicator CHAR 1 0 MPLTX
WPGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
GEWRK Object ID of the Work Center NUMC 8 0 CRID LGWID
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
LANGU Language key of the long text LANG 1 0 MPLANGU
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
ILOAI ILOA Individual CHAR 1 0 ILOAI
LAUFN Order number CHAR 12 0 AUFK LAUFN
BAUTL Assembly CHAR 40 0 MARA BAUTL
ANLZU System Condition CHAR 1 0 ANLZU
AUART Order Type CHAR 4 0 T003O AUFART
INACT Indicator that maintenance item is inactive CHAR 1 0 INACT
ILART Maintenance activity type CHAR 3 0 T353I ILA
GSBER Business Area CHAR 4 0 TGSB GSBER
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
IND_ABRVO Indicator showing settlement rule maintained CHAR 1 0 IND_ABRVO
PSPEL Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
STD_NETZ Key for Task List Group CHAR 8 0 PLNNR
STD_AVO Number of the Task List Node NUMC 8 0 PLNKN
KDAUF Sales Document CHAR 10 0 VBELN_VA
KDPOS Sales Document Item NUMC 6 0 POSNR_VA
MITYP Maintenance item category CHAR 2 0 T399P MITYP
BSTNR Purchase order number CHAR 10 0 BSTNR
BSTPO Purchase order item number NUMC 5 0 BSTPO
PACKNO Package number NUMC 10 0 PACKNO
NETPR Net Price CURR 11 2 NETPR
WAERS Currency Key CUKY 5 0 TCURC WAERS
SAKTO Cost Element CHAR 10 0 KSTAR
AUFNR Settlement order CHAR 12 0 ILOM_ORDST
APFKT Execution factor for whole task list DEC 3 0 APFKT
SCRRENTY SCREEN TYPE: for order-order category (see domain) CHAR 4 0 SCREENTY
SERIALNR Serial Number CHAR 18 0 GERNR
SERMAT Material Number CHAR 40 0 MARA MATNR
DEVICEID Additional Device Data CHAR 40 0 DEVICEID
QMNUM Notification Number CHAR 12 0 QMEL QMNUM
QMART Notification Type CHAR 2 0 TQ80 QMART
LBLNI Entry Sheet Number CHAR 10 0 LBLNI
TASK_DETERMINE Automatic task determination in the notification CHAR 1 0 TASK_DETERMINE
PRIOK Priority CHAR 1 0 T356 PRIOK
QMKAT Catalog Type - Coding CHAR 1 0 QMKAT
QMGRP Code Group - Coding CHAR 8 0 QMGRP
DUMMY_MPOS_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
QMCOD Coding CHAR 4 0 QMCOD
PHYNR Material Sample Number CHAR 12 0 QPHYSPRNR
ART Inspection Type CHAR 8 0 QPART
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
TSTMP_BW Time Stamp for BI Delta Extraction DEC 16 0 TSTMP_BW_EXT
NO_AUFRELKZ Do Not Release Immediately CHAR 1 0 NO_AUFRELKZ
SERVICE_DOCUMENT_TYPE Business Transaction Type CHAR 4 0 CRMT_PROCESS_TYPE
SERVICE_CONTRACT Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
SERVICE_CONTRACT_ITEM Shortened Item Number in Document NUMC 6 0 CRMS4_NUMBER_INT
SERVICE_TEMPLATE Transaction ID CHAR 10 0 CRMT_OBJECT_ID_DB
SERVICE_PRIORITY Activity Priority NUMC 1 0 CRMT_PRIORITY
PRODUCT Product Number CHAR 40 0 PRODUCTNUMBER
DESNUM CU: Design Number CHAR 12 0 /CUM/DESNUM
CYCLESEQIND Cycle Set Sequence NUMC 2 0 CYCLESETSEQ
ADPSP Reference Element PM/PS CHAR 40 0 ADDCOMPARE_CORE
IND_MPOS_API Maintenance Item Was Created/Changed by API CHAR 2 0 IND_MPOS_API
RBNR Catalog Profile CHAR 9 0 RBNR
RBNRI Origin of catalog profile CHAR 1 0 EAM_RBNRI_MITEM
0 Maintenance Plan Category
1 Equipment Master Record
2 Functional Location Master Record
3 Individual Maintenance Catalog
4 Material Master Record
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
ABCKZ ABC Indicator for Technical Object CHAR 1 0 T370C ABCKZ
ABCKZI Data origin for ABC indicator field CHAR 1 0 INH_ABCKZI
EQFNR Sort Field CHAR 30 0 EQFNR
EQFNRI Data origin for sort field CHAR 1 0 INH_EQFNRI
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
SWERKI Data origin for maintenance plant field CHAR 1 0 INH_SWERKI
STORT Location of maintenance object CHAR 10 0 T499S PMLOC
STORTI Data origin for location field CHAR 1 0 INH_STORTI
MSGRP Room CHAR 8 0 RAUMNR
MSGRPI Data origin for room number field CHAR 1 0 INH_MSGRPI
BEBER Plant Section CHAR 3 0 T357 BEBER
BEBERI Data origin for plant section field CHAR 1 0 INH_BEBERI
CR_OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
PPSID Object ID of PP work center NUMC 8 0 CRID PPSID
PPSIDI Data origin for PP work center field CHAR 1 0 INH_PPSIDI
GSBERI Data origin for business area field CHAR 1 0 INH_GSBERI
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOKRSI Data origin for controlling area field CHAR 1 0 INH_KOKRSI
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KOSTLI Data origin for cost center field CHAR 1 0 INH_KOSTLI
PROID Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
PROIDI Data origin for WBS element field CHAR 1 0 INH_PROIDI
BUKRS Company Code CHAR 4 0 T001 BUKRS
BUKRSI Data origin for company code field CHAR 1 0 INH_BUKRSI
ANLNR Main Asset Number CHAR 12 0 ANLH ANLN1
ANLNRI Data origin for asset main no./sub-no. fields CHAR 1 0 INH_ANLNRI
ANLUN Asset Subnumber CHAR 4 0 ANLA ANLN2
ANLUNI Data origin indicator CHAR 1 0 INHER
D Field maintained directly. No data transfer
H Data transfer from superior object
R Data transfer from reference object
DAUFN Standing order number CHAR 12 0 AUFK DAUFN
DAUFNI Data origin of standing order number field CHAR 1 0 INH_DAUFNI
AUFNRI Data origin for settlement order field CHAR 1 0 INH_AUFNRI
TPLNRI Data origin for functional location field CHAR 1 0 INH_TPLNRI
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VKORGI Data origin for sales organization field CHAR 1 0 INH_VKORGI
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
VTWEGI Data origin of distribution channel field CHAR 1 0 INH_VTWEGI
SPART Division CHAR 2 0 TVTA SPART
SPARTI Data origin for division field CHAR 1 0 INH_SPARTI
ADRNR Address Number CHAR 10 0 ADRC AD_ADDRNUM
ADRNRI Data origin for address field CHAR 1 0 INH_ADRNRI
OWNER Object reference indicator CHAR 1 0 ILOM_OWNER
Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
VKBUR Sales office CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
IGSBER Business Area CHAR 4 0 TGSB GSBER
IAUFNR Settlement order CHAR 12 0 AUFK ILOM_ORDST

VIMPOS foreign key relationships

Table Field Check Table Check Field
0 VIMPOS ABCKZ T370C ABC indicator for technical objects MANDT
1 VIMPOS ADRNR ADRC Addresses (Business Address Services) DATE_FROM
1 VIMPOS ADRNR ADRC Addresses (Business Address Services) NATION
0 VIMPOS ANLNR ANLH Main asset number BUKRS
0 VIMPOS ANLNR ANLH Main asset number ANLN1
1 VIMPOS ANLUN ANLA Asset Master Record Segment BUKRS
1 VIMPOS ANLUN ANLA Asset Master Record Segment ANLN1
1 VIMPOS ANLUN ANLA Asset Master Record Segment ANLN2
0 VIMPOS AUART T003O Order Types AUART
1 VIMPOS BAUTL MARA General Material Data MANDT
1 VIMPOS BAUTL MARA General Material Data MATNR
0 VIMPOS BEBER T357 Plant Section MANDT
0 VIMPOS BEBER T357 Plant Section WERKS
0 VIMPOS BEBER T357 Plant Section BEBER
1 VIMPOS BUKRS T001 Company Codes BUKRS
0 VIMPOS DAUFN AUFK Order master data AUFNR
1 VIMPOS EQUNR EQUI Equipment master data MANDT
0 VIMPOS GEWRK CRID CIM Resource - Entities MANDT
0 VIMPOS GEWRK CRID CIM Resource - Entities OBJID
1 VIMPOS GSBER TGSB Business Areas MANDT
1 VIMPOS GSBER TGSB Business Areas GSBER
0 VIMPOS IAUFNR AUFK Order master data AUFNR
1 VIMPOS IGSBER TGSB Business Areas MANDT
1 VIMPOS IGSBER TGSB Business Areas GSBER
0 VIMPOS ILART T353I Maintenance activity types MANDT
0 VIMPOS ILART T353I Maintenance activity types ILART
1 VIMPOS ILOAN ILOA PM Object Location and Account Assignment MANDT
1 VIMPOS ILOAN ILOA PM Object Location and Account Assignment ILOAN
0 VIMPOS IWERK T399I Planning plant parameters MANDT
1 VIMPOS KOKRS TKA01 Controlling Areas MANDT
0 VIMPOS KOSTL CSKS Cost Center Master Record MANDT
0 VIMPOS KOSTL CSKS Cost Center Master Record KOKRS
0 VIMPOS KOSTL CSKS Cost Center Master Record KOSTL
0 VIMPOS KOSTL CSKS Cost Center Master Record DATBI
1 VIMPOS LAUFN AUFK Order master data AUFNR
0 VIMPOS MANDT T000 Clients MANDT
1 VIMPOS MITYP T399P Maintenance item category parameter MANDT
1 VIMPOS MITYP T399P Maintenance item category parameter MITYP
0 VIMPOS OBJNR ONR00 General Object Number MANDT
1 VIMPOS PLNTY TCA01 Task list types MANDT
0 VIMPOS PPSID CRID CIM Resource - Entities MANDT
0 VIMPOS PPSID CRID CIM Resource - Entities OBJID
1 VIMPOS PRIOK T356 Priorities MANDT
1 VIMPOS PRIOK T356 Priorities ARTPR
0 VIMPOS PROID PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 VIMPOS PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 VIMPOS QMART TQ80 Notification Types MANDT
1 VIMPOS QMART TQ80 Notification Types QMART
0 VIMPOS QMNUM QMEL Quality Notification MANDT
0 VIMPOS QMNUM QMEL Quality Notification QMNUM
1 VIMPOS SERMAT MARA General Material Data MANDT
1 VIMPOS SERMAT MARA General Material Data MATNR
0 VIMPOS SPART TVTA Organizational Unit: Sales Area(s) MANDT
0 VIMPOS SPART TVTA Organizational Unit: Sales Area(s) VKORG
0 VIMPOS SPART TVTA Organizational Unit: Sales Area(s) VTWEG
0 VIMPOS SPART TVTA Organizational Unit: Sales Area(s) SPART
1 VIMPOS STORT T499S Location MANDT
1 VIMPOS STORT T499S Location WERKS
0 VIMPOS SWERK T001W Plants/Branches MANDT
0 VIMPOS SWERK T001W Plants/Branches WERKS
1 VIMPOS VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
1 VIMPOS VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
1 VIMPOS VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
1 VIMPOS VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
0 VIMPOS VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 VIMPOS VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 VIMPOS VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 VIMPOS VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 VIMPOS VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 VIMPOS VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
1 VIMPOS WAERS TCURC Currency Codes MANDT
1 VIMPOS WAERS TCURC Currency Codes WAERS
0 VIMPOS WARPL MPLA Maintenance plan WARPL
1 VIMPOS WPGRP T024I Maintenance planner groups INGRP
0 VIMPOS WSTRA T351 Maintenance strategy MANDT