1. SAP Tutorial
  2. Oil & Gas

OIURV03_TAXDTL SAP table for – Valuation Tax Master Detail

Here we would like to draw your attention to OIURV03_TAXDTL 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). OIURV03_TAXDTL is a SAP standard transp table used for storing Valuation Tax Master Detail related data in SAP. It comes under the package OIU_RV03.

SAP OIURV03_TAXDTL table

Table OIURV03_TAXDTL technical data

TableOIURV03_TAXDTL
Data storingValuation Tax Master Detail
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_RV03
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOC_NO : Val. document number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • LINE_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • POS_NO : Position Number for
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • TAX_TYPE : Severance Tax Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • 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
  • 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
  • TOT_TAX_PC : Total tax percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TOT_TAX_REIMB_PC : Total tax reimbursement 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_RMB : Actual state tax reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ACTL_GR_ST_TX_AM : Actual gross state tax amount
    Its data type is CURR (Currency Field) with field length 15
  • 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
  • ENTL_ST_TAX_AM : Entitled state taxable amount
    Its data type is CURR (Currency Field) with field length 15
  • ENTL_ST_TAX_RMB : Entitled State Tax Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • ENTL_TXVAL : Entitled taxable value
    Its data type is CURR (Currency Field) with field length 15
  • ENTL_TXVL : Entitled taxable volume
    Its data type is QUAN (Quantity field) with field length 13
  • SETT_ST_TAX_AM : Settlement State Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • SETT_ST_TAX_RMB : Settlement State Tax Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • SETT_TXVAL : Settlement taxable value
    Its data type is CURR (Currency Field) with field length 15
  • SETT_TXVL : Settlement taxable volume
    Its data type is QUAN (Quantity field) with field length 13
  • UOM : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INCL_TAX_FREE_05 : Include Tax Free 05 in taxable value/volume summarization
    Its data type is CHAR (Character String) with field length 1
  • 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
  • TAX_CLS : Tax Class
    Its data type is CHAR (Character String) with field length 4
  • TIER_TAX_IND : Tier tax indicator
    Its data type is CHAR (Character String) with field length 1

    • OIURV03_TAXDTL related tables

    • OIURV03_TAXDTL : Valuation Tax Master Detail
    • OIURV03_CONFIG : MP to Well Completion Split Out Config
    • OIURV03_FRMHDR : Valuation Transaction Level 3 – Formula
    • OIURV03_DOCMPXRF : VL Doc to MP XRef
    • OIURV03_VOLDTL : Valuation Transaction Level 2 -Volume
    • OIURV03_TAXEMP : Valuation Tax Exempt Detail
    • OIURV03_DTL_BK : Valuation Transactions Level 1 – Vltxns
    • OIURV03_TAXMKT : Valuation Tax Marketing Detail
    • OIURV03_FRMTAX : Valuation Transactions Level 3 – Formula Tax Detail
    • OIURV03_DTL_ZE : Valuation Transactions Level 1 – Zero Volume
    • OIURV03_MPWC_XRF : MP to Well Completion Split Out XRef
    • OIURV03_TAXHDR : Valuation Tax Header

    Related References

    Related Tutorials

    OIURV_DOC_TAXDTL SAP table for – Valuation Tax Master Detail

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

    OIURV03_FRMTAX SAP table for – Valuation Transactions Level 3 – Formula Tax Detail

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

    OIURV03_TAXMKT SAP table for – Valuation Tax Marketing Detail

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

    OIURV_DOC_FRMTAX SAP table for – Valuation Transactions Level 3 – Formula Tax Detail

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

    OIURV03_TAXEMP SAP table for – Valuation Tax Exempt Detail

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

    OIURV_DOC_TAXMKT SAP table for – Valuation Tax Marketing Detail

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

    OIURV_DOC_TAXEMP SAP table for – Valuation Tax Exempt Detail

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

    «
    »