I_MeasurementPointVolume

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MeasurementPointVolume.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPVMPVL

CREATE VIEW I_MeasurementPointVolume AS
SELECT
  mpvl_year AS MeasurementPtVolDocYear,
  mpvl_no AS MeasurementPtVolumeDoc,
  mp_no AS MeasurementPoint,
  vt_cd AS VolumeType,
  vc_cd AS VolumeClass,
  trnsp_no AS Transporter,
  trnsp_ref_no AS TransporterReference,
  matnr AS Material,
  freq_cd AS AllocationFrequency,
  dn_no AS DeliveryNetwork,
  ct_no AS PRAContract,
  tkt_no AS TicketNumber,
  tkt_timestamp AS TicketDateTime,
  prd_dt AS ProductionDate,
  ent_timestamp AS VolumeEntryDateTime,
  eff_from_dt AS EffectiveValidityStartDate,
  eff_to_dt AS EffectiveValidityEndDate,
  meter_start AS MeterStartDateTime,
  meter_stop AS MeterStopDateTime,
  conv_grp AS ConversionGroup,
  tkbtry_mp_no AS TankBatteryMeasurementPt,
  vs_cd AS VolumeSource,
  vl_cat_cd AS VolumeCategory,
  ld_oil_dn_no AS LoadOilDeliveryNetwork,
  ld_oil_wl_no AS LoadOilWell,
  ld_oil_wc_no AS LoadOilWellCompletion,
  ld_oil_mp_no AS LoadOilMeasurementPoint,
  orig_mp_no AS OriginatingMeasurementPt,
  dentyp AS DensityType,
  invt_dt AS InventoryDate,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime,
  cast( 'O3U_MPVL3' as fqm_origin_trans_id ) AS OriginTransaction,
  std_vol_u AS StandardVolUnit,
  energy_u AS EnergyUnit,
  heat_val_u AS HeatingValUnit,
  base_density_u AS StandardDensityUnit,
  heat_val AS HeatingValue,
  base_density AS StandardDensity,
  std_vol AS StandardVolume,
  Energy,
  mol_volume AS GasMolarVolume,
  ld_oil_wo_recov AS LoadOilTransferWithoutRecovery,
  status AS MsmtPtVolDocSts,
  me_docnr AS PRAMeasurementDocumentNumber,
  me_docyr AS MeasurementDocYear,
  draft_me_docnr AS DraftMeasurementDocumentNumber,
  draft_me_docyr AS DraftMeasurementDocYear
FROM oiu_pr_mpvl
LEFT OUTER JOIN I_CalendarYear AS _DocYear ON MeasurementPtVolDocYear = _DocYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON VolumeType = _VolumeType.VolumeType  -- association [0..1]
LEFT OUTER JOIN I_VolumeClass AS _VolumeClass ON VolumeClass = _VolumeClass.VolumeClass  -- association [0..1]
LEFT OUTER JOIN I_VolumeSource AS _VolumeSource ON VolumeSource = _VolumeSource.VolumeSource  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Transporter ON Transporter = _Transporter.Customer  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_AllocationFrequencyCode AS _AllocationFrequencyCode ON AllocationFrequency = _AllocationFrequencyCode.AllocationFrequency  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_ConversionGroup AS _ConversionGroup ON ConversionGroup = _ConversionGroup.ConversionGroup  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _TankBatteryMeasurementPt ON TankBatteryMeasurementPt = _TankBatteryMeasurementPt.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_VolumeCategory AS _VolumeCategory ON VolumeCategory = _VolumeCategory.VolumeCategory  -- association [0..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _LoadOilDeliveryNetwork ON LoadOilDeliveryNetwork = _LoadOilDeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_Well AS _LoadOilWell ON LoadOilWell = _LoadOilWell.Well  -- association [0..1]
LEFT OUTER JOIN I_WellCompletion AS _LoadOilWellCompletion ON LoadOilWell = _LoadOilWellCompletion.Well AND LoadOilWellCompletion = _LoadOilWellCompletion.WellCompletion  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _LoadOilMeasurementPoint ON LoadOilMeasurementPoint = _LoadOilMeasurementPoint.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _OriginatingMeasurementPt ON OriginatingMeasurementPt = _OriginatingMeasurementPt.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_DensityType AS _DensityType ON DensityType = _DensityType.DensityType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardVolUnit ON StandardVolUnit = _StandardVolUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EnergyUnit ON EnergyUnit = _EnergyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeatingValUnit ON HeatingValUnit = _HeatingValUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardDensityUnit ON StandardDensityUnit = _StandardDensityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
;