SAP ABAP Table J_1BNFLIN_SD (Nota Fiscal Line Items and SD Tax Code's Customer Usage)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	J_1BNFLIN_SD	Table Relationship Diagram
Short Description	Nota Fiscal Line Items and SD Tax Code's Customer Usage

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in