J_1BTXIC3

Grouped ICMS | #other | Component: Logistics Brazil
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
SHIPFROM FK Ship from location (tax region)
SHIPTO FK Ship to location (tax region)
GRUOP FK Tax Group for Dynamic Tax Exceptions
VALUE Dynamic Key Field
VALUE2 Dynamic Key Field
VALUE3 Dynamic Key Field
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EXEMPT No ICMS calculation - Other base Show values
CONVEN100 Product Subject to Convenio 100 Show values
PARTILHA_EXEMPT ICMS Partilha Exemption Show values
SPECF_RESALE Calculate FCP for Resale Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
RATE Tax Rate J_1BTXRATE
BASE Tax base (%) J_1BTXBASE
SPECF_RATE ICMS FCP Rate J_1BTXRATE
SPECF_BASE ICMS FCP Base J_1BTXBASE
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BTXIC3.LAND1 == T005.LAND1
  • J_1BTXIC3.MANDT == T005.MANDT
Client J_1BTXIC3.MANDT == T000.MANDT
Ship from location (tax region)
  • Country/Region Key
  • Ship from location (tax region)
Ship to location (tax region)
  • Country/Region Key
  • Ship to location (tax region)
Tax law: ICMS
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Group for Dynamic Tax Exceptions
  • Tax Group for Dynamic Tax Exceptions
  • Client