J_1BTXST1

Tax calc.: Sub.Trib. rules | #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)
MATNR FK Material Number
STGRP FK Customer group for Substituiçao Tributária calculation
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SUR_TYPE Sub.Trib. calculation rule Show values
SURCHIN Compare Minimum Price Without Surcharge Show values
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
RATE Sub.Trib. surcharge percentage rate J_1BTXRATE
PRICE Sub.Trib. fixed price per unit J_1BTXSTFP
FACTOR Number of units for Sub.Trib. calc. (price per n units) DEC4_2
BASERED1 Sub.Trib. Base Reduction 1 (Federal) (in %) J_1BTXBASE
BASERED2 Sub.Trib. Base Reduction 2 (State) (in %) J_1BTXBASE
ICMSBASER ICMS Reduction for Sub.Trib. (in %) J_1BTXBASE
MINPRICE Minimum Price Per Item Is Basis for Substituição Tributária J_1BTXSTFP
MINFACT Sub.Trib. Percentage to be Applied on Minimum Price J_1BTXRATE
FCP_BASERED1 Sub.Trib. Base Reduction 1 (Federal) for FCP J_1BTXBASE
FCP_BASERED2 Sub.Trib. Base Reduction 2 (State) for FCP J_1BTXBASE
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BTXST1.LAND1 == T005.LAND1
  • J_1BTXST1.MANDT == T005.MANDT
Client J_1BTXST1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_1BTXST1.MATNR == MARA.MATNR
  • J_1BTXST1.MANDT == MARA.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)
Customer group for Substituiçao Tributária calculation
Unit for Sub.Trib. calculation (price per n units)
  • J_1BTXST1.MANDT == T006.MANDT
  • J_1BTXST1.UNIT == T006.MSEHI
Currency Key
  • J_1BTXST1.MANDT == TCURC.MANDT
  • J_1BTXST1.WAERS == TCURC.WAERS