SAP EAMPIC_S_EQUI Structure of PIC-relevant EQUI Fields Table data and field list

EAMPIC_S_EQUI 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 "Structure of PIC-relevant EQUI Fields" 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_EAMPIC_S_EQUI TYPE EAMPIC_S_EQUI.

The EAMPIC_S_EQUI table consists of various fields, each holding specific information or linking keys about Structure of PIC-relevant EQUI Fields data available in SAP. These include DESCRIPTION (Description of technical object), EQUICATGRY (Equipment category), PLANPLANT (Maintenance Planning Plant), MAINTPLANT (Maintenance plant)... 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. .

EAMPIC_S_EQUI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EAMPIC_S_EQUI structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the EAMPIC_S_EQUI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
EQUIPMENTEquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
DESCRIPTIONDescription of technical object KTX01CHAR40TEXT40
EQUICATGRYEquipment category EQTYPCHAR1Assigned to domainEQTYPEQT
PLANPLANTMaintenance Planning Plant IWERKCHAR4Assigned to domainWERKSIWK
MAINTPLANTMaintenance plant SWERKCHAR4Assigned to domainWERKSSWK
PLANGROUPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3Assigned to domainINGRPIHG
MAINTLOCAsset location STORTCHAR10Assigned to domainAP_STAND
MAINTROOMRoom RAUMNRCHAR8CHAR8
PLSECTNPlant section BEBERCHAR3Assigned to domainBEBERBBE
ABCINDICABC indicator for technical object ABCKZCHAR1Assigned to domainABCKZ
SORTFIELDSort field EQFNRCHAR30CHAR30
ASSET_NOMain Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
SUB_NUMBERAsset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
SUPEQUISuperordinate Equipment HEQUICHAR18Assigned to domainALPHAEQUNR
FUNCLOCFunctional Location Label ILOM_STRNOCHAR40ILOM_STRNO
CONSTTYPEConstruction type material of the object SUBMTCHAR18Assigned to domainMATN1MATNRMAT
WORK_CTRWork center ARBPLCHAR8ARBPLAGR
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
DATABValid-From Date DATABDATS8DATUM
DATBIValid To Date DATBIDATS8DATUM
PM_WORK_CTRMain work center for maintenance tasks GEWRKCHAR8ARBPLVAP
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
ISTATSystem status J_ISTATCHAR5Assigned to domainJ_ISTAT
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
TXT04Individual status of an object (short form) J_TXT04CHAR4TEXT4
TXT30Object status J_TXT30CHAR30TEXT30

Key field Non-key field



How do I retrieve data from SAP structure EAMPIC_S_EQUI using ABAP code?

As EAMPIC_S_EQUI 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 EAMPIC_S_EQUI as there is no data to select.

How to access SAP table EAMPIC_S_EQUI

Within an ECC or HANA version of SAP you can also view further information about EAMPIC_S_EQUI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).