I_BR_SINFPosted

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_SINFPosted.
-- 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.

CREATE VIEW I_BR_SINFPosted AS
SELECT
  Document.BR_NotaFiscal AS BR_NotaFiscal,
  cast( lpad( Document.BR_NFReferenceDocument, 10, '0' ) as logbr_docnum ) AS BR_NFReferenceDocument,
  cast( Document.BusinessPlace as logbr_nfreceivercode) AS BR_NFReceiverID,
  _BR_BusinessPlace.BusinessPlaceName AS BusinessPlaceName,
  Document.BusinessPlace AS BusinessPlace,
  Document.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast(Document.BR_NFTotalAmount as logbr_nftotalamount preserving type) AS BR_NFTotalAmount,
  Document.CompanyCode AS CompanyCode,
  Document.CompanyCodeName AS CompanyCodeName,
  cast(concat_with_space(Document.CompanyCodeName, concat( concat('(', Document.CompanyCode), ')') , 1) as logbr_companycode ) AS CompanyCodeDescription,
  Document.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_BR_NFDocument AS Document
LEFT OUTER JOIN I_BR_SINFDocument AS _BR_SINFDocument ON BR_NFReferenceDocument = _BR_SINFDocument.BR_NotaFiscal  -- association [1..1]
LEFT OUTER JOIN I_BR_NFeActive AS _BR_NFeActive ON BR_NotaFiscal = _BR_NFeActive.BR_NotaFiscal  -- association [1..1]
LEFT OUTER JOIN I_BR_BusinessPlace_C AS _BR_BusinessPlace ON _BR_BusinessPlace.Branch = BusinessPlace AND _BR_BusinessPlace.CompanyCode = Document.CompanyCode  -- association [0..1]
;