1. Home
  2. Resources
  3. SAP Tables
  4. J_1BTXDATA - Tax calculation: NF transfer: Tax values

SAP Table J_1BTXDATA

Tax calculation: NF transfer: Tax values

J_1BTXDATA (Tax calculation: NF transfer: Tax values) 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_1BTXDATA to other SAP tables.

J_1BTXDATA table fields

Field Data element Checktable Datatype Length Decimals
KNUMV Number of the document condition KNUMV CHAR 10 0
KPOSN Condition item number KPOSN NUMC 6 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
TAXTYP Tax Type J_1BTAXTYP J_1BAJ CHAR 4 0
BASE Base amount J_1BBASE CURR 15 2
RATE Tax Rate J_1BTXRATE DEC 6 2
TAXVAL Tax value J_1BTAXVAL CURR 15 2
EXCBAS Excluded base amount J_1BEXCBAS CURR 15 2
OTHBAS Other base amount J_1BOTHBAS CURR 15 2
FACTOR Number of units J_1BTXIPF DEC 6 2
UNIT Pauta Unit J_1BTXIPU UNIT 3 0
RECTYPE Nota Fiscal tax record type J_1BTXRT CHAR 1 0
NULL Standard tax record
1 IPI record with IPI Pauta
2 Statistical tax record;eg. ICMS ST Backwards (only IS-Oil)
3 Statistical but added to total of nota fiscal (only IS-Oil)
TAXCHANGE Checkbox XFELD CHAR 1 0
X Yes
NULL No
FOREIGNCUR Checkbox XFELD CHAR 1 0
X Yes
NULL No
DEDUCTIBLE Character Field Length 1 CHAR01 CHAR 1 0
TAX_LOC Tax Jurisdiction Code For Brazilian Tax Calculation J_1BTXJCD CHAR 15 0
SERVTYPE_IN Official Service Type for Brazil (Incoming) J_1BSERVTYPE_IN CHAR 16 0
SERVTYPE_OUT Official Service Type for Brazil (Outgoing) J_1BSERVTYPE_OUT CHAR 16 0
WITHHOLD Withholding Tax (Brazil) J_1BTXWHT CHAR 1 0
X Yes
NULL No
TAXINNET Tax Already Included in Net Value J_1BTAXINNET CHAR 1 0
X Yes
NULL No
WHTCOLLCODE Official Withholding Tax Collection Code J_1BWHTCOLL CHAR 16 0
TXBASE Tax base (%) J_1BTXBASE DEC 6 2
BASERED1 Sub.Trib. Base Reduction 1 (Federal) (in %) J_1BTXSTB1 DEC 6 2
BASERED2 Sub.Trib. Base Reduction 2 (State) (in %) J_1BTXSTB2 DEC 6 2
RATE4DEC Tax Rate with 4 Decimal Places J_1BTXRATE4DEC DEC 8 4
FACTOR4DEC Number of Units for Pauta with 4 DP (for Reporting Only) J_1BTXPF4DEC DEC 6 2
TAX_DIFFERENCE Tax difference used for NF item calculation (PIS/COFINS) J_1BTXDIFF CURR 15 2
SRATE Sub.Trib. surcharge percentage rate J_1BTXSTPR DEC 6 2
PAUTA_BASE Pauta Base Four Decimals J_1BTXPAUTA_BASE_4DEC QUAN 16 4

J_1BTXDATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BTXDATA TAXTYP J_1BTXDATA TAXTYP J_1BAJ Tax types TAXTYP
J_1BTXDATA TAXTYP SYST MANDT J_1BAJ Tax types MANDT