/MRSS/D_SQP_ESTR SAP table for – Employee Profile – Structured Qualifications

Here we would like to draw your attention to /MRSS/D_SQP_ESTR table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). /MRSS/D_SQP_ESTR is a SAP standard transparent table used for storing Employee Profile – Structured Qualifications related data in SAP. It comes under the package /MRSS/SQP.

SAP /MRSS/D_SQP_ESTR table

Table /MRSS/D_SQP_ESTR technical data

Table/MRSS/D_SQP_ESTR
Data storingEmployee Profile – Structured Qualifications
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SQP
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_SQP_ESTR Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /MRSS/D_SQP_ESTR table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • RATING : Numeric values for traffic lights
    Its data type is N (Character String with Digits Only) with field length 8
  • VALID_FR
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • VALID_TO : Valid To (Time Stamp)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • FRM_SRC
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is /MRSS/T_SQP_ESTR_KEY
  • PROFILE_GUID
    Its a key field. Its data type is X (Byte string) with field length 16
  • QUAL_GUID
    Its a key field. Its data type is X (Byte string) with field length 16
  • IS_ACTIVE : Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘)
    Its a key field. Its data type is C (Character String) with field length 2
  • MATID
    Its data type is C (Character String) with field length 20
  • PRI_QUALIF
    Its data type is C (Character String) with field length 20
  • SEC_QUALIF
    Its data type is C (Character String) with field length 20