P_BR_ReportingNFTaxRate

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_ReportingNFTaxRate.
-- 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: PBRSPEDNFTXRATE

CREATE VIEW P_BR_ReportingNFTaxRate AS
SELECT
  BR_NotaFiscal,
  BR_NotaFiscalItem,
  BR_TaxType,
  OriginalTaxGroup,
  CompanyCode,
  BusinessPlace,
  BR_PaymentForm,
  BR_NFIssueDate,
  BR_NFSeries,
  BR_NFPartnerType,
  BR_NFPartner,
  LicensePlate,
  BR_NFeNumber,
  BR_NFIssuedBy,
  BR_NFSituationCode,
  BR_NFType,
  BR_NFDocumentType,
  BR_NFModel,
  BR_NFDirection,
  BR_IsNFe,
  BR_NFPartnerRegionCode,
  BR_NFIsCanceled,
  BR_CTeJurisdictionCodeOrigin,
  BR_CTeJurisdictionCodeDest,
  FreightPayer,
  BR_NFPartnerTaxJurisdiction,
  BR_NFCancellationDate,
  BR_NFShippingUnitBrand,
  BR_NFSVerificationCode,
  BR_NFSubSeries,
  SupplierInvoice,
  BR_NFSNumber,
  BR_NFPartnerStateTaxNumber,
  BR_NFIsMunicipal,
  BR_NFHasServiceItem,
  SalesDocumentCurrency,
  HeaderWeightUnit,
  IncotermsClassification,
  BR_NFPartnerMunicipalTaxNumber,
  BR_NFReferenceDocument,
  BR_NFPostingDate,
  CreationDate,
  CreatedByUser,
  BR_NFIsCreatedManually,
  BR_NFPartnerFunction,
  AccountingDocument,
  BR_NFIsContingency,
  BR_CTeDocumentType,
  BR_CTeServiceType,
  PaymentTerms,
  BR_NFArrivalOrDepartureDate,
  BR_NFPartnerName1,
  BR_NFPartnerDistrictName,
  BR_NFPartnerCityName,
  BR_NFPartnerPostalCode,
  BR_NFPartnerStreetName,
  BusinessPartnerHouseNumber,
  BPHsNmbrSuplmntTxt,
  PhoneNumber,
  MaterialOldID,
  Material,
  MaterialName,
  BR_NFIsPhysicalMvtOfMaterial,
  BR_ICMSTaxSituation,
  BR_CFOPCode,
  BR_IPITaxSituation,
  BR_PISTaxSituation,
  BR_COFINSTaxSituation,
  GLAccount,
  BR_MaterialUsage,
  ValuationType,
  BR_NFExternalItemNumber,
  BR_NFIsServiceItem,
  BR_ICMSTaxLaw,
  BR_IPITaxLaw,
  BR_MaterialOrigin,
  BR_COFINSTaxLaw,
  BR_PISTaxLaw,
  QuantityInBaseUnit,
  BR_NFItemType,
  BR_IPIControlSealCode,
  BR_IPIControlSealQuantityValue,
  BR_ICMSBaseDetn,
  PurchaseOrder,
  PurchaseOrderItem,
  NFHeaderTotalAmount,
  NetPriceAmount,
  BR_NFTotalAmount,
  BR_NFTotalAmountWithTaxes,
  BR_NFValueAmountWithTaxes,
  NetValueAmount,
  BR_NFDiscountAmountWithTaxes,
  BR_NFFreightAmountWithTaxes,
  BR_NFInsuranceAmountWithTaxes,
  BR_NFNetOtherExpensesAmount,
  BR_ExemptedICMSAmount,
  NCMCode,
  BR_NFSourceDocumentNumber,
  BR_NFSourceDocumentType,
  BR_NFSourceDocumentItem,
  Plant,
  Batch,
  BR_ISSTaxSituation,
  BR_ISSTaxLaw,
  BR_NFItemIsStatistical,
  BR_ReferenceNFNumber,
  BR_ReferenceNFItem,
  BR_NFPriceAmountWithTaxes,
  CostCenter,
  BR_NBSCode,
  BaseUnit,
  TaxGroup,
  BR_NFItemOriginalBaseAmount,
  BR_OriglNFItemExclBaseAmount,
  BR_OriglNFItemOtherBaseAmount,
  BR_OriginalNFItemTaxRate,
  BR_NFItemTaxAmount AS BR_NFItemOriginalTaxAmount,
  BR_NFItemTaxBasePct1,
  BR_NFItemTaxBasePct2,
  BR_NFItemIsStatisticalTax,
  BR_NFItemHasFixedMktTariff,
  BR_NFItemFixedMktTariffBaseQty,
  BR_NFItemFixedMarketTariffUnit,
  BR_NFItemWhldgCollectionCode,
  BR_NFItemFixedMktTariffTaxRate,
  BR_NFItemFixedMktTariffQty,
  BR_NFItmFxdMktTariffUnit4Dcmls,
  BR_NFItemHasWithholdingTax,
  BR_NFSServiceTypeIncoming,
  BR_NFSServiceTypeOutgoing,
  TaxJurisdiction,
  BR_UFTaxJurisdiction,
  BR_NFIsTaxInNetAmount,
  BR_ICMSIsIncludedInAmount,
  NFItemExcludedBaseAmount,
  NFItemOtherBaseAmount,
  NFItemBaseAmount,
  BR_IPIReductionTaxAmount,
  BR_ICMSReductionTaxAmount
FROM P_BR_RptgNFStatisticalTax
;