SAP table J_1BNFLIN (Nota Fiscal line items)

SAP table J_1BNFLIN has 3 primary key fields being MANDT,DOCNUM,ITMNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
DOCNUM Document Number NUMC 10 0 J_1BNFDOC J_1BDOCNUM
ITMNUM Document Item Number NUMC 6 0 J_1BITMNUM
MATNR Material Number CHAR 40 0 MARA MATNR
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 MBEW BWTAR_D
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
MATKL Material Group CHAR 9 0 T023 MATKL
MAKTX Material Description CHAR 40 0 MAKTX
DOCREF Reference to NF NUMC 10 0 J_1BNFDOC J_1BDOCREF
ITMREF Reference to item number (Return) NUMC 6 0 J_1BITMREF
CFOP CFOP Code and Extension CHAR 10 0 J_1BAGN J_1BCFOP
NBM Control code for consumption taxes in foreign trade CHAR 16 0 T604F STEUC
MATORG Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
TAXSIT Tax situation ICMS CHAR 1 0 J_1BTAXSIT
0 Liable to ICMS
1 Liable to ICMS + substituição tributária
2 Liable to ICMS (reduced tax base)
3 Exempt or nontaxable + substituição tributária
4 Exempt
5 Suspended
6 ICMS already levied by substituição tributária
7 Liable to ICMS (reduced tax base) + substituição tributária
9 Other
A Nontaxable
B Deferred
TAXSI2 Tax situation IPI NUMC 5 0 J_1BAS J_1BTAXSI2
OWNPRO Produced in-house CHAR 1 0 J_1BOWNPRO
MATUSE Usage of the material CHAR 1 0 J_1BMATUSE
0 Resale
1 Industrialisation
2 Consumption
3 Asset
4 Consumption for Main Activity
REFTYP Reference type CHAR 2 0 J_1BAB J_1BREFTYP
REFKEY Reference to source document CHAR 35 0 J_1BREFKEY
REFITM Reference item to source document NUMC 6 0 J_1BREFITM
MENGE Quantity QUAN 13 3 J_1BNETQTY
MEINS Base unit of measure UNIT 3 0 T006 J_1BNETUNT
NETPR Net price DEC 16 6 J_1BNETPRI
NETWR Net Value CURR 15 2 J_1BNETVAL
TAXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
TAXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
TMISS Service tax - no ICMS/IPI calculation CHAR 1 0 J_1BTMISS
NETFRE Net freight value in document currency CURR 15 2 J_1BNETFRE
NETINS Net insurance value in document currency CURR 15 2 J_1BNETINS
NETOTH Net expenses in document currency CURR 15 2 J_1BNETOTH
INDUS3 Material CFOP category CHAR 2 0 J_1BINDUS3
00 material
01 electricity
02 communication
03 transportation
04 animal
ITMTYP Nota Fiscal Item Type CHAR 2 0 J_1BITEMTYPES J_1BITMTYP
NETDIS Net discount value in document currency CURR 15 2 J_1BNETDIS
SPCSTO Nota Fiscal Special Case for CFOP Determination CHAR 2 0 J_1BSPCSTO
CFOP Determination Without Substituicao Tributaria
01 CFOP Determination with Substituicao Tributaria
02 CFOP for Services That Are Subject to ISS Tax
03 Cancellation of the Amount of Transport Services
50 Use as Required
60 Use as Required
70 Use as Required
80 Use as Required
90 Use as Required
INCLTX Value and price including ICMS/ISS CHAR 1 0 J_1BINCLTX
STATIT Indicator: Statistical item CHAR 1 0 J_1BSTATIT
WERKS Plant CHAR 4 0 T001W WERKS_D
DIRECT Direction of the movement CHAR 1 0 J_1BDIRECT
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
DSTCAT Destination category CHAR 1 0 J_1BDSTCAT
0 Same state
1 Different state
2 Different country
3 Same state - Free Trade Zone
4 Different state - Free Trade Zone
INDUS2 Business Place CFOP Category CHAR 2 0 J_1BINDUS2
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 rural
NFPRI Net Price Including Tax DEC 16 6 J_1BNFPRI
NFNET Net Value including taxes CURR 15 2 J_1BNFNET
NFDIS Discount value including taxes CURR 15 2 J_1BNFDIS
NFFRE Freight value including taxes CURR 15 2 J_1BNFFRE
NFINS Insurance value including taxes CURR 15 2 J_1BNFINS
NFOTH Expenses including taxes CURR 15 2 J_1BNFOTH
NETWRT Net value/Freight/Insurance/Expenses/Discount CURR 15 2 J_1BNFNETT
NFNETT Net value/Freight/Insurance/Expenses/Discount CURR 15 2 J_1BNFNETT
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 KALSM_D
ICMSAVR Average ICMS on Stock Transfers CURR 15 2 J_1BICMSAVR
SUBTAVR Average Substituição Tributária on Stock Transfers CURR 15 2 J_1BSUBTAVR
LPPNET Last Purchase Price (Net) CURR 15 2 J_1BLPPNET
LPPBRT Last Purchase Price (Gross) CURR 15 2 J_1BLPPBRT
ICMSVALP ICMS on Last Purchase Price CURR 15 2 J_1BICMSVAL
SUBTVALP Substituição Tributária on Last Purchase Price CURR 15 2 J_1BSUBTVAL
TAXLW3 ISS Tax Law CHAR 3 0 J_1BATL3 J_1BTAXLW3
SRVNR Activity Number CHAR 18 0 ASMD ASNUM
TAXSI3 Tax Situation ISS CHAR 2 0 * J_1BTAXSI3
TAXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
TAXSI4 Tax Situation COFINS CHAR 2 0 * J_1BTAXSI4
TAXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5
TAXSI5 Tax Situation PIS CHAR 2 0 * J_1BTAXSI5
REFTYP_PREV Previously linked NF-e - type of source document CHAR 2 0 J_1BREFTYP_PREV
REFKEY_PREV Previously linked NF-e - key of source document CHAR 35 0 J_1BREFKEY_PREV
REFITM_PREV Previously linked NF-e - item of source document NUMC 6 0 J_1BREFITM_PREV
NBS Brazilian Nomenclature Services code CHAR 20 0 J_1BNBS
CEAN International Article Number (EAN/UPC) CHAR 18 0 EAN11
XPED Purchase Order Number CHAR 15 0 J_1B_PURCH_ORDER_EXT
NITEMPED Purchase Order Item CHAR 6 0 J_1B_PURCH_ORD_ITEM_EXT
MODBC ICMS Tax Base Determination Modality CHAR 1 0 J_1B_ICMS_BASE_DET
0 Added Value Margin (%)
1 Pauta (Value)
2 Maximum Tabled Price (Value)
3 Operation Value
MODBCST ICMS Sub Trib Tax Base Determination Modality CHAR 1 0 J_1B_ICST_BASE_DET
0 Tabled Price or Suggested Maximum
1 Negative List (Value)
2 Positive List (Value)
3 Neutra List (Value)
4 Added Value Margin (%)
5 Pauta (Value)
6 Operation Value
MOTDESICMS ICMS Exemption Reason CHAR 2 0 J_1B_ICMS_EXEM_REASON
1 Taxi
10 Physically disabled person with driving license
11 Physically disabled person without driving license
12 Dep for Agricultural and Livestock Promotion and Development
16 Rio 2016 Olympics
2 Physically Handicapped
3 Agricultural Producer
4 Fleet Owner/Rental
5 Diplomatic/Consular
6 SUVs and Motorcycles in the West Amazon and Free Comm. Zone
7 SUFRAMA
8 Sales to public agencies
9 Others
90 Requested by Tax Authority
CLENQ IPI Classification for Tobacco Products and Beverages CHAR 5 0 J_1B_IPI_CLASS_TBC_BEV
CSELO IPI Control Seal Code CHAR 10 0 J_1B_IPI_CONTR_SEAL_CODE
QSELO IPI Quantity of Control Seal DEC 12 0 J_1B_IPI_CONTR_SEAL_QUAN
CENQ IPI Legal Classification Code CHAR 3 0 J_1BTCENQ J_1B_IPI_LEGAL_CLASS_CODE
NUM_ITEM External Item Number NUMC 3 0 J_1B_EXT_ITEM_NUM
IND_MOV Physical Movement of Materials CHAR 1 0 J_1B_PHYS_MOVE_MAT
0 Yes
1 No
COD_CTA G/L Account Number for Revenue/Expenses CHAR 10 0 * J_1B_GL_ACCOUNT
NRECOPI RECOPI Number CHAR 20 0 J_1BNFE_NRECOPI
INDINCENTIVO Tax Incentive NUMC 1 0 J_1BNFE_INDINCENTIVO
VICMSDESON Exemption value of ICMS DEC 15 2 J_1BNFE_VICMSDESON
NFICMSDESON Exemption Value of ICMS Including Taxes DEC 15 2 J_1BNFE_NFICMSDESON
VICMSDIF Value of deferment ICMS DEC 15 2 J_1BNFE_RFC_VICMSDIF
VICMSSTRET Wth. ICMS ST Value already charged CURR 15 2 J_1BNFE_RFC_ICMSSTRETTAXVAL
VBCSTRET WTH. ICMS ST Base already charged CURR 15 2 J_1BNFE_RFC_ICMSSTRETBASE
MEINS_TRIB Tributary Unit of Measure UNIT 3 0 * J_1B_UNTTRB
MENGE_TRIB Tributary Quantity of Material DEC 15 4 J_1B_QTDTRB
CEST ICMS ST Legal Classification Code CHAR 9 0 J_1BTCEST J_1BCEST
VDESPADU Customs Expense Value DEC 15 2 J_1BNFE_VDESPADU
VIOF IOF Value DEC 15 2 J_1BNFE_VIOF
CEAN_TRIB Tributary International Article Number (EAN/UPC) CHAR 18 0 J_1B_EAN_TRIB
UTRIB Tributary Unit of Measure CHAR 6 0 J_1BNFE_UTRIB
PST Final Consumer Rate DEC 7 4 J_1BNFE_PST
VBCFCPSTRET FCP Calculation Basis withheld for Tributary Substitution CURR 15 2 J_1BNFE_VBCFCPSTRET
PFCPSTRET Percentage of Tributary Substitution withheld from FCP DEC 7 4 J_1BNFE_PFCPSTRET
VFCPSTRET Tributary Substitution amount withheld from FCP DEC 15 2 J_1BNFE_VFCPSTRET
VBCSTDEST ICMS ST Calculation Basis from UF Destination CURR 15 2 J_1BNFE_VBCSTDEST
VICMSSTDEST ICMS ST Value from UF Destination CURR 15 2 J_1BNFE_VICMSSTDEST
INDESCALA Relevant Scale Indicator CHAR 1 0 J_1BNFE_INDESCALA
N No
S Yes
CNPJFAB Producer CNPJ NUMC 14 0 J_1BNFE_CNPJFAB
CBENEF State Fiscal Benefit Code CHAR 10 0 J_1BNFE_CB_ICMS J_1BNFE_CBENEF
PREDBCEFET Reduction Percentage of Effective Calculation Basis DEC 7 4 J_1BNFE_PREDBCEFET
VBCEFET Effective Calculation Basis Amount CURR 15 2 J_1BNFE_VBCEFET
PICMSEFET Effective ICMS Rate DEC 7 4 J_1BNFE_PICMSEFET
VICMSEFET Effective ICMS Amount CURR 15 2 J_1BNFE_VICMSEFET
VOUTRO Statistical Amount DEC 15 2 J_1BNFE_VOUTRO
XPROD Product or Service Description CHAR 120 0 J_1BNFE_XPROD
TAX_INFO_SOURCE Source of Tax Burden CHAR 10 0 J_1BNFSE_TAX_INFO_SOURCE
TAX_RATE Percentage of Tax Burden DEC 7 4 J_1BNFSE_TAX_RATE
VICMSSUBSTITUTO Substitute ICMS Value Charged in Previous Transaction DEC 15 2 J_1BNFE_VICMSSUBSTITUTO
MUNICIPAL_ISS_TAXSIT CST for ISS Defined by Municipality CHAR 3 0 * LOGBR_MUNICIPAL_ISS_TAXSIT
CPRB CPRB Relevance CHAR 1 0 LOGBR_CPRB
No
X Yes
REINF_SERVICE_CODE EFD-REINF Service Type Code CHAR 9 0 LOGBR_REINF LOGBR_REINF_CODE
LC116_SERVICE_CODE LC 116 Service Type Code CHAR 5 0 LOGBR_ABRASF LOGBR_ABRASF_CODE
COD_CTA_PIS G/L Account Number for Revenue/Expenses for PIS CHAR 10 0 * J_1BNFE_COD_CTA_PIS
COD_CTA_COFINS G/L Account Number for Revenue/Expenses for COFINS CHAR 10 0 * J_1BNFE_COD_CTA_COFINS
CBENEF_ISS Benefit Code for ISS Tax CHAR 10 0 J_1BNFSE_CBENEF J_1BNFE_CBENEF_ISS
STSTCL_VICMSDESON Statistical Exemption Value of ICMS DEC 15 2 J_1BNFE_STSTCL_VICMSDESON
P_MVAST Margin percentage of value Added from ICMS ST DEC 7 4 J_1BNFE_PMVAST
PICMSDEF Tax Rate for ICMS Deferral DEC 7 4 J_1BNFE_PICMSDEF
ITEM_CNAE_PARTNER CNAE Code for Partner CHAR 7 0 J_1BTCNAE LOGBR_ITEM_CNAE_PARTNER
ITEM_CNAE_BUPLA CNAE Business Place Code CHAR 7 0 J_1BTCNAE LOGBR_ITEM_CNAE_BUPLA
IND_NAT_FRT Freight Nature Indicator CHAR 1 0 LOGBR_IND_NAT_FRT
0 Sales operations with costs borne by the seller
1 Sales operations with costs borne by the buyer
2 Purchase trans. (inventory material, credit generators)
3 Purchase trans. (inventory material, non-credit generators)
4 Transfer of finished goods between legal entities
5 Transfer of semi-finished goods between legal entities
9 Other
CBARRA Internal Barcode CHAR 30 0 J_1BNFE_CBARRA
CBARRA_TRIB Internal Tributary Barcode CHAR 30 0 J_1BNFE_CBARRA_TRIB
VICMSSTDESON Exemption Value of ICMS ST DEC 15 2 J_1BNFE_VICMSSTDESON
MOTDESICMSST ICMS ST Exemption Reason CHAR 2 0 J_1BNFE_MOTDESICMSST
12 Dep for Agricultural and Livestock Promotion and Development
3 Agricultural Producer
9 Others
PDIF ICMS Deferral Percentage DEC 7 4 J_1BNFE_PDIF
VFCPDIF Deferred FCP Value DEC 15 2 J_1BNFE_VFCPDIF
PFCPDEF Tax Rate for FCP Deferral DEC 7 4 J_1BNFE_PFCPDEF
PFCPDIF FCP Deferral Percentage DEC 7 4 J_1BNFE_PFCPDIF
COFINSST COFINS ST Value CURR 15 2 J_1BNFE_COFINSST
PISST PIS ST Value CURR 15 2 J_1BNFE_PISST
INDSOMACOFINSST Indicator of COFINS ST in the Nota Fiscal Total CHAR 1 0 J_1BNFE_INDSOMACOFINSST
Not applicable
0 COFINS ST amount not considered in total amount of the NF-e
1 COFINS ST amount considered in total amount of the NF-e
INDSOMAPISST Indicator of PIS ST in the Nota Fiscal Total CHAR 1 0 J_1BNFE_INDSOMAPISST
Not applicable
0 PIS ST amount not considered in total amount of the NF-e
1 PIS ST amount considered in total amount of the NF-e
NFCOFINSST COFINS ST Value Including Taxes CURR 15 2 J_1BNFE_NFCOFINSST
NFPISST PIS ST Value Including Taxes CURR 15 2 J_1BNFE_NFPISST
EXCLUDED_ICMS_FROM_PISCOFINS ICMS Amount Excluded from the PIS/COFINS Calculation Base DEC 15 2 J_1BNFE_EXC_ICMS_PISCOF
VTOTTRIB Approximate Total Tax Amount CURR 15 2 J_1BNF_VTOTTRIB
NFCI FCI Number CHAR 36 0 J_1BNFE_NFCI
KOSTL Cost Center CHAR 10 0 * J_1BKOSTL
AUFNR Order Number CHAR 12 0 * J_1BAUFNR
PRCTR Profit Centers CHAR 10 0 J_1BPRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
KSTRG Cost Objects CHAR 12 0 * J_1BKSTRG
NPLNR Network Number for Account Assignment CHAR 12 0 * J_1BNPLNR
SEGMENT Segment for Segmental Reporting CHAR 10 0 * FB_SEGMENT
PIPIDEVOL Quantity Returned (%) DEC 5 2 J_1BNFE_PRET
NPROCESSO Judicial or Administrative Process Number which Suspends ISS CHAR 30 0 J_1BNFE_NPROCESSO
NAT_BC_CRED Credit Basis CHAR 2 0 ITMF_NAT_BC_CRED
01 Goods aquisition for resale
02 Goods aquisition to be used as input
03 Services aquisition to be used as input
04 Electric and thermal energy, including steam
05 Building renting
06 Machinery and equipment renting
07 Warehousing of goods and freight in sales operations
08 Counterinstallments in leasing
09 Machinery, equipment and other goods as assets (depreciation
10 Machinery, equipment and other goods as assets (aquisition)
11 Amortization of buildings and improvements on real estate
12 Return of sales subject to noncumulative incidence
13 Other operations entitled to credit
14 Freight an transpotation activities - Subcontracting
15 Real estate activity - Cost for property
16 Real estate activity - Budgeted cost of unit not completed
17 Cleaning, maintence, transport. and meal voucher, uniforms
18 Opening stock of goods

J_1BNFLIN foreign key relationships

Table Field Check Table Check Field
0 J_1BNFLIN BWTAR MBEW Material Valuation MANDT
0 J_1BNFLIN BWTAR MBEW Material Valuation MATNR
0 J_1BNFLIN BWTAR MBEW Material Valuation BWKEY
0 J_1BNFLIN BWTAR MBEW Material Valuation BWTAR
1 J_1BNFLIN CBENEF J_1BNFE_CB_ICMS Benefit Code for ICMS Tax REGIO
0 J_1BNFLIN CBENEF_ISS J_1BNFSE_CBENEF Benefit Code for ISS Tax TAXJURCODE
1 J_1BNFLIN CENQ J_1BTCENQ IPI Legal Classification Code MANDT
0 J_1BNFLIN CEST J_1BTCEST ICMS ST Legal Classification Code MANDT
1 J_1BNFLIN CFOP J_1BAGN CFOP with Version Number VERSION
1 J_1BNFLIN CFOP J_1BAGN CFOP with Version Number CFOP
0 J_1BNFLIN CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 J_1BNFLIN DOCNUM J_1BNFDOC Nota Fiscal Header MANDT
1 J_1BNFLIN DOCNUM J_1BNFDOC Nota Fiscal Header DOCNUM
0 J_1BNFLIN DOCREF J_1BNFDOC Nota Fiscal Header MANDT
0 J_1BNFLIN DOCREF J_1BNFDOC Nota Fiscal Header DOCNUM
1 J_1BNFLIN ITMTYP J_1BITEMTYPES Nota Fiscal Record Types MANDT
1 J_1BNFLIN ITMTYP J_1BITEMTYPES Nota Fiscal Record Types ITMTYP
0 J_1BNFLIN LC116_SERVICE_CODE LOGBR_ABRASF LC 116 Service Types CLIENT
0 J_1BNFLIN LC116_SERVICE_CODE LOGBR_ABRASF LC 116 Service Types ABRASF
1 J_1BNFLIN MANDT T000 Clients MANDT
0 J_1BNFLIN MATKL T023 Material Groups MATKL
1 J_1BNFLIN MATNR MARA General Material Data MANDT
1 J_1BNFLIN MATNR MARA General Material Data MATNR
0 J_1BNFLIN MEINS T006 Units of Measurement MANDT
0 J_1BNFLIN MEINS T006 Units of Measurement MSEHI
1 J_1BNFLIN NBM T604F Import Processing: Control Code MANDT
1 J_1BNFLIN NBM T604F Import Processing: Control Code LAND1
0 J_1BNFLIN REINF_SERVICE_CODE LOGBR_REINF EFD-REINF Service Types CLIENT
1 J_1BNFLIN TAXLW4 J_1BATL4A Tax Laws COFINS MANDT
0 J_1BNFLIN TAXLW5 J_1BATL5 PIS Tax Law MANDT
1 J_1BNFLIN TAXSI2 J_1BAS Tax situation IPI MANDT
0 J_1BNFLIN WERKS T001W Plants/Branches MANDT
0 J_1BNFLIN WERKS T001W Plants/Branches WERKS