J_1BTXST3 SAP (Dynamic Calculation of Substituição Tributária) Table details

Dictionary Type: Table
Description: Dynamic Calculation of Substituição Tributária




ABAP Code to SELECT data from J_1BTXST3
Related tables to J_1BTXST3
Access table J_1BTXST3




Table field list including key, data, relationships and ABAP select examples

J_1BTXST3 is a standard SAP Table which is used to store Dynamic Calculation of Substituição Tributária data and is available within R/3 SAP systems depending on the version and release level.

The J_1BTXST3 table consists of various fields, each holding specific information or linking keys about Dynamic Calculation of Substituição Tributária data available in SAP. These include LAND1 (Country Key), SHIPFROM (Ship from location (tax region)), SHIPTO (Ship to location (tax region)), GRUOP (Tax Group for Dynamic Tax Exceptions).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1BTXST3 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LAND1Country Key LAND1CHAR3T005LAND1LND
SHIPFROMShip from location (tax region) J_1BTXSHPFCHAR3J_1BTREGXJ_1BTXREG
SHIPTOShip to location (tax region) J_1BTXSHPTCHAR3J_1BTREGXJ_1BTXREG
GRUOPTax Group for Dynamic Tax Exceptions J_1BTXGRPNUMC2J_1BTXGRUOPJ_1BTXGRPH_J_1B_TXGRP
VALUEDynamic Key Field J_1BVALUECHAR20J_1BVALUE
VALUE2Dynamic Key Field J_1BVALUE2CHAR20J1BD2J_1BVALUE2
VALUE3Dynamic Key Field J_1BVALUE3CHAR20J1BD3J_1BVALUE3
STGRPCustomer group for Substituiçao Tributária calculation J_1BTCSTCHAR3J_1BTXSTGJ_1BTCST1
VALIDFROMDate from which the tax rule is valid J_1BTXDATFCHAR8INVDTDATUM_INVJ_1B_GET_DATE
VALIDTODate to which the tax rule is valid J_1BTXDATTCHAR8INVDTDATUM_INVJ_1B_GET_DATE
SUR_TYPESub.Trib. calculation rule J_1BTXSTTNUMC1J_1BTXSTT
RATESub.Trib. surcharge percentage rate J_1BTXSTPRDEC6(2) J_1BTXRATE
PRICESub.Trib. fixed price per unit J_1BTXSTFPDEC15(2) J_1BTXSTFP
FACTORNumber of units for Sub.Trib. calc. (price per n units) J_1BTXSTFDEC6(2) DEC4_2
UNITUnit for Sub.Trib. calculation (price per n units) J_1BTXSTUUNIT3T006CUNITMEINS
BASERED1Sub.Trib. Base Reduction 1 (Federal) (in %) J_1BTXSTB1DEC6(2) J_1BTXBASE
BASERED2Sub.Trib. Base Reduction 2 (State) (in %) J_1BTXSTB2DEC6(2) J_1BTXBASE
ICMSBASERICMS Reduction for Sub.Trib. (in %) J_1BTXSTI1DEC6(2) J_1BTXBASE
MINPRICEMinimum Price Per Item Is Basis for Substituição Tributária J_1BTXSTMPDEC15(2) J_1BTXSTFP
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
MINFACTSub.Trib. Percentage to be Applied on Minimum Price J_1BTXSTPFDEC6(2) J_1BTXRATE
SURCHINCompare Minimum Price Without Surcharge J_1BTXSTSCCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table J_1BTXST3 using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1BTXST3 to SELECT all data from the table
DATA: WA_J_1BTXST3 TYPE J_1BTXST3.

SELECT SINGLE *
FROM J_1BTXST3
INTO CORRESPONDING FIELDS OF WA_J_1BTXST3
WHERE...

How to access SAP table J_1BTXST3

Within an ECC or HANA version of SAP you can also view further information about J_1BTXST3 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!