C_SftyDataShtCntctEmgyNmbrTP

DDL: C_SFTYDATASHTCNTCTEMGYNMBRTP Type: view_entity CONSUMPTION
11 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

SDS Contact Emergency Number

C_SftyDataShtCntctEmgyNmbrTP is a Consumption CDS View that provides data about "SDS Contact Emergency Number" in SAP S/4HANA. It reads from 1 data source (R_SftyDataShtCntctEmgyNmbrTP) and exposes 11 fields with key field SftyDataShtCntctEmgyNmbrUUID. It is exposed through 1 OData service (UI_EHS_SDS_CONTACT_MAN). It is used in 1 Fiori application: Manage Contact Data - Safety Data Sheets.

Data Sources (1)

SourceAliasJoin Type
R_SftyDataShtCntctEmgyNmbrTP R_SftyDataShtCntctEmgyNmbrTP projection

Annotations (12)

NameValueLevelField
EndUserText.label SDS Contact Emergency Number view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey SftyDataShtCntctEmgyNmbrUUID view
UI.headerInfo.typeName Emergency Phone Number view
UI.headerInfo.typeNamePlural Emergency Phone Numbers view
UI.headerInfo.title.value LanguageName view
UI.headerInfo.description.value LanguageName view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_EHS_SDS_CONTACT_MAN UI_EHS_SDS_CONTACT_MAN V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F4521 Manage Contact Data - Safety Data Sheets Transactional

Manage Contact Data - Safety Data Sheets

Business Role: Product Stewardship Specialist - Product Compliance

With this feature, you can enter and edit address data as well as the emergency phone number for safety data sheets. In addition you can also enter a logo that has been selected from the Manage Logo app. This information is required in section 1.3 of a safety data sheet and can also be used for the coversheet when shipping safety data sheets.

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SftyDataShtCntctEmgyNmbrUUID SftyDataShtCntctEmgyNmbrUUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
LastChangeDateTime LastChangeDateTime Timestamp
SftyDataShtCntctUUID SftyDataShtCntctUUID
SftyDataShtCntctEmgyNmbrText SftyDataShtCntctEmgyNmbrText
Language Report Text Language
LanguageNamelocalized
_Language _Language

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_SftyDataShtCntctEmgyNmbrTP.
-- 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_SftyDataShtCntctEmgyNmbrTP AS
SELECT
  SftyDataShtCntctEmgyNmbrUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  LastChangeDateTime,
  SftyDataShtCntctUUID,
  SftyDataShtCntctEmgyNmbrText,
  cast( Language as ehfnd_langu preserving type ) AS Language,
  _Language._Text.LanguageName : localized AS LanguageNamelocalized
FROM R_SftyDataShtCntctEmgyNmbrTP
;

Learn More