SEPM_I_GenderCodeText

DDL: SEPM_I_GENDERCODETEXT SQL: SEPM_IGENDERCODT Type: view Package: S_EPM_CDS_REF

EPM Demo: Gender Code Text

SEPM_I_GenderCodeText is a CDS View that provides data about "EPM Demo: Gender Code Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, GenderCode. It has 2 associations to related views. Part of development package S_EPM_CDS_REF.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] SEPM_I_GenderCode _GenderCode $projection.GenderCode = _GenderCode.GenderCode
[0..1] SEPM_I_Language _Language $projection.Language = _Language.Language

Annotations (9)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language ddlanguage
KEY GenderCode
GenderCodeName ddtext
_GenderCode _GenderCode
_Language _Language 
@EndUserText.label: 'EPM Demo: Gender Code Text'
//@VDM.viewType: #BASIC

@Analytics.dataExtraction.enabled: true
@ObjectModel.dataCategory: #TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'GenderCode'
@AbapCatalog.sqlViewName: 'SEPM_IGENDERCODT'

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


define view SEPM_I_GenderCodeText  as 
select
  from dd07t                                                -- text table for all domain fix values
  
association [1..1] to SEPM_I_GenderCode as _GenderCode
  on $projection.GenderCode = _GenderCode.GenderCode
association [0..1] to SEPM_I_Language as _Language
  on $projection.Language = _Language.Language 
  
{
  @Semantics.language
  @ObjectModel.foreignKey.association: '_Language'
  key ddlanguage  as Language, 
  @ObjectModel.foreignKey.association: '_GenderCode'  
  key cast ( substring( domvalue_l, 1, 1 ) as snwd_sex preserving type ) as GenderCode,
  @Semantics.text
  ddtext          as GenderCodeName,                    
  _GenderCode,
  _Language
} 
where
      domname  = 'D_MF'                                -- domain name
  and as4local = 'A'                                   -- active in DDIC

Learn More