ACE_ACDOCA_MIG_ACRTYPE_RULE

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_ACDOCA_MIG_ACRTYPE_RULE.
-- 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_TYPE_RULE

CREATE VIEW ACE_ACDOCA_MIG_ACRTYPE_RULE AS
SELECT
  acdoca.acrobjtype AS acrobjtype,
  acdoca.gjahr AS gjahr,
  acdoca.rbukrs AS rbukrs,
  acesobj.objid AS objid,
  acesobj.subid AS subid,
  tace_itemtypel.acrtype AS acrtype,
  tace_combination.accrule AS accrule,
  acdoca.rldnr AS rldnr,
  acdoca.acritmtype AS acritmtype,
  acdoca.acrobj_id AS acrobj_id,
  acdoca.acrsobj_id AS acrsobj_id,
  acdoca.pre_gjahr AS pre_gjahr,
  acdoca.slalittype AS slalittype,
  acdoca.valtbp AS valtbp,
  acdoca.currency AS currency,
  acdoca.transtype AS transtype,
  acdoca.effdate AS effdate,
  acdoca.podate AS podate,
  acdoca.poper AS poper,
  acdoca.poyear AS poyear,
  acdoca.awtyp AS awtyp,
  acdoca.awkey AS awkey,
  acdoca.awsys AS awsys,
  acdoca.timestamp AS timestamp,
  acdoca.mig_source AS mig_source
FROM ACE_ACDOCA_MIG_ACCR AS acdoca
LEFT OUTER JOIN acesobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ACE_ITEMTYPEL_DISTINCT AS tace_itemtypel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tace_combination ON /* join condition not captured in parsed metadata */
;