What is R_SafetyCertificateTemplateTP in SAP S/4HANA?

R_SafetyCertificateTemplateTP is a transactional CDS view in SAP S/4HANA. Safety Certificate Template It contains 82 fields.

Which tables does R_SafetyCertificateTemplateTP read from?

R_SafetyCertificateTemplateTP reads data from: I_SafetyCertificateTemplate.

What VDM layer is R_SafetyCertificateTemplateTP?

R_SafetyCertificateTemplateTP is classified as a Transactional view that supports create, update, and delete operations.

R_SafetyCertificateTemplateTP

DDL: R_SAFETYCERTIFICATETEMPLATETP Type: view_entity TRANSACTIONAL

82 Fields 1 Data Sources 18 Associations

Safety Certificate Template

R_SafetyCertificateTemplateTP is a Transactional CDS View that provides data about "Safety Certificate Template" in SAP S/4HANA. It reads from 1 data source (I_SafetyCertificateTemplate) and exposes 82 fields with key field SafetyCertificate. It has 18 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SafetyCertificateTemplate	I_SafetyCertificateTemplate	from

Associations (18)

Cardinality	Target	Alias	Condition
[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_TechnicalObject	_TechnicalObjectVH	`_TechnicalObjectVH.MaintenancePlanningPlant = $projection.MaintenancePlanningPlant and $projection.FunctionalLocation = _TechnicalObjectVH.TechnicalObject`
[1..1]	I_TechnicalObject	_TechnicalObjectEquipVH	`_TechnicalObjectEquipVH.MaintenancePlanningPlant = $projection.MaintenancePlanningPlant and $projection.Equipment = _TechnicalObjectEquipVH.TechnicalObject`
[1..1]	I_SafetyCertificateLongText	_SftyCertLongText	`_SftyCertLongText.SafetyCertificate = $projection.SafetyCertificate and _SftyCertLongText.Language = $session.system_language`
[1..1]	I_SafetyCertificateBasic	_SafetyCertificateBasic	`_SafetyCertificateBasic.SafetyCertificateInternalID = $projection.SafetyCertificateTmplID`
[0..1]	I_TechObjIsEquipOrFuncnlLoc	_TechObjIsEquipOrFuncnlLocVH	`_TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc -- Extensions, do not expose as association:`
[0..1]	E_SafetyCertificateTemplate	_SafetyCertificateTmpExtension	`_SafetyCertificateTmpExtension.SafetyCertificate = $projection.SafetyCertificate`
[*]	R_SftyCertTemplateApprovalTP	_SftyCertTemplateApproval
[*]	R_SftyCertTmplApprvlSegmentTP	_SftyCertTmplApprvlSegment
[*]	R_SftyCertTmplSftyPrecautionTP	_SftyCertTmplSftyPrecaution
[*]	R_SftyCertTmplWrkPmtTemplateTP	_SftyCertTmplWrkPmtTemplate
[*]	R_SftyCertTemplateLongTextTP	_SftyCertTemplateLongText
[*]	R_SftyCertTmplTechObjectTP	_TechnicalObjectTmpl
[*]	R_SftyCertTemplatePartnerTP	_SftyCertTmplPartner

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.sapObjectNodeType.name	SafetyCertificate	view
EndUserText.label	Safety Certificate Template	view

Fields (82)

Key	Field	Source Table	Source Field	Description
KEY	SafetyCertificate		SafetyCertificate	WC Document
	SafetyCertificateInternalID		SafetyCertificateInternalID	Object number
	SftyCertificateSubobjectType		SftyCertificateSubobjectType	Object Type
	SafetyCertificateType		SafetyCertificateType	Usage
	SftyCertDesc		SftyCertDesc	Short Text
	SftyCertHasLongText		SftyCertHasLongText	Long Text
	LongTextKey		LongTextKey	Text Name
	SftyCertIsDeleted		SftyCertIsDeleted	Delete
	MaintenancePlannerGroup		MaintenancePlannerGroup	Planner Group
	MaintenancePlanningPlant		MaintenancePlanningPlant	Planning Plant
	ObjectTypeCode		ObjectTypeCode	Object Type
	OperationWorkCenterInternalID		OperationWorkCenterInternalID	Object ID
	TechObjAuthorizationGroup		TechObjAuthorizationGroup	AuthorizGroup
	SftyCertValidFrmDate		SftyCertValidFrmDate	Valid from
	SftyCertValidFrmTime		SftyCertValidFrmTime	ValidFrm Time
	SftyCertValidToDate		SftyCertValidToDate	Valid to
	SftyCertValidToTime		SftyCertValidToTime	Valid-To Time
	FunctionalLocation		FunctionalLocation	Object ID
	Equipment		Equipment	Equipment check
	FunctionalLocationLabelName	_FunctionalLocationLabel	FunctionalLocationLabelName	Functional Loc.
	MaintenancePlantendasMaintenancePlant
	PlantNameendasPlantName
	PlantSectionendasPlantSection
	AssetLocationendasAssetLocation
	AssetRoomendasAssetRoom
	LocationNameendasLocationName
	MaintenancePlantName
	SftyCertHasObjectList		SftyCertHasObjectList	Obj.List Exists
	CreatedByUserName		CreatedByUserName	Person Resp.
	CreatedByUser		CreatedByUser	User Name
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	CreationDateTime		CreationDateTime	Timestamp
	ValidFromDateTime		ValidFromDateTime	Time Stamp
	ValidToDateTime		ValidToDateTime	Time Stamp
	SftyCertRefSftyCertTemplate	_SafetyCertificateBasic	SafetyCertificate	WC Document
	LastChangedByUserName		UserDescription	Full Name
	LastChangedByUser		LastChangedByUser	User Name
	MaintenancePlanningPlantName	_SftyCertPlanningPlant	PlantName	Plant Name
	MaintenancePlannerGroupName	_MaintenancePlannerGroup	MaintenancePlannerGroupName	Planner Group Name
	SftyCertificateTypeDescription	_SftyCertTemplateType	SftyCertificateTypeDescription	Sfty Cert Type Desc
	LastChangeDate		LastChangeDate	Time Stamp
	LastChangeTime		LastChangeTime	Time changed
	LastChangeDateTime		LastChangeDateTime	Timestamp
	WorkCenter		WorkCenter	Work Center
	WorkCenterText		WorkCenterText	Work Center Text
	WorkCenterPlant	_MainWorkCenter	Plant	Valuation Area
	MainWorkCenterPlantName	_WorkCenterPlant	PlantName	Plant Name
	SftyCertIsLinkdToDoc		SftyCertIsLinkdToDoc	Document Link
	StatusProfile		StatusProfile	Status Profile
	IsAttachmentsEnabled
	SafetyCertificateTmplID		SafetyCertificateTmplID	Template
	SftyCertHasMaintRemark		SftyCertHasMaintRemark	Remarks Mt
	SftyCertHasOpRemark		SftyCertHasOpRemark	Remarks Op
	SftyCertProcessingStatus		SftyCertProcessingStatus	Proc Stat Sfty Cert
	SftyCertProcessingStatusText		SftyCertProcessingStatusText	Short Description
	_LastChangedByUser		_LastChangedByUser
	_CreatedByUser		_CreatedByUser
	SafetyCertificateLongText
	SftyCertCancellationText	_SftyCertLongText	SftyCertCancellationText	Long Text
	SftyCertCnctntdActvSystStsTxt		SftyCertCnctntdActvSystStsTxt	Concatenated System Status
	_Equipment		_Equipment
	_EquipmentText		_EquipmentText
	_FunctionalLocation		_FunctionalLocation
	_FunctionalLocationText		_FunctionalLocationText
	_FunctionalLocationLabel		_FunctionalLocationLabel
	_TechnicalObjectVH		_TechnicalObjectVH
	_TechnicalObjectEquipVH		_TechnicalObjectEquipVH
	IsApproved		IsApproved	Checkbox
	PrintIsReal
	SftyCertChgStsActnEnbldVal		SftyCertChgStsActnEnbldVal
	_MaintenancePlannerGroup		_MaintenancePlannerGroup
	_SftyCertTemplateApproval		_SftyCertTemplateApproval
	_SftyCertTmplApprvlSegment		_SftyCertTmplApprvlSegment
	_SftyCertTmplSftyPrecaution		_SftyCertTmplSftyPrecaution
	_SftyCertTmplWrkPmtTemplate		_SftyCertTmplWrkPmtTemplate
	_SftyCertTemplateLongText		_SftyCertTemplateLongText
	_SafetyCertificateBasic		_SafetyCertificateBasic
	_MainWorkCenter		_MainWorkCenter
	_TechObjIsEquipOrFuncnlLocVH		_TechObjIsEquipOrFuncnlLocVH
	_TechnicalObjectTmpl		_TechnicalObjectTmpl
	_SftyCertTmplPartner		_SftyCertTmplPartner

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 R_SafetyCertificateTemplateTP.
-- 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 R_SafetyCertificateTemplateTP AS
SELECT
  SafetyCertificate,
  SafetyCertificateInternalID,
  SftyCertificateSubobjectType,
  SafetyCertificateType,
  SftyCertDesc,
  SftyCertHasLongText,
  LongTextKey,
  SftyCertIsDeleted,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  SftyCertValidFrmDate,
  SftyCertValidFrmTime,
  SftyCertValidToDate,
  SftyCertValidToTime,
  FunctionalLocation,
  Equipment,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.MaintenancePlant when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.MaintenancePlant end as MaintenancePlant AS MaintenancePlantendasMaintenancePlant,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment._MaintenancePlant.PlantName when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment._MaintenancePlant.PlantName end as PlantName AS PlantNameendasPlantName,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.PlantSection when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.PlantSection end as PlantSection AS PlantSectionendasPlantSection,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.AssetLocation when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.AssetLocation end as AssetLocation AS AssetLocationendasAssetLocation,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.AssetRoom when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.AssetRoom end as AssetRoom AS AssetRoomendasAssetRoom,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment._Location.LocationName when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment._Location.LocationName end as LocationName AS LocationNameendasLocationName,
  _TechnicalObjectVH._LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
  SftyCertHasObjectList,
  CreatedByUserName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  ValidFromDateTime,
  ValidToDateTime,
  _SafetyCertificateBasic.SafetyCertificate AS SftyCertRefSftyCertTemplate,
  UserDescription AS LastChangedByUserName,
  LastChangedByUser,
  _SftyCertPlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _SftyCertTemplateType.SftyCertificateTypeDescription AS SftyCertificateTypeDescription,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  WorkCenter,
  WorkCenterText,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  _WorkCenterPlant.PlantName AS MainWorkCenterPlantName,
  SftyCertIsLinkdToDoc,
  StatusProfile,
  cast(' ' as cv_orig preserving type ) AS IsAttachmentsEnabled,
  SafetyCertificateTmplID,
  SftyCertHasMaintRemark,
  SftyCertHasOpRemark,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  _SftyCertLongText._LongText.PlainLongText AS SafetyCertificateLongText,
  _SftyCertLongText.SftyCertCancellationText AS SftyCertCancellationText,
  SftyCertCnctntdActvSystStsTxt,
  IsApproved,
  cast( '' as abap.char(1)) AS PrintIsReal,
  SftyCertChgStsActnEnbldVal
FROM I_SafetyCertificateTemplate
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_TechnicalObject AS _TechnicalObjectVH ON _TechnicalObjectVH.MaintenancePlanningPlant = MaintenancePlanningPlant AND FunctionalLocation = _TechnicalObjectVH.TechnicalObject  -- association [1..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObjectEquipVH ON _TechnicalObjectEquipVH.MaintenancePlanningPlant = MaintenancePlanningPlant AND Equipment = _TechnicalObjectEquipVH.TechnicalObject  -- association [1..1]
LEFT OUTER JOIN I_SafetyCertificateLongText AS _SftyCertLongText ON _SftyCertLongText.SafetyCertificate = SafetyCertificate AND _SftyCertLongText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SafetyCertificateBasic AS _SafetyCertificateBasic ON _SafetyCertificateBasic.SafetyCertificateInternalID = SafetyCertificateTmplID  -- association [1..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLocVH ON _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN E_SafetyCertificateTemplate AS _SafetyCertificateTmpExtension ON _SafetyCertificateTmpExtension.SafetyCertificate = SafetyCertificate  -- association [0..1]
LEFT OUTER JOIN R_SftyCertTemplateApprovalTP AS _SftyCertTemplateApproval ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTmplApprvlSegmentTP AS _SftyCertTmplApprvlSegment ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTmplSftyPrecautionTP AS _SftyCertTmplSftyPrecaution ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTmplWrkPmtTemplateTP AS _SftyCertTmplWrkPmtTemplate ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTemplateLongTextTP AS _SftyCertTemplateLongText ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTmplTechObjectTP AS _TechnicalObjectTmpl ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTemplatePartnerTP AS _SftyCertTmplPartner ON /* condition not available in parsed metadata */  -- association [*]
;

Depth:

R_SafetyCertificateTemplateTP view_entity

I_SafetyCertificateTemplate view

C_SafetyCertificateTemplateTP view_entity