MB5B_BSEG_PROXY

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 MB5B_BSEG_PROXY.
-- 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 MB5B_BSEG_PROXY AS
SELECT
  it.rbukrs AS bukrs,
  it.bwkey AS bwkey,
  it.matnr AS matnr,
  it.bwtar AS bwtar,
  case when it.hsl < 0 then 'H' when it.hsl = 0 and it.vmsl > 0 then 'S' when it.hsl = 0 and it.vmsl < 0 then 'H' else 'S' end as shkzg AS vmsl0thenHelseSendasshkzg,
  it.rvunit AS meins,
  it.budat AS budat,
  it.blart AS blart,
  cast( right(it.docln, 3) as buzei) AS buzei,
  concat(it.awref, it.aworg) AS awkey,
  it.belnr AS belnr,
  it.gjahr AS gjahr,
  cast(abs(it.vmsl) as menge_d) AS menge,
  abs(it.hsl) AS dmbtr,
  it.awtyp AS awtyp,
  it.bldat AS bldat,
  it.rhcur AS waers,
  b.shkzg AS shkzg,
  b.squan AS squan,
  it.racct AS hkont
FROM P_Materialledger_Curtp_Lit AS it
INNER JOIN fmlv_logistic_currency AS f ON /* join condition not captured in parsed metadata */
INNER JOIN bseg AS b ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ACDOCA
;