J_1BTXST3 - Dynamic Calculation of Substitui��o Tribut�ria
Dynamic Calculation of Substitui��o Tribut�ria information is stored in SAP table J_1BTXST3.
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
It is part of development package J1BA in software component FI-LOC-LO-BR. This development package consists of objects that can be grouped under "Localization Brazil".
Fields for table J_1BTXST3
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| LAND1 | Country/Region Key | X | LAND1 | CHAR | 6 | T005 |
| SHIPFROM | Ship from location (tax region) | X | J_1BTXSHPF | CHAR | 6 | J_1BTREGX |
| SHIPTO | Ship to location (tax region) | X | J_1BTXSHPT | CHAR | 6 | J_1BTREGX |
| GRUOP | Tax Group for Dynamic Tax Exceptions | X | J_1BTXGRP | NUMC | 4 | J_1BTXGRUOP |
| VALUE | Dynamic Key Field | X | J_1BVALUE | CHAR | 80 | |
| VALUE2 | Dynamic Key Field | X | J_1BVALUE2 | CHAR | 80 | |
| VALUE3 | Dynamic Key Field | X | J_1BVALUE3 | CHAR | 80 | |
| STGRP | Customer group for Substitui�ao Tribut�ria calculation | X | J_1BTCST | CHAR | 6 | J_1BTXSTG |
| VALIDFROM | Date from which the tax rule is valid | X | J_1BTXDATF | CHAR | 16 | |
| VALIDTO | Date to which the tax rule is valid | J_1BTXDATT | CHAR | 16 | ||
| SUR_TYPE | Sub.Trib. calculation rule | J_1BTXSTT | NUMC | 2 | ||
| RATE | Sub.Trib. surcharge percentage rate | J_1BTXSTPR | DEC | 4 | ||
| PRICE | Sub.Trib. fixed price per unit | J_1BTXSTFP | DEC | 8 | ||
| FACTOR | Number of units for Sub.Trib. calc. (price per n units) | J_1BTXSTF | DEC | 4 | ||
| UNIT | Unit for Sub.Trib. calculation (price per n units) | J_1BTXSTU | UNIT | 6 | T006 | |
| BASERED1 | Sub.Trib. Base Reduction 1 (Federal) (in %) | J_1BTXSTB1 | DEC | 4 | ||
| BASERED2 | Sub.Trib. Base Reduction 2 (State) (in %) | J_1BTXSTB2 | DEC | 4 | ||
| ICMSBASER | ICMS Reduction for Sub.Trib. (in %) | J_1BTXSTI1 | DEC | 4 | ||
| MINPRICE | Minimum Price Per Item Is Basis for Substitui��o Tribut�ria | J_1BTXSTMP | DEC | 8 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| MINFACT | Sub.Trib. Percentage to be Applied on Minimum Price | J_1BTXSTPF | DEC | 4 | ||
| SURCHIN | Compare Minimum Price Without Surcharge | J_1BTXSTSC | CHAR | 2 | ||
| FCP_BASERED1 | Sub.Trib. Base Reduction 1 (Federal) for FCP | J_1BTXSTB1_FCP | DEC | 4 | ||
| FCP_BASERED2 | Sub.Trib. Base Reduction 2 (State) for FCP | J_1BTXSTB2_FCP | DEC | 4 |