I_STATUSOBJECTSTATUSCHANGE_2

CDS View

Chang.Docs for System/User Status(JEST)2

I_STATUSOBJECTSTATUSCHANGE_2 is a CDS View in S/4HANA. Chang.Docs for System/User Status(JEST)2. It contains 6 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 6 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_MaintNotificationChgHistory view union_all COMPOSITE Maint. Notification Change History
I_MaintOrdChgHistory view union_all COMPOSITE Maint. Order Change History
I_MaintPlanChgHistory view union_all COMPOSITE Maint. Plan Change History
I_TechnicalObjectChgHistory view union_all COMPOSITE Technical Object Change History
P_EBOC_MaxOrdKeyStatusByPeriod view from COMPOSITE
P_EBOC_OrderKeyStatusByPeriod view from COMPOSITE
P_EBPC_MaxOrderStatusByPeriod view from COMPOSITE
P_EBPC_OrderStatusByPeriod view from COMPOSITE
P_MaintObjStatusLatestChg view from COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY LastChangeDate CreationDate 4
KEY LastChangeTime CreationTime 4
KEY StatusCode StatusCode 4
KEY StatusObject StatusObject 2
LastChangedByUser CreatedByUser 4
StatusIsInactive StatusIsInactive 3 
@AbapCatalog.sqlViewName: 'ISTATUSOBJSTSCH2'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@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
@EndUserText.label: 'Chang.Docs for System/User Status(JEST)2'
@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_2
  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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"JCDS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More