1. SAP Tutorial
  2. Oil & Gas

OIUH_CM_INSTL SAP table for – Revenue Installation Parameters

Here we would like to draw your attention to OIUH_CM_INSTL 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_INSTL is a SAP standard transp table used for storing Revenue Installation Parameters related data in SAP. It comes under the package OIU_H.

SAP OIUH_CM_INSTL table

Table OIUH_CM_INSTL technical data

TableOIUH_CM_INSTL
Data storingRevenue Installation Parameters
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_CM_INSTL 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_INSTL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DUMMY_SEQ_FIELD : System Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INSTL_LVL_1_TX9 : Null Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTL_LVL_1_TX : Level 1 Text
    Its data type is CHAR (Character String) with field length 13
  • INSTL_LVL_2_TX9 : Null Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTL_LVL_2_TX : Level 2 Text
    Its data type is CHAR (Character String) with field length 13
  • INSTL_LVL_3_TX9 : Null Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTL_LVL_3_TX : Level 3 Text
    Its data type is CHAR (Character String) with field length 13
  • INSTL_LVL_4_TX9 : Null Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTL_LVL_4_TX : Level 4 Text
    Its data type is CHAR (Character String) with field length 13
  • V_RCPMT_ALLW_FL : Revenue Recoupment Allowance
    Its data type is CHAR (Character String) with field length 1
  • REV_APPR_RQR_FL : Revenue Approval Required
    Its data type is CHAR (Character String) with field length 1
  • V_TO_DT_ALLW_FL : Revenue effective to date
    Its data type is CHAR (Character String) with field length 1
  • S_GENR_BA_NO_FL : System-Generated Business Associate Number Flag
    Its data type is CHAR (Character String) with field length 1
  • CS_SECURITY_FL : Case Security Flag
    Its data type is CHAR (Character String) with field length 1
  • STL_OR_LVL_1_NO : Company Level 1 – (ORG1)
    Its data type is CHAR (Character String) with field length 3
  • INSTL_ST_INC_CD : State Income Code
    Its data type is CHAR (Character String) with field length 2
  • INSTL_VER_NO : Version Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • INSTL_USERID : User ID
    Its data type is CHAR (Character String) with field length 8
  • INSTL_TIMESTAMP : Time Stamp
    Its data type is CHAR (Character String) with field length 14

    • OIUH_CM_INSTL related tables

    • OIUH_PR_DN : Oil and Gas appl table
    • OIUH_CM_SRBD : Oil and Gas appl table
    • OIUH_RV_INSL_H : Oil and Gas appl table
    • OIUH_RV_GLCC : Cross Reference GL to Cost Center
    • OIUH_RV_PAC : Property Affiliated Company
    • OIUH_NM_PDCD_XRF : New Mexico Product Code Cross Reference (TBLTR091)
    • OIUH_RV_WHHD : Table for withholding report
    • OIUH_RV_GCTA : Gross Check Tax Amounts
    • OIUH_RV_RP : MMS Royalty Pending
    • OIUH_RV_TR : Tract Information
    • OIUH_RV_TEP : Tax Extract Profile
    • OIUH_RV_COADV : Colorado Ad Valorem
    • OIUH_CDEX_PROD : Mapping Product code with CDEX Product Code
    • OIUH_RV_COA : Chart of Accounts
    • OIUH_RV_IVS : Invoice Selection
    • OIUH_RV_CPR : Check Process Rule
    • OIUH_RV_TRP : Tax And Royalty Profile
    • OIUH_RV_CR : Check Register
    • OIUH_RV_CMCC : Contract Marketing Cost Control
    • OIUH_RV_RJE : Journal Entry

    OIUH_CM_INSTL related transaction codes under SAP package OIU_H

    • OIUH_JE02 : Account Entry Control
    • O3UH_FT : Funds Transfer
    • O3UH_AD_VAL : Ad Valorem
    • O3UH_RV : Revenue Report Viewer
    • OIUH_JE10 : Miscellaneous Subledger Query
    • OIUH_TR06 : Colorado Ad Valorem
    • O3UH_FLASH_DOWNLOAD : Download Reporting Flashforms
    • O3UH_VMC : Process Void/Manual Checks
    • OIUH_DO08 : DOI Owner Accounting Entry code
    • O3UH_NA_PU : Negative Amount Purge
    • O3UH_JEPURGE_OFF : JE Offset Purge
    • O3UH_AR_UP : Accounts Receivable Update
    • OIUH_RD04 : Owner 1099 Information
    • O3UH_ARJE : A/R Journal Entry Generation
    • OIUH_RD09 : A/R Write-off Approval
    • OIUH_RD07 : Ad Valorem Tax Recovery
    • O3UH_ES : Escheat Processing
    • OIUH_RD06 : Withholding Tax Rate
    • S_SOG_81000119 : IMG activity: SIMG_SB_REV_AR
    • O3UH_TP_WO : Taxes Payable Write Off

    Related References

    Related Tutorials

    OIURV_DOC_BCN SAP table for – Revenue Document Concept – Batch Control Number

    OIURV_DOC_BCN table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    O3UH_RV SAP tcode for – Revenue Report Viewer

    O3UH_RV tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Revenue Report...

    OIU_DO_TRGRI SAP table for – Tract Gross Revenue Interest

    OIU_DO_TRGRI table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIU_DO_DOGRI SAP table for – Division Order Gross Revenue Interest

    OIU_DO_DOGRI table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUCW_RUN_PARMS SAP table for – User Input Parameters for the Payment Run

    OIUCW_RUN_PARMS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_CM_OR2 SAP table for – Organization Level 2 Table

    OIUH_CM_OR2 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_CM_OR1 SAP table for – Organization Level 1 Table

    OIUH_CM_OR1 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »