OIUH_RV_COA SAP table for – Chart of Accounts

Here we would like to draw your attention to OIUH_RV_COA 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_RV_COA is a SAP standard transp table used for storing Chart of Accounts related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_COA table

Table OIUH_RV_COA technical data

TableOIUH_RV_COA
Data storingChart of Accounts
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_RV_COA 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_RV_COA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COA_ACCT_NO : OIUH_CHAR10
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • COA_OR_LVL_1_NO : Organization level 1 number (Company Code)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • COA_ACCT_NM9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • COA_ACCT_NM : OIUH_CHAR30
    Its data type is CHAR (Character String) with field length 30
  • COA_ACCT_STS_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OA_ACCT_TYPE_CD : Account Type
    Its data type is CHAR (Character String) with field length 2
  • A_ACCT_REF_1_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • A_ACCT_REF_2_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • A_ACCT_REF_3_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • A_ACCT_REF_4_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • A_ACCT_REF_5_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • VALD_ENT_CD_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • VALD_SLR_CD_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • COA_CMT_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • COA_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • COA_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • COA_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14