C_SafetyCertificateApprovalTP

DDL: C_SAFETYCERTIFICATEAPPROVALTP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Approvals in Safety Certificate

C_SafetyCertificateApprovalTP is a Consumption CDS View that provides data about "Approvals in Safety Certificate" in SAP S/4HANA. It reads from 1 data source (R_SafetyCertificateApprovalTP) and exposes 20 fields with key fields SafetyCertificateInternalID, NumberOfSftyCertApprovals. It is exposed through 1 OData service (UI_SAFETYCERTIFICATE). It is used in 1 Fiori application: Manage Safety Certificates.

Data Sources (1)

SourceAliasJoin Type
R_SafetyCertificateApprovalTP R_SafetyCertificateApprovalTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Approvals in Safety Certificate view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Approval view
UI.headerInfo.typeNamePlural Approvals view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Approvals view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SAFETYCERTIFICATE UI_SAFETYCERTIFICATE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6678 Manage Safety Certificates Transactional Safety Certificate defines the safety precautions specific to a process / team for example Ionization Radiation, Vehicle Entry, Diving etc and documents approvals required and performed for the specific environment.

Manage Safety Certificates

Business Role: Maintenance Planner

With this app, you can create new safety certificates or manage the existing certificates that are active, non-active, or closed in the system. New safety certificates can be created with reference to an existing work permit, a pre-designed safety certificate template, or independently. Once the safety certificate has been created, you can enhance the record with additional details.

Key Features: Enables maintenance planners to create and manage safety certificates Supports the creation of certificates with reference to a work permit and/or a safety certificate template and independently Allows the configuration of the safety precautions as an integral component of the safety certificate solution Provides the ability to assign work permits, partners, and multiple functional locations or equipment to the safety certificate Offers easy data validation and a simplified approval process that adheres to a four-eyes principle In addition, the app supports the following technical features and options: Attachment Service Application Logs

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID SafetyCertificateInternalID Object number
KEY NumberOfSftyCertApprovals NumberOfSftyCertApprovals Counter
SafetyCertificateApprovalCode SafetyCertificateApprovalCode Approval Type
SafetyCertificate SafetyCertificate WC Document
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedDate LastChangedDate Created On
LastChangedByUser LastChangedByUser User Name
SftyCertApprovalDescription SftyCertApprovalDescription Description
SftyCertApprovalIsMandatory SftyCertApprovalIsMandatory App. Mandatory
SftyCertApprvlHierLevelValue SftyCertApprvlHierLevelValue Hierarchy Level
SftyCertApprvlMandText SftyCertApprvlMandText Requirement
SftyCertificateApprovalComment SftyCertificateApprovalComment Approver Information
TextObjectKey TextObjectKey Text Name
PlainLongText PlainLongText Comment
SftyCertApprovalStatusText _DomainText DomainText Status
SftyCertificateApprovalStatus SftyCertificateApprovalStatus Approval Status
SftyCertSftyRqmtCritltyCode SftyCertSftyRqmtCritltyCode Criticality
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
SafetyCertificateType SafetyCertificateType Usage

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 C_SafetyCertificateApprovalTP.
-- 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 C_SafetyCertificateApprovalTP AS
SELECT
  SafetyCertificateInternalID,
  NumberOfSftyCertApprovals,
  SafetyCertificateApprovalCode,
  SafetyCertificate,
  CreationDate,
  CreatedByUser,
  LastChangedDate,
  LastChangedByUser,
  SftyCertApprovalDescription,
  SftyCertApprovalIsMandatory,
  SftyCertApprvlHierLevelValue,
  SftyCertApprvlMandText,
  SftyCertificateApprovalComment,
  TextObjectKey,
  PlainLongText,
  _DomainText.DomainText AS SftyCertApprovalStatusText,
  SftyCertificateApprovalStatus,
  SftyCertSftyRqmtCritltyCode,
  MaintenancePlanningPlant,
  SafetyCertificateType
FROM R_SafetyCertificateApprovalTP
;

Learn More