1. SAP Tutorial
  2. Oil & Gas

OIURV_STS SAP table for – Severance tax statistics

Here we would like to draw your attention to OIURV_STS 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). OIURV_STS is a SAP standard transp table used for storing Severance tax statistics related data in SAP. It comes under the package OIU_RVDC.

SAP OIURV_STS table

Table OIURV_STS technical data

TableOIURV_STS
Data storingSeverance tax statistics
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-VAL
SAP PackageOIU_RVDC
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIURV_STS 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 OIURV_STS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SEV_NO : Severance tax number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • TAX_TYPE : Severance Tax Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SEVT_PAY_FL : Tax Severance Tax Calculation Payment Obligations Types
    Its data type is CHAR (Character String) with field length 1
  • SEVT_RPT_FL : State Severance Tax Reporting Indicators
    Its data type is CHAR (Character String) with field length 1
  • FX_MCD : Fixed marketing cost deduction
    Its data type is CURR (Currency Field) with field length 15
  • FX_MCD_RAT : Fixed marketing cost deduction rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VL_TAX_RAT : Volume tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • VAL_TAX_RAT : Value tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ACTL_TXVAL : Actual taxable value
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_TXVL : Actual taxable volume
    Its data type is QUAN (Quantity field) with field length 13
  • ACTL_OVRD_TAX_VA : Actual override taxable value
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_OVRD_TAX_VL : Actual override taxable volume
    Its data type is QUAN (Quantity field) with field length 13
  • TOTAL_TAX_PC : Total tax percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ACTL_ST_TAX_AM : Actual state tax amount
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_ST_TAX_REIM : Actual state tax reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TAX_FREE_05_VAL : Tax free 05 value
    Its data type is CURR (Currency Field) with field length 15
  • TAX_FREE_05_VL : Tax free 05 volume
    Its data type is QUAN (Quantity field) with field length 13
  • TAX_FREE_05_WLR : Tax free 05 wet-less-residue
    Its data type is QUAN (Quantity field) with field length 13
  • ST_TAX_PROC_ALLW : State tax processing allowance
    Its data type is CURR (Currency Field) with field length 15

    • OIURV_STS related tables

    • OIURV_TAXCONFD : State tax configuration detail
    • OIURV_SSTD_TAX : Settlement statement detail
    • OIURV_DOC_FRMLAU : Valuation Formula Alternate Use
    • OIURV_DOC_CRAD : Oil and Gas appl table
    • OIURV_SSTD_MKT : Settlement statement detail
    • OIURV_TCD_EMP : Tax calculation data
    • OIURV_DOC_BCN : Revenue Document Concept – Batch Control Number
    • OIURV_DOC_TAXDTL : Valuation Tax Master Detail
    • OIURV_TCD_MKT : Tax calculation data
    • OIURV_DOC_TAXEMP : Valuation Tax Exempt Detail
    • OIURV_DOC_FRMHDR : Valuation Transaction Level 3 – Formula
    • OIURV_TAXCONFH : State tax configuration header
    • OIU_CM_MKT_TX : Marketing type description table
    • OIURV_DOC_CRTAX : Oil and Gas appl table
    • OIURV_DOC_TAXMKT : Valuation Tax Marketing Detail
    • OIURV_DOC_FRMMKT : Valuation Transactions Level 3 – Marketing Detail
    • OIURV_TCD : Tax calculation data
    • OIURV_SSTD : Settlement statement detail
    • OIURV_DOC_DTL_ZE : Valuation Transactions Level 1 – Zero Volume
    • OIURV_DOC_CRMKT : Oil and Gas appl table

    OIURV_STS related transaction codes under SAP package OIU_RVDC

    • S_SO7_65001124 : Generated Text
    • O3U_MKT6 : Delete Internal Marketing Rates
    • S_SO7_65001125 : Generated Text
    • O3URV_SRPT : Valuation Selection Report
    • O3U_VLFR6 : Delete Valuation Formula
    • O3U_MKT3 : Display Internal Marketing Rates
    • O3UCP_MKT_CST0 : Contract Marketing Costs
    • O3UVL_MTA : Marketing Cost Tax Allowance
    • O3U_VLFR1 : Create Valuation Formula
    • O3URV_DOC : Valuation Document Worklist
    • O3URV_SS0 : Settlement Statement
    • S_SOG_81000016 : Generated Text
    • O3UVL_TCD0 : Tax Calculation Data – Doc Concept
    • O3U_MKT2 : Change Internal Marketing Rates
    • O3URV_COMB : Combined Run Report
    • O3U_DP9 : DOI Accounting List Processing
    • O3U_DP2 : DOI Accounting Change – Doc Concept
    • O3U_PP3 : Price maintenance
    • O3U_VLFR3 : Display Valuation Formula
    • O3U_VLFR9 : Valuation Formula list processing

    Related References

    Related Tutorials

    OIURV_STS_MKT SAP table for – Severance Tax Statistics – Marketing

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

    OIURV_STS_EMP SAP table for – Severance Tax Statistics – Exempt

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

    OIUVL_STS SAP table for – Severance tax statistics

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

    OIUX6_WY_SRPDT_H SAP table for – Tax 2.0 – Wyoming Severance Tax Report Detail

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

    OIUX6_WY_STAXSTG SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions Staging

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

    OIUX6_WY_SPRDT SAP table for – Tax 2.0 – Wyoming Severance Tax PRA Detail Transactions

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

    OIUX6_WY_STAXHST SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions History

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

    «
    »