P_BR_RptgNFDataAggregation

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_RptgNFDataAggregation.
-- 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: PBRRPTGNFDATAAG

CREATE VIEW P_BR_RptgNFDataAggregation AS
SELECT
  CompanyCode,
  BusinessPlace,
  BR_NotaFiscal,
  BR_NotaFiscalItem,
  BR_PaymentForm,
  BR_NFIssueDate,
  BR_NFPostingDate,
  BR_NFSeries,
  BR_NFPartnerType,
  BR_NFPartner,
  LicensePlate,
  BR_NFeNumber,
  BR_NFeAccessKeyCNPJOrCPF,
  BR_NFIssuedBy,
  BR_NFSituationCode,
  BR_NFDirection,
  SupplierInvoice,
  BR_NFModel,
  BR_NFeAccessKey,
  BR_NFPartnerRegionCode,
  BR_NFIsCanceled,
  BR_CTeAccessKey,
  BR_CTeOriginalDocumentType,
  BR_CTeDocumentType,
  BR_CTeJurisdictionCodeOrigin,
  BR_CTeJurisdictionCodeDest,
  FreightPayer,
  BR_NFPartnerTaxJurisdiction,
  Material,
  MaterialName,
  BaseUnit,
  BR_NFIsPhysicalMvtOfMaterial,
  BR_ICMSIsOriginalTaxSituation,
  BR_ICMSTaxSituation,
  BR_CFOPCode,
  NFOperationNature,
  BR_IPITaxSituation,
  BR_PISTaxSituation,
  BR_COFINSTaxSituation,
  GLAccount,
  BR_MaterialUsage,
  ValuationArea,
  ValuationType,
  BR_NFExternalItemNumber,
  BR_SUFRAMACode,
  BR_ICMSTaxLaw,
  BR_IPITaxLaw,
  BR_MaterialOrigin,
  BR_COFINSTaxLaw,
  BR_PISTaxLaw,
  BR_NFCancellationDate,
  BR_NFShippingUnitBrand,
  BR_NFSVerificationCode,
  BR_NFType,
  BR_NFSubSeries,
  BR_NFSNumber,
  BR_NFPartnerStateTaxNumber,
  QuantityInBaseUnit,
  sum( BR_PISSTTaxBaseAmount ) AS BR_PISSTTaxBaseAmount,
  sum( BR_PISSTTaxRate ) AS BR_PISSTTaxRate,
  sum( BR_PISSTTaxAmount ) AS BR_PISSTTaxAmount,
  sum( BR_PISSTTaxExcludedBaseAmount ) AS BR_PISSTTaxExcludedBaseAmount,
  sum( BR_IPITaxBaseAmount ) AS BR_IPITaxBaseAmount,
  sum( BR_IPITaxRate ) AS BR_IPITaxRate,
  sum( BR_IPITaxAmount ) AS BR_IPITaxAmount,
  sum( BR_IPITaxExcludedBaseAmount ) AS BR_IPITaxExcludedBaseAmount,
  sum( BR_IPITaxOtherBaseAmount ) AS BR_IPITaxOtherBaseAmount,
  sum( BR_ISSQNTaxBaseAmount ) AS BR_ISSQNTaxBaseAmount,
  sum( BR_ISSQNTaxRate ) AS BR_ISSQNTaxRate,
  sum( BR_ISSQNTaxAmount ) AS BR_ISSQNTaxAmount,
  sum( BR_ISSQNTaxExcludedBaseAmount ) AS BR_ISSQNTaxExcludedBaseAmount,
  sum( BR_ISSQNTaxOtherBaseAmount ) AS BR_ISSQNTaxOtherBaseAmount,
  sum( BR_PISTaxBaseAmount ) AS BR_PISTaxBaseAmount,
  sum( BR_AppliedPISTaxAmount ) AS BR_AppliedPISTaxAmount,
  sum( BR_PISTaxAmount ) AS BR_PISTaxAmount,
  sum( BR_PISTaxExcludedBaseAmount ) AS BR_PISTaxExcludedBaseAmount,
  sum( BR_PISTaxOtherBaseAmount ) AS BR_PISTaxOtherBaseAmount,
  sum( BR_PISTxFiscalTariffBaseAmount ) AS BR_PISTxFiscalTariffBaseAmount,
  sum( BR_ICMSTaxBaseAmount ) AS BR_ICMSTaxBaseAmount,
  sum( BR_ICMSTaxRate ) AS BR_ICMSTaxRate,
  sum( BR_ICMSTaxAmount ) AS BR_ICMSTaxAmount,
  sum( BR_ICMSTaxExcludedBaseAmount ) AS BR_ICMSTaxExcludedBaseAmount,
  sum( BR_ICMSTaxOtherBaseAmount ) AS BR_ICMSTaxOtherBaseAmount,
  sum( BR_ICMSSTTaxBaseAmount ) AS BR_ICMSSTTaxBaseAmount,
  sum( BR_ICMSSTTaxRate ) AS BR_ICMSSTTaxRate,
  sum( BR_ICMSSTTaxAmount ) AS BR_ICMSSTTaxAmount,
  sum( BR_ICMSSTTaxExcludedBaseAmount ) AS BR_ICMSSTTaxExcludedBaseAmount,
  sum( BR_ICMSSTTaxOtherBaseAmount ) AS BR_ICMSSTTaxOtherBaseAmount,
  sum( BR_COFINSTaxBaseAmount ) AS BR_COFINSTaxBaseAmount,
  sum( BR_AppliedCOFINSTaxAmount ) AS BR_AppliedCOFINSTaxAmount,
  sum( BR_COFINSTaxAmount ) AS BR_COFINSTaxAmount,
  sum( BR_COFINSTaxExcludedBaseAmount ) AS BR_COFINSTaxExcludedBaseAmount,
  sum( BR_COFINSTaxOtherBaseAmount ) AS BR_COFINSTaxOtherBaseAmount,
  sum( BR_COFINSTxFsclTrifBaseAmount ) AS BR_COFINSTxFsclTrifBaseAmount,
  sum( BR_COFINSSTTaxBaseAmount ) AS BR_COFINSSTTaxBaseAmount,
  sum( BR_COFINSSTTaxRate ) AS BR_COFINSSTTaxRate,
  sum( BR_COFINSSTTaxAmount ) AS BR_COFINSSTTaxAmount,
  sum( BR_COFINSSTTaxExcldBaseAmount ) AS BR_COFINSSTTaxExcldBaseAmount,
  sum( BR_COFINSSTTaxOtherBaseAmount ) AS BR_COFINSSTTaxOtherBaseAmount,
  NFHeaderTotalAmount,
  sum( BR_ICMSReductionTaxAmount ) AS BR_ICMSReductionTaxAmount,
  sum( BR_IPIReductionTaxAmount ) AS BR_IPIReductionTaxAmount,
  sum( BR_DIFALTaxBaseAmount ) AS BR_DIFALTaxBaseAmount,
  sum( BR_DIFALTaxRate ) AS BR_DIFALTaxRate,
  sum( BR_DIFALTaxAmount ) AS BR_DIFALTaxAmount,
  sum( BR_DIFALTaxExcludedBaseAmount ) AS BR_DIFALTaxExcludedBaseAmount,
  sum( BR_DIFALTaxOtherBaseAmount ) AS BR_DIFALTaxOtherBaseAmount,
  BR_NFItemType,
  BR_IPIControlSealCode,
  BR_IPIControlSealQuantity,
  PurchaseOrder,
  PurchaseOrderItem,
  NetPriceAmount,
  sum( BR_OutgoingNFOperationAmount ) AS BR_OutgoingNFOperationAmount,
  sum( BR_IncomingNFOperationAmount ) AS BR_IncomingNFOperationAmount,
  NCMCode,
  BR_NFIsMunicipal,
  BR_NFTotalAmount,
  sum( BR_OriginalICMSSTTaxAmount ) AS BR_OriginalICMSSTTaxAmount,
  sum( BR_OriginalIPITaxAmount ) AS BR_OriginalIPITaxAmount,
  sum( BR_OriginalICMSTaxAmount ) AS BR_OriginalICMSTaxAmount,
  sum( BR_OriginalFCPOnICMSTaxAmount ) AS BR_OriginalFCPOnICMSTaxAmount,
  sum( BR_OriglFCPOnICMSSTTaxAmount ) AS BR_OriglFCPOnICMSSTTaxAmount,
  MaterialType,
  BR_NFHasServiceItem,
  SalesDocumentCurrency,
  HeaderWeightUnit,
  IncotermsClassification,
  BR_NFPartnerMunicipalTaxNumber,
  BR_NFSourceDocumentNumber,
  BR_NFSourceDocumentType,
  BR_NFSourceDocumentItem,
  Plant,
  Batch,
  BR_ISSTaxSituation,
  BR_ISSTaxLaw,
  BR_NFItemIsStatistical,
  BR_ReferenceNFNumber,
  BR_ReferenceNFItem,
  BR_NFPriceAmountWithTaxes,
  BR_NFReferenceDocument,
  BR_NFPartnerFunction,
  AccountingDocument,
  BR_NFIsContingency,
  BR_CTeServiceType,
  PaymentTerms,
  BR_NFIsCreatedManually,
  sum( BR_ICMSOriginTaxRate ) AS BR_ICMSOriginTaxRate,
  sum( BR_ICMSOriginTaxAmount ) AS BR_ICMSOriginTaxAmount,
  sum( BR_ICMSOriginTaxBaseAmount ) AS BR_ICMSOriginTaxBaseAmount,
  sum( BR_ICMSDestinationTaxRate ) AS BR_ICMSDestinationTaxRate,
  sum( BR_ICMSDestinationTaxAmount ) AS BR_ICMSDestinationTaxAmount,
  sum( BR_FCPOnICMSTaxRate ) AS BR_FCPOnICMSTaxRate,
  sum( BR_FCPOnICMSTaxAmount ) AS BR_FCPOnICMSTaxAmount,
  sum( BR_FCPOnICMSTaxBaseAmount ) AS BR_FCPOnICMSTaxBaseAmount,
  sum( BR_FCPOnICMSSTTaxRate ) AS BR_FCPOnICMSSTTaxRate,
  sum( BR_FCPOnICMSSTTaxAmount ) AS BR_FCPOnICMSSTTaxAmount,
  sum( BR_FCPOnICMSSTTaxBaseAmount ) AS BR_FCPOnICMSSTTaxBaseAmount,
  BR_NFArrivalOrDepartureDate,
  BR_NFPartnerName1,
  BR_NFPartnerStreetName,
  BusinessPartnerHouseNumber,
  BPHsNmbrSuplmntTxt,
  BR_NFPartnerDistrictName,
  BR_NFPartnerCityName,
  BR_NFPartnerPostalCode,
  CostCenter,
  BR_NBSCode,
  BR_NCMCode,
  PhoneNumber,
  NetValueAmount,
  BR_NFDiscountAmountWithTaxes,
  BR_NFValueAmountWithTaxes,
  BR_NFFreightAmountWithTaxes,
  BR_NFInsuranceAmountWithTaxes,
  BR_NFNetOtherExpensesAmount,
  BR_NFReductionBaseAmount
FROM P_BR_ReportingNFData
;