SAP ABAP Table J_1BNFLIN (Nota Fiscal line items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1BNFLIN	Table Relationship Diagram
Short Description	Nota Fiscal line items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DOCNUM	☑	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	J_1BNFDOC
3	ITMNUM	☑	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
6	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
7	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
8	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
9	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
10	DOCREF	☐	J_1BDOCREF	J_1BDOCNUM	NUMC	10	0	Reference to NF	J_1BNFDOC
11	ITMREF	☐	J_1BITMREF	J_1BITMNUM	NUMC	6	0	Reference to item number (Return)
12	CFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG
13	NBM	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
14	MATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
15	TAXSIT	☐	J_1BTAXSIT	J_1BTAXSIT	CHAR	1	0	Tax situation ICMS
16	TAXSI2	☐	J_1BTAXSI2	J_1BTAXSI2	NUMC	5	0	Tax situation IPI	J_1BAS
17	OWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
18	MATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
19	REFTYP	☐	J_1BREFTYP	J_1BREFTYP	CHAR	2	0	Reference type	J_1BAB
20	REFKEY	☐	J_1BREFKEY	J_1BREFKEY	CHAR	35	0	Reference to source document
21	REFITM	☐	J_1BREFITM	J_1BREFITM	NUMC	6	0	Reference item to source document
22	MENGE	☐	J_1BNETQTY	MENG13	QUAN	13	3	Quantity
23	MEINS	☐	J_1BNETUNT	MEINS	UNIT	3	0	Base unit of measure	T006
24	NETPR	☐	J_1BNETPRI	J_1BNFPRI	DEC	16	6	Net price
25	NETWR	☐	J_1BNETVAL	WERTV8	CURR	15	2	Net Value
26	TAXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
27	TAXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
28	TMISS	☐	J_1BTMISS	XFELD	CHAR	1	0	Service tax - no ICMS/IPI calculation
29	NETFRE	☐	J_1BNETFRE	WERTV8	CURR	15	2	Net freight value in document currency
30	NETINS	☐	J_1BNETINS	WERTV8	CURR	15	2	Net insurance value in document currency
31	NETOTH	☐	J_1BNETOTH	WERTV8	CURR	15	2	Net expenses in document currency
32	INDUS3	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
33	ITMTYP	☐	J_1BITMTYP	J_1BITMTYP	CHAR	2	0	Nota Fiscal Item Type	J_1BITEMTYPES
34	NETDIS	☐	J_1BNETDIS	WERTV8	CURR	15	2	Net discount value in document currency
35	SPCSTO	☐	J_1BSPCSTO	J_1BSPCSTO	CHAR	2	0	Nota Fiscal Special Case for CFOP Determination
36	INCLTX	☐	J_1BINCLTX	XFELD	CHAR	1	0	Value and price including ICMS/ISS
37	STATIT	☐	J_1BSTATIT	XFELD	CHAR	1	0	Indicator: Statistical item
38	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
39	DIRECT	☐	J_1BDIRECT	J_1BDIRECT	CHAR	1	0	Direction of the movement
40	DSTCAT	☐	J_1BDSTCAT	J_1BDSTCAT	CHAR	1	0	Destination category
41	INDUS2	☐	J_1BINDUS2	J_1BINDUS2	CHAR	2	0	Business Place CFOP Category
42	NFPRI	☐	J_1BNFPRI	J_1BNFPRI	DEC	16	6	Net Price Including Tax
43	NFNET	☐	J_1BNFNET	WERTV8	CURR	15	2	Net Value including taxes
44	NFDIS	☐	J_1BNFDIS	WERTV8	CURR	15	2	Discount value including taxes
45	NFFRE	☐	J_1BNFFRE	WERTV8	CURR	15	2	Freight value including taxes
46	NFINS	☐	J_1BNFINS	WERTV8	CURR	15	2	Insurance value including taxes
47	NFOTH	☐	J_1BNFOTH	WERTV8	CURR	15	2	Expenses including taxes
48	NETWRT	☐	J_1BNFNETT	WERTV8	CURR	15	2	Net value/Freight/Insurance/Expenses/Discount
49	NFNETT	☐	J_1BNFNETT	WERTV8	CURR	15	2	Net value/Freight/Insurance/Expenses/Discount
50	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
51	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
52	ICMSAVR	☐	J_1BICMSAVR	J_1BTAXVAL	CURR	15	2	Average ICMS on Stock Transfers
53	SUBTAVR	☐	J_1BSUBTAVR	J_1BTAXVAL	CURR	15	2	Average Substituição Tributária on Stock Transfers
54	LPPNET	☐	J_1BLPPNET	WERTV8	CURR	15	2	Last Purchase Price (Net)
55	LPPBRT	☐	J_1BLPPBRT	WERTV8	CURR	15	2	Last Purchase Price (Gross)
56	ICMSVALP	☐	J_1BICMSVAL	J_1BTAXVAL	CURR	15	2	ICMS on Last Purchase Price
57	SUBTVALP	☐	J_1BSUBTVAL	J_1BTAXVAL	CURR	15	2	Substituição Tributária on Last Purchase Price
58	TAXLW3	☐	J_1BTAXLW3	J_1BTAXLW3	CHAR	3	0	Tax law: ISS	J_1BATL3
59	SRVNR	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
60	.INCLUDE	☐				0	0	Taxlaws and situation for Pis, Cofins & ISS
61	TAXSI3	☐	J_1BTAXSI3	J_1BTAXSI3	CHAR	2	0	Tax Situation ISS	*
62	TAXLW4	☐	J_1BTAXLW4	J_1BTAXLW4	CHAR	3	0	COFINS Tax Law	J_1BATL4A
63	TAXSI4	☐	J_1BTAXSI4	J_1BTAXSI4	CHAR	2	0	Tax Situation COFINS	*
64	TAXLW5	☐	J_1BTAXLW5	J_1BTAXLW5	CHAR	3	0	PIS Tax Law	J_1BATL5
65	TAXSI5	☐	J_1BTAXSI5	J_1BTAXSI5	CHAR	2	0	Tax Situation PIS	*
66	REFTYP_PREV	☐	J_1BREFTYP_PREV	J_1BREFTYP	CHAR	2	0	Previously linked NF-e - type of source document	*
67	REFKEY_PREV	☐	J_1BREFKEY_PREV	J_1BREFKEY	CHAR	35	0	Previously linked NF-e - key of source document
68	REFITM_PREV	☐	J_1BREFITM_PREV	J_1BREFITM	NUMC	6	0	Previously linked NF-e - item of source document
69	NBS	☐	J_1BNBS	J_1BNBS	CHAR	20	0	Brazilian Nomenclature Services code	*
70	.INCLUDE	☐				0	0	Nota Fiscal Item Additional Fields
71	CEAN	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
72	XPED	☐	J_1B_PURCH_ORDER_EXT	CHAR15	CHAR	15	0	Purchase Order Number
73	NITEMPED	☐	J_1B_PURCH_ORD_ITEM_EXT	CHAR6	CHAR	6	0	Purchase Order Item
74	MODBC	☐	J_1B_ICMS_BASE_DET	J_1B_ICMS_BASE_DET	CHAR	1	0	ICMS Tax Base Determination Modality
75	MODBCST	☐	J_1B_ICST_BASE_DET	J_1B_ICST_BASE_DET	CHAR	1	0	ICMS Sub Trib Tax Base Determination Modality
76	MOTDESICMS	☐	J_1B_ICMS_EXEM_REASON	J_1B_ICMS_EXEM_REASON	CHAR	1	0	ICMS Exemption Reason
77	CLENQ	☐	J_1B_IPI_CLASS_TBC_BEV	CHAR5	CHAR	5	0	IPI Classification for Tobacco Products and Beverages
78	CSELO	☐	J_1B_IPI_CONTR_SEAL_CODE	CHAR10	CHAR	10	0	IPI Control Seal Code
79	QSELO	☐	J_1B_IPI_CONTR_SEAL_QUAN	DEC12	DEC	12	0	IPI Quantity of Control Seal
80	CENQ	☐	J_1B_IPI_LEGAL_CLASS_CODE	CHAR3	CHAR	3	0	IPI Legal Classification Code
81	NUM_ITEM	☐	J_1B_EXT_ITEM_NUM	NUMC3	NUMC	3	0	External Item Number
82	IND_MOV	☐	J_1B_PHYS_MOVE_MAT	J_1B_PHYS_MOVE_MAT	CHAR	1	0	Physical Movement of Materials
83	COD_CTA	☐	J_1B_GL_ACCOUNT	SAKNR	CHAR	10	0	G/L Account Number for Revenue/Expenses	*
84	VTOTTRIB	☐	J_1BNF_VTOTTRIB	WERTV8	CURR	15	2	Approximate Total Tax Amount
85	NFCI	☐	J_1BNFE_NFCI		CHAR	36	0	FCI Number
86	.INCLUDE	☐				0	0	Nota fiscal writer cost information of posting
87	KOSTL	☐	J_1BKOSTL	KOSTL	CHAR	10	0	Cost Center	*
88	AUFNR	☐	J_1BAUFNR	AUFNR	CHAR	12	0	Order Number	*
89	PRCTR	☐	J_1BPRCTR	PRCTR	CHAR	10	0	Profit Centers	*
90	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
91	KSTRG	☐	J_1BKSTRG	KSTRG	CHAR	12	0	Cost Objects	*
92	NPLNR	☐	J_1BNPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
93	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BNFLIN	BWKEY	T001K	BWKEY	KEY	1	CN
2	J_1BNFLIN	BWTAR	MBEW	BWTAR	KEY	1	CN
3	J_1BNFLIN	CFOP	J_1BAG	CFOP	KEY	1	CN
4	J_1BNFLIN	CHARG	MCH1	CHARG		1	CN
5	J_1BNFLIN	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
6	J_1BNFLIN	DOCREF	J_1BNFDOC	DOCNUM	KEY	1	CN
7	J_1BNFLIN	ITMTYP	J_1BITEMTYPES	ITMTYP	KEY	1	CN
8	J_1BNFLIN	MANDT	T000	MANDT	KEY	1	CN
9	J_1BNFLIN	MATKL	T023	MATKL	KEY	1	CN
10	J_1BNFLIN	MATNR	MARA	MATNR	KEY	1	CN
11	J_1BNFLIN	MEINS	T006	MSEHI	KEY	1	CN
12	J_1BNFLIN	NBM	T604F	STEUC
13	J_1BNFLIN	REFTYP	J_1BAB	REFTYP	KEY	1	CN
14	J_1BNFLIN	SRVNR	ASMD	ASNUM	KEY	1	CN
15	J_1BNFLIN	TAXLW1	J_1BATL1	TAXLAW	KEY	1	CN
16	J_1BNFLIN	TAXLW2	J_1BATL2	TAXLAW	KEY	1	CN
17	J_1BNFLIN	TAXLW3	J_1BATL3	TAXLAW	KEY	1	CN
18	J_1BNFLIN	TAXLW4	J_1BATL4A	TAXLAW	KEY	1	CN
19	J_1BNFLIN	TAXLW5	J_1BATL5	TAXLAW	KEY	1	CN
20	J_1BNFLIN	TAXSI2	J_1BAS	TAXSIT	KEY	1	CN
21	J_1BNFLIN	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in