I_MaintObjPhseCtrlCodeChgHist

DDL: I_MAINTOBJPHSECTRLCODECHGHIST Type: view COMPOSITE Package: EAM_USR_STS_MGMT
8 Fields 2 Data Sources 1 Associations

Phase Control Code last change history

I_MaintObjPhseCtrlCodeChgHist is a Composite CDS View that provides data about "Phase Control Code last change history" in SAP S/4HANA. It reads from 2 data sources (P_MaintObjStatusLatestChg, I_StatusObjectStatusChange) and exposes 8 fields with key fields StatusObject, StatusCode, StatusObjectStatusChangeNumber. It has 1 association to related views. Part of development package EAM_USR_STS_MGMT.

Data Sources (2)

SourceAliasJoin Type
P_MaintObjStatusLatestChg MaintObjStatusLatestChg from
I_StatusObjectStatusChange StatusObjectStatusChange inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (10)

NameValueLevelField
EndUserText.label Phase Control Code last change history view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMNTOBJSTLSTCHG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY StatusObject P_MaintObjStatusLatestChg StatusObject Status Object
KEY StatusCode P_MaintObjStatusLatestChg StatusCode Statuscode
KEY StatusObjectStatusChangeNumber P_MaintObjStatusLatestChg StatusObjectStatusChangeNumber Change Number
StatusIsInactive P_MaintObjStatusLatestChg StatusIsInactive TRUE
LastChangedByUser I_StatusObjectStatusChange LastChangedByUser User Name
LastChangeDate I_StatusObjectStatusChange LastChangeDate Time Stamp
LastChangeTime I_StatusObjectStatusChange LastChangeTime Time changed
_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 I_MaintObjPhseCtrlCodeChgHist.
-- 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_MaintObjPhseCtrlCodeChgHist AS
SELECT
  MaintObjStatusLatestChg.StatusObject AS StatusObject,
  MaintObjStatusLatestChg.StatusCode AS StatusCode,
  MaintObjStatusLatestChg.StatusObjectStatusChangeNumber AS StatusObjectStatusChangeNumber,
  MaintObjStatusLatestChg.StatusIsInactive AS StatusIsInactive,
  StatusObjectStatusChange.LastChangedByUser AS LastChangedByUser,
  StatusObjectStatusChange.LastChangeDate AS LastChangeDate,
  StatusObjectStatusChange.LastChangeTime AS LastChangeTime
FROM P_MaintObjStatusLatestChg AS MaintObjStatusLatestChg
INNER JOIN I_StatusObjectStatusChange AS StatusObjectStatusChange ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More