VEQUI SAP (Change document structure; generated by RSSCD000) Structure details
Description: Change document structure; generated by RSSCD000
Structure field list including key, data, relationships and ABAP select examples
VEQUI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change document structure; generated by RSSCD000" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VEQUI TYPE VEQUI.
The VEQUI table consists of various fields, each holding specific information or linking keys about Change document structure; generated by RSSCD000 data available in SAP. These include MANDT (Client), EQUNR (Equipment Number), ERDAT (Date on Which Record Was Created), ERNAM (Name of Person who Created the Object).. 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: Can be enhanced (character-type or numeric)
SAP VEQUI structure 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 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
EQASP | Language in Which the Piece of Equipment was Entered | EQASP | LANG | 1 | T002 | ISOLA | SPRAS | ||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
EQTYP | Equipment category | EQTYP | CHAR | 1 | T370T | EQTYP | EQT | ||
EQART | Type of Technical Object | EQART | CHAR | 10 | T370K | EQART | |||
LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR | 1 | CHAR1 | ||||
INVNR | Inventory number | INVNR | CHAR | 25 | INVNR_ANLA | ||||
GROES | Size/dimension | GROSS | CHAR | 18 | GROES | ||||
BRGEW | Weight of object | OBJ_WEIGHT | QUAN | 13(3) | MENG13 | ||||
GEWEI | Unit of weight | WEIGHT_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANSDT | Acquisition date | ANDTI | DATS | 8 | DATUM | ||||
ANSWT | Acquisition Value | ANSWT | CURR | 13(2) | WERT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
ELIEF | Vendor number | ELIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
GWLEN | Date on which the warranty ends | GWLEN | DATS | 8 | DATUM | ||||
GWLDT | Warranty Date | GWLDT | DATS | 8 | DATUM | ||||
WDBWT | Equipment replacement value | WDBWT | CURR | 13(2) | WERT | ||||
HERST | Manufacturer of asset | HERST | CHAR | 30 | TEXT30 | ||||
HERLD | Country of manufacture | HERLD | CHAR | 3 | T005 | LAND1 | |||
HZEIN | Manufacturer drawing number | HZEIN | CHAR | 30 | HZEIN | ||||
SERGE | Manufacturer serial number | SERGE | CHAR | 30 | CHAR30 | ||||
TYPBZ | Manufacturer model number | TYPBZ | CHAR | 20 | TYPBZ | ||||
BAUJJ | Year of construction | BAUJJ | CHAR | 4 | GJAHR | CJAHR | |||
BAUMM | Month of construction | BAUMM | CHAR | 2 | BAUMM | ||||
APLKZ | Indicator: Task List Exists | APLKZ | CHAR | 1 | APLKZ | ||||
AULDT | First delivery date of the equipment | AULDT | DATS | 8 | DATUM | ||||
INBDT | Start-up Date of the Technical Object | ILOM_DATAB | DATS | 8 | DATUM | ||||
GERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
EQLFN | Consecutive numbering of EquipUsagePeriods on same day | EQLFN | NUMC | 3 | NUM03 | EQL | |||
GWLDV | Warranty date for Sales and Distribution | GWLDV | DATS | 8 | DATUM | ||||
EQDAT | Date, intended for SAP internal use | EQDAT | DATS | 8 | DATUM | ||||
EQBER | Technical information, intended for SAP internal use | EQBER | CHAR | 30 | CHAR30 | ||||
EQNUM | Numerical field, intended for SAP internal use | EQNUM | NUMC | 9 | NUM9 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
EQSNR | EQSE Number | EQSNR | CHAR | 18 | EQSE | EQSNR | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
KRFKZ | Referenced Configuration | KRFKZ | CHAR | 1 | X | ||||
KMATN | Configurable Material | KMATN | CHAR | 18 | MARA | MATN1 | MATNR | MAT1 | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
SERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
WERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LAGER | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
CHARGE | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
KUNDE | Customer to Whom Serial Number was Delivered | KUNDSE | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
IMRC_POINT | Measuring Point | IMRC_POINT | CHAR | 12 | IMPTT | ALPHA | IMRC_POINT | IPT | IMPM |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
MGANR | Master warranty number | MGANR | CHAR | 20 | BGMK | ALPHA | MGANR | GAM | |
BEGRUI | Data origin for authorization group field | INH_BEGRUI | CHAR | 1 | INHER | ||||
S_EQUI | Equipment data exists | EQUIP_KNZ | CHAR | 1 | X | ||||
S_SERIAL | Serial data when maintaining equipment | KZKSD | CHAR | 1 | X | ||||
S_KONFI | Configuration supported | KONFKNZ | CHAR | 1 | XFELD | ||||
S_SALE | Sales equipment | SDKNZ | CHAR | 1 | XFELD | ||||
S_FHM | Equip. category relevant to production resources and tools | FHMKZ | CHAR | 1 | XFLAG | ||||
S_ELSE | Indicator: Other Data Active | ELSE_KNZ | CHAR | 1 | X | ||||
S_ISU | IS-U data | ISU_KNZ | CHAR | 1 | X | ||||
S_EQBS | EQSI Exists | KZEQBS | CHAR | 1 | KZEQBS | ||||
S_FLEET | Indicator: Fleet object active | FLEET_KNZ | CHAR | 1 | X | ||||
BSTVP | Stock Check for Serial Numbers | BSTVP | CHAR | 1 | BSTVP | ||||
SPARTE | Division | SPARTE | CHAR | 2 | TSPA | SPART | SPA | ||
HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | ITOBTMP_TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | ITOBTMP_TSEGTEMPLA | CHAR | 10 | Assigned to domain | TMPLA | TSEGTEMPLA | ||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | HTN | |
ACT_CHANGE_AA | Change Equipment Master when Changing Asset | AAPM_ACT_CHANGE_AA | CHAR | 1 | AAPM_ACT | ||||
S_CC | Configuration Control Data | CCC_KNZ | CHAR | 1 | X | ||||
DATLWB | Date of Last Goods Movement | DATLWB | DATS | 8 | DATS | ||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
IUID_TYPE | Structure Type of UII | IUID_TYPE | CHAR | 10 | TIUID_TYPE | IUID_TYPE | H_IUID_TYPE | ||
UII_PLANT | Plant Responsible for UII | UII_PLANT | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
/GEP/PASSENGER | Number of Passengers | /GEP/FLEET_D_PASSENGER | NUMC | 2 | /GEP/FLEET_DO_PASSENGER | ||||
/GEP/AUTOM | Vehicle Equipment: Automatic Transmission | /GEP/FLEET_D_AUTOM | CHAR | 1 | CMPFLAG | ||||
/GEP/KLIMA | Vehicle Equipment: Air Conditioning | /GEP/FLEET_D_KLIMA | CHAR | 1 | CMPFLAG | ||||
/GEP/DACHG | Vehicle Equipment: Roof Rack | /GEP/FLEET_D_DACHG | CHAR | 1 | CMPFLAG | ||||
/GEP/SCHNEEK | Vehicle Equipment: Snow Chains | /GEP/FLEET_D_SCHNEEK | CHAR | 1 | CMPFLAG | ||||
/GEP/WINTERR | Vehicle Equipment: Snow Tyres | /GEP/FLEET_D_WINTERR | CHAR | 1 | CMPFLAG | ||||
/GEP/VHCAT | Vehicle Type | /GEP/FLEET_D_VHCAT | CHAR | 2 | /GEP/FLEET_DO_VEHICLE_CAT | ||||
.INCLU--AP | 0 | ||||||||
EQEXT_ACTIVE | Backpack Table /isdfps/lmeqext Active | /ISDFPS/DE_LM_DB_EQEXT_ACTIVE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | /MRSS/T_REQU_UPD | CHAR | 1 | /MRSS/_HCM_BOOLEAN | ||||
/MRSS/PROF_GUID | GUID | /MRSS/T_RSG_GUID | RAW | 16 | SYSUUID | ||||
/MRSS/PROF_KEY | Profile Key | /MRSS/T_RSG_REQUID | CHAR | 10 | ALPHA | /MRSS/RSG_REQUID | |||
/MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
EQUI_SRTYPE | Shift Report Type | COCF_SR_SRTYPE | CHAR | 10 | COCF_CU_SRTYPE | ||||
EQUI_SNTYPE | Shift Note Type | COCF_SN_SNTYPE | CHAR | 2 | TQ80 | QMART | |||
.INCLU--AP | 0 | ||||||||
EQLB_DUTY | Logbook Duty | DIACL_DUTY | CHAR | 1 | XFLAG | ||||
EQLB_HIDE | Hide Logbook Display | DIACL_HIDE | CHAR | 1 | XFLAG | ||||
.INCLU--AP | 0 | ||||||||
J_3GDISPO | Planning Indicator | J_3GDISPO | CHAR | 1 | J_3GDISPO | ||||
J_3GZDEQUI | Indicator for Central-Decentral Equipment | J_3GZDEQUI | CHAR | 1 | J_3GZDEQUI | ||||
J_3GEQART | Procurement Type for External Equipment | J_3GEQART | CHAR | 10 | J_3GFEQUI | J_3GEQART | |||
J_3GKZMENG | Item/Multipart Indicator | J_3GKZMENG | CHAR | 1 | J_3GKZMENG | ||||
J_3GKONDE | Material Pricing Group | KONDM | CHAR | 2 | T178 | KONDM | VKM | ||
J_3GFIKTIV | Fictitious Indicator | J_3GFIKTIV | CHAR | 1 | X | ||||
J_3GBELTYP | Document Categories Allowed | J_3GBELTYP | CHAR | 15 | CHAR15 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GKZLADG | Indicator: Relevancy to Loading Costs | J_3GKZLADG | CHAR | 1 | J_3GLADEKE | CHAR1 | |||
J_3GKZBERG | Indicator for Provision Fees | J_3GKZBERG | CHAR | 1 | J_3GKZBERG | ||||
J_3GEIFR | Indicator for Own/External Equipment | J_3GEIFR | CHAR | 1 | J_3GEIFR | ||||
J_3GVERMEIN | Unit of Measure for Settlement | J_3GVERMEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
J_3GZULNR | License Plate Number | J_3GLICENCE_NUM | CHAR | 15 | CHAR15 | ||||
/SAPCEM/ABRECHVH | Settlement Using Shipping Document | /SAPCEM/ABRECHVH | CHAR | 1 | XCHAR | ||||
/SAPCEM/ABRECHLG | Settlement Using PBE Document | /SAPCEM/ABRECHLG | CHAR | 1 | XCHAR | ||||
/SAPCEM/DISPOGR | Planning Group | /SAPCEM/DISPOGR | CHAR | 4 | /SAPCEM/DISPOGRU | /SAPCEM/DISPOGR | |||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
Key field | Non-key field |
How do I retrieve data from SAP structure VEQUI using ABAP code?
As VEQUI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VEQUI as there is no data to select.How to access SAP table VEQUI
Within an ECC or HANA version of SAP you can also view further information about VEQUI 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