I_DomainFixedValue

DDL: I_DOMAINFIXEDVALUE Type: view BASIC

Domain Fixed Value

I_DomainFixedValue is a Basic CDS View that provides data about "Domain Fixed Value" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 7 fields with key fields SAPDataDictionaryDomain, DomainValue, DomainActivationState, DomainValuePosition, DomainVersion. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Domain _Domain $projection.SAPDataDictionaryDomain = _Domain.SAPDataDictionaryDomain and $projection.DomainActivationState = _Domain.DomainActivationState and $projection.DomainVersion = _Domain.DomainVersion
[0..*] I_DomainFixedValueText _DomainFixedValueText $projection.SAPDataDictionaryDomain = _DomainFixedValueText.SAPDataDictionaryDomain and $projection.DomainValue = _DomainFixedValueText.DomainValue and $projection.DomainActivationState = _DomainFixedValueText.DomainActivationState and $projection.DomainValuePosition = _DomainFixedValueText.DomainValuePosition and $projection.DomainVersion = _DomainFixedValueText.DomainVersion

Annotations (13)

NameValueLevelField
EndUserText.label Domain Fixed Value view
ObjectModel.representativeKey DomainValue view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IDOMFIXVAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor NONE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SAPDataDictionaryDomain domname
KEY DomainValue domvalue_l
KEY DomainActivationState as4local
KEY DomainValuePosition valpos
KEY DomainVersion as4vers
_Domain _Domain
_DomainFixedValueText _DomainFixedValueText 
@EndUserText:   {label:              'Domain Fixed Value'}
@ObjectModel:   {representativeKey:  'DomainValue',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XL,
                                      dataClass:      #CUSTOMIZING}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IDOMFIXVAL'}
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@ClientHandling.algorithm:           #SESSION_VARIABLE

// views deprecated for Cloud 1808/ OP 1809

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'NONE'


define view I_DomainFixedValue
  as select from dd07l
  association [1..1] to I_Domain               as _Domain               on  $projection.SAPDataDictionaryDomain = _Domain.SAPDataDictionaryDomain
                                                                        and $projection.DomainActivationState   = _Domain.DomainActivationState
                                                                        and $projection.DomainVersion           = _Domain.DomainVersion
  association [0..*] to I_DomainFixedValueText as _DomainFixedValueText on  $projection.SAPDataDictionaryDomain = _DomainFixedValueText.SAPDataDictionaryDomain
                                                                        and $projection.DomainValue             = _DomainFixedValueText.DomainValue
                                                                        and $projection.DomainActivationState   = _DomainFixedValueText.DomainActivationState
                                                                        and $projection.DomainValuePosition     = _DomainFixedValueText.DomainValuePosition
                                                                        and $projection.DomainVersion           = _DomainFixedValueText.DomainVersion
{
      @ObjectModel.foreignKey.association: '_Domain'
  key domname    as  SAPDataDictionaryDomain,
  key domvalue_l as  DomainValue,
  key as4local   as  DomainActivationState,
  key valpos     as  DomainValuePosition,
  key as4vers    as  DomainVersion,

      /* Associations */
      _Domain,
      _DomainFixedValueText
}
where
  as4local = 'A';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_DOMAIN",
"I_DOMAINFIXEDVALUETEXT"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More