R_RgtyGrphcCollectionTP

DDL: R_RGTYGRPHCCOLLECTIONTP Type: view TRANSACTIONAL Package: EHFND_RAP_GRAPHIC
16 Fields 1 Data Sources 2 Associations

TP-View for Graphic Collections

R_RgtyGrphcCollectionTP is a Transactional CDS View that provides data about "TP-View for Graphic Collections" in SAP S/4HANA. It reads from 1 data source (I_RgtyGrphcCollection) and exposes 16 fields with key field RgtyGrphcCollectionUUID. It has 2 associations to related views. Part of development package EHFND_RAP_GRAPHIC.

Data Sources (1)

SourceAliasJoin Type
I_RgtyGrphcCollection I_RgtyGrphcCollection from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DataElementLabelText _DataElementLabelText _DataElementLabelText.ABAPDataElement = $projection.RgtyGrphcCollection and _DataElementLabelText.Language = $session.system_language
[0..*] R_RgtyGrphcTP _RgtyGrphc

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RRGTYGRPHCCOLTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label TP-View for Graphic Collections view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey RgtyGrphcCollectionUUID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RgtyGrphcCollectionUUID RgtyGrphcCollectionUUID Graphic Collection UUID
RgtyGrphcCollection RgtyGrphcCollection Graphic Collection
CmplRqVersUUID CmplRqVersUUID NodeID
ContentProvider _CmplRqVers ContentProvider Content Provider
ContentProviderName
RgtyGrphcCollCreationDateTime Timestamp
RgtyGrphcCollLstChgDteTme Timestamp
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CmplRqVers _CmplRqVers
_DataElementLabelText _DataElementLabelText
_RgtyGrphc _RgtyGrphc

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_RgtyGrphcCollectionTP.
-- 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_RgtyGrphcCollectionTP AS
SELECT
  RgtyGrphcCollectionUUID,
  RgtyGrphcCollection,
  CmplRqVersUUID,
  _CmplRqVers.ContentProvider AS ContentProvider,
  cast( _CmplRqVers.ContentProvider as ehfnd_content_provider_name preserving type ) AS ContentProviderName,
  cast( CreationDateTime as ehfnd_datetime_cr ) AS RgtyGrphcCollCreationDateTime,
  cast( LastChangeDateTime as ehfnd_datetime_ch ) AS RgtyGrphcCollLstChgDteTme,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_RgtyGrphcCollection
LEFT OUTER JOIN I_DataElementLabelText AS _DataElementLabelText ON _DataElementLabelText.ABAPDataElement = RgtyGrphcCollection AND _DataElementLabelText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN R_RgtyGrphcTP AS _RgtyGrphc ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More