I_STATUSOBJECTSTATUSCHANGE

CDS View

Change Docs for System or User Status

I_STATUSOBJECTSTATUSCHANGE is a CDS View in S/4HANA. Change Docs for System or User Status. It contains 4 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 4 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MaintObjPhseCtrlCodeChgHist view inner COMPOSITE Phase Control Code last change history
I_MaintOrderOpPhseCtrlChgHist view inner COMPOSITE Order Operation Phase Control last change history
I_MaintOrderPhseCtrlChgHist view inner COMPOSITE Order Phase Control last change history
P_InternalOrderChangeLogUser view from CONSUMPTION Internal Order Change Log User
P_InternalOrderChangeLogUser view union CONSUMPTION Internal Order Change Log User
P_InternalOrderStatusChangeLog view from CONSUMPTION Internal Order Status Change Log
P_IntOrdChgLgInternalOrderVH view union CONSUMPTION Value Help Internal Order for Change Log

Fields (4)

KeyField CDS FieldsUsed in Views
LastChangeDate LastChangeDate 3
LastChangedByUser LastChangedByUser 3
LastChangeTime LastChangeTime 3
StatusObject StatusObject 1 
@AbapCatalog.sqlViewName: 'ISTATUSOBJSTSCHG'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ]

@EndUserText.label: 'Change Docs for System or User Status'
@Analytics: {
    dataCategory: #FACT,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                {
                    table: 'jcds',role:#MAIN,
                    viewElement:  ['StatusObject', 'StatusCode','StatusObjectStatusChangeNumber'],
                    tableElement: ['objnr', 'stat','chgnr']
                }
            ]
        }
    }
    }
define view I_StatusObjectStatusChange
  as select from jcds
{

  key objnr   as StatusObject,
  key stat    as StatusCode,
  key chgnr   as StatusObjectStatusChangeNumber,
      usnam   as LastChangedByUser,
      udate   as LastChangeDate,
      utime   as LastChangeTime,
      cdtcode as ChangeTransactionCode,
      @Semantics.booleanIndicator
      inact   as StatusIsInactive,
      chind   as StatusChangeOperationCode

}

Learn More