C_MfgPlngExecChgRecdPopover

DDL: C_MFGPLNGEXECCHGRECDPOPOVER SQL: CMPECRPOPOVER Type: view CONSUMPTION
20 Fields 1 Data Sources 4 Associations

Change Record Popover

C_MfgPlngExecChgRecdPopover is a Consumption CDS View that provides data about "Change Record Popover" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordBsc) and exposes 20 fields with key field ChangeRecordUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordBsc I_ChangeRecordBsc from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_IssueCategoryText _ChangeRecordCategoryText _ChangeRecordCategoryText.IssueCategory = $projection.ChangeRecordCategory
[0..*] I_IssActyMgmtUserStatus1t _ChangeRecordStatusText _ChangeRecordStatusText.IssActyMgmtUserStatus1 = $projection.ChangeRecordStatus
[0..1] I_ChangeRecordTypeText _ChangeRecordTypeText $projection.ChangeRecordType = _ChangeRecordTypeText.ChangeRecordType and _ChangeRecordTypeText.Language = $session.system_language
[0..1] I_ChangeRecordContactPerson _ChangeRecordContactPerson $projection.Partner = _ChangeRecordContactPerson.Partner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPECRPOPOVER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Change Record Popover view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID ChangeRecordUUID NodeID
ChangeNumber ChangeNumber Change Number
ChangeRecord ChangeRecord Char20
ChangeRecordCategory ChangeRecordCategory Issue Cat.
ChangeRecordPriority ChangeRecordPriority Workflow priority
ChangeRecordStatus ChangeRecordStatus
ChangeRecordType ChangeRecordType Record Type
ChangeRecordTypeDesc _ChangeRecordTypeText ChangeRecordTypeDesc
ChgRecordApplication ChgRecordApplication UI Application
ChgRecordDescriptionText ChgRecordDescriptionText
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ParentChangeRecordUUID ParentChangeRecordUUID NodeID
Partner Partner With Partner
PersonFullName _ChangeRecordContactPerson PersonFullName Full Name
RootChangeRecordUUID RootChangeRecordUUID NodeID
_ChangeRecordCategoryText _ChangeRecordCategoryText
_ChangeRecordStatusText _ChangeRecordStatusText

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_MfgPlngExecChgRecdPopover.
-- 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: CMPECRPOPOVER

CREATE VIEW C_MfgPlngExecChgRecdPopover AS
SELECT
  ChangeRecordUUID,
  ChangeNumber,
  ChangeRecord,
  ChangeRecordCategory,
  ChangeRecordPriority,
  ChangeRecordStatus,
  ChangeRecordType,
  _ChangeRecordTypeText.ChangeRecordTypeDesc AS ChangeRecordTypeDesc,
  ChgRecordApplication,
  ChgRecordDescriptionText,
  CreatedByUser,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  ParentChangeRecordUUID,
  Partner,
  _ChangeRecordContactPerson.PersonFullName AS PersonFullName,
  RootChangeRecordUUID
FROM I_ChangeRecordBsc
LEFT OUTER JOIN I_IssueCategoryText AS _ChangeRecordCategoryText ON _ChangeRecordCategoryText.IssueCategory = ChangeRecordCategory  -- association [0..*]
LEFT OUTER JOIN I_IssActyMgmtUserStatus1t AS _ChangeRecordStatusText ON _ChangeRecordStatusText.IssActyMgmtUserStatus1 = ChangeRecordStatus  -- association [0..*]
LEFT OUTER JOIN I_ChangeRecordTypeText AS _ChangeRecordTypeText ON ChangeRecordType = _ChangeRecordTypeText.ChangeRecordType AND _ChangeRecordTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordContactPerson AS _ChangeRecordContactPerson ON Partner = _ChangeRecordContactPerson.Partner  -- association [0..1]
;

Learn More