Follow us on LinkedIn for your next SAP project

SAP Table J_1BNFLIN

Nota Fiscal line items

J_1BNFLIN (Nota Fiscal line items) 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_1BNFLIN to other SAP tables.

J_1BNFLIN table fields

Field Data element Checktable Datatype Length Decimals Possible values
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
MATNR
Material Number
MATNR MARA
CHAR
18 0
BWKEY
Valuation Area
BWKEY T001K
CHAR
4 0
BWTAR
Valuation Type
BWTAR_D MBEW
CHAR
10 0
CHARG
Batch Number
CHARG_D MCH1
CHAR
10 0
MATKL
Material Group
MATKL T023
CHAR
9 0
MAKTX
Material Description (Short Text)
MAKTX
CHAR
40 0
DOCREF
Reference to NF
J_1BDOCREF J_1BNFDOC
NUMC
10 0
ITMREF
Reference to item number (Return)
J_1BITMREF
NUMC
6 0
CFOP
CFOP Code and Extension
J_1BCFOP J_1BAG
CHAR
10 0
NBM
Control code for consumption taxes in foreign trade
STEUC T604F
CHAR
16 0
MATORG
Origin of the material
J_1BMATORG
CHAR
1 0
TAXSIT
Tax situation ICMS
J_1BTAXSIT
CHAR
1 0
TAXSI2
Tax situation IPI
J_1BTAXSI2 J_1BAS
NUMC
5 0
OWNPRO
Produced in-house
J_1BOWNPRO
CHAR
1 0
MATUSE
Usage of the material
J_1BMATUSE
CHAR
1 0
REFTYP
Reference type
J_1BREFTYP J_1BAB
CHAR
2 0
REFKEY
Reference to source document
J_1BREFKEY
CHAR
35 0
REFITM
Reference item to source document
J_1BREFITM
NUMC
6 0
MENGE
Quantity
J_1BNETQTY
QUAN
13 3
MEINS
Base unit of measure
J_1BNETUNT T006
UNIT
3 0
NETPR
Net price
J_1BNETPRI
DEC
16 6
NETWR
Net Value
J_1BNETVAL
CURR
15 2
TAXLW1
Tax law: ICMS
J_1BTAXLW1 J_1BATL1
CHAR
3 0
TAXLW2
Tax law: IPI
J_1BTAXLW2 J_1BATL2
CHAR
3 0
TMISS
Service tax - no ICMS/IPI calculation
J_1BTMISS
CHAR
1 0
NETFRE
Net freight value in document currency
J_1BNETFRE
CURR
15 2
NETINS
Net insurance value in document currency
J_1BNETINS
CURR
15 2
NETOTH
Net expenses in document currency
J_1BNETOTH
CURR
15 2
INDUS3
Material CFOP category
J_1BINDUS3
CHAR
2 0
ITMTYP
Nota Fiscal Item Type
J_1BITMTYP J_1BITEMTYPES
CHAR
2 0
NETDIS
Net discount value in document currency
J_1BNETDIS
CURR
15 2
SPCSTO
Nota Fiscal Special Case for CFOP Determination
J_1BSPCSTO
CHAR
2 0
INCLTX
Value and price including ICMS/ISS
J_1BINCLTX
CHAR
1 0
STATIT
Indicator: Statistical item
J_1BSTATIT
CHAR
1 0
WERKS
Plant
WERKS_D T001W
CHAR
4 0
DIRECT
Direction of the movement
J_1BDIRECT
CHAR
1 0
DSTCAT
Destination category
J_1BDSTCAT
CHAR
1 0
INDUS2
Business Place CFOP Category
J_1BINDUS2
CHAR
2 0
NFPRI
Net Price Including Tax
J_1BNFPRI
DEC
16 6
NFNET
Net Value including taxes
J_1BNFNET
CURR
15 2
NFDIS
Discount value including taxes
J_1BNFDIS
CURR
15 2
NFFRE
Freight value including taxes
J_1BNFFRE
CURR
15 2
NFINS
Insurance value including taxes
J_1BNFINS
CURR
15 2
NFOTH
Expenses including taxes
J_1BNFOTH
CURR
15 2
NETWRT
Net value/Freight/Insurance/Expenses/Discount
J_1BNFNETT
CURR
15 2
NFNETT
Net value/Freight/Insurance/Expenses/Discount
J_1BNFNETT
CURR
15 2
MWSKZ
Tax on sales/purchases code
MWSKZ
CHAR
2 0
KALSM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
KALSM_D
CHAR
6 0
ICMSAVR
Average ICMS on Stock Transfers
J_1BICMSAVR
CURR
15 2
SUBTAVR
J_1BSUBTAVR
CURR
15 2
LPPNET
Last Purchase Price (Net)
J_1BLPPNET
CURR
15 2
LPPBRT
Last Purchase Price (Gross)
J_1BLPPBRT
CURR
15 2
ICMSVALP
ICMS on Last Purchase Price
J_1BICMSVAL
CURR
15 2
SUBTVALP
J_1BSUBTVAL
CURR
15 2
TAXLW3
ISS Tax Law
J_1BTAXLW3 J_1BATL3
CHAR
3 0
SRVNR
Activity Number
ASNUM ASMD
CHAR
18 0
TAXSI3
Tax Situation ISS
J_1BTAXSI3
CHAR
2 0
TAXLW4
COFINS Tax Law
J_1BTAXLW4 J_1BATL4A
CHAR
3 0
TAXSI4
Tax Situation COFINS
J_1BTAXSI4
CHAR
2 0
TAXLW5
PIS Tax Law
J_1BTAXLW5 J_1BATL5
CHAR
3 0
TAXSI5
Tax Situation PIS
J_1BTAXSI5
CHAR
2 0
REFTYP_PREV
Previously linked NF-e - type of source document
J_1BREFTYP_PREV
CHAR
2 0
REFKEY_PREV
Previously linked NF-e - key of source document
J_1BREFKEY_PREV
CHAR
35 0
REFITM_PREV
Previously linked NF-e - item of source document
J_1BREFITM_PREV
NUMC
6 0
NBS
Brazilian Nomenclature Services code
J_1BNBS
CHAR
20 0
CEAN
International Article Number (EAN/UPC)
EAN11
CHAR
18 0
XPED
Purchase Order Number
J_1B_PURCH_ORDER_EXT
CHAR
15 0
NITEMPED
Purchase Order Item
J_1B_PURCH_ORD_ITEM_EXT
CHAR
6 0
MODBC
ICMS Tax Base Determination Modality
J_1B_ICMS_BASE_DET
CHAR
1 0
MODBCST
ICMS Sub Trib Tax Base Determination Modality
J_1B_ICST_BASE_DET
CHAR
1 0
MOTDESICMS
ICMS Exemption Reason
J_1B_ICMS_EXEM_REASON
CHAR
1 0
CLENQ
IPI Classification for Tobacco Products and Beverages
J_1B_IPI_CLASS_TBC_BEV
CHAR
5 0
CSELO
IPI Control Seal Code
J_1B_IPI_CONTR_SEAL_CODE
CHAR
10 0
QSELO
IPI Quantity of Control Seal
J_1B_IPI_CONTR_SEAL_QUAN
DEC
12 0
CENQ
IPI Legal Classification Code
J_1B_IPI_LEGAL_CLASS_CODE
CHAR
3 0
NUM_ITEM
External Item Number
J_1B_EXT_ITEM_NUM
NUMC
3 0
IND_MOV
Physical Movement of Materials
J_1B_PHYS_MOVE_MAT
CHAR
1 0
COD_CTA
G/L Account Number for Revenue/Expenses
J_1B_GL_ACCOUNT
CHAR
10 0
VTOTTRIB
Approximate Total Tax Amount
J_1BNF_VTOTTRIB
CURR
15 2
NFCI
FCI Control Number
J_1BNFE_NFCI
CHAR
36 0
KOSTL
Cost Center
J_1BKOSTL
CHAR
10 0
AUFNR
Order Number
J_1BAUFNR
CHAR
12 0
PRCTR
Profit Centers
J_1BPRCTR
CHAR
10 0
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
PS_PSP_PNR
NUMC
8 0
KSTRG
Cost Objects
J_1BKSTRG
CHAR
12 0
NPLNR
Network Number for Account Assignment
J_1BNPLNR
CHAR
12 0
SEGMENT
Segment for Segmental Reporting
FB_SEGMENT
CHAR
10 0
OIH_J1B_TAXVAL
Tax value to be printed in add.field NF (Tax Brazil)
OIH_J1B_TAXVAL
CURR
15 2
OIH_J1B_TAXBASE
Tax base to be printed in add.field NF (Tax Brazil)
OIH_J1B_TAXBASE
CURR
15 2
TRAN_TYPE
Transaction type (sales, purchase, transf. in, transf. out)
OIH_J1B_TRTYPE
CHAR
2 0
INT_OP
Inter / intra operation type
OIH_J1B_INT
CHAR
1 0
CUSTYPE
Customer type (end c./reseller/industry)
OIH_J1B_CTYP
CHAR
1 0
OIHCTXGR
Customer tax group
OIH_J1B_CTXGR
CHAR
4 0
VEND_COD
Vendor type (refinery/mill/other) (Brazil)
OIH_J1B_VTYP
CHAR
1 0
OIHVTXGR
Vendor group (refinery/mill/other)
OIH_J1B_VTXGR
CHAR
4 0
MAT_TAX_GR
Material tax group
OIH_J1B_MTXGR
CHAR
4 0
TAXATION_ORIG
Taxation at origin
OIH_J1B_TAX_ORIG
CHAR
1 0
TAXATION_DEST
Taxation at destination
OIH_J1B_TAX_DEST
CHAR
1 0
OIHCV03
Convenio 03
OIH_CONV_03
CHAR
1 0
OIHCV80O
Convenio 80 at origin
OIH_CONV_80O
CHAR
1 0
OIHCV80D
Convenio 80 at destin.
OIH_CONV_80D
CHAR
1 0
PRICE_CONTROL
Price controlled
OIH_J1B_PR_CNTRL
CHAR
1 0
TAX_CODE
Tax on sales/purchases code
MWSKZ
CHAR
2 0
SUBTR_TYPE
Type of sub. trib. (in-coming or backwards)
OIH_SUBTR_TYPE
CHAR
1 0
PRINT_ICMS
Indicator where to print ICMS
OIH_J1B_IPRINT
CHAR
1 0
STPR_INTRA
Sub.Trib. surcharge percentage rate intrastate
OIH_J1BSTPR_INTRA
DEC
6 2
STPR_INTER
Sub.Trib. surcharge percentage rate interstate =gross margin
OIH_J1BSTPR_INTER
DEC
6 2
FACTOR1
Reduction factor alc.taxation
OIH_J1B_REDFAC
DEC
6 2
FACTOR2
Reduction factor alc.taxation
OIH_J1B_REDFAC
DEC
6 2
CREDIT_IPI
IPI credit allowed
OIH_J1B_TXCREDIP
CHAR
1 0
CREDIT_ICMS
ICMS credit allowed (Brazil taxes)
OIH_J1B_TXCREDIC
CHAR
1 0
TAXTYPE
Incoming taxation type (Brazil)
OIH_J1B_TXITYP
CHAR
1 0
PERCENT
Percentage of backward sub.trib. collected
OIH_J1B_BCKRATE
DEC
6 2
MIXPROD
Product to be mixed with
OIH_J1B_MATNR
CHAR
18 0
FACPIS
Factor for PIS ST calculation
OIH_J1B_FACPIS
DEC
6 2
FACCOF
Factor for COFINS ST calculation
OIH_J1B_FACCOF
DEC
6 2
FORMULA
Formula type for PIS/COFINS ST calculation
OIH_J1B_PIS_FORM
CHAR
1 0
PRINT_IND
Indicator for PIS/COFINS ST printing exceptions
OIH_J1B_IPRINT_PIS
CHAR
1 0
OS_TXLW1
Tax law: ICMS
J_1BTAXLW1
CHAR
3 0
OS_TXLW2
Tax law: IPI
J_1BTAXLW2
CHAR
3 0
TXLW4
Tax law: PIS/COFINS
OIH_J1B_TAXLW4
CHAR
3 0
ZONA_FRANCA
Flag indicating whether operation involves Zona Franca
OIH_J1B_ZFR
CHAR
1 0
OIHVTYPE
Vendor type (refinery/mill/other) (Brazil)
OIH_J1B_VTYP
CHAR
1 0
OIHNOCON
Product with no contrib.(law 87)
OIH_NO_CONTRIB
CHAR
1 0
OIHREFST
Brazil: Refinery ST applied to end customer
OIH_REFST_END
CHAR
1 0
LEG_CLAIM
Indicator: customer is legal claimant for this case
OIH_J1B_ICREF
CHAR
1 0
NO_LBOOK
Don't bring tax amount as tax credit to legal book
OIH_J1B_NLBOOK
CHAR
1 0
PUR_NOTAX
Indicator: for this oper. no tax paid when purchasing
OIH_J1B_PURNOTAX
CHAR
1 0
PISCOF_EXC
PIS/COFINS exception for reading OIH_J1B_PIS
OIH_J1B_PICO_EXC
CHAR
1 0
PMPF_USED_ORIGIN
PMPF used indicator
OIH_J1B_PMPF_USED
CHAR
1 0
PMPF_USED_DESTIN
PMPF used indicator
OIH_J1B_PMPF_USED
CHAR
1 0
OIHSURCHARGE
OIH_J1B_SURCHARGE
CHAR
1 0
DUMMY
Dummy function in length 1
DUMMY
CHAR
1 0

J_1BNFLIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BNFLIN BWKEY J_1BNFLIN MANDT T001K
Valuation area
MANDT
J_1BNFLIN BWKEY J_1BNFLIN BWKEY T001K
Valuation area
BWKEY
J_1BNFLIN BWTAR J_1BNFLIN WERKS MBEW
Material Valuation
BWKEY
J_1BNFLIN BWTAR J_1BNFLIN BWTAR MBEW
Material Valuation
BWTAR
J_1BNFLIN BWTAR J_1BNFLIN MANDT MBEW
Material Valuation
MANDT
J_1BNFLIN BWTAR J_1BNFLIN MATNR MBEW
Material Valuation
MATNR
J_1BNFLIN CFOP J_1BNFLIN MANDT J_1BAG
CFOP
MANDT
J_1BNFLIN CFOP J_1BNFLIN CFOP J_1BAG
CFOP
CFOP
J_1BNFLIN CHARG J_1BNFLIN MANDT MCH1
Batches (if Batch Management Cross-Plant)
MANDT
J_1BNFLIN CHARG J_1BNFLIN MATNR MCH1
Batches (if Batch Management Cross-Plant)
MATNR
J_1BNFLIN CHARG J_1BNFLIN CHARG MCH1
Batches (if Batch Management Cross-Plant)
CHARG
J_1BNFLIN DOCNUM J_1BNFLIN MANDT J_1BNFDOC
Nota Fiscal Header
MANDT
J_1BNFLIN DOCNUM J_1BNFLIN DOCNUM J_1BNFDOC
Nota Fiscal Header
DOCNUM
J_1BNFLIN DOCREF J_1BNFLIN DOCREF J_1BNFDOC
Nota Fiscal Header
DOCNUM
J_1BNFLIN DOCREF J_1BNFLIN MANDT J_1BNFDOC
Nota Fiscal Header
MANDT
J_1BNFLIN ITMTYP J_1BNFLIN MANDT J_1BITEMTYPES
Nota Fiscal Record Types
MANDT
J_1BNFLIN ITMTYP J_1BNFLIN ITMTYP J_1BITEMTYPES
Nota Fiscal Record Types
ITMTYP
J_1BNFLIN MANDT J_1BNFLIN MANDT T000
Clients
MANDT
J_1BNFLIN MATKL J_1BNFLIN MANDT T023
Material Groups
MANDT
J_1BNFLIN MATKL J_1BNFLIN MATKL T023
Material Groups
MATKL
J_1BNFLIN MATNR J_1BNFLIN MANDT MARA
General Material Data
MANDT
J_1BNFLIN MATNR J_1BNFLIN MATNR MARA
General Material Data
MATNR
J_1BNFLIN MEINS J_1BNFLIN MEINS T006
Units of Measurement
MSEHI
J_1BNFLIN MEINS J_1BNFLIN MANDT T006
Units of Measurement
MANDT
J_1BNFLIN NBM J_1BNFLIN NBM T604F
Import Processing: Control Code
STEUC
J_1BNFLIN NBM J_1BNFLIN MANDT T604F
Import Processing: Control Code
MANDT
J_1BNFLIN NBM 'BR' T604F
Import Processing: Control Code
LAND1
J_1BNFLIN REFTYP J_1BNFLIN REFTYP J_1BAB
Reference type
REFTYP
J_1BNFLIN SRVNR SYST MANDT ASMD
Service Master: Basic Data
MANDT
J_1BNFLIN SRVNR J_1BNFLIN SRVNR ASMD
Service Master: Basic Data
ASNUM
J_1BNFLIN TAXLW1 J_1BNFLIN MANDT J_1BATL1
Tax Law ICMS
MANDT
J_1BNFLIN TAXLW1 J_1BNFLIN TAXLW1 J_1BATL1
Tax Law ICMS
TAXLAW
J_1BNFLIN TAXLW2 J_1BNFLIN MANDT J_1BATL2
Tax Law IPI
MANDT
J_1BNFLIN TAXLW2 J_1BNFLIN TAXLW2 J_1BATL2
Tax Law IPI
TAXLAW
J_1BNFLIN TAXLW3 J_1BNFLIN MANDT J_1BATL3
Tax Laws ISS
MANDT
J_1BNFLIN TAXLW3 J_1BNFLIN TAXLW3 J_1BATL3
Tax Laws ISS
TAXLAW
J_1BNFLIN TAXLW4 SYST MANDT J_1BATL4A
Tax Laws COFINS
MANDT
J_1BNFLIN TAXLW4 J_1BNFLIN TAXLW4 J_1BATL4A
Tax Laws COFINS
TAXLAW
J_1BNFLIN TAXLW5 J_1BNFLIN TAXLW5 J_1BATL5
Tax Laws PIS
TAXLAW
J_1BNFLIN TAXLW5 SYST MANDT J_1BATL5
Tax Laws PIS
MANDT
J_1BNFLIN TAXSI2 J_1BNFLIN TAXSI2 J_1BAS
Tax situation IPI
TAXSIT
J_1BNFLIN TAXSI2 J_1BNFLIN MANDT J_1BAS
Tax situation IPI
MANDT
J_1BNFLIN WERKS J_1BNFLIN MANDT T001W
Plants/Branches
MANDT
J_1BNFLIN WERKS J_1BNFLIN WERKS T001W
Plants/Branches
WERKS