V_EQUI_C 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
V_EQUI_C 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 V_EQUI_C table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EQUNR (Equipment Number), DATBI (Valid To Date), EQLFN (Consecutive numbering of EquipUsagePeriods on same day), EQUZN (Number of next EquipUsagePeriod on same day).. 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 V_EQUI_C 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 | |||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
DATBI | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
EQLFN | Consecutive numbering of EquipUsagePeriods on same day | EQLFN | NUMC | 3 | NUM03 | EQL | |||
EQUZN | Number of next EquipUsagePeriod on same day | EQNNR | NUMC | 3 | NUM03 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | 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 | ||||
TIMBI | Equipment usage period time stamp | TIMBI | TIMS | 6 | ZEITBI | ||||
ESTAI | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR | 1 | CHAR1 | ||||
ESTAE | SAP Development reserve: Format CHAR, length 4 | RESERVE_CHAR_004 | CHAR | 4 | CHAR4 | ||||
STNAM | SAP Development Reserve: Format CHAR, Length 12 | RESERVE_CHAR_012 | CHAR | 12 | CHAR12 | ||||
LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR | 1 | CHAR1 | ||||
DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
IWERKI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
SUBMT | Construction type material of the object | SUBMT | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
MAPAR | Manufacturer part number | MAPAR | CHAR | 30 | MAPAR | ||||
HEQUI | Superordinate Equipment | HEQUI | CHAR | 18 | EQUI | ALPHA | EQUNR | ||
HEQNR | Equipment position at InstallLoc (Superior Equip./FunctLoc) | HEQNR | CHAR | 4 | CHAR4 | ||||
INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
INGRPI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | CR_OBJTY | ||||
GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
GEWRKI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
TIDNR | Technical identification number | TIDNR | CHAR | 25 | TIDNR | ||||
TIDNRI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
KUND1 | Customer number | KUND1 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
KUND2 | End customer number | KUND2 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
KUND3 | Operator | KUND3 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LIZNR | Equipment license number | LIZNR | CHAR | 20 | CHAR20 | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
EZDAT | Date, intended for SAP internal use | EQDAT | DATS | 8 | DATUM | ||||
EZBER | Technical information, intended for SAP internal use | EQBER | CHAR | 30 | CHAR30 | ||||
EZNUM | Numerical field, intended for SAP internal use | EQNUM | NUMC | 9 | NUM9 | ||||
RBNR_I | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
IBLNR | Physical Inventory Document | IBLNR | CHAR | 10 | ALPHA | BELNR | IBN | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
PVS_FOCUS | Internal Identification for PVS Objects | PVS_GUID_CCC | RAW | 16 | SYSUUID | ||||
PPEGUID | Internal Identification for PVS Objects | PVS_GUID_CCC | RAW | 16 | SYSUUID | ||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
FUNCID | Function Identifier | CCC_FUNCID | CHAR | 40 | CHAR40 | ||||
FRCFIT | Indicator: Forced Installation/Dismantling | CCC_FRCFIT | CHAR | 1 | XCHAR | ||||
FRCRMV | Force Dismantling Flag | CCC_FRCRMV | CHAR | 1 | XCHAR | ||||
PVS_NODE | Internal Number of iPPE Node | PVS_PNGUID | RAW | 16 | SYSUUID | ||||
PVS_OTYPE | iPPE Object Type | PVS_OTYPE | CHAR | 1 | PVS_OTYPE | ||||
PVS_APPLOBJ_TYPE | Application Object Type for iPPE | PVS_APPLOBJ_TYPE | CHAR | 4 | PVS_APPLOBJ_TYPE | ||||
TOP_EQUI | Equipment Number | EQUNR | CHAR | 18 | ALPHA | EQUNR | EQN | EQUI | |
TOP_EQUI_FLAG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
J_3GEIGNER | Owner | J_3GEIGNER | CHAR | 12 | J_3GEIVERS | J_3GEIGVER | J_3GEE | ||
J_3GVERWAL | Administrator | J_3GVERWAL | CHAR | 12 | J_3GEIVERS | J_3GEIGVER | J_3GEV | ||
J_3GPMAUFE | PM Order Number (Owner) | J_3GPMAUFE | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
J_3GPMAUFV | PM Order Number (Administrator) | J_3GPMAUFV | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
J_3GPACHT | Leasing Type | J_3GPACHT | CHAR | 1 | J_3GKZPACH | ||||
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 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
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 | ||||
AUFNR | Settlement order | ILOM_ORDST | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDE | |
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 |
Key field | Non-key field |
How do I retrieve data from SAP table V_EQUI_C using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_EQUI_C to SELECT all data from the tableDATA: WA_V_EQUI_C TYPE V_EQUI_C.
SELECT SINGLE *
FROM V_EQUI_C
INTO CORRESPONDING FIELDS OF WA_V_EQUI_C
WHERE...
How to access SAP table V_EQUI_C
Within an ECC or HANA version of SAP you can also view further information about V_EQUI_C 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