P_ISU_DOMAIN_VALUES_BR

DDL: P_ISU_DOMAIN_VALUES_BR SQL: PSUDOMAINSH Type: view BASIC

P_ISU_DOMAIN_VALUES_BR is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 4 fields with key fields DomainName, Status, int4endasLow. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07l FixedValue from

Associations (1)

CardinalityTargetAliasCondition
[1..*] dd07t ValueText FixedValue.domname = ValueText.domname and FixedValue.domvalue_l = ValueText.domvalue_l and FixedValue.as4local = ValueText.as4local and ValueText.ddlanguage = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSUDOMAINSH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY DomainName dd07l domname
KEY Status dd07l as4local
KEY int4endasLow
Text ValueText ddtext 
@AbapCatalog.sqlViewName: 'PSUDOMAINSH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ISU_DOMAIN_VALUES_BR
  as select from    dd07l as FixedValue
  association [1..*] to dd07t as ValueText on  FixedValue.domname    = ValueText.domname
                                           and FixedValue.domvalue_l = ValueText.domvalue_l
                                           and FixedValue.as4local   = ValueText.as4local
                                           and ValueText.ddlanguage = $session.system_language

{
      @UI.hidden
  key FixedValue.domname                                                                 as DomainName,
      @UI.hidden
  key FixedValue.as4local                                                                as Status,
  key case FixedValue.domvalue_l
  when '' then 0
  else cast(cast(ltrim(FixedValue.domvalue_l, '0') as abap.numc( 3 )) as abap.int4 ) end as Low,
      @Semantics.text: true
      ValueText.ddtext                                                                   as Text
}

where
     FixedValue.as4local  = 'A'
   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More