C_ExpsrScenAssgmtTP

DDL: C_EXPSRSCENASSGMTTP Type: view CONSUMPTION Package: EHSDS_CRPAT_ES
14 Fields 1 Data Sources 2 Associations 2 OData Services 1 Fiori Apps

Exposure Scenario Assignment

C_ExpsrScenAssgmtTP is a Consumption CDS View that provides data about "Exposure Scenario Assignment" in SAP S/4HANA. It reads from 1 data source (I_ExpsrScenAssgmtTP) and exposes 14 fields. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F6751, UI_EHS_SDS_ESDSANX_MAN). It is used in 1 Fiori application: Manage eSDS Annex. Part of development package EHSDS_CRPAT_ES.

Data Sources (1)

SourceAliasJoin Type
I_ExpsrScenAssgmtTP I_ExpsrScenAssgmtTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ExpsrScenAnnexAssmtTP _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID -- Assigend Exposure Scnearios
[1..1] C_ExpsrScenAssgmtEnhanced _ExpsrScenAssgmtEnhanced $projection.PCESScenarioAssgmtUUID = _ExpsrScenAssgmtEnhanced.PCESScenarioAssgmtUUID

Annotations (14)

NameValueLevelField
EndUserText.label Exposure Scenario Assignment view
AbapCatalog.sqlViewName CCRRESAG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6751 ASQL_F6751 C2 NOT_RELEASED
UI_EHS_SDS_ESDSANX_MAN UI_EHS_SDS_ESDSANX_MAN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6751 Manage eSDS Annex Transactional Manage eSDS Annex

Manage eSDS Annex

Business Role: Product Stewardship Specialist - Product Compliance

With the Manage eSDS Annex app, you can create new or assign existing exposure scenarios to an unpackaged product. You can specify the data that is required as an annex to a safety data sheet to ensure that the unpackaged product stays compliant.

Fields (14)

KeyFieldSource TableSource FieldDescription
ComplianceAssessmentUUIDCmplRqRsltUUID
CmplRqVersUUIDasCmplRqVersUUID
PCESShortTitlePhrs2UUID _ExpsrScenAssgmtEnhanced PCESShortTitlePhrs2UUID Short Title
PCESShortTitlePhrs3UUID _ExpsrScenAssgmtEnhanced PCESShortTitlePhrs3UUID Short Title
PCESShortTitlePhrs4UUID _ExpsrScenAssgmtEnhanced PCESShortTitlePhrs4UUID Short Title
PCESShortTitlePhrs5UUID _ExpsrScenAssgmtEnhanced PCESShortTitlePhrs5UUID Short Title
PCESShortTitlePhrs6UUID _ExpsrScenAssgmtEnhanced PCESShortTitlePhrs6UUID Short Title
CmplRqRsltNavgnLinkasCmplRqRsltNavgnLink
CreateatdatetimeCreationDateTime
CreatebyuserCreatedByUser
UpdateatdatetimeLastChangeDateTime
UpdatebyuserLastChangedByUser
_CmplRqRslt _CmplRqRslt
_ExpsrScenAssgmtEnhanced _ExpsrScenAssgmtEnhanced

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_ExpsrScenAssgmtTP.
-- 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_ExpsrScenAssgmtTP AS
SELECT
  _ExpsrScenAssgmtEnhanced.PCESShortTitlePhrs2UUID AS PCESShortTitlePhrs2UUID,
  _ExpsrScenAssgmtEnhanced.PCESShortTitlePhrs3UUID AS PCESShortTitlePhrs3UUID,
  _ExpsrScenAssgmtEnhanced.PCESShortTitlePhrs4UUID AS PCESShortTitlePhrs4UUID,
  _ExpsrScenAssgmtEnhanced.PCESShortTitlePhrs5UUID AS PCESShortTitlePhrs5UUID,
  _ExpsrScenAssgmtEnhanced.PCESShortTitlePhrs6UUID AS PCESShortTitlePhrs6UUID
FROM I_ExpsrScenAssgmtTP
LEFT OUTER JOIN C_ExpsrScenAnnexAssmtTP AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_ExpsrScenAssgmtEnhanced AS _ExpsrScenAssgmtEnhanced ON PCESScenarioAssgmtUUID = _ExpsrScenAssgmtEnhanced.PCESScenarioAssgmtUUID  -- association [1..1]
;

Learn More