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_ReportingNFTaxRate

EFD - Nota Fiscal Tax Rate | view: PBRSPEDNFTXRATE | TRAN | Extraction: Not supported | Component: Financials Brazil

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

🔑 Keys (4)
💰 Amounts (17)
∑ Quantities (2)
📅 Dates (5)
☰ Categorical (27)
Other (57)
🔗 Relations (31)

Column Name	Description
BR_NotaFiscal FK	Document Number
BR_NotaFiscalItem	Document Item Number
BR_TaxType FK	Tax Type
OriginalTaxGroup	Tax Group	Show values

Column Name	Description
💲 SD Document Currency (SalesDocumentCurrency):
NFHeaderTotalAmount	Total value including all taxes
BR_NFTotalAmountWithTaxes	Net value/Freight/Insurance/Expenses/Discount
BR_NFValueAmountWithTaxes	Net Value including taxes
NetValueAmount	Net Amount
BR_NFDiscountAmountWithTaxes	Discount value including taxes
BR_NFFreightAmountWithTaxes	Freight value including taxes
BR_NFInsuranceAmountWithTaxes	Insurance value including taxes
BR_NFNetOtherExpensesAmount	Net expenses in document currency
BR_NFItemOriginalBaseAmount	Base amount
BR_OriglNFItemOtherBaseAmount	Other base amount
BR_NFItemOriginalTaxAmount	Tax value
NFItemOtherBaseAmount	Other base amount
NFItemBaseAmount	Base amount
BR_IPIReductionTaxAmount	null
BR_ICMSReductionTaxAmount	null
BR_NFTotalAmount	Net value/Freight/Insurance/Expenses/Discount
NFItemTaxAmount	null

Column Name	Description
📏 Weight Unit (HeaderWeightUnit):
QuantityInBaseUnit	Quantity
BR_NFItemFixedMktTariffBaseQty	Pauta Base Four Decimals

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

Column Name	Description
OriginalTaxGroup	Tax Group	Show values
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_NFModel	Nota Fiscal Model	Show values
BR_NFDirection	Movement Direction	Show values
BR_IsNFe	Electronic Fiscal Document	Show values
BR_NFIsCanceled	Nota Fiscal Cancelled	Show values
FreightPayer	Freight Mode	Show values
BR_NFIsMunicipal	Municipal Fiscal Document	Show values
BR_NFHasServiceItem	Service NF/NF-e	Show values
BR_NFIsCreatedManually	Manually Created	Show values
BR_NFIsContingency	Contingency Indicator for Nota Fiscal	Show values
BR_CTeDocumentType	CT-e Type	Show values
BR_CTeServiceType	Service Type Indicator	Show values
BR_NFIsPhysicalMvtOfMaterial	Material Movement	Show values
BR_ICMSTaxSituation	ICMS Tax Situation	Show values
BR_MaterialUsage	Material Usage	Show values
BR_NFIsServiceItem	Service tax - no ICMS/IPI calculation	Show values
BR_MaterialOrigin	Material Origin	Show values
BR_ICMSBaseDetn	ICMS Base Determination	Show values
BR_NFItemIsStatistical	Statistical Item	Show values
BR_NFItemIsStatisticalTax	Statistical Tax Item	Show values
BR_NFItemHasFixedMktTariff	Nota Fiscal tax record type	Show values
BR_NFItemHasWithholdingTax	Withholding Tax	Show values
BR_ICMSIsIncludedInAmount	Value and price including ICMS/ISS	Show values

Column Name	Description	Domain name
BR_NFSeries	Nota Fiscal Series	J_1BSERIES
BR_NFPartner	Partner ID (Customer, Vendor, Business Place)	J_1BPARID
LicensePlate	Vehicle License Plate	CHAR7
BR_NFeNumber	Nine-Digit Number
BR_CTeJurisdictionCodeOrigin	null
BR_CTeJurisdictionCodeDest	null
BR_NFShippingUnitBrand	Shipping Unit Mark	TEXT20
BR_NFSVerificationCode	Verification Code	J_1BCHECOD
BR_NFSubSeries	Sub series	J_1BSUBSER
SupplierInvoice	Invoice Number	CHAR20
BR_NFSNumber	Service NF-e Number	J_1BPREFNO
BR_NFPartnerStateTaxNumber	State Tax Number	J_1BSTAINS
BR_NFPartnerMunicipalTaxNumber	Municipal Tax Number	J_1BMUNINS
BR_NFReferenceDocument	null
CreatedByUser	User who created the document	USNAM
AccountingDocument	Accounting Document	BELNR
PaymentTerms	Terms of Payment Key	ZTERM
BR_NFPartnerName1	Name 1	NAME
BR_NFPartnerDistrictName	District	TEXT35
BR_NFPartnerCityName	City	TEXT35
BR_NFPartnerPostalCode	Postal Code	PSTLZ
BR_NFPartnerStreetName	Street and House Number	TEXT35
BusinessPartnerHouseNumber	House Number	TEXT10
BPHsNmbrSuplmntTxt	House number supplement	TEXT10
PhoneNumber	Addresses: telephone no.	TEXT30
Material	Material Number	MATNR
MaterialName	Material Description	TEXT40
BR_PISTaxSituation	PIS Tax Situation	J_1BTAXSI5
BR_COFINSTaxSituation	COFINS Tax Situation	J_1BTAXSI4
GLAccount	G/L Account Number	SAKNR
BR_NFExternalItemNumber	External Item Number	NUMC3
BR_IPIControlSealCode	IPI Control Seal Code	CHAR10
BR_IPIControlSealQuantityValue	IPI Control Seal Quantity	DEC12
PurchaseOrder	Purchase Order Number	CHAR15
PurchaseOrderItem	Purchase Order Item	CHAR6
NetPriceAmount	Net Price Including Tax	J_1BNFPRI
BR_ExemptedICMSAmount	ICMS Exemption Amount
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
CostCenter	Cost Center	KOSTL
BR_NBSCode	NBS Code	J_1BNBS
TaxGroup	null
BR_OriglNFItemExclBaseAmount	Excluded Base Amount	DECV15_2
BR_OriginalNFItemTaxRate	Tax Rate	J_1BTXRATE
BR_NFItemTaxBasePct1	Tax Base	J_1BTXBASE
BR_NFItemTaxBasePct2	Tax base (%)	J_1BTXBASE
BR_NFItemWhldgCollectionCode	Official Withholding Tax Collection Code	WITHCD2
BR_NFItemFixedMktTariffTaxRate	Tax Rate with 4 Decimal Places	J_1BTXRATE4DEC
BR_NFItemFixedMktTariffQty	Number of Units for Pauta with 4 DP (for Reporting Only)	DEC4_2
BR_UFTaxJurisdiction	null
BR_NFIsTaxInNetAmount	null
NFItemExcludedBaseAmount	Excluded Base Amount	DECV15_2
BR_TaxIsISSQN	null
NFItemTaxRate	Tax Rate with 4 Decimal Places	J_1BTXRATE4DEC

Master Data Relations	Join Conditions
Base unit of measure Client Base unit of measure	`P_BR_REPORTINGNFTAXRATE.MANDT == T006.MANDT` `P_BR_REPORTINGNFTAXRATE.BASEUNIT == T006.MSEHI`
Batch Number Batch Number Client Material Number	`P_BR_REPORTINGNFTAXRATE.BATCH == MCH1.CHARG` `P_BR_REPORTINGNFTAXRATE.MANDT == MCH1.MANDT` `P_BR_REPORTINGNFTAXRATE.MATERIALOLDID == MCH1.MATNR`
CFOP Code and Extension Client ? CFOP Code and Extension	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BAGN.MANDT` `P_BR_REPORTINGNFTAXRATE.[column in domain "J_1BCFOP_VER"] == J_1BAGN.VERSION` `P_BR_REPORTINGNFTAXRATE.BR_CFOPCODE == J_1BAGN.CFOP`
COFINS Tax Law Client COFINS Tax Law	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BATL4A.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_COFINSTAXLAW == J_1BATL4A.TAXLAW`
Tax Law ICMS Client Tax Law ICMS	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BATL1.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_ICMSTAXLAW == J_1BATL1.TAXLAW`
Tax Law IPI Client Tax Law IPI	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BATL2.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_IPITAXLAW == J_1BATL2.TAXLAW`
IPI Tax Situation Client IPI Tax Situation	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BAS.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_IPITAXSITUATION == J_1BAS.TAXSIT`
ISS Tax Law Client ISS Tax Law	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BATL3.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_ISSTAXLAW == J_1BATL3.TAXLAW`
Document Type Client Document Type	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BDOCTYPES.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFDOCUMENTTYPE == J_1BDOCTYPES.DOCTYP`
Pauta Unit Client Pauta Unit	`P_BR_REPORTINGNFTAXRATE.MANDT == T006.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFITEMFIXEDMARKETTARIFFUNIT == T006.MSEHI`
NF Item Type NF Item Type Client	`P_BR_REPORTINGNFTAXRATE.BR_NFITEMTYPE == J_1BITEMTYPES.ITMTYP` `P_BR_REPORTINGNFTAXRATE.MANDT == J_1BITEMTYPES.MANDT`
Nota Fiscal Partner Function Client Nota Fiscal Partner Function	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BAD.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFPARTNERFUNCTION == J_1BAD.PARVW`
Region (State, Province, County) Client Region (State, Province, County) ?	`P_BR_REPORTINGNFTAXRATE.MANDT == T005S.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFPARTNERREGIONCODE == T005S.BLAND` `P_BR_REPORTINGNFTAXRATE.[column in domain "LAND1"] == T005S.LAND1`
Tax Jurisdiction Client Tax Jurisdiction ?	`P_BR_REPORTINGNFTAXRATE.MANDT == TTXJ.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFPARTNERTAXJURISDICTION == TTXJ.TXJCD` `P_BR_REPORTINGNFTAXRATE.[column in domain "TAX_KALSM"] == TTXJ.KALSM`
Reference type	`P_BR_REPORTINGNFTAXRATE.BR_NFSOURCEDOCUMENTTYPE == J_1BAB.REFTYP`
Service Type (Incoming) Client Service Type (Incoming) ? Tax Jurisdiction Code For Brazilian Tax Calculation	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BSERVTYPES1.CLIENT` `P_BR_REPORTINGNFTAXRATE.BR_NFSSERVICETYPEINCOMING == J_1BSERVTYPES1.SERVTYPE_IN` `P_BR_REPORTINGNFTAXRATE.[column in domain "LAND1"] == J_1BSERVTYPES1.COUNTRY` `P_BR_REPORTINGNFTAXRATE.TAXJURISDICTION == J_1BSERVTYPES1.TAXJURCODE`
Service Type (Outgoing) Client Service Type (Outgoing) ? Tax Jurisdiction Code For Brazilian Tax Calculation	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BSERVTYPES2.CLIENT` `P_BR_REPORTINGNFTAXRATE.BR_NFSSERVICETYPEOUTGOING == J_1BSERVTYPES2.SERVTYPE_OUT` `P_BR_REPORTINGNFTAXRATE.[column in domain "LAND1"] == J_1BSERVTYPES2.COUNTRY` `P_BR_REPORTINGNFTAXRATE.TAXJURISDICTION == J_1BSERVTYPES2.TAXJURCODE`
Nota Fiscal Type Client Nota Fiscal Type	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BAA.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_NFTYPE == J_1BAA.NFTYPE`
Tax Law PIS Client Tax Law PIS	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BATL5.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_PISTAXLAW == J_1BATL5.TAXLAW`
Tax Type Client Tax Type	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BAJ.MANDT` `P_BR_REPORTINGNFTAXRATE.BR_TAXTYPE == J_1BAJ.TAXTYP`
Company Code Client Company Code	`P_BR_REPORTINGNFTAXRATE.MANDT == T001.MANDT` `P_BR_REPORTINGNFTAXRATE.COMPANYCODE == T001.BUKRS`
Weight Unit Client Weight Unit	`P_BR_REPORTINGNFTAXRATE.MANDT == T006.MANDT` `P_BR_REPORTINGNFTAXRATE.HEADERWEIGHTUNIT == T006.MSEHI`
Incoterms (Part 1) Incoterms (Part 1) Client	`P_BR_REPORTINGNFTAXRATE.INCOTERMSCLASSIFICATION == TINC.INCO1` `P_BR_REPORTINGNFTAXRATE.MANDT == TINC.MANDT`
Material Number Client Material Number	`P_BR_REPORTINGNFTAXRATE.MANDT == MARA.MANDT` `P_BR_REPORTINGNFTAXRATE.MATERIALOLDID == MARA.MATNR`
Control Code Client ? Control Code	`P_BR_REPORTINGNFTAXRATE.MANDT == T604F.MANDT` `P_BR_REPORTINGNFTAXRATE.[column in domain "LAND1"] == T604F.LAND1` `P_BR_REPORTINGNFTAXRATE.NCMCODE == T604F.STEUC`
Plants Client Plant	`P_BR_REPORTINGNFTAXRATE.MANDT == T001W.MANDT` `P_BR_REPORTINGNFTAXRATE.PLANT == T001W.WERKS`
SD Document Currency Client SD Document Currency	`P_BR_REPORTINGNFTAXRATE.MANDT == TCURC.MANDT` `P_BR_REPORTINGNFTAXRATE.SALESDOCUMENTCURRENCY == TCURC.WAERS`
Tax Jurisdiction Code For Brazilian Tax Calculation Client ? Tax Jurisdiction Code For Brazilian Tax Calculation	`P_BR_REPORTINGNFTAXRATE.MANDT == J_1BTXJUR.CLIENT` `P_BR_REPORTINGNFTAXRATE.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY` `P_BR_REPORTINGNFTAXRATE.TAXJURISDICTION == J_1BTXJUR.TAXJURCODE`
Valuation Type Client Material Number Plant Valuation Type	`P_BR_REPORTINGNFTAXRATE.MANDT == MBEW.MANDT` `P_BR_REPORTINGNFTAXRATE.MATERIALOLDID == MBEW.MATNR` `P_BR_REPORTINGNFTAXRATE.PLANT == MBEW.BWKEY` `P_BR_REPORTINGNFTAXRATE.VALUATIONTYPE == MBEW.BWTAR`