P_ACCRUALOBJECTPERIOD_ADMIN

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_ACCRUALOBJECTPERIOD_ADMIN.
-- 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: PPERADMIN

CREATE VIEW P_ACCRUALOBJECTPERIOD_ADMIN AS
SELECT
  _period.comp AS comp,
  _period.logsys AS logsys,
  _period.bukrs AS bukrs,
  _period.ref_key AS ref_key,
  _period.ref_subkey AS ref_subkey,
  _period.itemtype AS itemtype,
  _period.rldnr AS rldnr,
  _period.adjusted_by AS adjusted_by,
  _period.adjusted_on AS adjusted_on,
  _period.adjusted_at AS adjusted_at,
  cast(case review_status when 'X' then 'X' else ' ' end as ace_ds_xcamnt_reviewed preserving type) AS xreviewed,
  _period.review_type AS review_type,
  _period.reviewed_by AS reviewed_by,
  _period.reviewed_on AS reviewed_on,
  _period.reviewed_at AS reviewed_at,
  cast(case approval_status when 'X' then 'X' else ' ' end as ace_ds_xcamnt_approved preserving type) AS xapproved,
  _period.approved_by AS approved_by,
  _period.approved_on AS approved_on,
  _period.approved_at AS approved_at
FROM acesobj_item_per AS _period
INNER JOIN tace_itemtypec AS _itemtypec ON /* join condition not captured in parsed metadata */
;