1. Home
  2. Resources
  3. SAP Tables
  4. VIMPOS - Generated Table for View

SAP Table VIMPOS

Generated Table for View

VIMPOS (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIMPOS to other SAP tables.

VIMPOS table fields

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

VIMPOS foreign key relationships

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