SAP ABAP Table J_1BTXST3V (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | J_1BTXST3V | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | GRUOP | J_1BTXGRP | J_1BTXGRP | NUMC | 2 | 0 | Tax Group for Dynamic Tax Exceptions | J_1BTXGRUOP | |
4 | SHIPFROM | J_1BTXSHPF | J_1BTXREG | CHAR | 3 | 0 | Ship from location (tax region) | J_1BTREGX | |
5 | SHIPTO | J_1BTXSHPT | J_1BTXREG | CHAR | 3 | 0 | Ship to location (tax region) | J_1BTREGX | |
6 | VALUE | J_1BVALUE | J_1BVALUE | CHAR | 20 | 0 | Dynamic Key Field | ||
7 | VALUE2 | J_1BVALUE2 | J_1BVALUE2 | CHAR | 20 | 0 | Dynamic Key Field | ||
8 | VALUE3 | J_1BVALUE3 | J_1BVALUE3 | CHAR | 20 | 0 | Dynamic Key Field | ||
9 | STGRP | J_1BTCST | J_1BTCST1 | CHAR | 3 | 0 | Customer group for Substituiçao Tributária calculation | J_1BTXSTG | |
10 | VALIDFROM | J_1BTXDATF | DATUM_INV | CHAR | 8 | 0 | Date from which the tax rule is valid | ||
11 | VALIDTO | J_1BTXDATT | DATUM_INV | CHAR | 8 | 0 | Date to which the tax rule is valid | ||
12 | SUR_TYPE | J_1BTXSTT | J_1BTXSTT | NUMC | 1 | 0 | Sub.Trib. calculation rule | ||
13 | RATE | J_1BTXSTPR | J_1BTXRATE | DEC | 6 | 2 | Sub.Trib. surcharge percentage rate | ||
14 | PRICE | J_1BTXSTFP | J_1BTXSTFP | DEC | 15 | 2 | Sub.Trib. fixed price per unit | ||
15 | FACTOR | J_1BTXSTF | DEC4_2 | DEC | 6 | 2 | Number of units for Sub.Trib. calc. (price per n units) | ||
16 | UNIT | J_1BTXSTU | MEINS | UNIT | 3 | 0 | Unit for Sub.Trib. calculation (price per n units) | T006 | |
17 | BASERED1 | J_1BTXSTB1 | J_1BTXBASE | DEC | 6 | 2 | Sub.Trib. Base Reduction 1 (Federal) (in %) | ||
18 | BASERED2 | J_1BTXSTB2 | J_1BTXBASE | DEC | 6 | 2 | Sub.Trib. Base Reduction 2 (State) (in %) | ||
19 | ICMSBASER | J_1BTXSTI1 | J_1BTXBASE | DEC | 6 | 2 | ICMS Reduction for Sub.Trib. (in %) | ||
20 | MINPRICE | J_1BTXSTMP | J_1BTXSTFP | DEC | 15 | 2 | Minimum Price Per Item Is Basis for Substituição Tributária | ||
21 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
22 | MINFACT | J_1BTXSTPF | J_1BTXRATE | DEC | 6 | 2 | Sub.Trib. Percentage to be Applied on Minimum Price | ||
23 | SURCHIN | J_1BTXSTSC | XFELD | CHAR | 1 | 0 | Compare Minimum Price Without Surcharge |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | J_1BTXST3V | GRUOP | J_1BTXGRUOP | GRUOP | 1 | CN | |
2 | J_1BTXST3V | LAND1 | T005 | LAND1 | 1 | CN | |
3 | J_1BTXST3V | MANDT | T000 | MANDT | 1 | CN | |
4 | J_1BTXST3V | SHIPFROM | J_1BTREGX | TXREG | 1 | CN | |
5 | J_1BTXST3V | SHIPTO | J_1BTREGX | TXREG | 1 | CN | |
6 | J_1BTXST3V | STGRP | J_1BTXSTG | STGRP | 1 | CN | |
7 | J_1BTXST3V | UNIT | T006 | MSEHI | 1 | CN | |
8 | J_1BTXST3V | WAERS | TCURC | WAERS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |