I_SafetyCertificateStatus

DDL: I_SAFETYCERTIFICATESTATUS SQL: ISFTYCERTSTATUS Type: view BASIC
10 Fields 2 Data Sources 2 Associations

Safety Certificate Status

I_SafetyCertificateStatus is a Basic CDS View that provides data about "Safety Certificate Status" in SAP S/4HANA. It reads from 2 data sources (I_SafetyCertificateBasic, jest) and exposes 10 fields with key fields SafetyCertificate, SafetyCertificateInternalID, StatusCode. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SafetyCertificateBasic I_SafetyCertificateBasic inner
jest jest from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StatusObjectStatusChange _StatusChange $projection.SafetyCertificateInternalID = _StatusChange.StatusObject and $projection.StatusCode = _StatusChange.StatusCode and $projection.StatusObjectStatusChangeNumber = _StatusChange.StatusObjectStatusChangeNumber
[0..1] I_SystemStatus _SystemStatus $projection.StatusCode = _SystemStatus.SystemStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISFTYCERTSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Safety Certificate Status view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate I_SafetyCertificateBasic SafetyCertificate WC Document
KEY SafetyCertificateInternalID jest objnr Val. Obj. No.
KEY StatusCode jest stat Status of Time-Dependent Document Linkage
StatusObjectStatusChangeNumber jest chgnr Change Number
LastChangeDate _StatusChange LastChangeDate Time Stamp
LastChangeTime _StatusChange LastChangeTime Time changed
StatusIsInactive jest inact TRUE
StatusShortName
SystemStatusName
_SystemStatus _SystemStatus

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_SafetyCertificateStatus.
-- 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: ISFTYCERTSTATUS

CREATE VIEW I_SafetyCertificateStatus AS
SELECT
  I_SafetyCertificateBasic.SafetyCertificate AS SafetyCertificate,
  jest.objnr AS SafetyCertificateInternalID,
  jest.stat AS StatusCode,
  jest.chgnr AS StatusObjectStatusChangeNumber,
  _StatusChange.LastChangeDate AS LastChangeDate,
  _StatusChange.LastChangeTime AS LastChangeTime,
  jest.inact AS StatusIsInactive,
  _SystemStatus._SystemStatusText[ 1: Language = $session.system_language ].SystemStatusShortName AS StatusShortName,
  _SystemStatus._SystemStatusText[ 1: Language = $session.system_language ].SystemStatusName AS SystemStatusName
FROM jest
INNER JOIN I_SafetyCertificateBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatusChange AS _StatusChange ON SafetyCertificateInternalID = _StatusChange.StatusObject AND StatusCode = _StatusChange.StatusCode AND StatusObjectStatusChangeNumber = _StatusChange.StatusObjectStatusChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_SystemStatus AS _SystemStatus ON StatusCode = _SystemStatus.SystemStatus  -- association [0..1]
;

Learn More