C_SftyCertApprovalValueHelp

DDL: C_SFTYCERTAPPROVALVALUEHELP SQL: CSFCAPPRVLVH Type: view CONSUMPTION
9 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Approvals for safety certificate

C_SftyCertApprovalValueHelp is a Consumption CDS View that provides data about "Approvals for safety certificate" in SAP S/4HANA. It reads from 1 data source (I_SftyCertificateApprovalBasic) and exposes 9 fields with key fields MaintenancePlanningPlant, SafetyCertificateType, SafetyCertificateApprovalCode, SftyCertApprovalScenario. It is exposed through 2 OData services (UI_SAFETYCERTIFICATE, UI_SAFETYCERTIFICATETEMPLATE). It is used in 1 Fiori application: Manage Safety Certificates.

Data Sources (1)

SourceAliasJoin Type
I_SftyCertificateApprovalBasic Approval from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSFCAPPRVLVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Approvals for safety certificate view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MaintenancePlanningPlant view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SAFETYCERTIFICATE UI_SAFETYCERTIFICATE V2 C1 NOT_RELEASED
UI_SAFETYCERTIFICATETEMPLATE UI_SFTYCERTIFICATETEMPLATE 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 (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
KEY SafetyCertificateType SafetyCertificateType Usage
KEY SafetyCertificateApprovalCode SafetyCertificateApprovalCode Permit
KEY SftyCertApprovalScenario SftyCertApprovalScenario VAT Scenario
SftyCertApprvlHierLevelValue SftyCertApprvlHierLevelValue Hierarchy Level
SftyCertApprvlCopyIsAutomatic SftyCertApprvlCopyIsAutomatic Copy Apprv Auto
SftyCertApprovalIsMandatory SftyCertApprovalIsMandatory App. Mandatory
SftyCertApprovalDescription SftyCertApprovalDescription Permit Text
SftyCertApprvlMandText SftyCertApprvlMandText

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_SftyCertApprovalValueHelp.
-- 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: CSFCAPPRVLVH

CREATE VIEW C_SftyCertApprovalValueHelp AS
SELECT
  MaintenancePlanningPlant,
  SafetyCertificateType,
  SafetyCertificateApprovalCode,
  SftyCertApprovalScenario,
  SftyCertApprvlHierLevelValue,
  SftyCertApprvlCopyIsAutomatic,
  SftyCertApprovalIsMandatory,
  SftyCertApprovalDescription,
  SftyCertApprvlMandText
FROM I_SftyCertificateApprovalBasic AS Approval
;

Learn More