I_PRAMsmtPointVariableData

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_PRAMsmtPointVariableData.
-- 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.

CREATE VIEW I_PRAMsmtPointVariableData AS
SELECT
  mp_no AS MeasurementPoint,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  hvcls AS PRACalorificValueClass,
  crud_type_cd AS PRACrudeTypeCode,
  sa_pt_fl AS PRAIsSalesPointFlag,
  inactive_fl AS PRAIsMsmtPointInactive,
  op_fl AS PRAIsMsmtPointOperated,
  sat_dry_cd AS PRASaturatedDryCode,
  intra_nwk_fl AS PRAIsIntraNetworkNode,
  plt_inlet_fl AS PRAMsmtPointIsPlantInlet,
  strm_type_cd AS PRAStreamTypeCode,
  strm_dflt_fl AS PRAIsMsmtPointDefaultForStream,
  rlf_usage_fl AS PRAMsmtPtHasReturnLeaseFuelUse,
  company_code AS CompanyCode,
  cost_center AS CostCenter,
  chrt_typ_cd AS PRAMsmtPtChartTypeCode,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  pipl_open_pd AS PRAMsmtPtPipelineOpenPeriod
FROM oiu_pr_mpvd
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON _MeasurementPoint.MeasurementPoint = MeasurementPoint  -- association [1..1]
LEFT OUTER JOIN I_PRACrudeType AS _PRACrudeType ON _PRACrudeType.PRACrudeTypeCode = PRACrudeTypeCode  -- association [0..1]
LEFT OUTER JOIN I_PRACalorificValueClassVH AS _PRACalorificValueClassVH ON _PRACalorificValueClassVH.PRACalorificValueClass = PRACalorificValueClass  -- association [0..1]
LEFT OUTER JOIN I_PRASaturatedDryCodeVH AS _PRASaturatedDryCodeVH ON _PRASaturatedDryCodeVH.PRASaturatedDryCode = PRASaturatedDryCode  -- association [0..1]
LEFT OUTER JOIN I_PRAStreamTypeCodeVH AS _PRAStreamTypeCode ON _PRAStreamTypeCode.PRAStreamTypeCode = PRAStreamTypeCode  -- association [0..1]
LEFT OUTER JOIN I_PRAChartTypeCodeVH AS _PRAChartTypeCodeVH ON _PRAChartTypeCodeVH.PRAMsmtPtChartTypeCode = PRAMsmtPtChartTypeCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
;