1. Home
  2. Resources
  3. SAP Tables
  4. J_1BTXIC3V - Generated Table for View

SAP Table J_1BTXIC3V

Generated Table for View

J_1BTXIC3V (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_1BTXIC3V to other SAP tables.

Source: J_1BTXIC3V (Generated Table for View)

J_1BTXIC3V table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAND1 Country Key LAND1 T005 CHAR 3 0
GRUOP Tax Group for Dynamic Tax Exceptions J_1BTXGRP J_1BTXGRUOP NUMC 2 0
SHIPFROM Ship from location (tax region) J_1BTXSHPF J_1BTREGX CHAR 3 0
SHIPTO Ship to location (tax region) J_1BTXSHPT J_1BTREGX CHAR 3 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
EXEMPT No ICMS calculation - Other base J_1BTXEXIC CHAR 1 0
X Yes
NULL No
TAXLAW Tax law: ICMS J_1BTAXLW1 J_1BATL1 CHAR 3 0
CONVEN100 Product Subject to Convenio 100 J_1BTXC100 CHAR 1 0
X Yes
NULL No

J_1BTXIC3V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BTXIC3V GRUOP J_1BTXIC3V MANDT J_1BTXGRUOP Dynamic Determination of Tax-Related Master Data MANDT
J_1BTXIC3V GRUOP J_1BTXIC3V GRUOP J_1BTXGRUOP Dynamic Determination of Tax-Related Master Data GRUOP
J_1BTXIC3V LAND1 J_1BTXIC3V MANDT T005 Countries MANDT
J_1BTXIC3V LAND1 J_1BTXIC3V LAND1 T005 Countries LAND1
J_1BTXIC3V MANDT J_1BTXIC3V MANDT T000 Clients MANDT
J_1BTXIC3V SHIPFROM J_1BTXIC3V MANDT J_1BTREGX Tax region MANDT
J_1BTXIC3V SHIPFROM J_1BTXIC3V LAND1 J_1BTREGX Tax region LAND1
J_1BTXIC3V SHIPFROM J_1BTXIC3V SHIPFROM J_1BTREGX Tax region TXREG
J_1BTXIC3V SHIPTO J_1BTXIC3V MANDT J_1BTREGX Tax region MANDT
J_1BTXIC3V SHIPTO J_1BTXIC3V LAND1 J_1BTREGX Tax region LAND1
J_1BTXIC3V SHIPTO J_1BTXIC3V SHIPTO J_1BTREGX Tax region TXREG
J_1BTXIC3V TAXLAW J_1BTXIC3V MANDT J_1BATL1 Tax Law ICMS MANDT
J_1BTXIC3V TAXLAW J_1BTXIC3V TAXLAW J_1BATL1 Tax Law ICMS TAXLAW