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 StockAccount2KeyFigure.
-- 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 StockAccount2KeyFigure AS
SELECT
matbf AS matnr,
werks,
lgort_sid AS lgort,
charg_sid AS charg,
lifnr_sid AS lifnr,
mat_kdauf,
mat_kdpos,
mat_pspnr,
kunnr_sid AS kunnr,
disub_owner_sid AS disub_owner,
sobkz,
meins,
sum(case when lbbsa_sid = '06' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS trame,
sum(case when lbbsa_sid = '05' and sobkz = '' and stock_ind_l2 = '' then stock_vkwrt_l2 else 0 end) AS vkumc,
sum(case when lbbsa_sid = '06' and sobkz = '' and stock_ind_l2 = '' then stock_vkwrt_l2 else 0 end) AS vktrw,
sum(case when lbbsa_sid = '09' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS glgmg,
sum(case when lbbsa_sid = '09' and sobkz = '' and stock_ind_l2 = '' then stock_vkwrt_l2 else 0 end) AS vkglg,
sum(case when lbbsa_sid = '10' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS bwesb,
sum(case when lbbsa_sid = '02' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS insme,
sum(case when lbbsa_sid = '03' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS retme,
sum(case when lbbsa_sid = '04' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS umlme,
sum(case when lbbsa_sid = '07' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS speme,
sum(case when lbbsa_sid = '08' and sobkz = '' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS einme,
sum(case when lbbsa_sid = '01' and sobkz = 'K' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS klabs,
sum(case when lbbsa_sid = '02' and sobkz = 'K' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS kinsm,
sum(case when lbbsa_sid = '07' and sobkz = 'K' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS kspem,
sum(case when lbbsa_sid = '08' and sobkz = 'K' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS keinm,
sum(case when lbbsa_sid = '01' and sobkz = '' and stock_ind_l2 = '' then stock_vkwrt_l2 else 0 end) AS vklab,
sum(case when lbbsa_sid = '04' and sobkz = '' and stock_ind_l2 = '' then stock_vkwrt_l2 else 0 end) AS vkuml,
sum(case when lbbsa_sid = '04' and sobkz = '' and charg_sid <> '' then stock_qty_l1 else 0 end) AS cumlm,
sum(case when lbbsa_sid = '02' and sobkz = '' and charg_sid <> '' then stock_qty_l1 else 0 end) AS cinsm,
sum(case when lbbsa_sid = '08' and sobkz = '' and charg_sid <> '' then stock_qty_l1 else 0 end) AS ceinm,
sum(case when lbbsa_sid = '07' and sobkz = '' and charg_sid <> '' then stock_qty_l1 else 0 end) AS cspem,
sum(case when lbbsa_sid = '03' and sobkz = '' and charg_sid <> '' then stock_qty_l1 else 0 end) AS cretm,
sum(case when lbbsa_sid = '02' and sobkz = 'B' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS sdins,
sum(case when lbbsa_sid = '08' and sobkz = 'B' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS sdein,
sum(case when lbbsa_sid = '07' and sobkz = 'B' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS sdspe,
sum(case when lbbsa_sid = '02' and sobkz = 'B' and stock_ind_l2 = '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS ssins,
sum(case when lbbsa_sid = '08' and sobkz = 'B' and stock_ind_l2 = '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS ssein,
sum(case when lbbsa_sid = '07' and sobkz = 'B' and stock_ind_l2 = '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS ssspe,
sum(case when lbbsa_sid = '05' and sobkz = 'B' and stock_ind_l2 = '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS sstra,
sum(case when lbbsa_sid = '02' and (sobkz = 'K' or sobkz = 'M') and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS sinsm,
sum(case when lbbsa_sid = '08' and (sobkz = 'K' or sobkz = 'M') and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS seinm,
sum(case when lbbsa_sid = '07' and (sobkz = 'K' or sobkz = 'M') and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS sspem,
sum(case when lbbsa_sid = '02' and sobkz = 'C' and lifnr_sid <> '' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS cdins,
sum(case when lbbsa_sid = '08' and sobkz = 'C' and lifnr_sid <> '' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS cdein,
sum(case when lbbsa_sid = '02' and sobkz = 'C' and stock_ind_l2 = '' and lifnr_sid <> '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS csins,
sum(case when lbbsa_sid = '08' and sobkz = 'C' and stock_ind_l2 = '' and lifnr_sid <> '' and kunnr_sid <> '' then stock_qty_l2 else 0 end) AS csein,
sum(case when lbbsa_sid = '02' and sobkz = 'F' and lifnr_sid <> '' and mat_kdauf <> '' and mat_kdpos <> '000000' then stock_qty_l1 else 0 end) AS fdins,
sum(case when lbbsa_sid = '08' and sobkz = 'F' and lifnr_sid <> '' and mat_kdauf <> '' and mat_kdpos <> '000000' then stock_qty_l1 else 0 end) AS fdein,
sum(case when lbbsa_sid = '02' and sobkz = 'F' and stock_ind_l2 = '' and lifnr_sid <> '' and mat_kdauf <> '' and mat_kdpos <> '000000' then stock_qty_l2 else 0 end) AS fsins,
sum(case when lbbsa_sid = '08' and sobkz = 'F' and stock_ind_l2 = '' and lifnr_sid <> '' and mat_kdauf <> '' and mat_kdpos <> '000000' then stock_qty_l2 else 0 end) AS fsein,
sum(case when lbbsa_sid = '02' and (sobkz = 'I' or sobkz = 'J') and lifnr_sid <> '' and disub_owner_sid <> '' then stock_qty_l1 else 0 end) AS idins,
sum(case when lbbsa_sid = '08' and (sobkz = 'I' or sobkz = 'J') and lifnr_sid <> '' and disub_owner_sid <> '' then stock_qty_l1 else 0 end) AS idein,
sum(case when lbbsa_sid = '02' and (sobkz = 'I' or sobkz = 'J') and stock_ind_l2 = '' and lifnr_sid <> '' and disub_owner_sid <> '' then stock_qty_l2 else 0 end) AS isins,
sum(case when lbbsa_sid = '08' and (sobkz = 'I' or sobkz = 'J') and stock_ind_l2 = '' and lifnr_sid <> '' and disub_owner_sid <> '' then stock_qty_l2 else 0 end) AS isein,
sum(case when lbbsa_sid = '02' and sobkz = 'E' and mat_kdauf <> '' then stock_qty_l1 else 0 end) AS kains,
sum(case when lbbsa_sid = '07' and (sobkz = 'E' or sobkz = 'T') and mat_kdauf <> '' then stock_qty_l1 else 0 end) AS kaspe,
sum(case when lbbsa_sid = '08' and sobkz = 'E' and mat_kdauf <> '' then stock_qty_l1 else 0 end) AS kaein,
sum(case when lbbsa_sid = '02' and (sobkz = 'W' or sobkz = 'V') and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS kuins,
sum(case when lbbsa_sid = '08' and (sobkz = 'W' or sobkz = 'V') and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS kuein,
sum(case when lbbsa_sid = '05' and sobkz = 'V' and kunnr_sid <> '' then stock_qty_l1 else 0 end) AS kuuml,
sum(case when lbbsa_sid = '02' and sobkz = 'O' and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS lbins,
sum(case when lbbsa_sid = '08' and sobkz = 'O' and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS lbein,
sum(case when lbbsa_sid = '05' and sobkz = 'O' and lifnr_sid <> '' then stock_qty_l1 else 0 end) AS lbuml,
sum(case when lbbsa_sid = '02' and sobkz = 'Q' then stock_qty_l1 else 0 end) AS prins,
sum(case when lbbsa_sid = '07' and sobkz = 'Q' then stock_qty_l1 else 0 end) AS prspe,
sum(case when lbbsa_sid = '08' and sobkz = 'Q' then stock_qty_l1 else 0 end) AS prein,
sum(case when lbbsa_sid = '02' and sobkz = 'R' and lifnr_sid <> '' and mat_pspnr <> '00000000' then stock_qty_l1 else 0 end) AS rdins,
sum(case when lbbsa_sid = '08' and sobkz = 'R' and lifnr_sid <> '' and mat_pspnr <> '00000000' then stock_qty_l1 else 0 end) AS rdein,
sum(case when lbbsa_sid = '02' and sobkz = 'R' and stock_ind_l2 = '' and lifnr_sid <> '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS rsins,
sum(case when lbbsa_sid = '08' and sobkz = 'R' and stock_ind_l2 = '' and lifnr_sid <> '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS rsein,
sum(case when lbbsa_sid = '02' and sobkz = 'E' and stock_ind_l2 = '' and mat_kdauf <> '' then stock_qty_l2 else 0 end) AS sains,
sum(case when lbbsa_sid = '07' and ((sobkz = 'E' and mat_kdauf <> '') or sobkz = 'T') and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS saspe,
sum(case when lbbsa_sid = '08' and sobkz = 'E' and stock_ind_l2 = '' and mat_kdauf <> '' then stock_qty_l2 else 0 end) AS saein,
sum(case when lbbsa_sid = '06' and sobkz = 'E' and stock_ind_l2 = '' and mat_kdauf <> '' then stock_qty_l2 else 0 end) AS satra,
sum(case when lbbsa_sid = '10' and sobkz = 'E' and stock_ind_l2 = '' and mat_kdauf <> '' then stock_qty_l2 else 0 end) AS sabwe,
sum(case when lbbsa_sid = '02' and sobkz = 'O' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS slins,
sum(case when lbbsa_sid = '08' and sobkz = 'O' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS slein,
sum(case when lbbsa_sid = '05' and sobkz = 'O' and stock_ind_l2 = '' then stock_qty_l2 else 0 end) AS sluml,
sum(case when lbbsa_sid = '02' and sobkz = 'Q' and stock_ind_l2 = '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS sqins,
sum(case when lbbsa_sid = '07' and sobkz = 'Q' and stock_ind_l2 = '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS sqspe,
sum(case when lbbsa_sid = '08' and sobkz = 'Q' and stock_ind_l2 = '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS sqein,
sum(case when lbbsa_sid = '06' and sobkz = 'Q' and stock_ind_l2 = '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS sqtra,
sum(case when lbbsa_sid = '10' and sobkz = 'Q' and stock_ind_l2 = '' and mat_pspnr <> '00000000' then stock_qty_l2 else 0 end) AS sqbwe
FROM StockAccount2KeyFigureSum
;