I_StatKeyFigWhereUsedAllocType

DDL: I_STATKEYFIGWHEREUSEDALLOCTYPE SQL: ISKFWHEREUSDAT Type: view COMPOSITE Package: ODATA_WHERE_USED_STAT_KEY_FIG

Old and New Allocation Types

I_StatKeyFigWhereUsedAllocType is a Composite CDS View that provides data about "Old and New Allocation Types" in SAP S/4HANA. It reads from 2 data sources (dd07t, dd07t) and exposes 6 fields with key fields AllocationPostingType, AllocationPostingTypeContext, AllocationPostingTypeContext. Part of development package ODATA_WHERE_USED_STAT_KEY_FIG.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
dd07t dd07t from
dd07t dd07t union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISKFWHEREUSDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Old and New Allocation Types view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #META view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.textArrangement #TEXT_LAST view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AllocationPostingType domvalue_l
KEY AllocationPostingTypeContext
Language ddlanguage
KEY AllocationPostingTypeContext
Language ddlanguage
AllocationPostingTypeText ddtext 
@AbapCatalog.sqlViewName: 'ISKFWHEREUSDAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Old and New Allocation Types'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {
  sizeCategory: #S,
  serviceQuality: #C,
  dataClass: #META
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@UI.textArrangement: #TEXT_LAST
define view I_StatKeyFigWhereUsedAllocType as select from dd07t
//association [0..1] to I_Language    as _Language      on $projection.Language = _Language.Language

{
  key domvalue_l                                       as AllocationPostingType,
  key 'O'                                              as AllocationPostingTypeContext,
      ddlanguage                                       as Language,
      ddtext                                           as AllocationPostingTypeText
}
where
        domname      = 'ALART'
    and ddlanguage   = $session.system_language
    
union select from dd07t
//association [0..1] to I_Language    as _Language      on $projection.Language = _Language.Language

{
  key domvalue_l                                       as AllocationPostingType,
  key 'N'                                              as AllocationPostingTypeContext,
      ddlanguage                                       as Language,
      ddtext                                           as AllocationPostingTypeText
}
where
        domname      = 'STATKEYFIGWHEREUSEDALLOCTYPE'
    and ddlanguage   = $session.system_language

Learn More