VIMPLA SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
VIMPLA is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The VIMPLA table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include WARPL (Maintenance Plan), ERKNZ (Creation indicator), AEKNZ (Change indicator), ERSDT (Date of creation).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP VIMPLA table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | ALPHA | WARPL | MPL | MPLAL | |
ERKNZ | Creation indicator | ERKNZ | CHAR | 1 | FLAG | ||||
AEKNZ | Change indicator | AEKNZ | CHAR | 1 | FLAG | ||||
ERSDT | Date of creation | EDATUM | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
WPTXT | Maintenance Plan Text | WPTXT | CHAR | 40 | TEXT40 | ||||
STRAT | Maintenance strategy | STRAT | CHAR | 6 | T351 | WSTRA | STR | STRAA | |
ABRHO | Scheduling Period | ABRHO | NUMC | 3 | ANZTA | ||||
KUNUM | Customer Number | KUNUM | CHAR | 10 | ALPHA | KUNNR | KUN | ||
LTKNZ | Long Text Indicator | MPLTX | CHAR | 1 | XFELD | ||||
LVORM | Indicator: maintenance plan locked against calls | ABSTOP | CHAR | 1 | XFELD | ||||
ANZPS | Number of maintenance items in the maintenance plan | ANZMPOS | NUMC | 4 | WPPOS | ||||
ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
LANGU | Language key of the long text | MPLANGU | LANG | 1 | ISOLA | SPRAS | |||
VSPOS | Shift Factor for Late Completion | VERSCHPLUS | NUMC | 3 | NUM3 | ||||
VSNEG | Shift Factor for Early Completion | VERSCHNEG | NUMC | 3 | NUM3 | ||||
TOPOS | Tolerance for Late Completion (%) | TOLERPLUS | NUMC | 3 | NUM3 | ||||
TONEG | Tolerance for Early Completion (%) | TOLERNEG | NUMC | 3 | NUM3 | ||||
SFAKT | Cycle modification factor | SFAKT | DEC | 3(2) | SFAKT | ||||
STICH | Scheduling indicator | TERMKNZ | CHAR | 1 | TERMKNZ | ||||
TGOON | Scheduling to reoccur when lead float reached | TGON | NUMC | 3 | NUM3 | ||||
HORIZ | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3 | NUM3 | ||||
HORIZ_DAYS | Call horizon for maintenance plan calls | HORIZONT | NUMC | 3 | NUM3 | ||||
HORIZ_QUALIFIER | Calculation Type of Call Horizon | EAM_CC_CALLHORIZON_QUALIFIER | CHAR | 1 | EAMQF | EAM_CC_CALLHORIZON_QUALIFIER | |||
ANDOR | Indicator for OR or AND link | ANDOR | CHAR | 1 | RADIO | ||||
KNAUT | Reserved | KNZABR | CHAR | 1 | FLAG | ||||
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | J_OBJNR | ONR | |||
MPTYP | Maintenance plan category | MPTYP | CHAR | 2 | T399W | MPTYP | WAT | ||
HUNIT | Unit in scheduling interval | HUNIT | UNIT | 3 | CUNIT | MEINS | |||
STADT | Start date | STADT | DATS | 8 | DATUM | ||||
SZAEH | Start counter reading | SZAEHC | CHAR | 22 | WZYKL | ||||
CALL_CONFIRM | Only Create New Call Object After Completing Predecessor | CALL_CONFIRM | CHAR | 1 | CHAR1 | ||||
PLAN_SORT | Sort field for maintenance plans | PLAN_SORT | CHAR | 20 | T399G | CHAR20 | |||
FABKL | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
PUFFP | Lead Float in Days | PUFF_VORL | NUMC | 3 | NUM3 | ||||
PUFFN | Follow-up float in days | PUFF_NACHL | NUMC | 3 | NUM3 | ||||
START_DATE | Start Date for Scheduling | DATE_START | DATS | 8 | DATUM | ||||
START_TIME | Start Time for Scheduling | TIME_START | TIMS | 6 | TIME | ||||
CALL_UPDATE_IND | Indicator for Adapting Basic Dates of Call Object | IND_CALL_UPDATE | CHAR | 1 | XFELD | ||||
IND_MPLA_API | Maintenance Plan Was Created/Changed by API | IND_MPLA_API | CHAR | 2 | IND_API | ||||
MCP_SF | Shift Factor for Multiple Counter Plan | MCP_SF | CHAR | 1 | MCP_SF | ||||
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
WSTRA | Maintenance strategy | STRAT | CHAR | 6 | T351 | WSTRA | STR | STRAA | |
WPPOS | Item in the maintenance plan | WPPOS | NUMC | 4 | WPPOS | ||||
PSTXT | Item Short Text | POSTXT | CHAR | 40 | TEXT40 | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
OBKNR | Object list number | OBJKNR | INT4 | 10 | OBJKN | ||||
PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
STATUS | Maintenance Item Status | MPSTAT | CHAR | 1 | FLAG | ||||
WPGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
LAUFN | Order number | LAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
ANLZU | Syst.Condition | ANLZU | CHAR | 1 | ANLZU | ||||
AUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
INACT | Indicator that maintenance item is inactive | INACT | CHAR | 1 | FLAG | ||||
ILART | Maintenance activity type | ILA | CHAR | 3 | T353I | ILART | H_T350I | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
IND_ABRVO | Indicator showing settlement rule maintained | IND_ABRVO | CHAR | 1 | CHAR01 | ||||
PSPEL | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
STD_NETZ | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
STD_AVO | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
KDAUF | Sales Document | VBELN_VA | CHAR | 10 | ALPHA | VBELN | AUN | ||
KDPOS | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
MITYP | Maintenance item category | MITYP | CHAR | 2 | T399P | CHAR2 | |||
BSTNR | Purchase Order Number | BSTNR | CHAR | 10 | ALPHA | EBELN | BES | ||
BSTPO | Purchase Order Item Number | BSTPO | NUMC | 5 | EBELP | ||||
PACKNO | Package number | PACKNO | NUMC | 10 | PACKNO | ||||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
SAKTO | Cost Element | KSTAR | CHAR | 10 | ALPHA | KSTAR | KAT | ||
AUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | ALPHA | AUFNR | ORDE | ||
APFKT | Execution factor for whole task list | APFKT | DEC | 3 | AFAKT | ||||
SCRRENTY | SCREEN TYPE: for order-order category (see domain) | SCREENTY | CHAR | 4 | CHAR4 | ||||
SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
SERMAT | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
LBLNI | Entry Sheet Number | LBLNI | CHAR | 10 | ALPHA | LBLNI | LBL | ESSR | |
TASK_DETERMINE | Automatic task determination in the notification | TASK_DETERMINE | CHAR | 1 | CHAR1 | ||||
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | QKATART | ||||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QCODEGRP | ||||
QMCOD | Coding | QMCOD | CHAR | 4 | QCODE | ||||
PHYNR | Physical Sample Number | QPHYSPRNR | CHAR | 12 | ALPHA | QPHYSPRNR | QPN | ||
ART | Inspection Type | QPART | CHAR | 8 | QPART | QLA | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QPLOS | QLS | QALS | ||
TSTMP_BW | Time Stamp for BI Delta Extraction | TSTMP_BW_EXT | DEC | 16 | RKE_TSTMP | ||||
NO_AUFRELKZ | Do Not Release Immediately | NO_AUFRELKZ | CHAR | 1 | XFELD | ||||
DESNUM | CU: Design Number | /CUM/DESNUM | CHAR | 12 | ALPHA | /CUM/DESNUM | /CUM/DESNUM | ||
CYCLESEQIND | Cycle Set Sequence | CYCLESETSEQ | NUMC | 2 | NUMC2 | ||||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | ADDCOMPARE_CORE | ADCP | |||
IND_MPOS_API | Maintenance Item Was Created/Changed by API | IND_MPOS_API | CHAR | 2 | IND_API | ||||
POS_ERKNZ | Creation indicator | ERKNZ | CHAR | 1 | FLAG | ||||
POS_AEKNZ | Change indicator | AEKNZ | CHAR | 1 | FLAG | ||||
POS_ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
POS_ERSDT | Date of creation | EDATUM | DATS | 8 | DATUM | ||||
POS_AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
POS_AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
POS_OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
POS_LTKNZ | Long Text Indicator | MPLTX | CHAR | 1 | XFELD | ||||
POS_LANGU | Language key of the long text | MPLANGU | LANG | 1 | ISOLA | SPRAS | |||
TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | INHER | ||||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
EQFNRI | Data origin for sort field | INH_EQFNRI | CHAR | 1 | INHER | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
SWERKI | Data origin for maintenance plant field | INH_SWERKI | CHAR | 1 | INHER | ||||
STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
STORTI | Data origin for location field | INH_STORTI | CHAR | 1 | INHER | ||||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
MSGRPI | Data origin for room number field | INH_MSGRPI | CHAR | 1 | INHER | ||||
BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
BEBERI | Data origin for plant section field | INH_BEBERI | CHAR | 1 | INHER | ||||
CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
PPSIDI | Data origin for PP work center field | INH_PPSIDI | CHAR | 1 | INHER | ||||
GSBERI | Data origin for business area field | INH_GSBERI | CHAR | 1 | INHER | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOKRSI | Data origin for controlling area field | INH_KOKRSI | CHAR | 1 | INHER | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
KOSTLI | Data origin for cost center field | INH_KOSTLI | CHAR | 1 | INHER | ||||
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
PROIDI | Data origin for WBS element field | INH_PROIDI | CHAR | 1 | INHER | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUKRSI | Data origin for company code field | INH_BUKRSI | CHAR | 1 | INHER | ||||
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLNRI | Data origin for asset main no./sub-no. fields | INH_ANLNRI | CHAR | 1 | INHER | ||||
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
ANLUNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
DAUFNI | Data origin of standing order number field | INH_DAUFNI | CHAR | 1 | INHER | ||||
AUFNRI | Data origin for settlement order field | INH_AUFNRI | CHAR | 1 | INHER | ||||
TPLNRI | Data origin for functional location field | INH_TPLNRI | CHAR | 1 | INHER | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VKORGI | Data origin for sales organization field | INH_VKORGI | CHAR | 1 | INHER | ||||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
VTWEGI | Data origin of distribution channel field | INH_VTWEGI | CHAR | 1 | INHER | ||||
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
SPARTI | Data origin for division field | INH_SPARTI | CHAR | 1 | INHER | ||||
ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
ADRNRI | Data origin for address field | INH_ADRNRI | CHAR | 1 | INHER | ||||
OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
IGSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
IAUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDE |
Key field | Non-key field |
How do I retrieve data from SAP table VIMPLA using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIMPLA to SELECT all data from the tableDATA: WA_VIMPLA TYPE VIMPLA.
SELECT SINGLE *
FROM VIMPLA
INTO CORRESPONDING FIELDS OF WA_VIMPLA
WHERE...
How to access SAP table VIMPLA
Within an ECC or HANA version of SAP you can also view further information about VIMPLA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects