ESH_N_EFD_FMAA

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 ESH_N_EFD_FMAA.
-- 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: ESH_L_EFD_FMAA
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_EFD_FMAA AS
SELECT
  EARMARKEDFUNDSDOCUMENT,
  EARMARKEDFUNDSDOCUMENTITEM,
  BUDGETPERIOD,
  _BUDGETPERIOD.BUDGETPERIODAUTHZNGRP AS BUDGETPERIODAUTHZNGRP,
  COMMITMENTITEM,
  _COMMITMENTITEM.COMMITMENTITEMAUTHZNGRP AS COMMITMENTITEMAUTHZNGRP,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CONTROLLINGAREA,
  DOCUMENTITEMTEXT,
  _EARMARKEDFUNDSDOCCATEGORY[1: ddlanguage = $parameters. P_Language].ddtext AS EARMARKEDFUNDSDOCCATEGORYTEXT,
  _EARMARKEDFUNDSDOCTYPETEXT[1: LANGUAGE = $parameters. P_Language].EARMARKEDFUNDSDOCTYPETEXT AS EARMARKEDFUNDSDOCTYPETEXT,
  EARMARKEDFUNDSDOCUMENTCATEGORY,
  EARMARKEDFUNDSDOCUMENTTYPE,
  EMRKDFNDSAMOUNTINTRANSCRCY,
  FINANCIALMANAGEMENTAREA,
  FUNCTIONALAREA,
  _FUNDSMGMTFUNCTIONALAREA.FUNCTIONALAREAAUTHZNGRP AS FUNCTIONALAREAAUTHZNGRP,
  FUND,
  _FUND.FUNDAUTHZNGRP AS FUNDAUTHZNGRP,
  FUNDEDPROGRAM,
  _FUNDEDPROGRAM.FUNDEDPROGRAMAUTHZNGRP AS FUNDEDPROGRAMAUTHZNGRP,
  FUNDSCENTER,
  _GRANT.GRANTAUTHZNGRP AS GRANTAUTHZNGRP,
  GRANTID,
  _GRANT.GRANTLIFECYCLESTATUS AS GRANTLIFECYCLESTATUS,
  TRANSACTIONCURRENCY
FROM N_EARMARKEDFUNDSDOCUMENTITM
LEFT OUTER JOIN dd07t AS _EARMARKEDFUNDSDOCCATEGORY ON EarmarkedFundsDocumentCategory=_EARMARKEDFUNDSDOCCATEGORY.domvalue_l AND _EARMARKEDFUNDSDOCCATEGORY.domname='KBLTYP' AND _EARMARKEDFUNDSDOCCATEGORY.as4local='A' AND _EARMARKEDFUNDSDOCCATEGORY.as4vers='0000'  -- association [0..*]
;