J_1BNFSTX

Nota Fiscal tax per item | #transactional | Component: Logistics Brazil
Column Name Description
MANDT FK Client
DOCNUM FK Document Number
ITMNUM Document Item Number
TAXTYP FK Tax Type
Column Name Description
💲 SD Document Currency (J_1BNFDOC.WAERK):
BASE Base amount
TAXVAL Tax value
EXCBAS Excluded base amount
OTHBAS Other base amount
TAX_DIFFERENCE Tax difference used for NF item calculation (PIS/COFINS)
Column Name Description
📏 Pauta Unit (UNIT):
PAUTA_BASE Pauta Base Four Decimals
Column Name Description
Column Name Description
STATTX Indicator: Statistical tax item Show values
RECTYPE Nota Fiscal tax record type Show values
WITHHOLD Withholding Tax (Brazil) Show values
TAXINNET Tax Already Included in Net Value Show values
TAXGRP Tax group Show values
TAXOFF Offset condition for tax calculation Show values
TAXOUTVALUE Net Value Without Including Taxes Show values
Column Name Description Domain name
RATE Tax Rate J_1BTXRATE
FACTOR Number of units DEC4_2
WHTCOLLCODE Official Withholding Tax Collection Code WITHCD2
BASERED1 Tax base (%) J_1BTXBASE
BASERED2 Tax base (%) J_1BTXBASE
RATE4DEC Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
FACTOR4DEC Number of Units for Pauta with 4 DP (for Reporting Only) DEC4_2
SRATE Sub.Trib. surcharge percentage rate J_1BTXRATE
Master Data Relations Join Conditions
Client J_1BNFSTX.MANDT == T000.MANDT
Service Type (Incoming)
  • ?
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • Service Type (Incoming)
Service Type (Outgoing)
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • ?
  • Service Type (Outgoing)
Tax Type
  • Tax Type
  • Client
  • J_1BNFSTX.TAXTYP == J_1BAJ.TAXTYP
  • J_1BNFSTX.MANDT == J_1BAJ.MANDT
Tax Jurisdiction Code For Brazilian Tax Calculation
  • ?
  • Tax Jurisdiction Code For Brazilian Tax Calculation
  • J_1BNFSTX.MANDT == J_1BTXJUR.CLIENT
  • J_1BNFSTX.[column in domain "LAND1"] == J_1BTXJUR.COUNTRY
  • J_1BNFSTX.TAX_LOC == J_1BTXJUR.TAXJURCODE
Pauta Unit
  • J_1BNFSTX.MANDT == T006.MANDT
  • J_1BNFSTX.UNIT == T006.MSEHI