I_StatusObjectStatusChange

DDL: I_STATUSOBJECTSTATUSCHANGE SQL: ISTATUSOBJSTSCHG Type: view BASIC

Change Docs for System or User Status

I_StatusObjectStatusChange is a Basic CDS View (Fact) that provides data about "Change Docs for System or User Status" in SAP S/4HANA. It reads from 1 data source (jcds) and exposes 9 fields with key fields StatusObject, StatusCode, StatusObjectStatusChangeNumber.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
jcds jcds from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISTATUSOBJSTSCHG view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Change Docs for System or User Status view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusObject objnr
KEY StatusCode stat
KEY StatusObjectStatusChangeNumber chgnr
LastChangedByUser usnam
LastChangeDate udate
LastChangeTime utime
ChangeTransactionCode cdtcode
StatusIsInactive inact
StatusChangeOperationCode chind 
@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

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

Learn More