P_ACCGO_STOR_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_STOR_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_ACCGO_STOR_DTL

CREATE VIEW P_ACCGO_STOR_DTLS AS
SELECT
  appl_item.appldoc AS appldoc,
  appl_item.item AS item,
  appl_item.side AS side,
  appl_item.sub_item AS sub_item,
  'ZA' AS appldoc_type,
  appl_item.strg_agreement AS contract,
  appl_item.strg_agreement_item AS contract_itm,
  '' AS appl_status,
  appl_item.uis_id AS uis_evnt_id,
  appl_item.pred_doc2 AS OB_delivery,
  appl_item.pred_doc_type3 AS order_type,
  appl_item.pred_doc3 AS order_no,
  appl_item.pred_item3 AS order_itm,
  appl_item.pred_side3 AS order_side,
  appl_item.item_qty AS item_qty,
  appl_item.item_uom AS item_uom,
  appl_item.adjusted_qty AS adjusted_qty,
  appl_item.adjusted_uom AS adjusted_uom,
  appl_item.matnr AS material,
  appl_item.created_by AS created_by,
  appl_item.created_on AS created_on,
  appl_item.changed_by AS changed_by,
  appl_item.changed_on AS changed_on,
  appl_item.werks AS plant,
  contract_dtls.company_code AS company_code,
  contract_dtls. sales_org AS sales_org,
  contract_dtls.purch_org AS purch_org,
  contract_dtls.dist_chnl AS dist_chnl,
  contract_dtls.division AS division,
  contract_dtls.purch_grp AS purch_grp,
  appl_item.lifnr AS supplier,
  appl_item.nomtk AS nomtk,
  appl_item.nomnr AS nomnr,
  appl_item.nomit AS nomit,
  appl_item.qrep_guid AS qrep_guid,
  appl_item.qrep_version AS qrep_version,
  assgmt_data.a_guid AS assgmt_guid,
  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.settl_side AS settl_side,
  stlmt_data.doc_typ AS doc_typ,
  stlmt_data.settl_item AS settl_item,
  stlmt_data.adj_uom AS adj_uom,
  stlmt_data.unit_uom AS unit_uom,
  stlmt_data.contract_qty AS contract_qty,
  stlmt_data.contract_uom AS contract_uom,
  stlmt_data.document_qty AS document_qty,
  stlmt_data.document_uom AS document_uom
FROM p_cont_data AS contract_dtls
INNER JOIN p_accgo_app_stor AS appl_item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p_prasp_distr AS assgmt_data ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_cas_cab AS appl_bus ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_cas_cah AS appl_hdr ON /* join condition not captured in parsed metadata */
INNER JOIN jest AS status ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_cmn_stm AS stl_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p_stor_stl_dtls AS stlmt_data ON /* join condition not captured in parsed metadata */
;