C_SafetyCertificateTemplateTP

DDL: C_SAFETYCERTIFICATETEMPLATETP Type: view_entity CONSUMPTION
65 Fields 1 Data Sources 1 Associations 1 OData Services

Safety Certificate Template

C_SafetyCertificateTemplateTP is a Consumption CDS View that provides data about "Safety Certificate Template" in SAP S/4HANA. It reads from 1 data source (R_SafetyCertificateTemplateTP) and exposes 65 fields with key field SafetyCertificate. It has 1 association to related views. It is exposed through 1 OData service (UI_SAFETYCERTIFICATETEMPLATE).

Data Sources (1)

SourceAliasJoin Type
R_SafetyCertificateTemplateTP R_SafetyCertificateTemplateTP projection

Associations (1)

CardinalityTargetAliasCondition
[*] C_SftyCertTemplateStatus _SftyCertTemplateStatus _SftyCertTemplateStatus.SafetyCertificate = $projection.SafetyCertificate and _SftyCertTemplateStatus.SafetyCertificateInternalID = $projection.SafetyCertificateInternalID

Annotations (10)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name SafetyCertificate view
Search.searchable true view
EndUserText.label Safety Certificate Template view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SAFETYCERTIFICATETEMPLATE UI_SFTYCERTIFICATETEMPLATE V2 C1 NOT_RELEASED

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate SafetyCertificate WC Document
SafetyCertificateInternalID SafetyCertificateInternalID Object number
SftyCertificateSubobjectType SftyCertificateSubobjectType Object Type
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
SafetyCertificateType SafetyCertificateType Usage
SftyCertificateTypeDescription SftyCertificateTypeDescription Sfty Cert Type Desc
SftyCertDesc SftyCertDesc Short Text
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
WorkCenter WorkCenter Work Center
WorkCenterText WorkCenterText Work Center Text
WorkCenterPlant WorkCenterPlant Main Work Center Plant
MainWorkCenterPlantName MainWorkCenterPlantName Plant Name
MaintenancePlanningPlantName MaintenancePlanningPlantName Plant Name
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
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
FunctionalLocationLabelName
Equipment SafetyCertificateTemplate Equipment Equipment check
EquipmentNameasEquipmentNamelocalized
SftyCertHasLongText SftyCertHasLongText Long Text
SafetyCertificateLongText SafetyCertificateLongText Long Text
CreatedByUser CreatedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName LastChangedByUserName User Name
LastChangeDateTime LastChangeDateTime Timestamp
ValidFromDateTime ValidFromDateTime Time Stamp
ValidToDateTime ValidToDateTime Time Stamp
TechnicalObject TechnicalObject Technical Object
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
TechnicalObjectDescription TechnicalObjectDescription Tech. Obj. Desc
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc Work Center Text
MaintenancePlant MaintenancePlant Plant
MaintenancePlantName MaintenancePlantName Plant Name
PlantSection PlantSection Plant Section
PlantSectionDesc PlantSectionDesc
AssetLocation AssetLocation Location
LocationName LocationName Location Name
AssetRoom AssetRoom Room
SafetyCertificateTmplID SafetyCertificateTmplID Template
SftyCertRefSftyCertTemplate SftyCertRefSftyCertTemplate WC Document
SftyCertHasMaintRemark SftyCertHasMaintRemark Remarks Mt
SftyCertHasOpRemark SftyCertHasOpRemark Remarks Op
SftyCertCancellationText SftyCertCancellationText Long Text
SftyCertCnctntdActvSystStsTxt SftyCertCnctntdActvSystStsTxt Concatenated System Status
SftyCertProcessingStatus SftyCertProcessingStatus Proc Stat Sfty Cert
SftyCertProcessingStatusText SftyCertProcessingStatusText Short Description
SftyCertChgStsActnEnbldVal SftyCertChgStsActnEnbldVal
IsApproved IsApproved Checkbox
_SftyCertTemplateStatus _SftyCertTemplateStatus
_TechObjIsEquipOrFuncnlLocVH _TechObjIsEquipOrFuncnlLocVH
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_FunctionalLocationLabel _FunctionalLocationLabel
_FunctionalLocationText _FunctionalLocationText

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 C_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 C_SafetyCertificateTemplateTP AS
SELECT
  SafetyCertificate,
  SafetyCertificateInternalID,
  SftyCertificateSubobjectType,
  MaintenancePlanningPlant,
  SafetyCertificateType,
  SftyCertificateTypeDescription,
  SftyCertDesc,
  MaintenancePlannerGroup,
  WorkCenter,
  WorkCenterText,
  WorkCenterPlant,
  MainWorkCenterPlantName,
  MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  SftyCertValidFrmDate,
  SftyCertValidFrmTime,
  SftyCertValidToDate,
  SftyCertValidToTime,
  FunctionalLocation,
  _FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  SafetyCertificateTemplate.Equipment AS Equipment,
  _EquipmentText.EquipmentName as EquipmentName : localized AS EquipmentNameasEquipmentNamelocalized,
  SftyCertHasLongText,
  SafetyCertificateLongText,
  CreatedByUser,
  CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  LastChangedByUserName,
  LastChangeDateTime,
  ValidFromDateTime,
  ValidToDateTime,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLocVH._Text[1:Language = $session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  MaintenancePlant,
  MaintenancePlantName,
  PlantSection,
  PlantSectionDesc,
  AssetLocation,
  LocationName,
  AssetRoom,
  SafetyCertificateTmplID,
  SftyCertRefSftyCertTemplate,
  SftyCertHasMaintRemark,
  SftyCertHasOpRemark,
  SftyCertCancellationText,
  SftyCertCnctntdActvSystStsTxt,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  SftyCertChgStsActnEnbldVal,
  IsApproved
FROM R_SafetyCertificateTemplateTP
LEFT OUTER JOIN C_SftyCertTemplateStatus AS _SftyCertTemplateStatus ON _SftyCertTemplateStatus.SafetyCertificate = SafetyCertificate AND _SftyCertTemplateStatus.SafetyCertificateInternalID = SafetyCertificateInternalID  -- association [*]
;

Learn More