Which tables does I_SafetyRequirementValueHelp use?

I_SafetyRequirementValueHelp reads from 1 data source(s): ptwwrkpmtassgmt.

I_SafetyRequirementValueHelp

Q: How many fields does I_SafetyRequirementValueHelp have?

I_SafetyRequirementValueHelp has 11 fields. Key fields: MaintenancePlanningPlant, WorkPermitType, WorkPermitGroupCategory, WrkPmtSafetyRequirementGroup, WorkPermitSafetyRequirement.

DDL: I_SAFETYREQUIREMENTVALUEHELP SQL: ISFTYREQVH Type: view BASIC

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)

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 _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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
KEY	MaintenancePlanningPlant		iwerk
KEY	WorkPermitType		workpermittype
KEY	WorkPermitGroupCategory		ptwsftyrqmtcategory
KEY	WrkPmtSafetyRequirementGroup		ptwsftyrqmtgrp
KEY	WorkPermitSafetyRequirement		ptwsftyrqmt
	WrkPmtSftyRqmtIsImplemented		ptwsftyprcautnisimplmtbl
	WrkPmtSftyRequirementGroupText	_SftyPrcautnGroupTxt	WrkPmtSftyRequirementGroupText
	WrkPmtSafetyRequirementText	_SftyPrcautnItemTxt	WrkPmtSafetyRequirementText
	SafetyCertificateType		ptwsftycerttype
	SftyCertificateTypeDescription	_SafetyCertificateTypeText	SftyCertificateTypeDescription
	_SafetyCertificateTypeText		_SafetyCertificateTypeText

@AbapCatalog.sqlViewName: 'ISFTYREQVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #VALUE_HELP
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #S, dataClass: #META}
@EndUserText.label: 'Safety req category and item text'
@ObjectModel.representativeKey: 'MaintenancePlanningPlant'
define view I_SafetyRequirementValueHelp
  as select from ptwwrkpmtassgmt
  association [1..1] to I_SafetyPrecautionGroupText as _SftyPrcautnGroupTxt on  $projection.WrkPmtSafetyRequirementGroup = _SftyPrcautnGroupTxt.WrkPmtSafetyRequirementGroup
                                                                            and _SftyPrcautnGroupTxt.Language            = $session.system_language
  association [1..1] to I_SafetyPrecautionText      as _SftyPrcautnItemTxt  on  $projection.WorkPermitSafetyRequirement = _SftyPrcautnItemTxt.WorkPermitSafetyRequirement
                                                                            and _SftyPrcautnItemTxt.Language            = $session.system_language
  association [1..1] to I_SafetyCertificateTypeText as _SafetyCertificateTypeText  on  $projection.SafetyCertificateType    = _SafetyCertificateTypeText.SafetyCertificateType
                                                                                   and $projection.MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant
                                                                                   and _SafetyCertificateTypeText.Language  = $session.system_language
{
  key iwerk                    as MaintenancePlanningPlant,
  key workpermittype           as WorkPermitType,
  key ptwsftyrqmtcategory      as WorkPermitGroupCategory,
  key ptwsftyrqmtgrp           as WrkPmtSafetyRequirementGroup,
  key ptwsftyrqmt              as WorkPermitSafetyRequirement,
      ptwsftyprcautnisimplmtbl as WrkPmtSftyRqmtIsImplemented,
      _SftyPrcautnGroupTxt.WrkPmtSftyRequirementGroupText,
      _SftyPrcautnItemTxt.WrkPmtSafetyRequirementText,
     ptwsftycerttype           as SafetyCertificateType,
     _SafetyCertificateTypeText.SftyCertificateTypeDescription,
     _SafetyCertificateTypeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAFETYCERTIFICATETYPETEXT",
"I_SAFETYPRECAUTIONGROUPTEXT",
"I_SAFETYPRECAUTIONTEXT",
"PTWWRKPMTASSGMT"
],
"ASSOCIATED":
[
"I_SAFETYCERTIFICATETYPETEXT",
"I_SAFETYPRECAUTIONGROUPTEXT",
"I_SAFETYPRECAUTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_SafetyRequirementValueHelp view

ptwwrkpmtassgmt