PPH_DDL_STOCK_KF_2

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 PPH_DDL_STOCK_KF_2.
-- 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.
-- SQL view name: V_PPH_STOCK_KF_2

CREATE VIEW PPH_DDL_STOCK_KF_2 AS
SELECT
  stck.matnr AS matnr,
  stck.werks AS werks,
  stck.berid AS berid,
  stck.sobkz AS sobkz,
  stck.lifnr AS lifnr,
  stck.kunnr AS kunnr,
  stck.kdauf AS kdauf,
  stck.kdpos AS kdpos,
  stck.pspnr AS pspnr,
  stck.plaab AS plaab,
  stck.planr AS planr,
  stck.delkz AS delkz,
  stck.charg AS charg,
  stck.sgt_scat AS sgt_scat,
  stck.lgort AS lgort,
  stck.MrpAreaCategory AS MrpAreaCategory,
  stck.klabs AS klabs,
  stck.insme AS insme,
  stck.kinsm AS kinsm,
  case when MrpAreaCategory <> '03' then stck.umlme else 0 end AS umlme,
  case when t399d.xfan1 = 'X' then stck.speme else 0 end AS speme,
  case when t399d.xfan1 = 'X' then stck.kspem else 0 end AS kspme,
  case when t399d.nfvbc = 'X' then stck.einme else 0 end AS einme,
  case when t399d.nfvbc = 'X' then stck.keinm else 0 end AS keinm,
  sains,
  case when xfan1 = 'X' then saspe else 0 end AS saspe,
  case when nfvbc = 'X' then saein else 0 end AS saein,
  sqins,
  case when xfan1 = 'X' then sqspe else 0 end AS sqspe,
  case when nfvbc = 'X' then sqein else 0 end AS sqein,
  slins,
  sluml,
  case when MrpAreaCategory = '01' then ssins else 0 end AS ssins,
  always include case when MrpAreaCategory = '01' and t399d.xfan1 = 'X' then ssspe else 0 end as ssspe AS xfan1Xthenssspeelse0endasssspe,
  case when MrpAreaCategory = '01' and t399d.kzumb = 'X' then sstra else 0 end AS sstra,
  case when MrpAreaCategory = '01' and t399d.nfvbc = 'X' then ssein else 0 end AS ssein,
  case when MrpAreaCategory = '01' then csins else 0 end AS csins,
  not EWM/DECSY case when MrpAreaCategory = '01' and t399d.nfvbc = 'X' then csein else 0 end as csein AS nfvbcXthencseinelse0endascsein,
  case when MrpAreaCategory = '01' then fsins else 0 end AS fsins,
  not EWM/DECSY case when MrpAreaCategory = '01' and t399d.nfvbc = 'X' then fsein else 0 end as fsein AS nfvbcXthenfseinelse0endasfsein,
  case when MrpAreaCategory = '01' then rsins else 0 end AS rsins,
  not EWM/DECSY case when MrpAreaCategory = '01' and t399d.nfvbc = 'X' then rsein else 0 end as rsein AS nfvbcXthenrseinelse0endasrsein,
  stck.isins AS isins,
  always include case when t399d.nfvbc = 'X' then isein else 0 end as isein AS nfvbcXtheniseinelse0endasisein
FROM pph_ddl_stock_kf_1 AS stck
LEFT OUTER JOIN mard ON /* join condition not captured in parsed metadata */
INNER JOIN MDCV_E_T399D AS t399d ON /* join condition not captured in parsed metadata */
;