/APEU/I_MCM_Inst_Data

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 /APEU/I_MCM_Inst_Data.
-- 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: /APEU/INSTDATA

CREATE VIEW /APEU/I_MCM_Inst_Data AS
SELECT
  _Inst_Hdr_Pod.InstanceGuid AS INSTANCE_GUID,
  _Inst_Hdr_Pod.Pod AS POD_ID,
  _Inst_Hdr_Pod.PodDesc AS POD_DESC,
  _Inst_Hdr_Pod.InstanceId AS INSTANCE_ID,
  _Inst_Hdr_Pod.InstanceKey AS INSTANCE_KEY,
  _Inst_Hdr_Pod.Version AS Version,
  _Inst_Hdr_Pod.SubVersion AS SubVersion,
  _Inst_Hdr_Pod.ModelId AS MODEL_ID,
  _Inst_Hdr_Pod.Division AS Division,
  _Inst_Hdr_Pod.PlannedDate AS PLANNED_DATE,
  _Inst_Hdr_Pod.ValidFrom AS VALID_FROM,
  _Inst_Hdr_Pod.ValidTo AS VALID_TO,
  _Inst_Hdr_Pod.Status AS Status,
  _Inst_Hdr_Pod.Progress AS Progress,
  _Inst_Hdr_Pod.auth_grp AS auth_grp,
  _Inst_Hdr_Pod.Target AS Target,
  _Inst_Hdr_Pod.ChangedOn AS CHANGED_ON,
  _Inst_Hdr_Pod.ChangedBy AS CHANGED_BY,
  _Inst_Hdr_Pod.CreatedOn AS CREATED_ON,
  _Inst_Hdr_Pod.CreatedBy AS CREATED_BY,
  _Inst_Hdr_Pod.BusinessStartDate AS BUSINESS_START_DATE,
  _Inst_Hdr_Pod.BusinessEndDate AS BUSINESS_END_DATE,
  _Inst_Hdr_Pod.DeviceTransDate AS DEVICE_TRANS_DATE,
  _Inst_Hdr_Pod.DeletionFlag AS DELETION_FLAG,
  _Inst_Hdr_Pod.ExternalId AS ExternalId,
  _Inst_Hdr_Pod.Direction AS Direction,
  _Inst_Hdr_Pod.LocClassId AS Loc_Class_Id,
  _Inst_Hdr_Pod.LocId AS Loc_Id,
  _Inst_Hdr_Pod.LocCatCode AS Loc_Cat_Code,
  _Inst_Hdr_Pod.Origin AS Origin,
  _Inst_Hdr_Pod.DirectSell AS DIRECT_SELL,
  _Inst_Hdr_Pod.SettleProcedure AS SETTLE_PROCEDURE,
  _Inst_Hdr_Pod.BillProcedure AS BILL_PROCEDURE,
  _Inst_Hdr_Pod.EnergySourceCode AS ENERGY_SOURCE_CODE,
  _Inst_Hdr_Pod.GroupingValue AS GROUPING_VALUE,
  _Inst_Hdr_Pod.ConnectionObjectId AS CONNOBJ_NO,
  _Inst_Hdr_Pod.DeviceLocationId AS DEVLOC_NO,
  _Inst_Hdr_Pod.PremiseId AS PREMISE_NO,
  _Inst_Hdr_Pod.InstallationId AS INSTLN_NO,
  _Inst_Hdr_Pod.MeterType AS METER_TYPE,
  _Inst_Hdr_Pod.ModelEntityId AS MODEL_ENTITY_ID,
  _Inst_Hdr_Pod.ExternalCode AS EXTERNAL_CODE,
  _Inst_Hdr_Pod.ParentPod AS PARENT_POD
FROM /APEU/I_MCM_INST_HDR_POD AS _Inst_Hdr_Pod
LEFT OUTER JOIN /APEU/I_MCM_INST_ACTOR AS _Inst_Objs_Actor ON _Inst_Hdr_Pod.InstanceGuid = _Inst_Objs_Actor.instance_guid AND _Inst_Hdr_Pod.Pod = _Inst_Objs_Actor.pod_id  -- association [1..*]
LEFT OUTER JOIN /APEU/I_MCM_Inst_Meas AS _Inst_Objs_Meas_Task ON _Inst_Hdr_Pod.InstanceGuid = _Inst_Objs_Meas_Task.instance_guid AND _Inst_Hdr_Pod.Pod = _Inst_Objs_Meas_Task.pod_id  -- association [1..*]
;