I_IntercompanyEmailTmpl

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 I_IntercompanyEmailTmpl.
-- 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: ICAICOETMPL

CREATE VIEW I_IntercompanyEmailTmpl AS
SELECT
  docm.method_id AS MatchingMethodID,
  docm.docnr AS MatchingDocument,
  docm.docln AS MatchingDocumentItem,
  docm.rcomp AS Company,
  docm.rassc AS TradingPartner,
  docm.grref AS MatchingAssignmentNumber,
  mtxt.descm AS MatchingMethodDesc,
  docm.rule_id AS MatchingRuleID,
  rtxt.descm AS MatchingRuleDesc,
  assign.rcode AS MatchingReasonCode,
  rctxt.descm AS MatchingReasonCodeDesc,
  cast( coalesce( genj_ffd.fiscal_year_period, cons_ffd.fiscal_year_period ) as fins_fyearperiod preserving type ) AS FiscalYearPeriod,
  rc.recon_case_id AS ReconciliationCaseID,
  rct.descm AS ReconciliationCaseDesc,
  user.bname AS LoggedInUser,
  adress.name_text AS UserDescription
FROM icadocm AS docm
LEFT OUTER JOIN I_Globalcompany AS _Company ON docm.rcomp = _Company.Company  -- association [1]
LEFT OUTER JOIN I_Globalcompany AS _PartnerCompany ON docm.rassc = _PartnerCompany.Company  -- association [1]
;