StockAccount2KeyFigureSum

DDL: STOCKACCOUNT2KEYFIGURESUM Type: view
15 Fields 1 Data Sources

StockAccount2KeyFigureSum is a CDS View 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.

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 Stock Mat.
KEY werks werks Receiving Plant
KEY lgort_sid lgort_sid Stor. Location SID
KEY charg_sid charg_sid Batch SID
KEY lifnr_sid lifnr_sid Supplier SID
KEY mat_kdauf mat_kdauf SD Doc of Inv.
KEY mat_kdpos mat_kdpos SD Item of Inv.
KEY mat_pspnr mat_pspnr WBSElem of Inv.
KEY kunnr_sid kunnr_sid Customer SID
sobkz sobkz Special Stock
lbbsa_sid lbbsa_sid Stock Type
meins meins Valuation Unit
stock_ind_l2 stock_ind_l2 CDS View Ind. L2
stock_qty_l1
stock_qty_l2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view StockAccount2KeyFigureSum.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW StockAccount2KeyFigureSum AS
SELECT
  matbf,
  werks,
  lgort_sid,
  charg_sid,
  lifnr_sid,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  kunnr_sid,
  sobkz,
  lbbsa_sid,
  meins,
  stock_ind_l2,
  sum(stock_qty_l1) AS stock_qty_l1,
  sum(stock_qty_l2) AS stock_qty_l2
FROM matdoc_extract
;

Learn More