A_BR_NFTax

Brazil Nota Fiscal Tax | view: ABRNFTAX | Extraction: Not supported | Component: Logistics Brazil
Tables used: J_1BNFDOCJ_1BNFNADJ_1BNFSTXT001TKA02KNA1LFA1
Column Name Description
BR_NotaFiscal FK Document Number
BR_NotaFiscalItem Document Item Number
BR_TaxType FK Tax Type
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
BR_NFItemBaseAmount Base amount
BR_NFItemTaxAmount Tax value
BR_NFItemOtherBaseAmount Other base amount
AggregateBaseAmount null
Column Name Description
📏 Pauta Unit (BR_NFItemFixedMarketTariffUnit):
BR_NFItemFixedMktTariffBaseQty Pauta Base Four Decimals
Column Name Description
Column Name Description
TaxGroup Tax Group Show values
BR_NFItemIsStatisticalTax Statistical Tax Item Show values
BR_NFItemHasFixedMktTariff Nota Fiscal tax record type Show values
TaxesAreIncludedInNetAmount Tax Already Included in Net Value Show values
BR_NFItemHasWithholdingTax Withholding Tax Show values
Column Name Description Domain name
BR_NFItemTaxRate Tax Rate J_1BTXRATE
BR_NFItemExcludedBaseAmount Excluded Base Amount DECV15_2
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
Master Data Relations Join Conditions
Pauta Unit
  • Client
  • Pauta Unit
  • A_BR_NFTAX.MANDT == T006.MANDT
  • A_BR_NFTAX.BR_NFITEMFIXEDMARKETTARIFFUNIT == T006.MSEHI
Service Type (Incoming)
  • ?
  • Client
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • Service Type (Incoming)
Service Type (Outgoing)
  • ?
  • Service Type (Outgoing)
  • Client
  • Tax Jurisdiction Code For Brazilian Tax Calculation
Tax Type
  • Client
  • Tax Type
  • A_BR_NFTAX.MANDT == J_1BAJ.MANDT
  • A_BR_NFTAX.BR_TAXTYPE == J_1BAJ.TAXTYP
SD Document Currency
  • SD Document Currency
  • Client
  • A_BR_NFTAX.SALESDOCUMENTCURRENCY == TCURC.WAERS
  • A_BR_NFTAX.MANDT == TCURC.MANDT
Tax Jurisdiction Code For Brazilian Tax Calculation
  • ?
  • Client
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • A_BR_NFTAX.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
  • A_BR_NFTAX.MANDT == J_1BTXJUR.CLIENT
  • A_BR_NFTAX.TAXJURISDICTION == J_1BTXJUR.TAXJURCODE