0ID_BR_NF_3

Nota Fiscal Tax per Item | #TRAN | Extraction method: V | No Delta | Component: Nota Fiscal for Brazil
Tables used: J_1BNFSTXJ_1BNFDOCshow details
Column Name Description
PSTDAT Posting date
BUKRS FK Company Code
BRANCH FK Business Place
DOCNUM FK Document Number
ITMNUM Document Item Number
TAXTYP FK Tax Type
Column Name Description
💲 SD Document Currency (WAERK):
BASE Base amount
TAXVAL Tax value
EXCBAS Excluded base amount
OTHBAS Other base amount
Column Name Description
Column Name Description
PSTDAT Posting date
Column Name Description
STATTX Indicator: Statistical tax item Show values
RECTYPE Nota Fiscal tax record type Show values
Column Name Description Domain name
RATE Tax Rate J_1BTXRATE
FACTOR Number of units DEC4_2
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • 0ID_BR_NF_3.BUKRS == T001.BUKRS
  • 0ID_BR_NF_3.MANDT == T001.MANDT
Tax Type
  • Client
  • Tax Type
  • 0ID_BR_NF_3.MANDT == J_1BAJ.MANDT
  • 0ID_BR_NF_3.TAXTYP == J_1BAJ.TAXTYP
Pauta Unit
  • Pauta Unit
  • Client
  • 0ID_BR_NF_3.UNIT == T006.MSEHI
  • 0ID_BR_NF_3.MANDT == T006.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • 0ID_BR_NF_3.WAERK == TCURC.WAERS
  • 0ID_BR_NF_3.MANDT == TCURC.MANDT