P_SafetyCertificateCube

DDL: P_SAFETYCERTIFICATECUBE Type: view_entity COMPOSITE Package: VDM_EAM_WCM_SAFETY_CERTIFICATE
15 Fields 1 Data Sources

Safety Certificate

P_SafetyCertificateCube is a Composite CDS View that provides data about "Safety Certificate" in SAP S/4HANA. It reads from 1 data source (I_SafetyCertificateBasic) and exposes 15 fields with key field SafetyCertificate. Part of development package VDM_EAM_WCM_SAFETY_CERTIFICATE.

Data Sources (1)

SourceAliasJoin Type
I_SafetyCertificateBasic I_SafetyCertificateBasic from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Safety Certificate view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate SafetyCertificate WC Document
SafetyCertificateType SafetyCertificateType Usage
SftyCertificateSubobjectType SftyCertificateSubobjectType Object Type
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
TechObjAuthorizationGroup TechObjAuthorizationGroup AuthorizGroup
FunctionalLocation FunctionalLocation Object ID
ObjectTypeCode ObjectTypeCode Object Type
Equipment Equipment Equipment check
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
SftyCertValidFrmDate SftyCertValidFrmDate Valid from
SftyCertValidToDate SftyCertValidToDate Valid to
SafetyCertificateInternalID SafetyCertificateInternalID Object number
SftyCertProcessingStatus SftyCertProcessingStatus Proc Stat Sfty Cert
NumberOfOpenSafetyCertificates

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_SafetyCertificateCube.
-- 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.

CREATE VIEW P_SafetyCertificateCube AS
SELECT
  SafetyCertificate,
  SafetyCertificateType,
  SftyCertificateSubobjectType,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  TechObjAuthorizationGroup,
  FunctionalLocation,
  ObjectTypeCode,
  Equipment,
  OperationWorkCenterInternalID,
  SftyCertValidFrmDate,
  SftyCertValidToDate,
  SafetyCertificateInternalID,
  SftyCertProcessingStatus,
  cast(1 as nmbr_of_opn_sfty_certs) AS NumberOfOpenSafetyCertificates
FROM I_SafetyCertificateBasic
;

Learn More