I_PCESExposureScenarioTypeTxt

DDL: I_PCESEXPOSURESCENARIOTYPETXT Type: view BASIC Package: EHSDS_CRPAT_ES

Exposure Scenario Type - Text

I_PCESExposureScenarioTypeTxt is a Basic CDS View that provides data about "Exposure Scenario Type - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields. It has 1 association to related views. It is exposed through 1 OData service (UI_EHS_SDS_ESDSANX_MAN). It is used in 1 Fiori application: Manage eSDS Annex. Part of development package EHSDS_CRPAT_ES.

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07t ExpsrScenTypeText from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
EndUserText.label Exposure Scenario Type - Text view
AbapCatalog.sqlViewName IPCESESCNTYPETXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey PCESExposureScenarioType view

OData Services (1)

ServiceBindingVersionContractRelease
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 (4)

KeyFieldSource TableSource FieldDescription
domvalue_l13asPCESExposureScenarioType
ddlanguageassylanguasLanguage
ddtextasPCESExposureScenarioTypeTxt
_Language _Language 
@EndUserText.label: 'Exposure Scenario Type - Text'

@AbapCatalog:
{
  sqlViewName: 'IPCESESCNTYPETXT',
  compiler.compareFilter: true,
  preserveKey: true
}

// authorization check not required as view only reads domain values

@AccessControl.authorizationCheck: #NOT_REQUIRED

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC

@ObjectModel:
{
  --Data category
  dataCategory: #TEXT,
  --Performance annotation
  usageType:
  {
    dataClass: #META,
    serviceQuality: #B,
    sizeCategory: #S
  },
  --Representative Key
  representativeKey: 'PCESExposureScenarioType'
}

define view I_PCESExposureScenarioTypeTxt
  --Select data from domain value description table
  as select from dd07t as ExpsrScenTypeText

  --association to I_Language
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
      --Domain Value of Basic Data Status
  key substring(ExpsrScenTypeText.domvalue_l, 1, 3) as PCESExposureScenarioType,

      --Language
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cast(ExpsrScenTypeText.ddlanguage as sylangu) as Language,

      --language-dependent description of domain value
      @Semantics.text: true
      ExpsrScenTypeText.ddtext                      as PCESExposureScenarioTypeTxt,

      /* Associations */
      _Language
}
where
      ExpsrScenTypeText.domname  = 'EHSDS_ES_EXPSR_SCENARIO_TYPE'
  and ExpsrScenTypeText.as4local = 'A'

Learn More