Menu

SAP Table J_1BTXST3

Dynamic Calculation of Substituição Tributária

The table J_1BTXST3 (Dynamic Calculation of Substituição Tributária) is a standard table in SAP ERP. It belongs to the package J1BA.

Technical Information

Table J_1BTXST3
Short Text Dynamic Calculation of Substituição Tributária
Package J1BA
Table Type Transparent Table

Fields for Table J_1BTXST3

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
LAND1 Country Key LAND1 CHAR 3 T005
SHIPFROM Ship from location (tax region) J_1BTXSHPF CHAR 3 J_1BTREGX
SHIPTO Ship to location (tax region) J_1BTXSHPT CHAR 3 J_1BTREGX
GRUOP Tax Group for Dynamic Tax Exceptions J_1BTXGRP NUMC 2 J_1BTXGRUOP
VALUE Dynamic Key Field J_1BVALUE CHAR 20
VALUE2 Dynamic Key Field J_1BVALUE2 CHAR 20
VALUE3 Dynamic Key Field J_1BVALUE3 CHAR 20
STGRP Customer group for Substituiçao Tributária calculation J_1BTCST CHAR 3 J_1BTXSTG
VALIDFROM Date from which the tax rule is valid J_1BTXDATF CHAR 8
VALIDTO Date to which the tax rule is valid J_1BTXDATT CHAR 8
SUR_TYPE Sub.Trib. calculation rule J_1BTXSTT NUMC 1
RATE Sub.Trib. surcharge percentage rate J_1BTXSTPR DEC 6
PRICE Sub.Trib. fixed price per unit J_1BTXSTFP DEC 15
FACTOR Number of units for Sub.Trib. calc. (price per n units) J_1BTXSTF DEC 6
UNIT Unit for Sub.Trib. calculation (price per n units) J_1BTXSTU UNIT 3 T006
BASERED1 Sub.Trib. Base Reduction 1 (Federal) (in %) J_1BTXSTB1 DEC 6
BASERED2 Sub.Trib. Base Reduction 2 (State) (in %) J_1BTXSTB2 DEC 6
ICMSBASER ICMS Reduction for Sub.Trib. (in %) J_1BTXSTI1 DEC 6
MINPRICE Minimum Price Per Item Is Basis for Substituição Tributária J_1BTXSTMP DEC 15
WAERS Currency Key WAERS CUKY 5 TCURC
MINFACT Sub.Trib. Percentage to be Applied on Minimum Price J_1BTXSTPF DEC 6
SURCHIN Compare Minimum Price Without Surcharge J_1BTXSTSC CHAR 1