C_SftyDataShtCntctAddrTP

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

SDS Contact Address

C_SftyDataShtCntctAddrTP is a Consumption CDS View that provides data about "SDS Contact Address" in SAP S/4HANA. It reads from 1 data source (R_SftyDataShtCntctAddrTP) and exposes 13 fields with key field SftyDataShtCntctAddrUUID. 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_SftyDataShtCntctAddrTP R_SftyDataShtCntctAddrTP projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label SDS Contact Address view
Metadata.allowExtensions true view
ObjectModel.representativeKey SftyDataShtCntctAddrUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Address view
UI.headerInfo.typeNamePlural Addresses view
UI.headerInfo.title.value SftyDataShtCntctAddrTypeText view
UI.headerInfo.description.value SftyDataShtCntctAddrTypeText view
VDM.viewType #CONSUMPTION 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 (13)

KeyFieldSource TableSource FieldDescription
KEY SftyDataShtCntctAddrUUID SftyDataShtCntctAddrUUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
LastChangeDateTime LastChangeDateTime Timestamp
SftyDataShtCntctUUID SftyDataShtCntctUUID
SftyDataShtCntctAddrTypeCode SftyDataShtCntctAddrTypeCode
SftyDataShtCntctAddrTypeTextlocalized
BusinessPartner BusinessPartner Issuing Authority
SftyDataShtCntctAddrID SftyDataShtCntctAddrID
_ContactAddrType _ContactAddrType
_BusinessPartner _BusinessPartner

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_SftyDataShtCntctAddrTP.
-- 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_SftyDataShtCntctAddrTP AS
SELECT
  SftyDataShtCntctAddrUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  cast(_LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type) AS LastChangedByUserName,
  LastChangeDateTime,
  SftyDataShtCntctUUID,
  SftyDataShtCntctAddrTypeCode,
  _ContactAddrType._Text.SftyDataShtCntctAddrTypeText : localized AS SftyDataShtCntctAddrTypeTextlocalized,
  BusinessPartner,
  SftyDataShtCntctAddrID
FROM R_SftyDataShtCntctAddrTP
;

Learn More