SAP ABAP Table ROXAX40271 (Generated Table for View V_NFLIN)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI (Application Component) Financial Accounting
     ⤷ ID-BR-NF (Package) Brazilian Legal Reporting: Nota Fiscal

Basic Data

Table Category	INTTAB	Structure
Structure	ROXAX40271	Table Relationship Diagram
Short Description	Generated Table for View V_NFLIN

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	T149D
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	*
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	ROXAX40271	BRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
2	ROXAX40271	BUKRS	T001	BUKRS	KEY	1	CN
3	ROXAX40271	BWKEY	T001K	BWKEY	KEY	1	CN
4	ROXAX40271	BWTAR	T149D	BWTAR	KEY	1	CN
5	ROXAX40271	CFOP	J_1BAG	CFOP	KEY	1	CN
6	ROXAX40271	CHARG	MCH1	CHARG		1	CN
7	ROXAX40271	DOCNUM	J_1BNFDOC	DOCNUM	KEY	1	CN
8	ROXAX40271	DOCREF	J_1BNFDOC	DOCNUM	KEY	1	CN
9	ROXAX40271	MANDT	T000	MANDT	KEY	1	CN
10	ROXAX40271	MATKL	T023	MATKL	KEY	1	CN
11	ROXAX40271	MATNR	MARA	MATNR	KEY	1	CN
12	ROXAX40271	MEINS	T006	MSEHI	KEY	1	CN
13	ROXAX40271	NBM	T604F	STEUC
14	ROXAX40271	REFTYP	J_1BAB	REFTYP	KEY	1	CN
15	ROXAX40271	TAXLW1	J_1BATL1	TAXLAW	KEY	1	CN
16	ROXAX40271	TAXLW2	J_1BATL2	TAXLAW	KEY	1	CN
17	ROXAX40271	TAXSI2	J_1BAS	TAXSIT	KEY	1	CN
18	ROXAX40271	WAERK	TCURC	WAERS	KEY	1	CN
19	ROXAX40271	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in