C_BalanceConfirmationEmailTmpl

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 C_BalanceConfirmationEmailTmpl.
-- 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: CBLNCCNFRMEMAILT

CREATE VIEW C_BalanceConfirmationEmailTmpl AS
SELECT
  OutputRequestItemUUID,
  Recipient AS Account,
  SenderOrganizationalCenter AS CompanyCode,
  cast (RecipientRole as fis_koart) AS FinancialAccountType,
  OutputControlApplicationObject AS BalanceConfirmationID,
  _EmlTmpl.Name AS Name,
  _EmlTmpl.FullName AS FullName,
  _EmlTmpl.CompanyCodeName AS CompanyCodeName,
  _EmlTmpl.ReferenceAccountGroup AS ReferenceAccountGroup,
  _BalanceConfirmation.KeyDate AS KeyDate,
  _BalanceConfirmation.IssueDate AS IssueDate,
  _BalanceConfirmation.ReplyUntilDate AS ReplyUntilDate
FROM I_OutputRequestItem AS _ORItem
INNER JOIN I_EmlTmplCustSuplrCompanyCode AS _EmlTmpl ON /* join condition not captured in parsed metadata */
INNER JOIN R_BalanceConfirmationEmailTmpl AS _BalanceConfirmation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EmlTmplCustSuplrCompanyCode AS _EmailTmpl ON Account = _EmailTmpl.Account AND CompanyCode = _EmailTmpl.CompanyCode AND FinancialAccountType = _EmailTmpl.FinancialAccountType  -- association [0..1]
;