1. SAP Tutorial
  2. Oil & Gas

OIUVL_STS SAP table for – Severance tax statistics

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

SAP OIUVL_STS table

Table OIUVL_STS technical data

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

SAP OIUVL_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 OIUVL_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
  • 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
  • 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
  • TOTAL_TAX_PC : Total tax percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_CD_1 : Exempt Entity Code
    Its data type is CHAR (Character String) with field length 2
  • EXMP_CD_2 : Exempt Entity Code
    Its data type is CHAR (Character String) with field length 2
  • EXMP_CD_3 : Exempt Entity Code
    Its data type is CHAR (Character String) with field length 2
  • EXMP_CD_4 : Exempt Entity Code
    Its data type is CHAR (Character String) with field length 2
  • EXMP_CD_5 : Exempt Entity Code
    Its data type is CHAR (Character String) with field length 2
  • EXMP_INT_DEC_1 : Exempt interest decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_INT_DEC_2 : Exempt interest decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_INT_DEC_3 : Exempt interest decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_INT_DEC_4 : Exempt interest decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_INT_DEC_5 : Exempt interest decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXMP_VL_1 : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXMP_VL_2 : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXMP_VL_3 : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXMP_VL_4 : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXMP_VL_5 : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXMP_VAL_1 : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • EXMP_VAL_2 : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • EXMP_VAL_3 : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • EXMP_VAL_4 : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • EXMP_VAL_5 : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_1 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_2 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_3 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_4 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_5 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_6 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_7 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_8 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_9 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MKCT_10 : Actual marketing cost
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_1 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_2 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_3 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_4 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_5 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_6 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_7 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_8 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_9 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_MCR_10 : Actual marketing cost reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • 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

    • OIUVL_STS related tables

    • OIUVL_OILTAX_HST : Oil Run Statement Tax Marketing
    • OIUVL_GASDTL_CUR : Gas statement Detail
    • OIUVL_DD_MASTER : Master DD list
    • OIUVL_TCWC : Tax Class – Well Completion
    • OIUVL_GASTAX_HST : Gas Statement Tax Marketing
    • OIUVL_TTVLTY : Tier tax volume type
    • OIUVL_TPAH : Tax Processing Allowance
    • OIUVL_TTRD : Tax Tier Rate – Data
    • OIUVL_RPT : Valuation reporting header
    • OIUVL_OILTAX_CUR : Oil Run Statement Tax Marketing
    • OIUVL_SEVCI : Severance tax check input
    • OIUVL_CUR_SEL : Valuation currect selection
    • OIUVL_SEV : Severance tax
    • OIUVL_PLTR : Weighted average plant reimbursement header
    • OIUVL_OILRPTD : Oil statement report detail
    • OIUVL_OILRPTH : Oil statement report header
    • OIUVL_TCMP : Tax Class Measurement Points
    • OIUVL_STTR : State Tax Rates
    • OIUVL_TTRPD : Tax Tier Rate by Project – Data
    • OIUVL_SEVMP : Severance tax measurement point

    OIUVL_STS related transaction codes under SAP package OIU_RVVA

    • O3UVL_TCL9 : Tax Classification List Processing
    • O3UVL_GST9 : Gas Statement Report List Processing
    • O3UVL_GSP0 : Gas Statement Profile
    • S_SO6_65000960 : Generated Text
    • O3UVL_STR0 : State Tax Rates
    • O3UVL_TTX0 : Tier Tax Maintenance
    • S_SO6_65000961 : Generated Text
    • O3UVL_OST9 : Oil Statement Report List Processing
    • O3UVL_RTI : Run Tickets
    • S_SO7_65001096 : Generated Text
    • S_SO7_65001097 : Generated Text
    • O3UVL_TPA0 : Tax Processing Allowance
    • O3UVL_TCL0 : Tax Classification
    • O3UVL_RPA0 : Royalty Processing Allowance
    • S_SO7_65001095 : Generated Text
    • S_SO6_65000994 : Generated Text
    • O3UVL_OSP0 : Oil Statement Profile

    Related References

    Related Tutorials

    OIURV_STS SAP table for – Severance tax statistics

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

    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...

    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...

    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_STAXTXN SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions

    OIUX6_WY_STAXTXN 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...

    «
    »