P_STOR_STL_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 P_STOR_STL_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: P_STOR_STL_DTLS

CREATE VIEW P_STOR_STL_DETAILS AS
SELECT
  stlmt_data.settl_doc AS settl_doc,
  stlmt_data.settl_yr AS settl_yr,
  stlmt_data.settl_cat AS settl_cat,
  stlmt_data.settl_type AS settl_type,
  stlmt_data.side AS settl_side,
  stlmt_data.appl_guid AS appl_guid,
  stlmt_data.appl_version AS appl_version,
  stlmt_data.doc_typ AS doc_typ,
  stlmt_data.side AS side,
  stlmt_data.appldoc AS appldoc,
  stlmt_data.appldoc_item AS appldoc_item,
  stl_item_data.settl_item AS settl_item,
  stl_item_data.adj_uom AS adj_uom,
  stl_item_data.doc_curr AS doc_curr,
  stl_item_data.unit_uom AS unit_uom,
  stl_item_data.contract_qty AS contract_qty,
  stl_item_data.contract_uom AS contract_uom,
  stl_item_data.document_qty AS document_qty,
  stl_item_data.document_uom AS document_uom
FROM /accgo/t_stlhead AS stlmt_data
INNER JOIN /accgo/t_stlitem AS stl_item_data ON /* join condition not captured in parsed metadata */
INNER JOIN jest AS stlmt_status ON /* join condition not captured in parsed metadata */
INNER JOIN tj04 AS stat_cntr ON /* join condition not captured in parsed metadata */
;