C_SftyDataShtCntctRgnTP

DDL: C_SFTYDATASHTCNTCTRGNTP Type: view_entity CONSUMPTION Package: EHSDS_CNS_CONTACT_DATA
14 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

SDS Contact Target Region

C_SftyDataShtCntctRgnTP is a Consumption CDS View that provides data about "SDS Contact Target Region" in SAP S/4HANA. It reads from 1 data source (R_SftyDataShtCntctRgnTP) and exposes 14 fields with key field SftyDataShtCntctCntryRgnUUID. It is exposed through 2 OData services (ASQL_F4521, UI_EHS_SDS_CONTACT_MAN). It is used in 1 Fiori application: Manage Contact Data - Safety Data Sheets. Part of development package EHSDS_CNS_CONTACT_DATA.

Data Sources (1)

SourceAliasJoin Type
R_SftyDataShtCntctRgnTP R_SftyDataShtCntctRgnTP projection

Annotations (13)

NameValueLevelField
EndUserText.label SDS Contact Target Region view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey SftyDataShtCntctCntryRgnUUID view
UI.headerInfo.typeName Region view
UI.headerInfo.typeNamePlural Regions view
UI.headerInfo.title.value Region view
UI.headerInfo.description.value Region view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4521 ASQL_F4521 C2 NOT_RELEASED
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 (14)

KeyFieldSource TableSource FieldDescription
KEY SftyDataShtCntctCntryRgnUUID SftyDataShtCntctCntryRgnUUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
LastChangeDateTime LastChangeDateTime Timestamp
SftyDataShtCntctUUID SftyDataShtCntctUUID
Country Country Venue: Ctry/Reg
Region Region Venue Region
RegionNamelocalized
virtualSftyDataShtCntctAssgdCountryland1
_Country
_CountryText _CountryText
_Region _Region

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_SftyDataShtCntctRgnTP.
-- 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_SftyDataShtCntctRgnTP AS
SELECT
  SftyDataShtCntctCntryRgnUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type ) AS LastChangedByUserName,
  LastChangeDateTime,
  SftyDataShtCntctUUID,
  Country,
  Region,
  _RegionText.RegionName : localized AS RegionNamelocalized,
  virtual SftyDataShtCntctAssgdCountry : land1 AS virtualSftyDataShtCntctAssgdCountryland1
FROM R_SftyDataShtCntctRgnTP
;

Learn More