P_BR_RptgNFStatisticalTax

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 P_BR_RptgNFStatisticalTax.
-- 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: PBRSPEDNFSTCT

CREATE VIEW P_BR_RptgNFStatisticalTax AS
SELECT
  tax.BR_NotaFiscal AS BR_NotaFiscal,
  tax.TaxGroup AS OriginalTaxGroup,
  _doc.CompanyCode AS CompanyCode,
  _doc.BR_IsNFe AS BR_IsNFe,
  _doc.BR_NFPartnerRegionCode AS BR_NFPartnerRegionCode,
  _doc.BR_NFSNumber AS BR_NFSNumber,
  _doc.IncotermsClassification AS IncotermsClassification,
  _doc.BR_CTeServiceType AS BR_CTeServiceType,
  _doc.BusinessPartnerHouseNumber AS BusinessPartnerHouseNumber,
  _doc.BPHsNmbrSuplmntTxt AS BPHsNmbrSuplmntTxt,
  _doc.PhoneNumber AS PhoneNumber,
  _doc.BR_NFTotalAmount AS NFHeaderTotalAmount,
  case when _itm.Material <> '' then _itm.Material else case when _doc.BR_NFSNumber <> '' then _doc.BR_NFSNumber else concat(concat(_doc.BR_NFeNumber, _doc.BR_NotaFiscal), tax.BR_NotaFiscalItem) end end as Material AS BR_NotaFiscalItemendendasMaterial,
  _itm.BR_NFIsPhysicalMvtOfMaterial AS BR_NFIsPhysicalMvtOfMaterial,
  _itm.BR_ICMSTaxSituation AS BR_ICMSTaxSituation,
  _itm.BR_CFOPCode AS BR_CFOPCode,
  _itm.BR_NFDiscountAmountWithTaxes AS BR_NFDiscountAmountWithTaxes,
  _itm.BR_NFFreightAmountWithTaxes AS BR_NFFreightAmountWithTaxes,
  _itm.BR_NFInsuranceAmountWithTaxes AS BR_NFInsuranceAmountWithTaxes,
  _itm.BR_NFNetOtherExpensesAmount AS BR_NFNetOtherExpensesAmount,
  _itm.BR_ExemptedICMSAmount AS BR_ExemptedICMSAmount,
  _itm.NCMCode AS NCMCode,
  _itm.BaseUnit AS BaseUnit,
  case when tax.TaxGroup = 'ISS' or tax.TaxGroup = 'ISSS' or tax.TaxGroup = 'ISSP' then 'ISSQN' else tax.TaxGroup end as TaxGroup AS TaxGroupendasTaxGroup,
  tax.BR_NFItemBaseAmount AS BR_NFItemOriginalBaseAmount,
  tax.BR_NFItemExcludedBaseAmount AS BR_OriglNFItemExclBaseAmount,
  tax.BR_NFItemOtherBaseAmount AS BR_OriglNFItemOtherBaseAmount,
  tax.BR_NFItemTaxRate AS BR_OriginalNFItemTaxRate,
  tax.BR_NFItemTaxAmount AS BR_NFItemTaxAmount,
  tax.BR_NFItemTaxBasePct1 AS BR_NFItemTaxBasePct1,
  tax.BR_NFItemTaxBasePct2 AS BR_NFItemTaxBasePct2,
  tax.BR_NFItemIsStatisticalTax AS BR_NFItemIsStatisticalTax,
  tax.BR_NFItemHasFixedMktTariff AS BR_NFItemHasFixedMktTariff,
  tax.BR_NFItemFixedMktTariffBaseQty AS BR_NFItemFixedMktTariffBaseQty,
  tax.BR_NFItemFixedMarketTariffUnit AS BR_NFItemFixedMarketTariffUnit,
  tax.BR_NFItemWhldgCollectionCode AS BR_NFItemWhldgCollectionCode,
  tax.BR_NFItemFixedMktTariffTaxRate AS BR_NFItemFixedMktTariffTaxRate,
  tax.BR_NFItemFixedMktTariffQty AS BR_NFItemFixedMktTariffQty,
  tax.BR_NFItmFxdMktTariffUnit4Dcmls AS BR_NFItmFxdMktTariffUnit4Dcmls,
  tax.BR_NFItemHasWithholdingTax AS BR_NFItemHasWithholdingTax,
  tax.BR_NFSServiceTypeIncoming AS BR_NFSServiceTypeIncoming,
  tax.BR_NFSServiceTypeOutgoing AS BR_NFSServiceTypeOutgoing,
  tax.TaxJurisdiction AS TaxJurisdiction,
  substring(tax.TaxJurisdiction,4,2) AS BR_UFTaxJurisdiction,
  '' AS BR_NFIsTaxInNetAmount
FROM I_BR_NFTax AS tax
LEFT OUTER JOIN I_BR_NFDocument AS _doc ON BR_NotaFiscal = _doc.BR_NotaFiscal  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItem AS _itm ON BR_NotaFiscal = _itm.BR_NotaFiscal AND BR_NotaFiscalItem = _itm.BR_NotaFiscalItem  -- association [1..1]
;