ESH_N_EFD_DOC

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

CREATE VIEW ESH_N_EFD_DOC AS
SELECT
  EARMARKEDFUNDSDOCUMENT AS EARMARKEDFUNDSDOCUMENT1,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  DOCUMENTDATE,
  _EARMARKEDFUNDSDOCCATEGORY[1: ddlanguage = $parameters. P_Language].ddtext AS EARMARKEDFUNDSDOCCATEGORYTEXT,
  EARMARKEDFUNDSDOCENTRYSTATUS,
  EARMARKEDFUNDSDOCREFERENCE,
  EARMARKEDFUNDSDOCREFERENCE2,
  EARMARKEDFUNDSDOCREFERENCE3,
  _EARMARKEDFUNDSDOCTYPETEXT[1: LANGUAGE = $parameters. P_Language].EARMARKEDFUNDSDOCTYPETEXT AS EARMARKEDFUNDSDOCTYPETEXT,
  EARMARKEDFUNDSDOCUMENT,
  EARMARKEDFUNDSDOCUMENTCATEGORY,
  EARMARKEDFUNDSDOCUMENTTYPE,
  EARMARKEDFUNDSHEADERTEXT,
  EARMARKEDFUNDSISAPPROVED,
  EARMARKEDFUNDSISCOMPLETED,
  EMRKDFNDSDOCCREATEDBYUSER,
  EMRKDFNDSDOCCREATIONDATE,
  EMRKDFNDSDOCLASTCHANGEDATE,
  EMRKDFNDSDOCLASTCHANGEDBYUSER,
  _CONTROLLINGAREA.FINANCIALMANAGEMENTAREA AS FINANCIALMANAGEMENTAREA,
  _EMRKDFNDSDOCLASTCHANGEDBYUSER.USERDESCRIPTION AS CHANGEDBYUSERNAME,
  _EMRKDFNDSDOCCREATEDBYUSER.USERDESCRIPTION AS CREATEDBYUSERNAME
FROM I_EARMARKEDFUNDSDOCUMENT
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..*]
;