I_EHSCmplncAnlysFltrTaskC

DDL: I_EHSCMPLNCANLYSFLTRTASKC SQL: IEHSCAFLTRTC Type: view COMPOSITE Package: EHENV_CNS_EMISSION_INVENTORY

Compliance Analysis FIlter Cube

I_EHSCmplncAnlysFltrTaskC is a Composite CDS View (Cube) that provides data about "Compliance Analysis FIlter Cube" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 5 fields with key fields EHSTaskDueDate, Country. It has 2 associations to related views. Part of development package EHENV_CNS_EMISSION_INVENTORY.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EHSCountriesExclGroups _Country $projection.Country = _Country.Country
[0..*] I_EHSCountriesTextExclGroups _CountryName $projection.Country = _CountryName.Country

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEHSCAFLTRTC view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Compliance Analysis FIlter Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDueDate
KEY Country _Country Country
EHSTaskStatusValueForSorting
CmplRqType
_CountryName _CountryName 
@AbapCatalog.sqlViewName: 'IEHSCAFLTRTC'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Compliance Analysis FIlter Cube'
@ClientHandling.algorithm: #SESSION_VARIABLE

@Analytics: { dataCategory:#CUBE, internalName:#LOCAL }
@VDM.viewType: #COMPOSITE
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED,
  // blocking of personal data not required (user data can not be blocked and no BP info from user exposed)

  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel.usageType:{ serviceQuality: #D,
                         sizeCategory:  #XL,
                         dataClass: #MIXED }
@Metadata.allowExtensions:true

define view I_EHSCmplncAnlysFltrTaskC
  as select from I_SAPClient

  association [1..1] to I_EHSCountriesExclGroups     as _Country     on $projection.Country = _Country.Country
  association [0..*] to I_EHSCountriesTextExclGroups as _CountryName on $projection.Country = _CountryName.Country
{
  key            cast ( '00000000' as ehfnd_task_plan_due_date ) as EHSTaskDueDate,
                 @ObjectModel.text.association: '_CountryName'
  key            _Country.Country                                as Country,

                 cast ( '01' as ehfnd_task_calendar_status )     as EHSTaskStatusValueForSorting,

                 cast( '00' as ehfnd_req_type_nce )              as CmplRqType,

                 _CountryName
}
where
  sapclient = $session.client

Learn More