I_MaintObjPhseCtrlCodeChgHist

DDL: I_MAINTOBJPHSECTRLCODECHGHIST Type: view COMPOSITE

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.

2 data source(s) 8 fields

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
KEY StatusCode P_MaintObjStatusLatestChg StatusCode
KEY StatusObjectStatusChangeNumber P_MaintObjStatusLatestChg StatusObjectStatusChangeNumber
StatusIsInactive P_MaintObjStatusLatestChg StatusIsInactive
LastChangedByUser I_StatusObjectStatusChange LastChangedByUser
LastChangeDate I_StatusObjectStatusChange LastChangeDate
LastChangeTime I_StatusObjectStatusChange LastChangeTime
_LastChangedByUser _LastChangedByUser 
@EndUserText.label: 'Phase Control Code last change history'

@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'IMNTOBJSTLSTCHG',
  preserveKey: true,
  compiler.compareFilter: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType: {
                         serviceQuality: #C,
                         sizeCategory: #XL,
                         dataClass: #TRANSACTIONAL
                         }

@VDM.viewType: #COMPOSITE

define view I_MaintObjPhseCtrlCodeChgHist
  -- Retrieves the last change information of a status object / code
  as select from P_MaintObjStatusLatestChg  as MaintObjStatusLatestChg
    inner join   I_StatusObjectStatusChange as StatusObjectStatusChange on  MaintObjStatusLatestChg.StatusObject                   = StatusObjectStatusChange.StatusObject
                                                                        and MaintObjStatusLatestChg.StatusCode                     = StatusObjectStatusChange.StatusCode
                                                                        and MaintObjStatusLatestChg.StatusObjectStatusChangeNumber = StatusObjectStatusChange.StatusObjectStatusChangeNumber

  association [0..1] to I_User as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID

{
  key MaintObjStatusLatestChg.StatusObject,
  key MaintObjStatusLatestChg.StatusCode,
  key MaintObjStatusLatestChg.StatusObjectStatusChangeNumber,
  
      MaintObjStatusLatestChg.StatusIsInactive,

      @Semantics.user.lastChangedBy: true
      StatusObjectStatusChange.LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      StatusObjectStatusChange.LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      StatusObjectStatusChange.LastChangeTime,

      //Propagated associations

      _LastChangedByUser
}

Learn More