OIU_PR_DNVD SAP table for – Delivery Network Variable Data

Here we would like to draw your attention to OIU_PR_DNVD 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_PR_DNVD is a SAP standard transp table used for storing Delivery Network Variable Data related data in SAP. It comes under the package OIU.

SAP OIU_PR_DNVD table

Table OIU_PR_DNVD technical data

TableOIU_PR_DNVD
Data storingDelivery Network Variable Data
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_PR_DNVD 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_PR_DNVD 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
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AL_BASIS_CD : Allocation Basis Code
    Its data type is CHAR (Character String) with field length 1
  • AL_FL : Allocation indicator
    Its data type is CHAR (Character String) with field length 1
  • THEO_BASIS_CD : Saturated/Dry Code
    Its data type is CHAR (Character String) with field length 1
  • THEO_INFL_AM : Theoretical inflation factor
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CHA_COMPAT_CD : Chemical analysis compatibility code.
    Its data type is CHAR (Character String) with field length 4
  • PI_METH_CD : Plant inlet calculation method code
    Its data type is CHAR (Character String) with field length 1
  • INACTIVE_FL : Inactive indicator
    Its data type is CHAR (Character String) with field length 1
  • CHEM_MEAS_GRP_ID : Chemical Measurement Group
    Its data type is CHAR (Character String) with field length 10
  • MEAS_GRP_ID : Measurement Group ID
    Its data type is CHAR (Character String) with field length 10
  • CA_PRCS_FREQ_CD : Processing Frequency Code
    Its data type is CHAR (Character String) with field length 1
  • CA_AUTO_SEL_FL : Contractual Allocation Auto Select indicator
    Its data type is CHAR (Character String) with field length 1
  • CA_ALLOC_METH_CD : Allocation Method Code
    Its data type is CHAR (Character String) with field length 1
  • CA_ALLOC_TOL_PC : CA Allocation Tolerance Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CA_ALLOC_BAS_CD : Gas Allocation Basis Code
    Its data type is CHAR (Character String) with field length 1
  • CA_ASSUME_MKR_FL : Assume Market Groups
    Its data type is CHAR (Character String) with field length 1
  • CA_ASSUME_ACR_FL : Assume ACRs
    Its data type is CHAR (Character String) with field length 1
  • CA_ASSUME_DOI_FL : Assume DOIs in Simple Plants
    Its data type is CHAR (Character String) with field length 1
  • CA_SPF_SBE_FL : SPF Sales-Based Entitlements indicator
    Its data type is CHAR (Character String) with field length 1
  • CA_SPF_CPNT_FL : Component Level
    Its data type is CHAR (Character String) with field length 1
  • CA_FPF_WGB_CD : FPF Wet Gas Balancing Code
    Its data type is CHAR (Character String) with field length 1
  • CA_FPF_SP_RLF_FL : FPF Special Return Lease Fuel Processing Flag
    Its data type is CHAR (Character String) with field length 1
  • VL_PRCS_FREQ_CD : Run Valuation
    Its data type is CHAR (Character String) with field length 1
  • VL_AUTO_SEL_FL : Valuation Auto Select Flag
    Its data type is CHAR (Character String) with field length 1
  • VL_VAL_ON_VAL_FL : Value on Value indicator
    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