C_ConfignRevsnReqRecdMntr

DDL: C_CONFIGNREVSNREQRECDMNTR Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 2 Associations

CBC Backsync Request Record Columns

C_ConfignRevsnReqRecdMntr is a Consumption CDS View that provides data about "CBC Backsync Request Record Columns" in SAP S/4HANA. It reads from 1 data source (I_ConfignRevsnRequestRecord) and exposes 10 fields with key fields ConfignRevsnUUID, ConfigurationRevisionTarget, ConfignRevsnRequestPosition, ConfignRevsnTableName, ConfignRevsnTableKeyHash. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConfignRevsnRequestRecord I_ConfignRevsnRequestRecord projection

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ConfignRevsnReqRecdRltnMntr _ConfignRevsnReqRecdRltnMntr $projection.ConfignRevsnUUID = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnUUID and $projection.ConfigurationRevisionTarget = _ConfignRevsnReqRecdRltnMntr.ConfigurationRevisionTarget and $projection.ConfignRevsnRequestPosition = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnRequestPosition and $projection.ConfignRevsnTableName = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnTableName and $projection.ConfignRevsnTableKeyHash = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnTableKeyHash
[1..*] C_ConfignRevsnRqstRcrdCMonitor _ConfignRevsnRqstRcrdCMonitor $projection.ConfignRevsnUUID = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnUUID and $projection.ConfigurationRevisionTarget = _ConfignRevsnRqstRcrdCMonitor.ConfigurationRevisionTarget and $projection.ConfignRevsnRequestPosition = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnRequestPosition and $projection.ConfignRevsnTableName = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnTableName and $projection.ConfignRevsnTableKeyHash = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnTableKeyHash

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CBC Backsync Request Record Columns view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ConfignRevsnUUID ConfignRevsnUUID Revision ID
KEY ConfigurationRevisionTarget ConfigurationRevisionTarget UUID
KEY ConfignRevsnRequestPosition ConfignRevsnRequestPosition Req. Position
KEY ConfignRevsnTableName ConfignRevsnTableName Table/View Name
KEY ConfignRevsnTableKeyHash ConfignRevsnTableKeyHash Table HashKey
LastChangeDateTime LastChangeDateTime Timestamp
virtualDatacbc_rev_table_data
_Target _Target
_ConfignRevsnReqRecdRltnMntr _ConfignRevsnReqRecdRltnMntr
_ConfignRevsnRqstRcrdCMonitor _ConfignRevsnRqstRcrdCMonitor

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 C_ConfignRevsnReqRecdMntr.
-- 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 C_ConfignRevsnReqRecdMntr AS
SELECT
  ConfignRevsnUUID,
  ConfigurationRevisionTarget,
  ConfignRevsnRequestPosition,
  ConfignRevsnTableName,
  ConfignRevsnTableKeyHash,
  LastChangeDateTime,
  virtual Data : cbc_rev_table_data AS virtualDatacbc_rev_table_data
FROM I_ConfignRevsnRequestRecord
LEFT OUTER JOIN C_ConfignRevsnReqRecdRltnMntr AS _ConfignRevsnReqRecdRltnMntr ON ConfignRevsnUUID = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnUUID AND ConfigurationRevisionTarget = _ConfignRevsnReqRecdRltnMntr.ConfigurationRevisionTarget AND ConfignRevsnRequestPosition = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnRequestPosition AND ConfignRevsnTableName = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnTableName AND ConfignRevsnTableKeyHash = _ConfignRevsnReqRecdRltnMntr.ConfignRevsnTableKeyHash  -- association [1..1]
LEFT OUTER JOIN C_ConfignRevsnRqstRcrdCMonitor AS _ConfignRevsnRqstRcrdCMonitor ON ConfignRevsnUUID = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnUUID AND ConfigurationRevisionTarget = _ConfignRevsnRqstRcrdCMonitor.ConfigurationRevisionTarget AND ConfignRevsnRequestPosition = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnRequestPosition AND ConfignRevsnTableName = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnTableName AND ConfignRevsnTableKeyHash = _ConfignRevsnRqstRcrdCMonitor.ConfignRevsnTableKeyHash  -- association [1..*]
;

Learn More