P_ACCGO_PRASP_DTLS

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_ACCGO_PRASP_DTLS.
-- 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_PRASP_DISTR

CREATE VIEW P_ACCGO_PRASP_DTLS AS
SELECT
  assgmt_data.type_from AS type_from,
  assgmt_data.item_from AS item_from,
  assgmt_data.side_from AS side_from,
  assgmt_data.tkonn AS tkonn,
  assgmt_data.tposn AS tposn,
  assgmt_data.side_to AS side_to,
  assgmt_data.tposn_com AS tposn_com,
  assgmt_data.assgd_quan AS assgd_quan,
  assgmt_data.assgd_uom AS assgd_uom,
  assgmt_data.a_guid AS a_guid,
  assgmt_data.pred_a_guid AS pred_a_guid,
  assgmt_data.pred_quan AS pred_quan,
  assgmt_data.frozen AS frozen,
  assgmt_data.cr_name AS cr_name,
  assgmt_data.cr_date AS cr_date,
  assgmt_data.cr_time AS cr_time,
  assgmt_data.ch_name AS ch_name,
  assgmt_data.ch_date AS ch_date,
  assgmt_data.ch_time AS ch_time,
  assgmt_data.cancel_flag AS cancel_flag,
  assgmt_data._dataaging AS _dataaging,
  assgmt_data.place_holder AS place_holder
FROM wb2_d_assgmt AS assgmt_data
LEFT OUTER JOIN wb2_d_asgt_dist AS asgmt_distr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /accgo/t_cpe_bri AS price_dist ON /* join condition not captured in parsed metadata */
;