/MRSS/D_ADDRESS SAP table for – Stores Primary/Secondary address

Here we would like to draw your attention to /MRSS/D_ADDRESS 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_ADDRESS is a SAP standard transparent table used for storing Stores Primary/Secondary address related data in SAP. It comes under the package /MRSS/SGE.

SAP /MRSS/D_ADDRESS table

Table /MRSS/D_ADDRESS technical data

Table/MRSS/D_ADDRESS
Data storingStores Primary/Secondary address
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_ADDRESS 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_ADDRESS table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • COUNTRY : Country Key
    Its data type is C (Character String) with field length 6
  • REGION : Region (State, Province, County)
    Its data type is C (Character String) with field length 6
  • SEC_ADDRESS
    Its data type is C (Character String) with field length 2
  • ACTIVE : Alert configuration: flag
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /MRSS/T_GEOPOSITION
  • LONGITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LATITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ALTITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • PRECISID
    Its data type is C (Character String) with field length 8
  • SOURCE_ID : Character field, length 32
    Its data type is C (Character String) with field length 8
  • OBJECT_KEY
    Its a key field. Its data type is X (Byte string) with field length 16
  • SOURCE_TSTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ADDRESS_TYPE : ACMTST: Address Type
    Its data type is C (Character String) with field length 2
  • VALID_FROM : Valid From (Time Stamp)
    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
  • CHANGED_ON : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ADDRESS_SOURCE
    Its data type is N (Character String with Digits Only) with field length 2
  • LOCATION : Logical Destination (Specified in Function Call)
    Its data type is C (Character String) with field length 80
  • BUILDING : Building (number or code)
    Its data type is C (Character String) with field length 40
  • FLOOR : Floor in building
    Its data type is C (Character String) with field length 20
  • ADDRESS_GUID
    Its a key field. Its data type is X (Byte string) with field length 16
  • ROOMNUMBER : Room or Appartment Number
    Its data type is C (Character String) with field length 20
  • ADDRESS_KEY
    Its data type is C (Character String) with field length 12
  • STREET : Street
    Its data type is C (Character String) with field length 120
  • HOUSE_NUM
    Its data type is C (Character String) with field length 20
  • CITY
    Its data type is C (Character String) with field length 80
  • CITY_DISTRICT
    Its data type is C (Character String) with field length 80
  • POST_CODE : Postal Code
    Its data type is C (Character String) with field length 20