Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
Cross-Application Components (CA)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
  - ACR Activities (FI-LOC-VAT)
  - Audit Reporting (FI-LOC-AUR)
  - Cash Flow Localization (FI-LOC-CF)
  - Cash Management (FI-LOC-CM)
  - Contract Accounts Receivable and Payable (FI-LOC-CA)
  - Corporate Income Tax Framework (FI-LOC-CIT)
  - Globalization Service: Business Place (FI-LOC-BUP)
  - Golden Audit Interface (FI-LOC-GAI)
  - Localization Asset Accounting (FI-LOC-AA)
  - Localization E-Payment Integration (FI-LOC-EPI)
  - Localization Financials (FI-LOC-FI)
    - Financials Arabic Emirates (FI-LOC-FI-AE)
    - Financials Argentina (FI-LOC-FI-AR)
    - Financials Austria (FI-LOC-FI-AT)
    - Financials Belgium (FI-LOC-FI-BE)
    - Financials Brazil (FI-LOC-FI-BR)
    - Financials Chile (FI-LOC-FI-CL)
    - Financials China (FI-LOC-FI-CN)
    - Financials Colombia (FI-LOC-FI-CO)
    - Financials Czech Republic (FI-LOC-FI-CZ)
    - Financials Denmark (FI-LOC-FI-DK)
    - Financials Egypt (FI-LOC-FI-EG)
    - Financials France (FI-LOC-FI-FR)
    - Financials Germany (FI-LOC-FI-DE)
    - Financials Great Britain (FI-LOC-FI-GB)
    - Financials Hungary (FI-LOC-FI-HU)
    - Financials Indonesia (FI-LOC-FI-ID)
    - Financials Ireland (FI-LOC-FI-IE)
    - Financials Israel (FI-LOC-FI-IL)
    - Financials Italy (FI-LOC-FI-IT)
    - Financials Japan (FI-LOC-FI-JP)
    - Financials Kazakhastan (FI-LOC-FI-KZ)
    - Financials Luxembourg (FI-LOC-FI-LU)
    - Financials Malaysia (FI-LOC-FI-MY)
    - Financials Mexico (FI-LOC-FI-MX)
    - Financials Netherlands (FI-LOC-FI-NL)
    - Financials New Zealand (FI-LOC-FI-NZ)
    - Financials Norway (FI-LOC-FI-NO)
    - Financials Peru (FI-LOC-FI-PE)
    - Financials Philippines (FI-LOC-FI-PH)
    - Financials Poland (FI-LOC-FI-PL)
    - Financials Portugal (FI-LOC-FI-PT)
    - Financials Qatar (FI-LOC-FI-QA)
    - Financials Romania (FI-LOC-FI-RO)
    - Financials Russia (FI-LOC-FI-RU)
    - Financials Singapore (FI-LOC-FI-SG)
    - Financials Slovak republic (FI-LOC-FI-SK)
    - Financials Slovenia (FI-LOC-FI-SI)
    - Financials South Korea (FI-LOC-FI-KR)
    - Financials Spain (FI-LOC-FI-ES)
    - Financials Sweden (FI-LOC-FI-SE)
    - Financials Switzerland (FI-LOC-FI-CH)
    - Financials Taiwan (FI-LOC-FI-TW)
    - Financials Thailand (FI-LOC-FI-TH)
    - Financials Turkey (FI-LOC-FI-TR)
    - Financials USA (FI-LOC-FI-US)
    - Financials Ukraine (FI-LOC-FI-UA)
    - Financials Venezuela (FI-LOC-FI-VE)
  - Localization Financials (generic parts) (FI-LOC-GEN)
  - Localization Financials EC Sales List (FI-LOC-ECS)
  - Localization Financials Statements (FI-LOC-FS)
  - Localization Funds Management (FI-LOC-FM)
  - Localization Logistics (FI-LOC-LO)
  - Localization for Utilities Industry (FI-LOC-UT)
  - Payment Receipt (FI-LOC-PR)
  - SAF-T Reporting (Generic Part) (FI-LOC-SAF)
  - Statutory Reporting (FI-LOC-IS)
  - Statutory Reporting Framework (FI-LOC-SRF)
  - Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

P_BR_RptgNFDataAggregation

EFD - Nota Fiscal Data - Aggregation | view: PBRRPTGNFDATAAG | Extraction: Not supported | Component: Financials Brazil

Tables used: J_1BNFDOC, J_1BNFE_ACTIVE, J_1BNFLIN, J_1BNFNAD, J_1BNFSTX, J_1BAJ, T001, TKA02, KNA1, LFA1, T006A

🔑 Keys (3)
💰 Amounts (50)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (17)
Other (81)
🔗 Relations (23)

Column Name	Description
CompanyCode FK	Company Code
BusinessPlace FK	Business Place
BR_NotaFiscal FK	Document Number

Column Name	Description
BR_PISSTTaxBaseAmount	null
BR_PISSTTaxAmount	null
BR_IPITaxBaseAmount	null
BR_IPITaxAmount	null
BR_IPITaxOtherBaseAmount	null
BR_ISSQNTaxBaseAmount	null
BR_ISSQNTaxAmount	null
BR_ISSQNTaxOtherBaseAmount	null
BR_PISTaxBaseAmount	null
BR_PISTaxAmount	null
BR_PISTaxOtherBaseAmount	null
BR_ICMSTaxBaseAmount	null
BR_ICMSTaxAmount	null
BR_ICMSTaxOtherBaseAmount	null
BR_ICMSSTTaxBaseAmount	null
BR_ICMSSTTaxAmount	null
BR_ICMSSTTaxOtherBaseAmount	null
BR_COFINSTaxBaseAmount	null
BR_COFINSTaxAmount	null
BR_COFINSTaxOtherBaseAmount	null
BR_COFINSSTTaxBaseAmount	null
BR_COFINSSTTaxAmount	null
BR_COFINSSTTaxOtherBaseAmount	null
BR_ICMSReductionTaxAmount	null
BR_IPIReductionTaxAmount	null
BR_DIFALTaxBaseAmount	null
BR_DIFALTaxAmount	null
BR_DIFALTaxOtherBaseAmount	null
BR_OutgoingNFOperationAmount	null
BR_IncomingNFOperationAmount	null
BR_OriginalICMSSTTaxAmount	null
BR_OriginalIPITaxAmount	null
BR_OriginalICMSTaxAmount	null
BR_OriginalFCPOnICMSTaxAmount	null
BR_OriglFCPOnICMSSTTaxAmount	null
BR_ICMSOriginTaxAmount	null
BR_ICMSOriginTaxBaseAmount	null
BR_ICMSDestinationTaxAmount	null
BR_FCPOnICMSTaxAmount	null
BR_FCPOnICMSTaxBaseAmount	null
BR_FCPOnICMSSTTaxAmount	null
BR_FCPOnICMSSTTaxBaseAmount	null
💲 SD Document Currency (SalesDocumentCurrency):
NFHeaderTotalAmount	Total value including all taxes
BR_NFTotalAmount	Net Value including taxes
NetValueAmount	Net Amount
BR_NFDiscountAmountWithTaxes	null
BR_NFValueAmountWithTaxes	Net Value including taxes
BR_NFFreightAmountWithTaxes	Freight value including taxes
BR_NFInsuranceAmountWithTaxes	Insurance value including taxes
BR_NFNetOtherExpensesAmount	Net expenses in document currency

Column Name	Description
📏 Weight Unit (HeaderWeightUnit):
QuantityInBaseUnit	Quantity

Column Name	Description
BR_NFIssueDate	Document Date
BR_NFPostingDate	Posting Date
BR_NFCancellationDate	Cancellation Date
BR_NFArrivalOrDepartureDate	Goods Departure or Arrival Date

Column Name	Description
BR_PaymentForm	Payment Form Indicator	Show values
BR_NFPartnerType	Type	Show values
BR_NFIssuedBy	Nota Fiscal Issued By	Show values
BR_NFSituationCode	Status Code of Fiscal Document	Show values
BR_NFIsCanceled	Nota Fiscal Cancelled	Show values
BR_CTeOriginalDocumentType	CT-e Type	Show values
FreightPayer	Freight Mode	Show values
BR_NFIsPhysicalMvtOfMaterial	Material Movement	Show values
BR_ICMSIsOriginalTaxSituation	ICMS Tax Situation	Show values
BR_MaterialUsage	Material Usage	Show values
BR_MaterialOrigin	Material Origin	Show values
BR_NFIsMunicipal	Municipal Fiscal Document	Show values
BR_NFHasServiceItem	Service NF/NF-e	Show values
BR_NFItemIsStatistical	Statistical Item	Show values
BR_NFIsContingency	Contingency Indicator for Nota Fiscal	Show values
BR_CTeServiceType	Service Type Indicator	Show values
BR_NFIsCreatedManually	Manually Created	Show values

Column Name	Description	Domain name
BR_NotaFiscalItem	Document Item Number	J_1BITMNUM
BR_NFSeries	Nota Fiscal Series	J_1BSERIES
BR_NFPartner	null
LicensePlate	Vehicle License Plate	CHAR7
BR_NFeNumber	Nine-Digit Number
BR_NFeAccessKeyCNPJOrCPF	CNPJ/CPF Number of Document Issuer	J_1BSTCD1
BR_NFDirection	null
SupplierInvoice	Invoice Number	CHAR20
BR_NFModel	null
BR_NFeAccessKey	null
BR_CTeAccessKey	null
BR_CTeDocumentType	null
BR_CTeJurisdictionCodeOrigin	null
BR_CTeJurisdictionCodeDest	null
Material	Material Number	MATNR
MaterialName	Material Description	TEXT40
BaseUnit	External Unit of Measurement in Commercial Format (3-Char.)	MSEH3
BR_ICMSTaxSituation	null
BR_CFOPCode	null
BR_PISTaxSituation	PIS Tax Situation	J_1BTAXSI5
BR_COFINSTaxSituation	COFINS Tax Situation	J_1BTAXSI4
GLAccount	G/L Account Number	SAKNR
ValuationArea	null
BR_NFExternalItemNumber	External Item Number	NUMC3
BR_SUFRAMACode	null
BR_NFShippingUnitBrand	Shipping Unit Mark	TEXT20
BR_NFSVerificationCode	Verification Code	J_1BCHECOD
BR_NFSubSeries	Sub series	J_1BSUBSER
BR_NFSNumber	Service NF-e Number	J_1BPREFNO
BR_NFPartnerStateTaxNumber	State Tax Number	J_1BSTAINS
BR_PISSTTaxRate	null
BR_PISSTTaxExcludedBaseAmount	null
BR_IPITaxRate	null
BR_IPITaxExcludedBaseAmount	null
BR_ISSQNTaxRate	null
BR_ISSQNTaxExcludedBaseAmount	null
BR_AppliedPISTaxAmount	null
BR_PISTaxExcludedBaseAmount	null
BR_PISTxFiscalTariffBaseAmount	null
BR_ICMSTaxRate	null
BR_ICMSTaxExcludedBaseAmount	null
BR_ICMSSTTaxRate	null
BR_ICMSSTTaxExcludedBaseAmount	null
BR_AppliedCOFINSTaxAmount	null
BR_COFINSTaxExcludedBaseAmount	null
BR_COFINSTxFsclTrifBaseAmount	null
BR_COFINSSTTaxRate	null
BR_COFINSSTTaxExcldBaseAmount	null
BR_DIFALTaxRate	null
BR_DIFALTaxExcludedBaseAmount	null
BR_IPIControlSealCode	IPI Control Seal Code	CHAR10
BR_IPIControlSealQuantity	null
PurchaseOrder	Purchase Order Number	CHAR15
PurchaseOrderItem	Purchase Order Item	CHAR6
NetPriceAmount	Net Price Including Tax	J_1BNFPRI
MaterialType	null
BR_NFPartnerMunicipalTaxNumber	Municipal Tax Number	J_1BMUNINS
BR_NFSourceDocumentNumber	Source Document Key	J_1BREFKEY
BR_NFSourceDocumentItem	Reference item to source document	J_1BREFITM
BR_ISSTaxSituation	ISS Tax Situation	CHAR80
BR_ReferenceNFItem	NF Reference Item	J_1BITMNUM
BR_NFPriceAmountWithTaxes	Net Price Including Tax	J_1BNFPRI
BR_NFReferenceDocument	null
AccountingDocument	Accounting Document	BELNR
PaymentTerms	Terms of Payment Key	ZTERM
BR_ICMSOriginTaxRate	null
BR_ICMSDestinationTaxRate	null
BR_FCPOnICMSTaxRate	null
BR_FCPOnICMSSTTaxRate	null
BR_NFPartnerName1	Name 1	NAME
BR_NFPartnerStreetName	Street and House Number	TEXT35
BusinessPartnerHouseNumber	null
BPHsNmbrSuplmntTxt	null
BR_NFPartnerDistrictName	District	TEXT35
BR_NFPartnerCityName	City	TEXT35
BR_NFPartnerPostalCode	Postal Code	PSTLZ
CostCenter	Cost Center	KOSTL
BR_NBSCode	null
BR_NCMCode	null
PhoneNumber	Addresses: telephone no.	TEXT30
BR_NFReductionBaseAmount	Excluded Base Amount	DECV15_2

Master Data Relations	Join Conditions
Batch Number Client ? Batch Number	`P_BR_RPTGNFDATAAGGREGATION.MANDT == MCH1.MANDT` `P_BR_RPTGNFDATAAGGREGATION.[column in domain "MATNR"] == MCH1.MATNR` `P_BR_RPTGNFDATAAGGREGATION.BATCH == MCH1.CHARG`
COFINS Tax Law Client COFINS Tax Law	`P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BATL4A.MANDT` `P_BR_RPTGNFDATAAGGREGATION.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW`
Tax Law ICMS Tax Law ICMS Client	`P_BR_RPTGNFDATAAGGREGATION.BR_ICMSTAXLAW == J_1BATL1.TAXLAW` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BATL1.MANDT`
Tax Law IPI Tax Law IPI Client	`P_BR_RPTGNFDATAAGGREGATION.BR_IPITAXLAW == J_1BATL2.TAXLAW` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BATL2.MANDT`
IPI Tax Situation IPI Tax Situation Client	`P_BR_RPTGNFDATAAGGREGATION.BR_IPITAXSITUATION == J_1BAS.TAXSIT` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BAS.MANDT`
ISS Tax Law Client ISS Tax Law	`P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BATL3.MANDT` `P_BR_RPTGNFDATAAGGREGATION.BR_ISSTAXLAW == J_1BATL3.TAXLAW`
NF Item Type NF Item Type Client	`P_BR_RPTGNFDATAAGGREGATION.BR_NFITEMTYPE == J_1BITEMTYPES.ITMTYP` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BITEMTYPES.MANDT`
Nota Fiscal Partner Function Client Nota Fiscal Partner Function	`P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BAD.MANDT` `P_BR_RPTGNFDATAAGGREGATION.BR_NFPARTNERFUNCTION == J_1BAD.PARVW`
Region (State, Province, County) Region (State, Province, County) ? Client	`P_BR_RPTGNFDATAAGGREGATION.BR_NFPARTNERREGIONCODE == T005S.BLAND` `P_BR_RPTGNFDATAAGGREGATION.[column in domain "LAND1"] == T005S.LAND1` `P_BR_RPTGNFDATAAGGREGATION.MANDT == T005S.MANDT`
Tax Jurisdiction Tax Jurisdiction ? Client	`P_BR_RPTGNFDATAAGGREGATION.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD` `P_BR_RPTGNFDATAAGGREGATION.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `P_BR_RPTGNFDATAAGGREGATION.MANDT == TTXJ.MANDT`
Reference type	`P_BR_RPTGNFDATAAGGREGATION.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP`
Nota Fiscal Type Client Nota Fiscal Type	`P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BAA.MANDT` `P_BR_RPTGNFDATAAGGREGATION.BR_NFTYPE == J_1BAA.NFTYPE`
Tax Law PIS Tax Law PIS Client	`P_BR_RPTGNFDATAAGGREGATION.BR_PISTAXLAW == J_1BATL5.TAXLAW` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BATL5.MANDT`
Company Code Company Code Client	`P_BR_RPTGNFDATAAGGREGATION.COMPANYCODE == T001.BUKRS` `P_BR_RPTGNFDATAAGGREGATION.MANDT == T001.MANDT`
Weight Unit Client Weight Unit	`P_BR_RPTGNFDATAAGGREGATION.MANDT == T006.MANDT` `P_BR_RPTGNFDATAAGGREGATION.HEADERWEIGHTUNIT == T006.MSEHI`
Incoterms (Part 1) Client Incoterms (Part 1)	`P_BR_RPTGNFDATAAGGREGATION.MANDT == TINC.MANDT` `P_BR_RPTGNFDATAAGGREGATION.INCOTERMSCLASSIFICATION == TINC.INCO1`
Control Code ? Control Code Client	`P_BR_RPTGNFDATAAGGREGATION.[column in domain "LAND1"] == T604F.LAND1` `P_BR_RPTGNFDATAAGGREGATION.NCMCODE == T604F.STEUC` `P_BR_RPTGNFDATAAGGREGATION.MANDT == T604F.MANDT`
CFOP Code and Extension ? CFOP Code and Extension Client	`P_BR_RPTGNFDATAAGGREGATION.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION` `P_BR_RPTGNFDATAAGGREGATION.NFOPERATIONNATURE == J_1BAGN.CFOP` `P_BR_RPTGNFDATAAGGREGATION.MANDT == J_1BAGN.MANDT`
Plants Plant Client	`P_BR_RPTGNFDATAAGGREGATION.PLANT == T001W.WERKS` `P_BR_RPTGNFDATAAGGREGATION.MANDT == T001W.MANDT`
SD Document Currency Client SD Document Currency	`P_BR_RPTGNFDATAAGGREGATION.MANDT == TCURC.MANDT` `P_BR_RPTGNFDATAAGGREGATION.SALESDOCUMENTCURRENCY == TCURC.WAERS`
Valuation Type Plant Valuation Type Client ?	`P_BR_RPTGNFDATAAGGREGATION.PLANT == MBEW.BWKEY` `P_BR_RPTGNFDATAAGGREGATION.VALUATIONTYPE == MBEW.BWTAR` `P_BR_RPTGNFDATAAGGREGATION.MANDT == MBEW.MANDT` `P_BR_RPTGNFDATAAGGREGATION.[column in domain "MATNR"] == MBEW.MATNR`