SAP table J_1BTXIC3V (Generated Table for View)
SAP table J_1BTXIC3V has 9 primary key fields being MANDT,LAND1,GRUOP,SHIPFROM,SHIPTO,VALUE,VALUE2,VALUE3,VALIDFROM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| LAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| GRUOP | Tax Group for Dynamic Tax Exceptions | NUMC | 2 | 0 | J_1BTXGRUOP | J_1BTXGRP | |
| SHIPFROM | Ship from location (tax region) | CHAR | 3 | 0 | J_1BTREGX | J_1BTXSHPF | |
| SHIPTO | Ship to location (tax region) | CHAR | 3 | 0 | J_1BTREGX | J_1BTXSHPT | |
| VALUE | Dynamic Key Field | CHAR | 40 | 0 | J_1BVALUE | ||
| VALUE2 | Dynamic Key Field | CHAR | 40 | 0 | J_1BVALUE2 | ||
| VALUE3 | Dynamic Key Field | CHAR | 40 | 0 | J_1BVALUE3 | ||
| VALIDFROM | Date from which the tax rule is valid | CHAR | 8 | 0 | J_1BTXDATF | ||
| VALIDTO | Date to which the tax rule is valid | CHAR | 8 | 0 | J_1BTXDATT | ||
| RATE | Tax Rate | DEC | 6 | 2 | J_1BTXRATE | ||
| BASE | Tax base (%) | DEC | 6 | 2 | J_1BTXBASE | ||
| EXEMPT | No ICMS calculation - Other base | CHAR | 1 | 0 | J_1BTXEXIC | ||
| TAXLAW | Tax law: ICMS | CHAR | 3 | 0 | J_1BATL1 | J_1BTAXLW1 | |
| CONVEN100 | Product Subject to Convenio 100 | CHAR | 1 | 0 | J_1BTXC100 | ||
| SPECF_RATE | ICMS FCP Rate | DEC | 6 | 2 | J_1BSPECFRATE | ||
| SPECF_BASE | ICMS FCP Base | DEC | 6 | 2 | J_1BSPECFBASE | ||
| PARTILHA_EXEMPT | ICMS Partilha Exemption | CHAR | 1 | 0 | J_1BPARTEXEMPT | ||
| SPECF_RESALE | Calculate FCP for Resale | CHAR | 1 | 0 | J_1BSPECFRESALE |
J_1BTXIC3V foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 J_1BTXIC3V | GRUOP | J_1BTXGRUOP | Dynamic Determination of Tax-Related Master Data | MANDT |
| 1 J_1BTXIC3V | LAND1 | T005 | Countries | MANDT |
| 1 J_1BTXIC3V | LAND1 | T005 | Countries | LAND1 |
| 0 J_1BTXIC3V | MANDT | T000 | Clients | MANDT |
| 1 J_1BTXIC3V | SHIPFROM | J_1BTREGX | Tax region | MANDT |
| 1 J_1BTXIC3V | SHIPFROM | J_1BTREGX | Tax region | LAND1 |
| 0 J_1BTXIC3V | SHIPTO | J_1BTREGX | Tax region | MANDT |
| 0 J_1BTXIC3V | SHIPTO | J_1BTREGX | Tax region | LAND1 |