I_DistrControllingValueType

DDL: I_DISTRCONTROLLINGVALUETYPE Type: view_entity COMPOSITE

Distribution controlling value type

I_DistrControllingValueType is a Composite CDS View that provides data about "Distribution controlling value type" in SAP S/4HANA. It reads from 2 data sources (dd07t, t002) and exposes 3 fields with key fields ControllingValueType, Language.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
dd07t a from
t002 b inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Distribution controlling value type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ControllingValueType
KEY Language dd07t ddlanguage
ControllingValueTypeText dd07t ddtext 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Distribution controlling value type'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_DistrControllingValueType
  as select from dd07t as a
    inner join   t002  as b on b.spras = a.ddlanguage
{
  key cast( a.domvalue_l as co_wrttp ) as ControllingValueType,
  key a.ddlanguage                     as Language,
      a.ddtext                         as ControllingValueTypeText

}
where
       a.domname    = 'CO_WRTTP'
  and  a.as4local   = 'A'
  and(
       a.domvalue_l = '04'
    or a.domvalue_l = '12'
    or a.domvalue_l = '22'
  )
  and  a.ddlanguage = $session.system_language

Learn More