ACE_ACEDSASSGMTC

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 ACE_ACEDSASSGMTC.
-- 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: ACEV_DSASSGMTC

CREATE VIEW ACE_ACEDSASSGMTC AS
SELECT
  acesobj_assgmt.comp AS comp,
  acesobj_assgmt.bukrs AS bukrs,
  acesobj.objid AS objid,
  acesobj.subid AS subid,
  acesobj_assgmt.date_to AS date_to,
  acesobj_assgmt.date_from AS date_from,
  acesobj_assgmt.gsber AS bus_area,
  acesobj_assgmt.prctr AS profit_ctr,
  acesobj_assgmt.segment AS segment,
  acesobj_assgmt.geber AS fund,
  acesobj_assgmt.fistl AS funds_ctr,
  acesobj_assgmt.fipos AS cmmt_item,
  acesobj_assgmt.grant_nbr AS grant_nbr,
  acesobj_assgmt.measure AS measure,
  acesobj_assgmt.kostl AS costcenter,
  acesobj_assgmt.aufnr AS orderid,
  acesobj_assgmt.kstrg AS costobject,
  acesobj_assgmt.lstar AS acttype,
  acesobj_assgmt.nplnr AS network,
  acesobj_assgmt.aufpl AS routing_no,
  acesobj_assgmt.prznr AS co_busproc,
  acesobj_assgmt.kdauf AS sales_ord,
  acesobj_assgmt.kdpos AS s_ord_item
FROM acesobj_assgmt
INNER JOIN acesobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps ON /* join condition not captured in parsed metadata */
;