P_ACCGO_APPDOC_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_APPDOC_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_APPLDOC_DATA

CREATE VIEW P_ACCGO_APPDOC_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,
  appldata.refdoc_type AS appldoc_type,
  appldata.contract_num AS contract,
  appldata.contract_item AS contract_itm,
  appldata.appl_status AS appl_status,
  appl_hdr.ref_app_doc AS REF_APP_DOC,
  appl_hdr.ref_app_doc_typ AS REF_APP_DOC_TYP,
  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.appl_uom AS appl_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.doc_curr AS doc_curr,
  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,
  ppmg_data.PrepaymentAgrmtRefDocument AS PrepaymentAgrmtRefDocument,
  ppmg_data.PrepaymentAgrmtRefDocItem AS PrepaymentAgrmtRefDocItem
FROM /accgo/t_appdata AS appldata
INNER JOIN p_cont_data AS contract_dtls ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_cas_cai 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_stl_doc_dtls AS stlmt_data ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_AssignedDocument AS ppmg_data ON /* join condition not captured in parsed metadata */
;