What is I_SafetyRequirementValueHelp in SAP S/4HANA?

I_SafetyRequirementValueHelp is a basic CDS view in SAP S/4HANA. Safety req category and item text It contains 11 fields.

Which tables does I_SafetyRequirementValueHelp read from?

I_SafetyRequirementValueHelp reads data from: ptwwrkpmtassgmt.

What VDM layer is I_SafetyRequirementValueHelp?

I_SafetyRequirementValueHelp is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SafetyRequirementValueHelp

DDL: I_SAFETYREQUIREMENTVALUEHELP Type: view_entity BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK

11 Fields 1 Data Sources 3 Associations 3 OData Services 2 Fiori Apps

Safety req category and item text

I_SafetyRequirementValueHelp is a Basic CDS View that provides data about "Safety req category and item text" in SAP S/4HANA. It reads from 1 data source (ptwwrkpmtassgmt) and exposes 11 fields with key fields MaintenancePlanningPlant, WorkPermitType, WorkPermitGroupCategory, WrkPmtSafetyRequirementGroup, WorkPermitSafetyRequirement. It has 3 associations to related views. It is exposed through 3 OData services (ASQL_F4692, UI_WORKPERMIT, UI_WORKPERMITTEMPLATE). It is used in 2 Fiori applications: Manage Work Permit Templates, Manage Work Permits. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

Source	Alias	Join Type
ptwwrkpmtassgmt	ptwwrkpmtassgmt	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_SafetyPrecautionGroupText	_SftyPrcautnGroupTxt	`$projection.WrkPmtSafetyRequirementGroup = _SftyPrcautnGroupTxt.WrkPmtSafetyRequirementGroup and _SftyPrcautnGroupTxt.Language = $session.system_language`
[1..1]	I_SafetyPrecautionText	_SftyPrcautnItemTxt	`$projection.WorkPermitSafetyRequirement = _SftyPrcautnItemTxt.WorkPermitSafetyRequirement and $projection.WorkPermitGroupCategory = _SftyPrcautnItemTxt.WrkPmtSftyRequirementCategory and _SftyPrcautnItemTxt.Language = $session.system_language`
[1..1]	I_SafetyCertificateTypeText	_SafetyCertificateTypeText	`$projection.SafetyCertificateType = _SafetyCertificateTypeText.SafetyCertificateType and $projection.MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant and _SafetyCertificateTypeText.Language = $session.system_language`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#BASIC	view
ObjectModel.dataCategory	#VALUE_HELP	view
Analytics.technicalName	ISFTYREQVH	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#META	view
EndUserText.label	Safety req category and item text	view
ObjectModel.representativeKey	MaintenancePlanningPlant	view

OData Services (3)

Service	Binding	Version	Contract	Release
ASQL_F4692	ASQL_F4692		C2	NOT_RELEASED
UI_WORKPERMIT	UI_WORKPERMIT	V2	C1	NOT_RELEASED
UI_WORKPERMITTEMPLATE	UI_WORKPERMITTEMPLATE	V2	C1	NOT_RELEASED

Fiori Apps (2)

App ID	App Name	Type	Description
F4692	Manage Work Permit Templates	Transactional	Work permit template provides a predesigned structure that can be used to create work permits of consistent format. This can help you streamline the process when Permits for similar work are required to be created periodically. You can use this app to maintain the re-use library of templates to use them for creating actual work permits.
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 Permit Templates

Business Role: Industrial Hygienist

The Manage Work Permit Templates app allows to create work permit templates as predesigned models for creating work permits. The templates can be used as they are, or easily modified while work permits are created. Usage of work permit templates can help to streamline the work permit creation process when identical work permits are generated often. The app can perform the following operations:Allows to create, process, and manage work permit templatesProvides the ability to assign multiple functional locations, equipment, partners, and attachmentsAllows the configuration of the nature of work, personal protective equipment, and safety precautionsOffers easy data validation and a simplified approval process that adheres to a four-eyes principleProvides the ability to view the records of data transfers using application logs

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 (11)

Key	Field	Source Table	Source Field	Description
KEY	MaintenancePlanningPlant		iwerk	Planning Plant
KEY	WorkPermitType		workpermittype	Work Permit Type
KEY	WorkPermitGroupCategory		ptwsftyrqmtcategory	Category
KEY	WrkPmtSafetyRequirementGroup		ptwsftyrqmtgrp	Safety Rqmt Group
KEY	WorkPermitSafetyRequirement		ptwsftyrqmt	Safety Rqmt
	WrkPmtSftyRqmtIsImplemented		ptwsftyprcautnisimplmtbl	SP implment
	WrkPmtSftyRequirementGroupText	_SftyPrcautnGroupTxt	WrkPmtSftyRequirementGroupText	Safety Rqmt Grp Txt
	WrkPmtSafetyRequirementText	_SftyPrcautnItemTxt	WrkPmtSafetyRequirementText	Safety Rqmt Txt
	SafetyCertificateType		ptwsftycerttype	Safety Certif Type
	SftyCertificateTypeDescription	_SafetyCertificateTypeText	SftyCertificateTypeDescription	Sfty Cert Type Desc
	_SafetyCertificateTypeText		_SafetyCertificateTypeText

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_SafetyRequirementValueHelp.
-- 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 I_SafetyRequirementValueHelp AS
SELECT
  iwerk AS MaintenancePlanningPlant,
  WorkPermitType,
  ptwsftyrqmtcategory AS WorkPermitGroupCategory,
  ptwsftyrqmtgrp AS WrkPmtSafetyRequirementGroup,
  ptwsftyrqmt AS WorkPermitSafetyRequirement,
  ptwsftyprcautnisimplmtbl AS WrkPmtSftyRqmtIsImplemented,
  _SftyPrcautnGroupTxt.WrkPmtSftyRequirementGroupText AS WrkPmtSftyRequirementGroupText,
  _SftyPrcautnItemTxt.WrkPmtSafetyRequirementText AS WrkPmtSafetyRequirementText,
  ptwsftycerttype AS SafetyCertificateType,
  _SafetyCertificateTypeText.SftyCertificateTypeDescription AS SftyCertificateTypeDescription
FROM ptwwrkpmtassgmt
LEFT OUTER JOIN I_SafetyPrecautionGroupText AS _SftyPrcautnGroupTxt ON WrkPmtSafetyRequirementGroup = _SftyPrcautnGroupTxt.WrkPmtSafetyRequirementGroup AND _SftyPrcautnGroupTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SafetyPrecautionText AS _SftyPrcautnItemTxt ON WorkPermitSafetyRequirement = _SftyPrcautnItemTxt.WorkPermitSafetyRequirement AND WorkPermitGroupCategory = _SftyPrcautnItemTxt.WrkPmtSftyRequirementCategory AND _SftyPrcautnItemTxt.Language = $session.system_language  -- association [1..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]
;

Depth:

I_SafetyRequirementValueHelp view_entity

ptwwrkpmtassgmt