P_ACMObjectStatusDetails

DDL: P_ACMOBJECTSTATUSDETAILS SQL: PACMOBJSTAT Type: view COMPOSITE
5 Fields 1 Data Sources

P_ACMObjectStatusDetails is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ACMObjectStatus) and exposes 5 fields with key fields StatusObject, StatusCode.

Data Sources (1)

SourceAliasJoin Type
I_ACMObjectStatus jest from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PACMOBJSTAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_ACMObjectStatus StatusObject Status Object
KEY StatusCode I_ACMObjectStatus StatusCode Statuscode
StatusIsInactive I_ACMObjectStatus StatusIsInactive TRUE
ChangeDocumentStatusDate jcds ChangeDocumentStatusDate
ChangeDocumentStatusTime jcds ChangeDocumentStatusTime

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 P_ACMObjectStatusDetails.
-- 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: PACMOBJSTAT

CREATE VIEW P_ACMObjectStatusDetails AS
SELECT
  jest.StatusObject AS StatusObject,
  jest.StatusCode AS StatusCode,
  jest.StatusIsInactive AS StatusIsInactive,
  jcds.ChangeDocumentStatusDate AS ChangeDocumentStatusDate,
  jcds.ChangeDocumentStatusTime AS ChangeDocumentStatusTime
FROM I_ACMObjectStatus AS jest
;

Learn More