/MRSS/D_GEO_ZIP SAP table for – Postal Codes for Georeferencing

Here we would like to draw your attention to /MRSS/D_GEO_ZIP 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_GEO_ZIP is a SAP standard transparent table used for storing Postal Codes for Georeferencing related data in SAP. It comes under the package /MRSS/OPT.

SAP /MRSS/D_GEO_ZIP table

Table /MRSS/D_GEO_ZIP technical data

Table/MRSS/D_GEO_ZIP
Data storingPostal Codes for Georeferencing
ModulePM
ComponentPM-WOC
SAP Package/MRSS/OPT
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP /MRSS/D_GEO_ZIP 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_GEO_ZIP table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • ALTITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • DENISTY_LOAD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • COUNTRY : Country Key
    Its a key field. Its data type is C (Character String) with field length 6
  • POST_CODE : Postal Code
    Its a key field. Its data type is C (Character String) with field length 20
  • CITY
    Its a key field. Its data type is C (Character String) with field length 80
  • STREET : Street
    Its a key field. Its data type is C (Character String) with field length 120
  • CITY_DISTRICT
    Its data type is C (Character String) with field length 80
  • REGION : Region (State, Province, County)
    Its data type is C (Character String) with field length 6
  • LATITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LONGITUDE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8