OIU_RV_VLTXNS SAP table for – Valuation Transactions

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

SAP OIU_RV_VLTXNS table

Table OIU_RV_VLTXNS technical data

TableOIU_RV_VLTXNS
Data storingValuation Transactions
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • 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
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MAJPD_CD : Major product code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FREQ_CD : Frequency
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SALE_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SCHOOL_DIST_CD : School district code
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • TAX_CLS : Tax Class
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VLTXNS_NO : Valuation Transaction Number
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • POS_NO : Last used (highest) position number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • FRML_NO : Formula number
    Its data type is CHAR (Character String) with field length 8
  • LVL_CD : Level Code
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • GROUP_CD : Group Code
    Its data type is CHAR (Character String) with field length 1
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    Its data type is CHAR (Character String) with field length 2
  • UNIT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • DOI_SUM_FL : Summarize RD to DOI Level Flag
    Its data type is CHAR (Character String) with field length 1
  • RM_FEE_FL : CO2 Removal Fee Flag
    Its data type is CHAR (Character String) with field length 1
  • DUAL_ACCT_FL : Dual Accounting Flag
    Its data type is CHAR (Character String) with field length 1
  • TXN_PRCS_CD : Transaction Process Code
    Its data type is CHAR (Character String) with field length 2
  • CT_TYPE_CD : Contract Type
    Its data type is CHAR (Character String) with field length 2
  • VL_VAL_ON_VAL_FL : Value on Value indicator
    Its data type is CHAR (Character String) with field length 1
  • REJ_REPRCS_FL : Reject Reprocess Flag
    Its data type is CHAR (Character String) with field length 1
  • FULL_SMPL_PLT_CD : Full Simple Plant Network
    Its data type is CHAR (Character String) with field length 1
  • .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