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