SEPM_I_GenderCode

DDL: SEPM_I_GENDERCODE SQL: SEPM_IGENDERCODE Type: view

EPM Demo: Gender Code

SEPM_I_GenderCode is a CDS View of category Dimension that provides data about "EPM Demo: Gender Code" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 1 field. It has 1 association to related views.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] SEPM_I_GenderCodeText _Text $projection.GenderCode = _Text.GenderCode

Annotations (9)

NameValueLevelField
EndUserText.label EPM Demo: Gender Code view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey GenderCode view
AbapCatalog.sqlViewName SEPM_IGENDERCODE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (1)

KeyFieldSource TableSource FieldDescription
_Text _Text 
@EndUserText.label: 'EPM Demo: Gender Code'
//@VDM.viewType: #BASIC

@Analytics:{ dataCategory: #DIMENSION , dataExtraction.enabled: true }  -- directly usable in analytics
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'GenderCode'
@AbapCatalog.sqlViewName: 'SEPM_IGENDERCODE'

@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass: #MASTER


define view SEPM_I_GenderCode  as 
select
  from dd07l                                                -- table of all domain fix values
  
association [0..*] to SEPM_I_GenderCodeText as _Text
  on  $projection.GenderCode = _Text.GenderCode

{
  -- shorten the generic char(10) format of domain fix values and cast to appropriate data element
  @ObjectModel.text.association: '_Text'
  key cast ( substring( domvalue_l, 1, 1 ) as snwd_sex preserving type ) as GenderCode,  
  _Text
} 
where
      domname  = 'D_MF'                                     -- domain name
  and as4local = 'A'                                        -- active in DDIC

Learn More