I_SrvcMgmtObjStsChgInformation

DDL: I_SRVCMGMTOBJSTSCHGINFORMATION SQL: ISRVSTSCHNG Type: view BASIC
8 Fields 1 Data Sources

View to read from DB table CRM_JCDS

I_SrvcMgmtObjStsChgInformation is a Basic CDS View that provides data about "View to read from DB table CRM_JCDS" in SAP S/4HANA. It reads from 1 data source (crm_jcds) and exposes 8 fields with key fields SrvcMgmtObjStatusChangeNumber, StatusObjectUUID, SrvcMgmtObjectStatus.

Data Sources (1)

SourceAliasJoin Type
crm_jcds crm_jcds from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISRVSTSCHNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label View to read from DB table CRM_JCDS view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SrvcMgmtObjStatusChangeNumber chgnr Change Number
KEY StatusObjectUUID objnr Val. Obj. No.
KEY SrvcMgmtObjectStatus stat Status of Time-Dependent Document Linkage
SrvcMgmtObjStsChgInformation chind Change Indicator
SrvcMgmtObjectStatusIsInactive inact TRUE
ChangeDocumentStatusDate udate Update Date
ChangeDocumentStatusTime utime Time
SrvcMgmtObjStsChangeUser usnam User Name

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_SrvcMgmtObjStsChgInformation.
-- 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: ISRVSTSCHNG

CREATE VIEW I_SrvcMgmtObjStsChgInformation AS
SELECT
  chgnr AS SrvcMgmtObjStatusChangeNumber,
  objnr AS StatusObjectUUID,
  stat AS SrvcMgmtObjectStatus,
  chind AS SrvcMgmtObjStsChgInformation,
  inact AS SrvcMgmtObjectStatusIsInactive,
  udate AS ChangeDocumentStatusDate,
  utime AS ChangeDocumentStatusTime,
  usnam AS SrvcMgmtObjStsChangeUser
FROM crm_jcds
;

Learn More