I_BR_SINFPreviewItem

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_SINFPreviewItem.
-- 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_SINFPreviewItem AS
SELECT
  Item.BR_NotaFiscal AS BR_NotaFiscal,
  cast( Item.BR_NotaFiscal as logbr_docnum_temporary ) AS BR_NFTemporaryID,
  Item.BR_NotaFiscalItem AS BR_NotaFiscalItem,
  cast( '' as logbr_nfitemseqnumber ) AS BR_NFItemSequenceNumber,
  Item.Material AS Material,
  Item.MaterialName AS MaterialName,
  cast( '3.949/AA' as logbr_cfopcode ) AS BR_CFOPFrmtdCode,
  Item.Plant AS Plant,
  _BR_Plant.PlantName AS PlantName,
  Item.QuantityInBaseUnit AS QuantityInBaseUnit,
  Item.BaseUnit AS BaseUnit,
  Item.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast( Item.BR_NFPriceAmountWithTaxes as logbr_nfunitprice preserving type ) AS BR_NFItemUnitPriceAmount,
  cast( Item.BR_NFTotalAmount as logbr_totalvalue preserving type ) AS BR_NFTotalAmount,
  cast( _ICMSValues.BR_NFItemBaseAmount as logbr_nficmsbaseamount preserving type ) AS BR_ICMSBaseAmount,
  Item.BR_MaterialUsage AS BR_MaterialUsage,
  _BR_MaterialUsage.BR_MaterialUsageDesc AS BR_MaterialUsageDesc,
  Item.BR_IPITaxSituation AS BR_IPITaxSituation,
  _BR_TaxSituationIPIText.BR_IPITaxSituationDesc AS BR_IPITaxSituationDesc,
  Item.BR_ICMSTaxSituation AS BR_ICMSTaxSituation,
  _BR_ICMSTaxSituationText.BR_ICMSTaxSituationDesc AS BR_ICMSTaxSituationDesc,
  Item.BR_COFINSTaxSituation AS BR_COFINSTaxSituation,
  _BR_TaxSituationCOFINSText.BR_COFINSTaxSituationDesc AS BR_COFINSTaxSituationDesc,
  Item.BR_PISTaxSituation AS BR_PISTaxSituation,
  _BR_TaxSituationPISText.BR_PISTaxSituationDesc AS BR_PISTaxSituationDesc,
  Item.BR_ISSSuspensionProcess AS BR_ISSSuspensionProcess
FROM I_BR_NFItem AS Item
LEFT OUTER JOIN I_BR_SINFDocument AS _BR_SINFDocument ON _BR_SINFDocument.BR_NotaFiscal = BR_NotaFiscal  -- association [1..1]
LEFT OUTER JOIN I_BR_Plant_C AS _BR_Plant ON _BR_Plant.Plant = Item.Plant  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemTaxByItem_C AS _ICMSValues ON _ICMSValues.BR_NotaFiscal = BR_NotaFiscal AND _ICMSValues.BR_NotaFiscalItem = BR_NotaFiscalItem AND _ICMSValues.TaxGroup = 'ICMS' AND _ICMSValues.BR_ICMSPartilhaSubdivisionCode = ''  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialUsageText AS _BR_MaterialUsage ON Item.BR_MaterialUsage = _BR_MaterialUsage.BR_MaterialUsage AND _BR_MaterialUsage.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_BR_ICMSTaxSituationText AS _BR_ICMSTaxSituationText ON Item.BR_ICMSTaxSituation = _BR_ICMSTaxSituationText.BR_ICMSTaxSituation AND _BR_ICMSTaxSituationText.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_BR_TaxSituationPISText AS _BR_TaxSituationPISText ON _BR_TaxSituationPISText.Language = $session.system_language AND _BR_TaxSituationPISText.BR_PISTaxSituation = Item.BR_PISTaxSituation  -- association [0..1]
LEFT OUTER JOIN I_BR_TaxSituationIPIText AS _BR_TaxSituationIPIText ON _BR_TaxSituationIPIText.Language = $session.system_language AND _BR_TaxSituationIPIText.BR_IPITaxSituation = Item.BR_IPITaxSituation  -- association [0..1]
LEFT OUTER JOIN I_BR_TaxSituationCOFINSText AS _BR_TaxSituationCOFINSText ON _BR_TaxSituationCOFINSText.Language = $session.system_language AND _BR_TaxSituationCOFINSText.BR_COFINSTaxSituation = Item.BR_COFINSTaxSituation  -- association [0..1]
;