I_BR_Ctenfrefannotations_C

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_BR_Ctenfrefannotations_C.
-- 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: IBRCTENFREFANNOC

CREATE VIEW I_BR_Ctenfrefannotations_C AS
SELECT
  ReferencedNotaFiscal.BR_CTe AS BR_CTe,
  ReferencedNotaFiscal.BR_CTeReferencedNFSequenceNmbr AS BR_CTeReferencedNFSequenceNmbr,
  ReferencedNotaFiscal.BR_NFNumber AS BR_NFNumber,
  ReferencedNotaFiscal.BR_NFeNumber AS BR_NFeNumber,
  ReferencedNotaFiscal.BR_NFFiscalYear AS BR_NFFiscalYear,
  cast( _BR_NotaFiscal.BR_NFPartnerName1 as logbr_partner_name_cte) AS PartnerFirstName,
  case _BR_NotaFiscal.BR_NFIssueDate when '' then ReferencedNotaFiscal.BR_NFIssueDate else _BR_NotaFiscal.BR_NFIssueDate end as BR_NFIssueDate AS BR_NFIssueDateendasBR_NFIssueDate,
  _BR_NotaFiscal.BR_NFPostingDate AS BR_NFPostingDate,
  ReferencedNotaFiscal.SalesDocumentCurrency AS SalesDocumentCurrency
FROM I_BR_Ctenotafiscalreference_C AS ReferencedNotaFiscal
LEFT OUTER JOIN I_BR_NFDocument AS _BR_NotaFiscal ON _BR_NotaFiscal.BR_NotaFiscal = ReferencedNotaFiscal.BR_NotaFiscal  -- association [1..1]
;