I_StatusObjectStatusChange_2

DDL: I_STATUSOBJECTSTATUSCHANGE_2 SQL: ISTATUSOBJSTSCH2 Type: view BASIC Package: VDM_FND

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

I_StatusObjectStatusChange_2 is a Basic CDS View (Fact) that provides data about "Chang.Docs for System/User Status(JEST)2" in SAP S/4HANA. It reads from 1 data source (jcds) and exposes 9 fields with key fields StatusObject, StatusCode, StatusObjectStatusChangeNumber. Part of development package VDM_FND.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
jcds jcds from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISTATUSOBJSTSCH2 view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 Chang.Docs for System/User Status(JEST)2 view
Analytics.dataCategory #FACT 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: '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

}

Learn More