FAA_SDM_DOCIT_CP03

DDL: FAA_SDM_DOCIT_CP03 SQL: FAAVDOCITCP03 Type: view Package: FINS_FAA_POST_SDM

KFC DOC_IT aggregation

FAA_SDM_DOCIT_CP03 is a CDS View that provides data about "KFC DOC_IT aggregation" in SAP S/4HANA. It reads from 8 data sources and exposes 21 fields with key fields bukrs, gjahr, anlkl, SelectedCurrencyBranch, DisplayCurrency. Part of development package FINS_FAA_POST_SDM.

8 data source(s) 21 fields

Data Sources (8)

SourceAliasJoin Type
faat_doc_it doc_it from
faat_doc_it doc_it union
faat_doc_it doc_it union
faat_doc_it doc_it union
faac_kfc_spec kfc_spec left_outer
faac_kfc_spec kfc_spec left_outer
faac_kfc_spec kfc_spec left_outer
faac_kfc_spec kfc_spec left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAAVDOCITCP03 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label KFC DOC_IT aggregation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY bukrs faat_doc_it bukrs
KEY gjahr faat_doc_it gjahr
KEY anlkl faat_doc_it anlkl
KEY SelectedCurrencyBranch
KEY DisplayCurrency
bukrs
KEY gjahr faat_doc_it gjahr
KEY anlkl faat_doc_it anlkl
KEY SelectedCurrencyBranch
KEY DisplayCurrency
bukrs
KEY gjahr faat_doc_it gjahr
KEY anlkl faat_doc_it anlkl
KEY SelectedCurrencyBranch
KEY DisplayCurrency
bukrs
KEY gjahr faat_doc_it gjahr
KEY anlkl faat_doc_it anlkl
KEY SelectedCurrencyBranch
KEY DisplayCurrency
AmountInDisplayCurrency 
@AbapCatalog.sqlViewName: 'FAAVDOCITCP03'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'KFC DOC_IT aggregation'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL


define view FAA_SDM_DOCIT_CP03
  as select from    faat_doc_it   as doc_it
    left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = doc_it.movcat
                                              and kfc_spec.slalittype = doc_it.slalittype
{
  key doc_it.bukrs,
  key doc_it.gjahr,
  key doc_it.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( '10' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( doc_it.rhcur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( doc_it.hsl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
where
  doc_it.sdm_status = '19'
group by
  doc_it.bukrs,
  doc_it.gjahr,
  doc_it.anlkl,
  kfc_spec.key_figure_code,
  doc_it.rhcur

union select from faat_doc_it   as doc_it
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = doc_it.movcat
                                            and kfc_spec.slalittype = doc_it.slalittype
{
  key doc_it.bukrs,
  key doc_it.gjahr,
  key doc_it.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( '30' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( doc_it.rkcur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( doc_it.ksl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
where
  doc_it.sdm_status = '19'
group by
  doc_it.bukrs,
  doc_it.gjahr,
  doc_it.anlkl,
  kfc_spec.key_figure_code,
  doc_it.rkcur


union select from faat_doc_it   as doc_it
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = doc_it.movcat
                                            and kfc_spec.slalittype = doc_it.slalittype
{
  key doc_it.bukrs,
  key doc_it.gjahr,
  key doc_it.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( 'F1' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( doc_it.rocur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( doc_it.osl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
where
  doc_it.sdm_status = '19'
group by
  doc_it.bukrs,
  doc_it.gjahr,
  doc_it.anlkl,
  kfc_spec.key_figure_code,
  doc_it.rocur

union select from faat_doc_it   as doc_it
  left outer join faac_kfc_spec as kfc_spec on  kfc_spec.movcat     = doc_it.movcat
                                            and kfc_spec.slalittype = doc_it.slalittype
{
  key doc_it.bukrs,
  key doc_it.gjahr,
  key doc_it.anlkl,
  key case
        when kfc_spec.key_figure_code is null then 'NULL'
        else kfc_spec.key_figure_code
      end                                                   as key_figure_code,
  key cast( 'F2' as fis_selected_currency_branch )          as SelectedCurrencyBranch,
      @Semantics.currencyCode: true
  key cast( doc_it.rvcur as vdm_v_display_currency )        as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast( sum( doc_it.vsl ) as farp_amount_display_crcy ) as AmountInDisplayCurrency
}
where
  doc_it.sdm_status = '19'
group by
  doc_it.bukrs,
  doc_it.gjahr,
  doc_it.anlkl,
  kfc_spec.key_figure_code,
  doc_it.rvcur

Learn More