C_WrkPmtSftyCertValueHelp

DDL: C_WRKPMTSFTYCERTVALUEHELP Type: view_entity CONSUMPTION Package: VDM_EAM_WCM_PERMIT_TO_WORK
24 Fields 1 Data Sources 7 Associations 1 OData Services 1 Fiori Apps

Safety Certificate in Work Permit

C_WrkPmtSftyCertValueHelp is a Consumption CDS View that provides data about "Safety Certificate in Work Permit" in SAP S/4HANA. It reads from 1 data source (I_SafetyCertificate) and exposes 24 fields with key field SafetyCertificate. It has 7 associations to related views. It is exposed through 1 OData service (UI_WORKPERMIT). It is used in 1 Fiori application: Manage Work Permits. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

SourceAliasJoin Type
I_SafetyCertificate I_SafetyCertificate from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..*] I_EquipmentText _EquipmentText $projection.Equipment = _EquipmentText.Equipment
[0..1] I_FunctionalLocation _FunctionalLocation $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
[0..*] I_FunctionalLocationText _FunctionalLocationText $projection.FunctionalLocation = _FunctionalLocationText.FunctionalLocation
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel $projection.FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation
[1..1] I_SafetyCertificateTypeText _SafetyCertificateTypeText $projection.SafetyCertificateType = _SafetyCertificateTypeText.SafetyCertificateType and $projection.MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant and _SafetyCertificateTypeText.Language = $session.system_language
[1..1] I_Plant _Plant $projection.MaintenancePlanningPlant = _Plant.Plant

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.dataCategory #VALUE_HELP view
Analytics.technicalName CPMTSFTYCERTVH view
ObjectModel.representativeKey SafetyCertificate view
EndUserText.label Safety Certificate in Work Permit view
AccessControl.personalData.blocking #NOT_REQUIRED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_WORKPERMIT UI_WORKPERMIT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6579 Manage Work Permits Transactional Work Permit is initiated during the planning of a maintenance activity and typically created from a predesigned template, together with the work order associated with the maintenance task. You can use this to search and maintain Work Permits.

Manage Work Permits

Business Role: Maintenance Planner

The Manage Work Permits app allows you to create, manage, and monitor work permits and gain valuable insights about the progress of your maintenance operations. Using the app, new work permits can be created with reference to an existing maintenance order, a predesigned work permit template, or independently. It provides the following capabilities:Allows to create and process new work permit using the optimized work permit management solutionProvides the ability to assign multiple functional locations, equipment, maintenance orders, partners, and attachments to enhance work permit with details related to the work activityAllows the configuration of the nature of work, personal protective equipment, and safety precautions to enhance work permit with safety protocols.Offers easy data validation and a simplified approval process that adheres to a four-eyes principleSupports the printing of work permit in the output form maintained by the userProvides the ability to extend the validity even after the creation of work permitSupports all operations relevant to work permit management such as approval, print, issue, return, close, deactivate, cancel, and mark for deletion.Provides the ability to view the records of data transfers using application logs

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate SafetyCertificate WC Document
SafetyCertificateInternalID SafetyCertificateInternalID Object number
SftyCertDesc SftyCertDesc Short Text
SafetyCertificateType SafetyCertificateType Usage
SftyCertificateTypeDescription _SafetyCertificateTypeText SftyCertificateTypeDescription Sfty Cert Type Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
PlantName _Plant PlantName Plant Name
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
ValidFromDateTime ValidFromDateTime Time Stamp
ValidToDateTime ValidToDateTime Time Stamp
SftyCertProcessingStatus SftyCertProcessingStatus Proc Stat Sfty Cert
SftyCertProcessingStatusText SftyCertProcessingStatusText Short Description
WorkCenter WorkCenter Work Center
WorkCenterText WorkCenterText Work Center Text
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
TechObjAuthorizationGroup TechObjAuthorizationGroup AuthorizGroup
_Equipment _Equipment
_EquipmentText _EquipmentText
_FunctionalLocation _FunctionalLocation
_FunctionalLocationText _FunctionalLocationText
_FunctionalLocationLabel _FunctionalLocationLabel
_SafetyCertificateTypeText _SafetyCertificateTypeText
_Plant _Plant

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_WrkPmtSftyCertValueHelp.
-- 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_WrkPmtSftyCertValueHelp AS
SELECT
  SafetyCertificate,
  SafetyCertificateInternalID,
  SftyCertDesc,
  SafetyCertificateType,
  _SafetyCertificateTypeText.SftyCertificateTypeDescription AS SftyCertificateTypeDescription,
  MaintenancePlanningPlant,
  _Plant.PlantName AS PlantName,
  Equipment,
  FunctionalLocation,
  ValidFromDateTime,
  ValidToDateTime,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  WorkCenter,
  WorkCenterText,
  MaintenancePlannerGroup,
  TechObjAuthorizationGroup
FROM I_SafetyCertificate
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_SafetyCertificateTypeText AS _SafetyCertificateTypeText ON SafetyCertificateType = _SafetyCertificateTypeText.SafetyCertificateType AND MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant AND _SafetyCertificateTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON MaintenancePlanningPlant = _Plant.Plant  -- association [1..1]
;

Learn More