OIUH_CM_STATE SAP table for – State Codes Table

Here we would like to draw your attention to OIUH_CM_STATE table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUH_CM_STATE is a SAP standard transp table used for storing State Codes Table related data in SAP. It comes under the package OIU_H.

SAP OIUH_CM_STATE table

Table OIUH_CM_STATE technical data

TableOIUH_CM_STATE
Data storingState Codes Table
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_CM_STATE Table Fields

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

  • STATE_ST_CD : STATE CODE
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • STATE_CNTRY_CD : COUNTRY CODE
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • STATE_ST_DE : STATE DESCRIPTION
    Its data type is CHAR (Character String) with field length 50
  • STATE_POSTAL_CD9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • STATE_POSTAL_CD : POSTAL CODE
    Its data type is CHAR (Character String) with field length 3
  • STATE_VER_NO : Version number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • STATE_USER_ID : User ID
    Its data type is CHAR (Character String) with field length 8
  • STATE_TIMESTAMP : TIMESTAMP
    Its data type is CHAR (Character String) with field length 14