C_MeasurementPointVolQry

Measurement Point Volume Query | view: CPVMPVLQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_PR_MPVL
Column Name Description
Column Name Description
Column Name Description
📏 Heating Value Unit (HeatingValUnit):
HeatingValue Heating value
📏 Standard volume unit (StandardVolUnit):
StandardVolume Standard volume
📏 Energy quantity unit (EnergyUnit):
Energy Energy quantity
📏 Unit for densities at standard/base conditions (StandardDensityUnit):
GasMolarVolume Gas mol volume
Column Name Description
ProductionDate Production date
EffectiveValidityStartDate Effective from date
EffectiveValidityEndDate Effective To Date
InventoryDate Inventory date
Column Name Description
VolumeClass Volume class code Show values
AllocationFrequency Frequency Show values
VolumeCategory Volume Category Code Show values
DensityType Density Type Show values
Column Name Description Domain name
MeasurementPtVolDocYear Measurement point document year GJAHR
MeasurementPtVolumeDoc MP volume Number OIU_DOCNR
TransporterReference Transporter Reference Number OIU_TEXT25
TicketNumber Ticket number OIU_TKT_NO
TicketDateTime Ticket timestamp TZNTSTMPS
VolumeEntryDateTime Entry timestamp TZNTSTMPS
MeterStartDateTime Meter start time TZNTSTMPS
MeterStopDateTime Meter stop time TZNTSTMPS
TankBatteryMeasurementPt Tank battery measurement point number OIU_MP_NO
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
StandardDensity Oil/gas density at standard/base conditions OIU_DICHT
Master Data Relations Join Conditions
Conversion group
  • Conversion Group (Oil, Natural Gas,..)
  • Client
  • C_MEASUREMENTPOINTVOLQRY.CONVERSIONGROUP == OIB01.UMRSL
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIB01.MANDT
Delivery network number
  • Client
  • Delivery network number
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_DN.MANDT
  • C_MEASUREMENTPOINTVOLQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Energy quantity unit
  • Energy quantity unit
  • Client
  • C_MEASUREMENTPOINTVOLQRY.ENERGYUNIT == T006.MSEHI
  • C_MEASUREMENTPOINTVOLQRY.MANDT == T006.MANDT
Standardized gas quantity unit
  • Heating Value Unit
  • Client
  • C_MEASUREMENTPOINTVOLQRY.HEATINGVALUNIT == T006.MSEHI
  • C_MEASUREMENTPOINTVOLQRY.MANDT == T006.MANDT
Load oil delivery network
  • Client
  • Load oil delivery network
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_DN.MANDT
  • C_MEASUREMENTPOINTVOLQRY.LOADOILDELIVERYNETWORK == OIU_PR_DN.DN_NO
Load oil measurement point
  • Load oil measurement point
  • Client
  • C_MEASUREMENTPOINTVOLQRY.LOADOILMEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_MP.MANDT
Load oil well number
  • Load oil well number
  • Client
  • C_MEASUREMENTPOINTVOLQRY.LOADOILWELL == OIU_PR_WELL.WL_NO
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_WELL.MANDT
Load oil well completion
  • Load oil well number
  • Client
  • Load oil well completion
  • C_MEASUREMENTPOINTVOLQRY.LOADOILWELL == OIU_PR_WC.WL_NO
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_WC.MANDT
  • C_MEASUREMENTPOINTVOLQRY.LOADOILWELLCOMPLETION == OIU_PR_WC.WC_NO
Material Number
  • Material Number
  • Client
Measurement point number
  • Client
  • Measurement point number
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_MP.MANDT
  • C_MEASUREMENTPOINTVOLQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Measurement Point ID
  • Original measurement point number
  • Client
  • C_MEASUREMENTPOINTVOLQRY.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • C_MEASUREMENTPOINTVOLQRY.MANDT == OIU_PR_MP.MANDT
Standardized Volume Unit
  • Standard volume unit
  • Client
  • C_MEASUREMENTPOINTVOLQRY.STANDARDVOLUNIT == T006.MSEHI
  • C_MEASUREMENTPOINTVOLQRY.MANDT == T006.MANDT
Transporter number
  • Transporter number
  • Client
  • C_MEASUREMENTPOINTVOLQRY.TRANSPORTER == KNA1.KUNNR
  • C_MEASUREMENTPOINTVOLQRY.MANDT == KNA1.MANDT
Volume Source Code
  • Volume Source Code
  • Client
Volume Type Code C_MEASUREMENTPOINTVOLQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD