Fac_Bcf_Posting_Period

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 Fac_Bcf_Posting_Period.
-- 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: FACADV_P_PERIOD

CREATE VIEW Fac_Bcf_Posting_Period AS
SELECT
  f.bukrs AS bukrs,
  f.opvar AS opvar,
  f.rldnr AS rldnr,
  case when t.bukrs is null then '?' else t.bukrs end AS t_opvar,
  case when t.frye1 is null then '?' else t.frye1 end AS frye1,
  case when t.toye1 is null then '?' else t.toye1 end AS toye1,
  case when t.frye2 is null then '?' else t.frye2 end AS frye2,
  case when t.toye2 is null then '?' else t.toye2 end AS toye2,
  case when t.frye3 is null then '?' else t.frye3 end AS frye3,
  case when t.toye3 is null then '?' else t.toye3 end AS toye3
LEFT OUTER JOIN t001b AS t ON /* join condition not captured in parsed metadata */
;