R_SafetyCertificateTP

DDL: R_SAFETYCERTIFICATETP Type: view_entity TRANSACTIONAL
87 Fields 1 Data Sources 19 Associations

Safety Certificate

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

Data Sources (1)

SourceAliasJoin Type
I_SafetyCertificate I_SafetyCertificate from

Associations (19)

CardinalityTargetAliasCondition
[1..1] I_SafetyCertificateBasic _SafetyCertificateBasic _SafetyCertificateBasic.SafetyCertificateInternalID = $projection.SafetyCertificateTmplID
[1..1] I_WorkPermit _WorkPermit $projection.SafetyCertificateTmplID = _WorkPermit.WorkPermitInternalID
[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
[0..1] I_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLocVH _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc -- Extensions, do not expose as association:
[0..1] E_SafetyCertificate _SafetyCertificateExtension _SafetyCertificateExtension.SafetyCertificate = $projection.SafetyCertificate
[*] R_SafetyCertificateLongTextTP _SafetyCertificateLongTxt
[*] R_SafetyCertificateApprovalTP _SafetyCertificateApproval
[*] R_SftyCertApprovalSegmentTP _SftyCertApprovalSegment
[*] R_SftyCertTechnicalObjectTP _TechnicalObject
[*] R_SftyCertSafetyPrecautionTP _SafetyPrecaution
[*] R_SafetyCertificatePartnerTP _SafetyCertificatePartner
[*] R_SftyCertWorkPermitTP _SafetyCertificateWrkPmt

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Safety Certificate 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

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate SafetyCertificate WC Document
SafetyCertificateInternalID SafetyCertificateInternalID Object number
SftyCertificateSubobjectType SftyCertificateSubobjectType Object Type
SftyCertExternalNumber
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
LastChangedByUserName UserDescription Full Name
LastChangedByUser LastChangedByUser User Name
MaintenancePlanningPlantName _SftyCertPlanningPlant PlantName Plant Name
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
SftyCertificateTypeDescription 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
SftyCertRefSftyCertTemplate _SafetyCertificateBasic SafetyCertificate WC Document
WorkPermitReferenceWorkPermit _WorkPermit WorkPermit Application
SftyCertReferenceObjectType
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
_Equipment _Equipment
_EquipmentText _EquipmentText
_FunctionalLocation _FunctionalLocation
_FunctionalLocationText _FunctionalLocationText
_FunctionalLocationLabel _FunctionalLocationLabel
_TechnicalObjectVH _TechnicalObjectVH
_TechnicalObjectEquipVH _TechnicalObjectEquipVH
IsApproved IsApproved Checkbox
PrintIsReal
SftyCertChgStsActnEnbldVal SftyCertChgStsActnEnbldVal
SftyCertCnctntdActvSystStsTxt SftyCertCnctntdActvSystStsTxt Concatenated System Status
_MaintenancePlannerGroup _MaintenancePlannerGroup
_SafetyCertificateLongTxt _SafetyCertificateLongTxt
_TechnicalObject _TechnicalObject
_SafetyPrecaution _SafetyPrecaution
_SafetyCertificatePartner _SafetyCertificatePartner
_SafetyCertificateWrkPmt _SafetyCertificateWrkPmt
_SftyCertApprovalSegment _SftyCertApprovalSegment
_SafetyCertificateApproval _SafetyCertificateApproval
_SftyCertProcessingStatusText _SftyCertProcessingStatusText
_MainWorkCenter _MainWorkCenter
_TechObjIsEquipOrFuncnlLocVH _TechObjIsEquipOrFuncnlLocVH
_SafetyCertificateBasic _SafetyCertificateBasic
_WorkPermit _WorkPermit

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_SafetyCertificateTP.
-- 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_SafetyCertificateTP AS
SELECT
  SafetyCertificate,
  SafetyCertificateInternalID,
  SftyCertificateSubobjectType,
  cast ('' as wcewcnr ) AS SftyCertExternalNumber,
  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,
  UserDescription AS LastChangedByUserName,
  LastChangedByUser,
  _SftyCertPlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  SftyCertificateTypeDescription,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  WorkCenter,
  WorkCenterText,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  _WorkCenterPlant.PlantName AS MainWorkCenterPlantName,
  SftyCertIsLinkdToDoc,
  StatusProfile,
  _SafetyCertificateBasic.SafetyCertificate AS SftyCertRefSftyCertTemplate,
  _WorkPermit.WorkPermit AS WorkPermitReferenceWorkPermit,
  cast('' as ptwereferenceobject ) AS SftyCertReferenceObjectType,
  cast(' ' as cv_orig preserving type ) AS IsAttachmentsEnabled,
  SafetyCertificateTmplID,
  SftyCertHasMaintRemark,
  SftyCertHasOpRemark,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  _SftyCertLongText._LongText.PlainLongText AS SafetyCertificateLongText,
  _SftyCertLongText.SftyCertCancellationText AS SftyCertCancellationText,
  IsApproved,
  cast( '' as abap.char(1)) AS PrintIsReal,
  SftyCertChgStsActnEnbldVal,
  SftyCertCnctntdActvSystStsTxt
FROM I_SafetyCertificate
LEFT OUTER JOIN I_SafetyCertificateBasic AS _SafetyCertificateBasic ON _SafetyCertificateBasic.SafetyCertificateInternalID = SafetyCertificateTmplID  -- association [1..1]
LEFT OUTER JOIN I_WorkPermit AS _WorkPermit ON SafetyCertificateTmplID = _WorkPermit.WorkPermitInternalID  -- association [1..1]
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_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLocVH ON _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN E_SafetyCertificate AS _SafetyCertificateExtension ON _SafetyCertificateExtension.SafetyCertificate = SafetyCertificate  -- association [0..1]
LEFT OUTER JOIN R_SafetyCertificateLongTextTP AS _SafetyCertificateLongTxt ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SafetyCertificateApprovalTP AS _SafetyCertificateApproval ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertApprovalSegmentTP AS _SftyCertApprovalSegment ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertTechnicalObjectTP AS _TechnicalObject ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertSafetyPrecautionTP AS _SafetyPrecaution ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SafetyCertificatePartnerTP AS _SafetyCertificatePartner ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SftyCertWorkPermitTP AS _SafetyCertificateWrkPmt ON /* condition not available in parsed metadata */  -- association [*]
;

Learn More