I_SafetyDataSheetFormTemplate

DDL: I_SAFETYDATASHEETFORMTEMPLATE Type: view_entity BASIC Package: EHSDS_RAP_CRV_CONFIGURATION
3 Fields 1 Data Sources 1 Associations

SDS Templates

I_SafetyDataSheetFormTemplate is a Basic CDS View that provides data about "SDS Templates" in SAP S/4HANA. It reads from 1 data source (fpcontext) and exposes 3 fields with key field SafetyDataSheetFormTemplate. It has 1 association to related views. Part of development package EHSDS_RAP_CRV_CONFIGURATION.

Data Sources (1)

SourceAliasJoin Type
fpcontext Template from

Associations (1)

CardinalityTargetAliasCondition
[0..*] fpcontextt _Text $projection.SafetyDataSheetFormTemplate = _Text.name

Annotations (8)

NameValueLevelField
EndUserText.label SDS Templates view
Analytics.technicalName ISDSTEMPLATE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey SafetyDataSheetFormTemplate view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SafetyDataSheetFormTemplate fpcontext name Zone name
FormTemplateDataProvider fpcontext dataprovider Name
SafetyDataSheetFormTemplateTxt

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_SafetyDataSheetFormTemplate.
-- 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 I_SafetyDataSheetFormTemplate AS
SELECT
  Template.name AS SafetyDataSheetFormTemplate,
  Template.dataprovider AS FormTemplateDataProvider,
  _Text[1: language = $session.system_language ].text AS SafetyDataSheetFormTemplateTxt
FROM fpcontext AS Template
LEFT OUTER JOIN fpcontextt AS _Text ON SafetyDataSheetFormTemplate = _Text.name  -- association [0..*]
;

Learn More