SAP ABAP Table BILL_ACC_ITL_NFLIN_DATA (Data Part: Nota Fiscal Item Details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ BEA_BRAZIL (Package) CRM Billing International - Brazil Specific

Basic Data

Table Category	INTTAB	Structure
Structure	BILL_ACC_ITL_NFLIN_DATA	Table Relationship Diagram
Short Description	Data Part: Nota Fiscal Item Details

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	DOCNUM	☐	ITL_NFDOCNUM	NUMC10	NUMC	10	0	Nota Fiscal Document Number
3	ITMNUM	☐	ITL_NFITMNUM	NUMC6	NUMC	6	0	Nota Fiscal Item Number
4	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number
5	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
6	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
7	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
8	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
9	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
10	DOCREF	☐	ITL_NF_DOCREF	NUMC10	NUMC	10	0	Reference to NF
11	ITMREF	☐	ITL_NF_ITMREF	NUMC6	NUMC	6	0	Reference to item number (Return)
12	CFOP_5	☐	ITL_CFOP_5	ITL_CFOP_5	CHAR	5	0	CFOP Code and Extension (Length 5)
13	NCM	☐	CRMT_TAX_TARIFF_CODE	CHAR16	CHAR	16	0	Tax Tariff Code
14	MATORG	☐	ITL_NF_MATORG	ITL_NF_MATORG	CHAR	1	0	Origin of the material
15	TAXSIT_ICMS	☐	ITL_TAXSIT1	ITL_TAXSIT1	CHAR	1	0	ICMS Taxability
16	TAXSIT_IPI	☐	ITL_TAXSIT2	ITL_TAXSIT_IPI	NUMC	5	0	IPI Tax situation
17	OWNPRO	☐	ITL_OWNPRO	XFELD	CHAR	1	0	Produced in-house
18	MATUSE	☐	ITL_MAT_USAGE	ITL_MAT_USAGE	CHAR	1	0	Material Usage
19	REFTYP	☐	ITL_REFTYP	ITL_REFTYP	CHAR	2	0	Reference type
20	REFKEY	☐	ITL_REFKEY	ITL_REFKEY	CHAR	35	0	Reference to source document
21	REFITM	☐	ITL_REFITM	ITL_REFITM	NUMC	6	0	Reference item to source document
22	MENGE	☐	ITL_NFNETQTY	MENGE13	QUAN	13	3	Quantity
23	MEINS	☐	ITL_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure	*
24	NETPR	☐	ITL_NET_PRICE	ITL_NET_PRICE	DEC	16	6	Net price
25	NETWR	☐	ITL_NET_VALUE	ITL_AMOUNT	CURR	15	2	Net Value
26	TAXLAW_ICMS	☐	ITL_TAXLAW1	ITL_TAXLAW1	CHAR	3	0	ICMS Tax Law ID	*
27	TAXLAW_IPI	☐	ITL_TAXLAW2	ITL_TAXLAW2	CHAR	3	0	IPI Tax Law ID	*
28	TMISS	☐	ITL_NF_TMISS	XFELD	CHAR	1	0	Service tax - no ICMS/IPI calculation
29	NETFRE	☐	ITL_NF_NETFRE	ITL_AMOUNT	CURR	15	2	Net freight value in document currency
30	NETINS	☐	ITL_NF_NETINS	ITL_AMOUNT	CURR	15	2	Net insurance value in document currency
31	NETOTH	☐	ITL_NF_NETOTH	ITL_AMOUNT	CURR	15	2	Net expenses in document currency
32	INDUS3	☐	ITL_NF_INDUS3	ITL_NF_INDUS3	CHAR	2	0	Material CFOP category
33	ITMTYP	☐	ITL_NFITMTYP	ITL_NFITMTYP	CHAR	2	0	Nota Fiscal Item Type	*
34	NETDIS	☐	ITL_NF_NETDIS	ITL_AMOUNT	CURR	15	2	Net discount value in document currency
35	SPCSTO	☐	ITL_NF_SPCSTO	ITL_NF_SPCSTO	CHAR	2	0	Nota Fiscal Special Case for CFOP Determination
36	INCLTX	☐	ITL_NF_INCLTX	XFELD	CHAR	1	0	Value and price including ICMS/ISS
37	STATIT	☐	ITL_STATTX	XFELD	CHAR	1	0	Indicator: Statistical Nota Fiscal Tax Item
38	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
39	CFOP	☐	ITL_CFOP	ITL_CFOP	CHAR	10	0	CFOP Code and Extension	*
40	R_REFTYP	☐	ITL_REFTYP	ITL_REFTYP	CHAR	2	0	Reference type
41	R_REFKEY	☐	ITL_REFKEY	ITL_REFKEY	CHAR	35	0	Reference to source document
42	R_AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
43	DIRECT	☐	ITL_NFDIRECT	ITL_NFDIRECT	CHAR	1	0	Direction of Movement
44	DSTCAT	☐	ITL_NF_DSTCAT	ITL_NF_DSTCAT	CHAR	1	0	Destination category
45	INDUS2	☐	ITL_NF_INDUS2	ITL_NF_INDUS2	CHAR	2	0	Business Place CFOP Category
46	NFPRI	☐	ITL_NET_PRICE	ITL_NET_PRICE	DEC	16	6	Net price
47	NFNET	☐	ITL_NF_NET	ITL_AMOUNT	CURR	15	2	Net Value including taxes
48	NFDIS	☐	ITL_NF_NETDIS	ITL_AMOUNT	CURR	15	2	Net discount value in document currency
49	NFFRE	☐	ITL_NF_FRE	ITL_AMOUNT	CURR	15	2	Freight value including taxes
50	NFINS	☐	ITL_NF_INS	ITL_AMOUNT	CURR	15	2	Insurance value including taxes
51	NFOTH	☐	ITL_NF_NETOTH	ITL_AMOUNT	CURR	15	2	Net expenses in document currency
52	NETWRT	☐	ITL_NF_NFNETT	ITL_AMOUNT	CURR	15	2	Net value/Freight/Insurance/Expenses/Discount
53	NFNETT	☐	ITL_NF_NFNETT	ITL_AMOUNT	CURR	15	2	Net value/Freight/Insurance/Expenses/Discount
54	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
55	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
56	ICMSAVR	☐	ITL_NF_ICMSAVR	ITL_AMOUNT	CURR	15	2	Average ICMS on Stock Transfers
57	SUBTAVR	☐	ITL_NF_SUBTAVR	ITL_AMOUNT	CURR	15	2	Average Substituição Tributária on Stock Transfers
58	LPPNET	☐	ITL_NF_LPPNET	ITL_AMOUNT	CURR	15	2	Last Purchase Price (Net)
59	LPPBRT	☐	ITL_NF_LPPBRT	ITL_AMOUNT	CURR	15	2	Last Purchase Price (Gross)
60	ICMSVALP	☐	ITL_NF_ICMSVALP	ITL_AMOUNT	CURR	15	2	ICMS on Last Purchase Price
61	SUBTVALP	☐	ITL_NF_SUBTVALP	ITL_AMOUNT	CURR	15	2	Substituição Tributária on Last Purchase Price

History

Last changed by/on	SAP	20140117
SAP Release Created in	400