ACE_ACEPSOIT_BASIC

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_ACEPSOIT_BASIC.
-- 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_ACEPSOITBSC

CREATE VIEW ACE_ACEPSOIT_BASIC AS
SELECT
  acepsoit.mandt AS mandt,
  acepsoit.comp AS comp,
  acepsoit.bukrs AS bukrs,
  gjahr,
  acepsoit.objid AS objid,
  acepsoit.subid AS subid,
  acrtype,
  accrule,
  docnr,
  valcum,
  valtbp,
  currency,
  transtype,
  effdate,
  podate,
  poper,
  poyear,
  runid,
  awkey,
  awsys,
  acepsoit.timestmp AS timestmp,
  reversal_doc,
  reversed_doc,
  cast( substring( awkey, 1, 10) as awref ) AS awref,
  cast( substring( awkey, 11, 8) as aworg ) AS aworg,
  acesobj.ref_key AS ref_key,
  acesobj.ref_subkey AS ref_subkey,
  acac_objects.acac_objtype AS acac_objtype
FROM acepsoit
LEFT OUTER JOIN acesobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acedsoh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tacecomp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acac_objects ON /* join condition not captured in parsed metadata */
;