SAP ABAP Table V_NFLIN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_NFLIN	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PSTDAT	☑	J_1BPSTDAT	DATUM	DATS	8	0	Posting date
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BRANCH	☑	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
5	DOCNUM	☑	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	J_1BNFDOC
6	ITMNUM	☑	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
9	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
10	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
11	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
12	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
13	DOCREF	☐	J_1BDOCREF	J_1BDOCNUM	NUMC	10	0	Reference to NF	J_1BNFDOC
14	ITMREF	☐	J_1BITMREF	J_1BITMNUM	NUMC	6	0	Reference to item number (Return)
15	CFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG
16	NBM	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	T604F
17	MATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
18	TAXSIT	☐	J_1BTAXSIT	J_1BTAXSIT	CHAR	1	0	Tax situation ICMS
19	TAXSI2	☐	J_1BTAXSI2	J_1BTAXSI2	NUMC	5	0	Tax situation IPI	J_1BAS
20	OWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
21	MATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
22	REFTYP	☐	J_1BREFTYP	J_1BREFTYP	CHAR	2	0	Reference type	J_1BAB
23	REFKEY	☐	J_1BREFKEY	J_1BREFKEY	CHAR	35	0	Reference to source document
24	REFITM	☐	J_1BREFITM	J_1BREFITM	NUMC	6	0	Reference item to source document
25	MENGE	☐	J_1BNETQTY	MENG13	QUAN	13	3	Quantity
26	MEINS	☐	J_1BNETUNT	MEINS	UNIT	3	0	Base unit of measure	T006
27	NETPR	☐	J_1BNETPRI	J_1BNFPRI	DEC	16	6	Net price
28	NETWR	☐	J_1BNETVAL	WERTV8	CURR	15	2	Net Value
29	TAXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
30	TAXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
31	TMISS	☐	J_1BTMISS	XFELD	CHAR	1	0	Service tax - no ICMS/IPI calculation
32	NETFRE	☐	J_1BNETFRE	WERTV8	CURR	15	2	Net freight value in document currency
33	NETINS	☐	J_1BNETINS	WERTV8	CURR	15	2	Net insurance value in document currency
34	NETOTH	☐	J_1BNETOTH	WERTV8	CURR	15	2	Net expenses in document currency
35	INDUS3	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
36	ITMTYP	☐	J_1BITMTYP	J_1BITMTYP	CHAR	2	0	Nota Fiscal Item Type	J_1BITEMTYPES
37	NETDIS	☐	J_1BNETDIS	WERTV8	CURR	15	2	Net discount value in document currency
38	SPCSTO	☐	J_1BSPCSTO	J_1BSPCSTO	CHAR	2	0	Nota Fiscal Special Case for CFOP Determination
39	INCLTX	☐	J_1BINCLTX	XFELD	CHAR	1	0	Value and price including ICMS/ISS
40	STATIT	☐	J_1BSTATIT	XFELD	CHAR	1	0	Indicator: Statistical item
41	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_NFLIN	BRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
2	V_NFLIN	BUKRS	T001	BUKRS	KEY	1	CN
3	V_NFLIN	BWKEY	T001K	BWKEY	KEY	1	CN
4	V_NFLIN	BWTAR	MBEW	BWTAR	KEY	1	CN
5	V_NFLIN	CFOP	J_1BAG	CFOP	KEY	1	CN
6	V_NFLIN	CHARG	MCH1	CHARG		1	CN
7	V_NFLIN	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
8	V_NFLIN	DOCREF	J_1BNFDOC	DOCNUM	KEY	1	CN
9	V_NFLIN	ITMTYP	J_1BITEMTYPES	ITMTYP	KEY	1	CN
10	V_NFLIN	MANDT	T000	MANDT	KEY	1	CN
11	V_NFLIN	MATKL	T023	MATKL	KEY	1	CN
12	V_NFLIN	MATNR	MARA	MATNR	KEY	1	CN
13	V_NFLIN	MEINS	T006	MSEHI	KEY	1	CN
14	V_NFLIN	NBM	T604F	STEUC
15	V_NFLIN	REFTYP	J_1BAB	REFTYP	KEY	1	CN
16	V_NFLIN	TAXLW1	J_1BATL1	TAXLAW	KEY	1	CN
17	V_NFLIN	TAXLW2	J_1BATL2	TAXLAW	KEY	1	CN
18	V_NFLIN	TAXSI2	J_1BAS	TAXSIT	KEY	1	CN
19	V_NFLIN	WAERK	TCURC	WAERS	KEY	1	CN
20	V_NFLIN	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in