FARR_POSTING

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 FARR_POSTING.
-- 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 FARR_POSTING AS
SELECT
  _posting.company_code AS company_code,
  _posting.recon_key AS recon_key,
  _posting.pob_id AS pob_id,
  post_cat,
  shkzg,
  _posting.guid AS guid,
  _posting.gjahr AS gjahr,
  _posting.poper AS poper,
  betrw,
  waers,
  betrh,
  hwaer,
  betr2,
  hwae2,
  betr3,
  hwae3,
  _posting.contract_id AS contract_id,
  hkont,
  statistic,
  shkzg_va,
  srcdoc_comp,
  srcdoc_type,
  srcdoc_id,
  valobjtype,
  valobj_id,
  fkber,
  gsber,
  segment,
  prctr,
  paobjnr,
  kostl,
  aufnr,
  kdauf,
  kdpos,
  _WBSElement.WBSElementExternalID AS ps_posid,
  ps_psp_pnr,
  _reconkey.status AS status,
  cast(' ' as awtyp preserving type) AS awtyp,
  cast(' ' as awsys preserving type) AS awsys,
  cast(' ' as aworg preserving type) AS aworg,
  cast(' ' as awref preserving type) AS awref,
  cast(' ' as fis_belnr preserving type) AS belnr,
  cast(' ' as fis_bstat preserving type) AS bstat,
  cast(' ' as fis_acdoc_mig_source preserving type) AS mig_source,
  ACCT_PRINCIPLE,
  CONDITION_TYPE,
  SPEC_INDICATOR,
  SRCDOC_LOGSYS,
  timestamp
FROM farr_d_posting AS _posting
LEFT OUTER JOIN farr_d_recon_key AS _reconkey ON _reconkey.company_code = _posting.company_code AND _reconkey.acct_principle = _posting.acct_principle AND _reconkey.contract_id = _posting.contract_id AND _reconkey.recon_key = _posting.recon_key  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON ps_psp_pnr = _WBSElement.WBSElementInternalID  -- association [0..1]
-- UNION ALL with additional select branch(es): FARR_JournalEntryItem
;