1. SAP Tutorial
  2. Oil & Gas

OIUVL_SCAUDIT SAP table for – Settlement statement batch

Here we would like to draw your attention to OIUVL_SCAUDIT 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_SCAUDIT is a SAP standard transp table used for storing Settlement statement batch related data in SAP. It comes under the package OIU_RVVA.

SAP OIUVL_SCAUDIT table

Table OIUVL_SCAUDIT technical data

TableOIUVL_SCAUDIT
Data storingSettlement statement batch
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_SCAUDIT 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_SCAUDIT 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_ITEM_NO : Document Line Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • SALE_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WI_OWN_NO : Working Interest Owner
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • WI_INT_TYPE_CD : Participant Interest Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • WI_OWN_ISQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TRANSACT_TYPE : Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • SYSTEM_SRCE_CD : Valuation Transaction Source Code
    Its data type is CHAR (Character String) with field length 2
  • SALE_MONTH : Sales Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TXN_PRCS_CD : Transaction Process Code
    Its data type is CHAR (Character String) with field length 2
  • CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • VL_TYPE_CD : Volume type code
    Its data type is CHAR (Character String) with field length 2
  • DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • PURCH_NO : Purchaser
    Its data type is CHAR (Character String) with field length 10
  • CT_DECM : Contract Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • HEAT_VAL_FCT_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACT_HEAT_VAL_FCT : Actual Heating Factor
    Its data type is QUAN (Quantity field) with field length 13
  • GRV : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • DENSITY_U : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DNTYP : Density Type
    Its data type is CHAR (Character String) with field length 1
  • TOT_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACTL_GR_VL : Actual Gross Volume Amount
    Its data type is QUAN (Quantity field) with field length 13
  • WLR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACTL_WLR_VL : Act. Wet-less-Residue Vol. Amount
    Its data type is QUAN (Quantity field) with field length 13
  • GR_VAL_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACTL_GR_VAL : Actual Gross Value Amount
    Its data type is CURR (Currency Field) with field length 13
  • MKCT_1 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_2 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_3 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_4 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_5 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_6 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_7 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_8 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_9 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_10 : Marketing cost amount
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_1 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_2 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_3 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_4 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_5 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_6 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_7 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_8 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_9 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • MK_RMB_10 : Marketing Reimbursement
    Its data type is CURR (Currency Field) with field length 15
  • TAX_CALC_FL : Calculate Tax Flag
    Its data type is CHAR (Character String) with field length 1
  • SEVT_TYPE_CD_1 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_2 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_3 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_4 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_5 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_6 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_7 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_8 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SEVT_TYPE_CD_9 : Severance tax type code
    Its data type is CHAR (Character String) with field length 2
  • SVTR_1 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_2 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_3 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_4 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_5 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_6 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_7 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_8 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SVTR_9 : Tax or reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_1 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_2 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_3 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_4 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_5 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_6 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_7 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_8 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • SEVT_9 : Severance tax amount
    Its data type is CURR (Currency Field) with field length 15
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    Its data type is CHAR (Character String) with field length 2
  • .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

    • OIUVL_SCAUDIT related tables

    • OIUVL_MTAD : Marketing Cost Tax Exemption – Detail
    • OIUVL_OILRPTH : Oil statement report header
    • OIUVL_SEVMP : Severance tax measurement point
    • OIUVL_STTR : State Tax Rates
    • OIUVL_GASRPTD : Gas statement report detail
    • OIUVL_PPN_REJSEL : PPN – Reject Selection
    • OIUVL_TTRPD : Tax Tier Rate by Project – Data
    • OIUVL_GASDTL_HST : Gas statement Detail
    • OIUVL_GASRPTH : Gas statement report header
    • OIUVL_TPAH : Tax Processing Allowance
    • OIUVL_TCJV : Tax Class – Venture DOI’s
    • OIUVL_SSTH : Settlement statement header
    • OIUVL_STIKO : Severance tax take in kind
    • OIUVL_SEVWC : Severance tax well completion
    • OIUVL_RPTD : Valuation report detail
    • OIUVL_SCAUDIT : Settlement statement batch
    • OIUVL_OILTAX_HST : Oil Run Statement Tax Marketing
    • OIUVL_TTRD : Tax Tier Rate – Data
    • OIUVL_GASTAX_HST : Gas Statement Tax Marketing
    • OIUVL_GSP : Gas Statement Profile

    OIUVL_SCAUDIT related transaction codes under SAP package OIU_RVVA

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

    Related References

    Related Tutorials

    OIURV_SSTD_TAX SAP table for – Settlement statement detail

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

    OIURV_SSTD_MKT SAP table for – Settlement statement detail

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

    OIUVL_SSTH SAP table for – Settlement statement header

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

    OIURV_SSTD SAP table for – Settlement statement detail

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

    OIUVL_GASTAX_CUR SAP table for – Gas Statement Tax Marketing

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

    OIUVL_GASTAX_HST SAP table for – Gas Statement Tax Marketing

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

    OIUVL_OILTAX_CUR SAP table for – Oil Run Statement Tax Marketing

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

    «
    »