P_AllocDisplayCurrencyType

DDL: P_ALLOCDISPLAYCURRENCYTYPE SQL: PALLOCGRPHCUR Type: view BASIC

P_AllocDisplayCurrencyType is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field AllocationDisplayCurrencyType. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[1] P_AllocDisplayCurrencyTypeName _Text $projection.AllocationDisplayCurrencyType = _Text.AllocationDisplayCurrencyType and _Text.Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PALLOCGRPHCUR view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable false view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY AllocationDisplayCurrencyType
_Text _Text 
@AbapCatalog.sqlViewName: 'PALLOCGRPHCUR'
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: false
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.private: true

define view P_AllocDisplayCurrencyType
  as select from dd07l
  association [1] to P_AllocDisplayCurrencyTypeName as _Text on  $projection.AllocationDisplayCurrencyType = _Text.AllocationDisplayCurrencyType
                                                             and _Text.Language                            = $session.system_language
{
  key  cast( substring( domvalue_l, 1, 1) as fco_alloc_ng_currency_type ) as AllocationDisplayCurrencyType,
       _Text

}
where
      dd07l.domname  = 'FCO_ALLOC_NG_CURRENCY_TYPE'
  and dd07l.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"P_ALLOCDISPLAYCURRENCYTYPENAME"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More