I_BR_NFPharmaceutical

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_NFPharmaceutical.
-- 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: IBRNFLINPHARMA

CREATE VIEW I_BR_NFPharmaceutical AS
SELECT
  j_1bnfpharmaceut.docnum AS BR_NotaFiscal,
  j_1bnfpharmaceut.itmnum AS BR_NotaFiscalItem,
  j_1bnfpharmaceut.counter AS BR_NFePharmaMedicineLineID,
  j_1bnfpharmaceut.nlote AS MedicineBatch,
  j_1bnfpharmaceut.qlote AS MedicineQuantity,
  cast(j_1bnfpharmaceut.dfab as logbr_manufacturingdate) AS MedicineManufacturingDate,
  j_1bnfpharmaceut.dval AS MedicineExpiringDate,
  cast(j_1bnfpharmaceut.vpmc as logbr_consumermaxprice) AS ConsumerMaxPriceMedicineAmount,
  _BR_NotaFiscalItem._BR_NotaFiscal.SalesDocumentCurrency AS SalesDocumentCurrency,
  _BR_NotaFiscalItem.BaseUnit AS BaseUnit
FROM j_1bnfpharmaceut
LEFT OUTER JOIN I_Currency AS _SalesDocumentCurrency ON SalesDocumentCurrency = _SalesDocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItem AS _BR_NotaFiscalItem ON BR_NotaFiscalItem = _BR_NotaFiscalItem.BR_NotaFiscalItem AND BR_NotaFiscal = _BR_NotaFiscalItem.BR_NotaFiscal  -- association [1..1]
;