I_SafetyRequirementValueHelp

DDL: I_SAFETYREQUIREMENTVALUEHELP SQL: ISFTYREQVH Type: view BASIC
11 Fields 1 Data Sources 3 Associations

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.

Data Sources (1)

SourceAliasJoin Type
ptwwrkpmtassgmt ptwwrkpmtassgmt from

Associations (3)

CardinalityTargetAliasCondition
[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 (12)

NameValueLevelField
AbapCatalog.sqlViewName ISFTYREQVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE 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

Fields (11)

KeyFieldSource TableSource FieldDescription
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.
-- SQL view name: ISFTYREQVH

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]
;

Learn More