I_StatusObjectStatusChange_2

DDL: I_STATUSOBJECTSTATUSCHANGE_2 SQL: ISTATUSOBJSTSCH2 Type: view BASIC
9 Fields 1 Data Sources

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.

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 Val. Obj. No.
KEY StatusCode stat Status of Time-Dependent Document Linkage
KEY StatusObjectStatusChangeNumber chgnr Change Number
LastChangedByUser usnam User Name
LastChangeDate udate Update Date
LastChangeTime utime Time
ChangeTransactionCode cdtcode Transaction
StatusIsInactive inact TRUE
StatusChangeOperationCode chind Change Indicator

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StatusObjectStatusChange_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISTATUSOBJSTSCH2

CREATE VIEW I_StatusObjectStatusChange_2 AS
SELECT
  objnr AS StatusObject,
  stat AS StatusCode,
  chgnr AS StatusObjectStatusChangeNumber,
  usnam AS LastChangedByUser,
  udate AS LastChangeDate,
  utime AS LastChangeTime,
  cdtcode AS ChangeTransactionCode,
  inact AS StatusIsInactive,
  chind AS StatusChangeOperationCode
FROM jcds
;

Learn More