FINOC_CHECK_REC_01_PRCTRS

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 FINOC_CHECK_REC_01_PRCTRS.
-- 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.

CREATE VIEW FINOC_CHECK_REC_01_PRCTRS AS
SELECT
  rec.intreno AS intreno,
  rec.recnnr AS recnnr,
  rec.bukrs AS bukrs,
  moa.termtype AS moa_termtype,
  moa.termno AS moa_termno,
  moa.validto AS moa_validto,
  val.termno AS val_termno,
  val.validto AS val_valid_to,
  moa.prctr AS moa_prctr,
  case when ( moa.prctr is not initial and moa.prctr is not null ) then 'X' else ' ' end as by_moa AS prctrisnotnullthenXelseendasby_moa,
  case when ( ccr1.prctr is not initial and ccr1.prctr is not null ) or ( wbs1.prctr is not initial and wbs1.prctr is not null ) or ( ord1.prctr is not initial and ord1.prctr is not null ) then 'X' else ' ' end as by_val AS prctrisnotnullthenXelseendasby_val,
  case when ( ccr2.prctr is not initial and ccr2.prctr is not null ) or ( wbs2.prctr is not initial and wbs2.prctr is not null ) or ( ord2.prctr is not initial and ord2.prctr is not null ) then 'X' else ' ' end as by_subj AS prctrisnotnullthenXelseendasby_subj
FROM vicncn AS rec
LEFT OUTER JOIN vitmoa AS moa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vicerule AS val ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN csks AS ccr1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS wbs1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS ord1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vibdcnsubject AS sbj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN csks AS ccr2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS wbs2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aufk AS ord2 ON /* join condition not captured in parsed metadata */
;