I_DOMAINFIXEDVALUE

CDS View

Domain Fixed Value

I_DOMAINFIXEDVALUE is a CDS View in S/4HANA. Domain Fixed Value. 10 CDS views read from this table.

Used by 10 CDS view(s)

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_OpnCtlgItmPrpslStatusVH view from CONSUMPTION Open Catalog Proposal Status Value Help
C_PurOrdProcessingStatusVH view from CONSUMPTION Purch doc processing state value help
C_RO_StRpDomesticSlsPurListC view left_outer CONSUMPTION Romania Domestic Sales and Purchase List - Cube
C_SSPSuplrInvcTransCat view from CONSUMPTION SSP Suplier Invoice Transaction category
I_MaintenanceJobSelection view from BASIC Maintenance Job Selection Values
I_MaintTaskListTypeUnified view from BASIC Maintenance Task List Type Unified
I_PublicSectorFormClass view from BASIC Public Sector Form Class
I_PublicSectorFormStatus view from BASIC Public Sector Form Status
I_PublicSectorMessageStatus view from BASIC Public Sector Message Status
I_PublicSectorMessageType view from BASIC Public Sector Message Type 
@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