/UCOM/C_MCM_Master_Data

DDL: /UCOM/C_MCM_MASTER_DATA SQL: /UCOM/CMASTDAT Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 9 Associations

Instance Master Data

/UCOM/C_MCM_Master_Data is a Consumption CDS View that provides data about "Instance Master Data" in SAP S/4HANA. It reads from 1 data source (/UCOM/C_MCM_Inst_Pod_Rel) and exposes 8 fields with key fields InstanceGuid, InternalPoD, ParentPod. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/UCOM/C_MCM_Inst_Pod_Rel /UCOM/C_MCM_Inst_Pod_Rel from

Associations (9)

CardinalityTargetAliasCondition
[1..1] /APEU/I_MCM_Inst_Data _InstData _InstData.INSTANCE_GUID = $projection.InstanceGuid and _InstData.POD_ID = $projection.PoD
[0..1] /UCOM/C_MCM_Connobj_VH _ConnObj _ConnObj.UtilitiesConnectionObject = $projection.ConnectionObject
[0..1] /UCOM/C_MCM_Premise_VH _Premise _Premise.UtilitiesPremise = $projection.UtilitiesPremise
[1..*] /UCOM/C_MCM_Inst_Meas _InstMeas _InstMeas.InstanceGuid = $projection.InstanceGuid and _InstMeas.PodId = $projection.PoD
[0..*] /UCOM/C_MCM_Device _Device _Device.InstanceGuid = $projection.InstanceGuid and _Device.PodId = $projection.PoD
[0..*] /UCOM/C_MCM_FORMULA _Formula _Formula.InstanceGuid = $projection.InstanceGuid and _Formula.PointOfDelivery = $projection.PoD
[0..*] /UCOM/C_MCM_ACTORS _Actors _Actors.InstanceGuid = $projection.InstanceGuid and _Actors.PointOfDelivery = $projection.PoD
[0..*] /UCOM/C_MCM_POD_SERVICE_DETAIL _PoDService _PoDService.UtilsExternalPointOfDelivery = $projection.PoD and ( _PoDService.ServiceStartDate <= $projection.ValidTo and _PoDService.ServiceEndDate >= $projection.ValidFrom )
[1..1] /UCOM/I_UTILSINSTLN _UtilsInstln _UtilsInstln.INSTANCE_GUID = $projection.InstanceGuid and _UtilsInstln.POD_ID = $projection.PoD

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Instance Master Data view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InstanceGuid InstanceGuid
KEY InternalPoD InternalPoD
KEY ParentPod ParentPod
PoD PoD Point of Delivery
LocCatDesc LocCatDesc Type
LocClassId LocClassId
DirectionDescription DirectionDescription Direction
LocClassDesc LocClassDesc Location Classification

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 /UCOM/C_MCM_Master_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: /UCOM/CMASTDAT

CREATE VIEW /UCOM/C_MCM_Master_Data AS
SELECT
  InstanceGuid,
  InternalPoD,
  ParentPod,
  PoD,
  LocCatDesc,
  LocClassId,
  DirectionDescription,
  LocClassDesc
FROM /UCOM/C_MCM_Inst_Pod_Rel
LEFT OUTER JOIN /APEU/I_MCM_Inst_Data AS _InstData ON _InstData.INSTANCE_GUID = InstanceGuid AND _InstData.POD_ID = PoD  -- association [1..1]
LEFT OUTER JOIN /UCOM/C_MCM_Connobj_VH AS _ConnObj ON _ConnObj.UtilitiesConnectionObject = ConnectionObject  -- association [0..1]
LEFT OUTER JOIN /UCOM/C_MCM_Premise_VH AS _Premise ON _Premise.UtilitiesPremise = UtilitiesPremise  -- association [0..1]
LEFT OUTER JOIN /UCOM/C_MCM_Inst_Meas AS _InstMeas ON _InstMeas.InstanceGuid = InstanceGuid AND _InstMeas.PodId = PoD  -- association [1..*]
LEFT OUTER JOIN /UCOM/C_MCM_Device AS _Device ON _Device.InstanceGuid = InstanceGuid AND _Device.PodId = PoD  -- association [0..*]
LEFT OUTER JOIN /UCOM/C_MCM_FORMULA AS _Formula ON _Formula.InstanceGuid = InstanceGuid AND _Formula.PointOfDelivery = PoD  -- association [0..*]
LEFT OUTER JOIN /UCOM/C_MCM_ACTORS AS _Actors ON _Actors.InstanceGuid = InstanceGuid AND _Actors.PointOfDelivery = PoD  -- association [0..*]
LEFT OUTER JOIN /UCOM/C_MCM_POD_SERVICE_DETAIL AS _PoDService ON _PoDService.UtilsExternalPointOfDelivery = PoD AND ( _PoDService.ServiceStartDate <= ValidTo AND _PoDService.ServiceEndDate >= ValidFrom )  -- association [0..*]
LEFT OUTER JOIN /UCOM/I_UTILSINSTLN AS _UtilsInstln ON _UtilsInstln.INSTANCE_GUID = InstanceGuid AND _UtilsInstln.POD_ID = PoD  -- association [1..1]
;

Learn More