1. SAP Tutorial
  2. Oil & Gas

OIUH_RV_OSTA SAP table for – Owners State Tax Adjustments

Here we would like to draw your attention to OIUH_RV_OSTA 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_OSTA is a SAP standard transp table used for storing Owners State Tax Adjustments related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_OSTA table

Table OIUH_RV_OSTA technical data

TableOIUH_RV_OSTA
Data storingOwners State Tax Adjustments
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_OSTA 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_OSTA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DUMMY_SEQ_FIELD : OIUH_CHAR10
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • STA_OR_LVL_1_NO : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • OSTA_BA_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • OSTA_BA_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OSTA_OI_TYPE_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OSTA_TAX_DT : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14
  • OSTA_ST_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • A_GR_VAL_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • STA_SEVT_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_MKD_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • STA_NVAL_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_NRA_WH_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_WH_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_ST_TAX_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_VALTAX_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_OTH_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_INT_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_GR_VAL_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_SEVT_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_MKD_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_NVAL_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_NRA_WH_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_WH_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_ST_TAX_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_VALTAX_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • STA_INT_PAID_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • TA_OTH_DED_7_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • TA_OTH_DED_8_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_11_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_12_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_13_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_14_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_15_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_16_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_17_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_OTH_DED_18_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_NEMCMP_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • A_NEMCMP_ADJ_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OSTA_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OSTA_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • OSTA_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14

    • OIUH_RV_OSTA related tables

    • OIUH_RV_MSSL_H : Oil and Gas appl table
    • OIUH_RV_DPPN : Division Order Prior Period Notification
    • OIUH_RV_CR : Check Register
    • OIUH_RV_JE : Journal Entry
    • OIUH_RV_CC : Obsolete (4.72) – keep for 1 minor release – Check Control
    • OIUH_RV_MRC : Manual Royalty Check
    • OIUH_CM_CY : Counties Per State
    • OIUH_RV_TAXHA : New Mexico Tax History For Affiliated Txns
    • OIUH_RV_DPACC : DOI Override Acct Codes
    • OIUH_RV_NPSH : Negative Payable/Suspense Header Table
    • OIUH_RV_GVLST : Gross Volume State Table
    • OIUH_RV_RTDE : Receivable Transactions Detail Table
    • OIUH_PR_WC : Oil and Gas appl table
    • OIUH_NM_PDCD_XRF : New Mexico Product Code Cross Reference (TBLTR091)
    • OIUH_PR_SAND : Oil and Gas appl table
    • OIUH_RV_RB : Receivable Balances Table
    • OIUH_RV_DOEX : Owner State Tax Exemption
    • OIUH_RV_RTD : RD DOI Transferee Detail
    • OIUH_RV_ICSL_H : Oil and Gas appl table
    • OIUH_RV_LWDED : Louisiana Marketing Deduction

    OIUH_RV_OSTA related transaction codes under SAP package OIU_H

    • OIUH_JE18 : Accounts Payable Subledger Query
    • OIUH_RD03 : Owner Check
    • S_SOG_81000030 : IMG activity: OIUH_PREMAS_NR
    • S_SO7_65001139 : Generated Text
    • O5UH_JE03 : Accounting Category
    • O3UH_JEPURGE_ANN : JE Annual Purge
    • OIUH_JE11 : Intercompany Subledger Query
    • O3UH_FLASH_UPLOAD : Upload Reporting Flashforms
    • O3UH_ACCT_CLOSE : Accounting Period Close
    • S_SOG_81000121 : IMG activity: OIUH_ACTION_TAKEN
    • S_SOG_81000120 : IMG activity: OIUH_LEGEND_CODE
    • OIUH_JE10 : Miscellaneous Subledger Query
    • OIUH_RD02 : A/R Reconciliation
    • S_SOG_81000122 : IMG activity: OIUH_LA_PARISH
    • O3UH_TC : Treasury Check
    • OIUH_CI06 : Product/Property Translations
    • OIUH_JE19 : Accounts Receivable Subledger Query
    • O3UH_RV : Revenue Report Viewer
    • O3UH_ES : Escheat Processing
    • OIUH_JE13 : Legal Suspense Subledger Query

    Related References

    Related Tutorials

    OIUX8_NM_RPDT_H SAP table for – Tax 2.0 – NM Tax Report Detail – State History

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

    OIUH_RV_ONAB SAP table for – Owners Negative Account Balance

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

    OIUX1_ADJ_MKTC SAP table for – Tax adjustments marketing costs for reporting

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

    OIUH_RV_DOEX SAP table for – Owner State Tax Exemption

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

    OIUX1_ADJ_TAXDC SAP table for – Tax adjustments detail for reporting

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

    OIUH_RV_SVTD SAP table for – Severence Tax State Reporting Number

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

    OIUH_RV_STXR SAP table for – State Tax Rates

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

    «
    »