P_MCAdocref

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_MCAdocref.
-- 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: PGLEMCADOC

CREATE VIEW P_MCAdocref AS
SELECT
  Rldnr,
  cast( bukrs as fis_bukrs preserving type ) AS bukrs,
  cast( belnr as farp_belnr_d preserving type ) AS belnr,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS gjahr,
  Buzei,
  mca_docno AS McaDocno,
  mca_gjahr AS McaGjahr,
  doc_category AS DocCategory,
  Runid,
  Prccat,
  Budat,
  Reversed,
  fipp_created AS FippCreated,
  fipp_rejected AS FippRejected,
  pp_objno AS PpObjno,
  wf_status AS WfStatus,
  wf_rel_proc AS WfRelProc,
  archive_status AS ArchiveStatus,
  archive_flud AS ArchiveFlud,
  Rejection
FROM gle_mca_docref
;