StockAccount2KeyFigureSum

DDL: STOCKACCOUNT2KEYFIGURESUM Type: view Package: MBND_RESTRICTED

Convert Stock in account model to key figure - SUM

StockAccount2KeyFigureSum is a CDS View that provides data about "Convert Stock in account model to key figure - SUM" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 15 fields with key fields matbf, werks, lgort_sid, charg_sid, lifnr_sid. Part of development package MBND_RESTRICTED.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (8)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName STKACCT2KFSUM view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY matbf matbf
KEY werks werks
KEY lgort_sid lgort_sid
KEY charg_sid charg_sid
KEY lifnr_sid lifnr_sid
KEY mat_kdauf mat_kdauf
KEY mat_kdpos mat_kdpos
KEY mat_pspnr mat_pspnr
KEY kunnr_sid kunnr_sid
sobkz sobkz
lbbsa_sid lbbsa_sid
meins meins
stock_ind_l2 stock_ind_l2
stock_qty_l1
stock_qty_l2 
@AbapCatalog.preserveKey: true
@AbapCatalog:
              {
                sqlViewName: 'STKACCT2KFSUM',
                compiler.compareFilter: true
              }
@ObjectModel:
              { 
                usageType:
                          {
                            sizeCategory: #XXL,
                            serviceQuality: #D,
                            dataClass:#TRANSACTIONAL
                          }
              }
@ClientHandling.algorithm: #AUTOMATED
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view StockAccount2KeyFigureSum
as select from matdoc_extract
{
  key matbf,
  key werks,
  key lgort_sid,
  key charg_sid,
  key lifnr_sid,
  key mat_kdauf,
  key mat_kdpos,
  key mat_pspnr,
  key kunnr_sid,
  key disub_owner_sid,
  sobkz,
  lbbsa_sid,
  meins,
  stock_ind_l2,
  sum(stock_qty_l1)        as stock_qty_l1,
  sum(stock_vkwrt_l1)      as stock_vkwrt_l1,
  sum(stock_qty_l2)        as stock_qty_l2,
  sum(stock_vkwrt_l2)      as stock_vkwrt_l2
}
where meins <> ''
group by
  matbf,
  werks,
  lgort_sid,
  charg_sid,
  lifnr_sid,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  kunnr_sid,
  disub_owner_sid,
  sobkz,
  lbbsa_sid,
  meins,
  stock_ind_l2

Learn More