1. Home
  2. Resources
  3. SAP Tables
  4. J_1BNFSTX - Nota Fiscal tax per item

SAP Table J_1BNFSTX

Nota Fiscal tax per item

J_1BNFSTX (Nota Fiscal tax per item) 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_1BNFSTX to other SAP tables.

J_1BNFSTX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DOCNUM Document Number J_1BDOCNUM J_1BNFDOC NUMC 10 0
ITMNUM Document Item Number J_1BITMNUM NUMC 6 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
STATTX Indicator: Statistical tax item J_1BSTATTX CHAR 1 0
X Yes
NULL No
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)
FACTOR Number of units J_1BTXIPF DEC 6 2
UNIT Pauta Unit J_1BTXIPU T006 UNIT 3 0
TAX_LOC Tax Jurisdiction Code For Brazilian Tax Calculation J_1BTXJCD J_1BTXJUR CHAR 15 0
SERVTYPE_IN Official Service Type for Brazil (Incoming) J_1BSERVTYPE_IN J_1BSERVTYPES1 CHAR 16 0
SERVTYPE_OUT Official Service Type for Brazil (Outgoing) J_1BSERVTYPE_OUT J_1BSERVTYPES2 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
BASERED1 Tax base (%) J_1BTXBASE DEC 6 2
BASERED2 Tax base (%) J_1BTXBASE 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
UNIT4DEC UoM for Pauta with 4 Decimal Places (for Reporting Only) J_1BTXPU4DEC UNIT 3 0
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
TAXGRP Tax group J_1BTAXGRP CHAR 4 0
ICMS ICMS
ICST Sub.Trib.
IPI IPI
ISS ISS
ICOP Complement ICMS
ICFR Freight ICMS
ICFS Freight Sub.Trib.
RBST Reimbursement Sub.Trib.
RBIC Reimbursement ICMS
ISSS ISS at location where service is provided
ISSP ISS at location of service provider
PIS PIS
COFI COFINS
WHT General Withholding Tax
WHPI PIS Withholding Tax
WHCO COFINS Withholding Tax
WHCS CSLL Withholding Tax
WHIR IR Withholding Tax
WAT General Withholding Tax - Accumulated
WAPI PIS Withholding Tax - Accumulated
WACO COFINS Withholding Tax - Accumulated
WACS CSLL Withholding Tax - Accumulated
WAIR IR Withholding Tax - Accumulated
II Import Tax
PISS PIS Sub.Trib. (only IS-Oil)
COFS COFINS Sub.Trib. (only IS-Oil)
OI1A PIS
OI1B COFIS
OI21 ICMS Subtrib at refinery
OI2A ICMS Subtrib complementar
OI2B ICMS Subtrib reimbursement
OI2C ICMS Subtrib transfer
OI2D ICMS Subtrib distributor
OI2E ICMS Subtrib reseller/Cust
OI2F ICMS Subtrib backwards
OI2G ICMS Subtrib Protocolo 19
OI2H ICMS Subtrib added to the price
OI1C Offset PIS
OI1D Offset COFINS
OI22 Offset ICMS Subtrib at refinery
OI2K Offset ICMS Subtrib Complimentar
OI2L Offset ICMS Subtrib Reimbursement
OI2M Offset ICMS Subtrib transfer
OI2N Offset ICMS Subtrib Distributor
OI2O Offset ICMS Subtrib Reseller/Cust
OI2P Offset ICMS Subtrib Backwards
OI2Q Offset ICMS Subtrib Protocolo 19
OI2R Offset ICMS Subtrib added to the price
OI3 Calculation by Oil Formula
TAXOFF Offset condition for tax calculation J_1BTAXOFFSET CHAR 1 0
X Yes
NULL No

J_1BNFSTX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BNFSTX DOCNUM J_1BNFSTX DOCNUM J_1BNFDOC Nota Fiscal Header DOCNUM
J_1BNFSTX DOCNUM J_1BNFSTX MANDT J_1BNFDOC Nota Fiscal Header MANDT
J_1BNFSTX MANDT J_1BNFSTX MANDT T000 Clients MANDT
J_1BNFSTX SERVTYPE_IN J_1BNFSTX MANDT J_1BSERVTYPES1 Official Brazilian Service Types - Incoming CLIENT
J_1BNFSTX SERVTYPE_IN 'BR' J_1BSERVTYPES1 Official Brazilian Service Types - Incoming COUNTRY
J_1BNFSTX SERVTYPE_IN J_1BNFSTX TAX_LOC J_1BSERVTYPES1 Official Brazilian Service Types - Incoming TAXJURCODE
J_1BNFSTX SERVTYPE_IN J_1BNFSTX SERVTYPE_IN J_1BSERVTYPES1 Official Brazilian Service Types - Incoming SERVTYPE_IN
J_1BNFSTX SERVTYPE_OUT J_1BNFSTX MANDT J_1BSERVTYPES2 Official Brazilian Service Types - Outgoing CLIENT
J_1BNFSTX SERVTYPE_OUT 'BR' J_1BSERVTYPES2 Official Brazilian Service Types - Outgoing COUNTRY
J_1BNFSTX SERVTYPE_OUT J_1BNFSTX TAX_LOC J_1BSERVTYPES2 Official Brazilian Service Types - Outgoing TAXJURCODE
J_1BNFSTX SERVTYPE_OUT J_1BNFSTX SERVTYPE_OUT J_1BSERVTYPES2 Official Brazilian Service Types - Outgoing SERVTYPE_OUT
J_1BNFSTX TAXTYP J_1BNFSTX MANDT J_1BAJ Tax types MANDT
J_1BNFSTX TAXTYP J_1BNFSTX TAXTYP J_1BAJ Tax types TAXTYP
J_1BNFSTX TAX_LOC J_1BNFSTX TAX_LOC J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation TAXJURCODE
J_1BNFSTX TAX_LOC J_1BNFSTX MANDT J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation CLIENT
J_1BNFSTX TAX_LOC 'BR' J_1BTXJUR Tax Jurisdiction Codes For Brazilian Tax Calculation COUNTRY
J_1BNFSTX UNIT J_1BNFSTX MANDT T006 Units of Measurement MANDT
J_1BNFSTX UNIT J_1BNFSTX UNIT T006 Units of Measurement MSEHI