SAP Table J_1BTXISS

Tax Calculation: ISS

J_1BTXISS (Tax Calculation: ISS) 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_1BTXISS to other SAP tables.

J_1BTXISS table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
GRUOP Tax Group for Dynamic Tax Exceptions J_1BTXGRP J_1BTXGRUOP NUMC 2 0
TAXJURCODE Tax Jurisdiction Code For Brazilian Tax Calculation J_1BTXJCD J_1BTXJUR CHAR 15 0
VALUE Dynamic Key Field J_1BVALUE CHAR 20 0
VALUE2 Dynamic Key Field J_1BVALUE2 CHAR 20 0
VALUE3 Dynamic Key Field J_1BVALUE3 CHAR 20 0
VALIDFROM Date from which the tax rule is valid J_1BTXDATF CHAR 8 0
VALIDTO Date to which the tax rule is valid J_1BTXDATT CHAR 8 0
RATE Tax Rate J_1BTXRATE DEC 6 2
BASE Tax base (%) J_1BTXBASE DEC 6 2
TAXLAW ISS Tax Law J_1BTAXLW3 J_1BATL3 CHAR 3 0
TAXRELLOC Tax-Relevant Location For ISS (Brazil) J_1BTAXRELLOC CHAR 1 0
1 Provider
2 Service
WITHHOLD Post ISS As Withholding Tax J_1BISSWT CHAR 1 0
X Yes
NULL No
MINVAL_WT Minimum Value for ISS Withholding Tax J_1BISSMINPRICE DEC 15 2
WAERS Currency Key WAERS TCURC CUKY 5 0

J_1BTXISS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BTXISS CLIENT J_1BTXISS CLIENT T000 Clients MANDT
J_1BTXISS COUNTRY J_1BTXISS CLIENT T005 Countries MANDT
J_1BTXISS COUNTRY J_1BTXISS COUNTRY T005 Countries LAND1
J_1BTXISS GRUOP J_1BTXISS CLIENT J_1BTXGRUOP Dynamic Determination of Tax-Related Master Data MANDT
J_1BTXISS GRUOP J_1BTXISS GRUOP J_1BTXGRUOP Dynamic Determination of Tax-Related Master Data GRUOP
J_1BTXISS TAXJURCODE J_1BTXISS CLIENT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
J_1BTXISS TAXJURCODE J_1BTXISS COUNTRY J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
J_1BTXISS TAXJURCODE J_1BTXISS TAXJURCODE J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
J_1BTXISS TAXLAW J_1BTXISS CLIENT J_1BATL3 Tax Laws ISS MANDT
J_1BTXISS TAXLAW J_1BTXISS TAXLAW J_1BATL3 Tax Laws ISS TAXLAW
J_1BTXISS WAERS J_1BTXISS CLIENT TCURC Currency Codes MANDT
J_1BTXISS WAERS J_1BTXISS WAERS TCURC Currency Codes WAERS