R_ReferenceStructure

DDL: R_REFERENCESTRUCTURE Type: view_entity BASIC
17 Fields 1 Data Sources 5 Associations

Reference Structure

R_ReferenceStructure is a Basic CDS View that provides data about "Reference Structure" in SAP S/4HANA. It reads from 1 data source (asmm_refstruc) and exposes 17 fields with key field ReferenceStructureUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
asmm_refstruc asmm_refstruc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] R_ReferenceStructureText _ReferenceStructureDesc $projection.ReferenceStructureUUID = _ReferenceStructureDesc.ReferenceStructureUUID and _ReferenceStructureDesc.Language = $session.system_language
[0..*] I_StatusObjectStatusBasic _Status $projection.ReferenceStructureObjectNumber = _Status.StatusObject and _Status.StatusIsInactive = ''
[0..*] I_StatusCodeText _StatusText _StatusText.StatusCode = $projection.StatusCode and _StatusText.Language = $session.system_language
[0..1] I_User _CreatedByUser _CreatedByUser.UserID = $projection.CreatedByUser
[0..1] I_User _LastChangedByUser _LastChangedByUser.UserID = $projection.LastChangedByUser

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Reference Structure view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ReferenceStructureUUID referencestructureuuid
ReferenceStructureIdentifier referencestructureidentifier
RefStructureType refstructuretype
RefStructureValidFromDateTime refstructurevalidfromdatetime
RefStructureValidToDateTime refstructurevalidtodatetime
ReferenceStructureObjectNumber referencestructureobjectnumber
RefStructureReleaseDateTime refstructurereleasedatetime
CreatedByUser createdbyuser User Name
LastChangedByUser lastchangedbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangeDateTime lastchangedatetime Timestamp
ReferenceStructureIsExternal referencestructureisexternal
_ReferenceStructureDesc _ReferenceStructureDesc
_StatusText _StatusText
CurrentSystemUTCDateTime
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 R_ReferenceStructure.
-- 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 R_ReferenceStructure AS
SELECT
  ReferenceStructureUUID,
  ReferenceStructureIdentifier,
  RefStructureType,
  RefStructureValidFromDateTime,
  RefStructureValidToDateTime,
  ReferenceStructureObjectNumber,
  RefStructureReleaseDateTime,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime,
  ReferenceStructureIsExternal,
  tstmp_current_utctimestamp() AS CurrentSystemUTCDateTime
FROM asmm_refstruc
LEFT OUTER JOIN R_ReferenceStructureText AS _ReferenceStructureDesc ON ReferenceStructureUUID = _ReferenceStructureDesc.ReferenceStructureUUID AND _ReferenceStructureDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _Status ON ReferenceStructureObjectNumber = _Status.StatusObject AND _Status.StatusIsInactive = ''  -- association [0..*]
LEFT OUTER JOIN I_StatusCodeText AS _StatusText ON _StatusText.StatusCode = StatusCode AND _StatusText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;

Learn More