I_RESrvcGrpArchtrObjPartcipn

DDL: I_RESRVCGRPARCHTROBJPARTCIPN Type: view_entity BASIC
10 Fields 1 Data Sources 2 Associations

Architecture Object in Srvc Grp particip

I_RESrvcGrpArchtrObjPartcipn is a Basic CDS View that provides data about "Architecture Object in Srvc Grp particip" in SAP S/4HANA. It reads from 1 data source (vicsobparticip) and exposes 10 fields with key field RESrvcGrpArchtrObjPartcipnUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
vicsobparticip vicsobparticip from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REServiceGroup _REServiceGroup $projection.REServiceGroupUUID = _REServiceGroup.REServiceGroupUUID
[1..1] I_REArchitectureObject _REPartcipnArchitectureObject $projection.REArchitectureObjectUUID = _REPartcipnArchitectureObject.REArchitectureObjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Architecture Object in Srvc Grp particip view
ObjectModel.representativeKey RESrvcGrpArchtrObjPartcipnUUID view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RESrvcGrpArchtrObjPartcipnUUID participuuid
REServiceGroupUUID servicegroupuuid
REArchitectureObjectUUID architectureobjectuuid UUID Architecture Object
ValidityStartDate validfrom Vers.Valid From
ValidityEndDate validto Vers.Valid To
REArchitectureObjectType _REPartcipnArchitectureObject REArchitectureObjectType Architecture Object Type
REArchitectureObjectNumber _REPartcipnArchitectureObject REArchitectureObjectNumber Architecture Object Number
REArchitectureObjectOID _REPartcipnArchitectureObject REArchitectureObjectOID Architecture Object OID
_REServiceGroup _REServiceGroup
_REPartcipnArchitectureObject _REPartcipnArchitectureObject

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_RESrvcGrpArchtrObjPartcipn.
-- 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_RESrvcGrpArchtrObjPartcipn AS
SELECT
  participuuid AS RESrvcGrpArchtrObjPartcipnUUID,
  servicegroupuuid AS REServiceGroupUUID,
  architectureobjectuuid AS REArchitectureObjectUUID,
  validfrom AS ValidityStartDate,
  validto AS ValidityEndDate,
  _REPartcipnArchitectureObject.REArchitectureObjectType AS REArchitectureObjectType,
  _REPartcipnArchitectureObject.REArchitectureObjectNumber AS REArchitectureObjectNumber,
  _REPartcipnArchitectureObject.REArchitectureObjectOID AS REArchitectureObjectOID
FROM vicsobparticip
LEFT OUTER JOIN I_REServiceGroup AS _REServiceGroup ON REServiceGroupUUID = _REServiceGroup.REServiceGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_REArchitectureObject AS _REPartcipnArchitectureObject ON REArchitectureObjectUUID = _REPartcipnArchitectureObject.REArchitectureObjectUUID  -- association [1..1]
;

Learn More