/MRSS/D_BAS_ASG SAP table for – MRS Basis Assignments

Here we would like to draw your attention to /MRSS/D_BAS_ASG 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_BAS_ASG is a SAP standard transparent table used for storing MRS Basis Assignments related data in SAP. It comes under the package /MRSS/BASIS_ASGN.

SAP /MRSS/D_BAS_ASG table

Table /MRSS/D_BAS_ASG technical data

Table/MRSS/D_BAS_ASG
Data storingMRS Basis Assignments
ModulePM
ComponentPM-WOC
SAP Package/MRSS/BASIS_ASGN
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_BAS_ASG 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_BAS_ASG table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • REMAINING_DUR
    Its data type is X (Byte string) with field length 4
  • PARENT_KEY
    Its data type is X (Byte string) with field length 16
  • ROOT_KEY
    Its data type is X (Byte string) with field length 16
  • BOOKING_TYPE
    Its data type is C (Character String) with field length 2
  • CONCRETE
    Its data type is C (Character String) with field length 2
  • WTIME_BASED
    Its data type is C (Character String) with field length 2
  • RULE_BASED
    Its data type is C (Character String) with field length 2
  • PLANNING_TYPE
    Its data type is C (Character String) with field length 2
  • PLANNING_UNIT
    Its data type is C (Character String) with field length 6
  • APPL_STATUS
    Its data type is C (Character String) with field length 10
  • GUID : 16 Byte UUID in 32 Characters (Hexadecimal Encoded)
    Its a key field. Its data type is X (Byte string) with field length 16
  • CREATED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • CREATED_AWTYP
    Its data type is C (Character String) with field length 10
  • CREATED_LOGSYS
    Its data type is C (Character String) with field length 20
  • CREATED
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED_BY : User Name in User Master Record
    Its data type is C (Character String) with field length 24
  • CHANGED
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CHANGED_AWTYP
    Its data type is C (Character String) with field length 10
  • CHANGED_LOGSYS
    Its data type is C (Character String) with field length 20
  • DESCRIPTION : Alert configuration: data element for text
    Its data type is C (Character String) with field length 160
  • RES_UTIL_RATIO
    Its data type is F (Floating point number) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /MRSS/T_BASIS_ASGN_DATA
  • RES_UTIL_ORIGIN
    Its data type is C (Character String) with field length 2
  • RES_TYPE : Resource Type
    Its data type is C (Character String) with field length 4
  • ASSIGNMENT_KEY
    Its data type is X (Byte string) with field length 16
  • DEMAND_KEY
    Its data type is X (Byte string) with field length 16
  • RESOURCE_KEY
    Its data type is X (Byte string) with field length 16
  • BEG_TSTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • END_TSTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DURATION : Duration in Seconds
    Its data type is X (Byte string) with field length 4