SBN_DRF_PI_DETAILS

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 SBN_DRF_PI_DETAILS.
-- 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: SBN_PI_DETAIL

CREATE VIEW SBN_DRF_PI_DETAILS AS
SELECT
  p.packnr AS id,
  o.packitem AS packitem,
  p.packnr AS packnr,
  p.hdcount AS hdcount,
  p.pobjid AS pobjid,
  p.chtim AS chtim,
  o.paitemtype AS paitemtype,
  o.matnr AS matnr,
  t.maktx AS maktx,
  o.trgqty AS trgqty,
  o.minqty AS minqty,
  o.rndqty AS rndqty,
  o.unitqty AS unitqty,
  o.matmixawd AS matmixawd,
  o.indnohu AS indnohu,
  '' AS is_aux,
  m.vhart AS vhart,
  m.laeng AS laeng,
  m.breit AS breit,
  m.hoehe AS hoehe,
  m.volum AS volum,
  m.ntgew AS ntgew,
  m.brgew AS brgew,
  m.meabm AS meabm,
  m.voleh AS voleh,
  m.gewei AS gewei,
  o.subpacknr AS subpacknr
FROM packkp AS p
INNER JOIN packpo AS o ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mara AS m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN packkp AS sp ON /* join condition not captured in parsed metadata */
;