OIUH_RV_COADV SAP table for – Colorado Ad Valorem

Here we would like to draw your attention to OIUH_RV_COADV 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_COADV is a SAP standard transp table used for storing Colorado Ad Valorem related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_COADV table

Table OIUH_RV_COADV technical data

TableOIUH_RV_COADV
Data storingColorado Ad Valorem
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_COADV 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_COADV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ADV_OR_LVL_1_NO : OIUH_CHAR3
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • COADV_DOI_PR_NO : OIUH_CHAR8
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • COADV_DOI_NO : OIUH_CHAR5
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • COADV_FL_NO : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • COADV_FL_ST_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • COADV_CY_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • DV_SCHOLDIST_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • COADV_OP_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • COADV_OP_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • COADV_RI_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • COADV_WI_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ADV_GAS_GRVA_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • ADV_GAS_GRVL_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • ADV_OIL_GRVA_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • ADV_OIL_GRVL_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OADV_GAS_ASS_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OADV_OIL_ASS_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OADV_GAS_ROY_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OADV_OIL_ROY_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • COADV_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • COADV_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • COADV_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14