SAP Table J_1BTAXCODEV
Generated Table for View
J_1BTAXCODEV (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link J_1BTAXCODEV to other SAP tables.
J_1BTAXCODEV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | T683 | CHAR | 6 | 0 | ||||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | 0 | |||||||
| TEXT1 | Name for value-added tax | TEXT1_007S | CHAR | 50 | 0 | |||||||
| MWART | Tax Type | MWART | CHAR | 1 | 0 |
Possible values
|
||||||
| J_1BUSAGE | Tax Calculation: Material Usage | J_1BTXMMU | CHAR | 1 | 0 |
Possible values
|
||||||
| J_1BISS | Tax Calculation: Service Without ICMS/IPI | J_1BTXMMIS | CHAR | 1 | 0 |
Possible values
|
||||||
| J_1BTAXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BATL1 | CHAR | 3 | 0 | ||||||
| J_1BTAXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BATL2 | CHAR | 3 | 0 | ||||||
| J_1BTXICEX | ICMS Stored as "Exempt" Instead of "Other Basis" | J_1BTXICEX | CHAR | 1 | 0 |
Possible values
|
||||||
| J_1BTXIPEX | IPI Stored as "Exempt" Instead of "Other Basis" | J_1BTXIPEX | CHAR | 1 | 0 |
Possible values
|
||||||
| IN_MWSKZ | Tax Code at Goods Receipt | J_1BINMWSKZ | T007A | CHAR | 2 | 0 | ||||||
| SD_MWSKZ | SD Tax Code | J_1BSDMWSKZ | J_1BTXSDC | CHAR | 2 | 0 | ||||||
| J_1BTAXLW4 | COFINS Tax Law | J_1BTAXLW4 | J_1BATL4A | CHAR | 3 | 0 | ||||||
| J_1BTAXLW5 | PIS Tax Law | J_1BTAXLW5 | J_1BATL5 | CHAR | 3 | 0 | ||||||
J_1BTAXCODEV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| J_1BTAXCODEV | IN_MWSKZ | J_1BTAXCODEV | MANDT | T007A | Tax Keys | MANDT |
| J_1BTAXCODEV | IN_MWSKZ | J_1BTAXCODEV | KALSM | T007A | Tax Keys | KALSM |
| J_1BTAXCODEV | IN_MWSKZ | J_1BTAXCODEV | IN_MWSKZ | T007A | Tax Keys | MWSKZ |
| J_1BTAXCODEV | J_1BTAXLW1 | J_1BTAXCODEV | MANDT | J_1BATL1 | Tax Law ICMS | MANDT |
| J_1BTAXCODEV | J_1BTAXLW1 | J_1BTAXCODEV | J_1BTAXLW1 | J_1BATL1 | Tax Law ICMS | TAXLAW |
| J_1BTAXCODEV | J_1BTAXLW2 | J_1BTAXCODEV | MANDT | J_1BATL2 | Tax Law IPI | MANDT |
| J_1BTAXCODEV | J_1BTAXLW2 | J_1BTAXCODEV | J_1BTAXLW2 | J_1BATL2 | Tax Law IPI | TAXLAW |
| J_1BTAXCODEV | J_1BTAXLW4 | SYST | MANDT | J_1BATL4A | Tax Laws COFINS | MANDT |
| J_1BTAXCODEV | J_1BTAXLW4 | J_1BTAXCODEV | J_1BTAXLW4 | J_1BATL4A | Tax Laws COFINS | TAXLAW |
| J_1BTAXCODEV | J_1BTAXLW5 | SYST | MANDT | J_1BATL5 | Tax Laws PIS | MANDT |
| J_1BTAXCODEV | J_1BTAXLW5 | J_1BTAXCODEV | J_1BTAXLW5 | J_1BATL5 | Tax Laws PIS | TAXLAW |
| J_1BTAXCODEV | KALSM | J_1BTAXCODEV | MANDT | T683 | Pricing procedures | MANDT |
| J_1BTAXCODEV | KALSM | 'A' | T683 | Pricing procedures | KVEWE | |
| J_1BTAXCODEV | KALSM | 'TX' | T683 | Pricing procedures | KAPPL | |
| J_1BTAXCODEV | KALSM | J_1BTAXCODEV | KALSM | T683 | Pricing procedures | KALSM |
| J_1BTAXCODEV | MANDT | J_1BTAXCODEV | MANDT | T000 | Clients | MANDT |
| J_1BTAXCODEV | SD_MWSKZ | J_1BTAXCODEV | SD_MWSKZ | J_1BTXSDC | SD tax codes | TAXCODE |
| J_1BTAXCODEV | SD_MWSKZ | J_1BTAXCODEV | MANDT | J_1BTXSDC | SD tax codes | MANDT |
