SAP ABAP Table V_N1MATVM (Generated Table for View V_N1MATVM)

Basic Data

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

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	LNRLM	☑	ISH_LNRLP	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of Material Consumption
3	LNRLM_P	☐	ISH_LNRLM	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of a Material Requisition
4	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
5	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
6	LNRLS	☐	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
7	MATNR	☐	ISH_MMATNR_CONS	MATNR	CHAR	18	0	IS-H: Material Number for Material Consumption
8	MBLNR	☐	ISH_MBLNR	BELNR	CHAR	10	0	IS-H MM: Number of a material document
9	MBPOS	☐	ISH_MBPOS	BNFPO	NUMC	5	0	IS-H MM: Item Number on the Material Document
10	MJAHR	☐	ISH_MJAHR	GJAHR	NUMC	4	0	IS-H MM: Material Document Year
11	EXMAT	☐	ISH_EXMAT	ISH_EXMAT	CHAR	20	0	IS-H: External material number
12	ANFOE	☐	ANFOE	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit Requesting Service
13	ANPOE	☐	ANPOE	ORGID	CHAR	8	0	IS-H: Nursing Org. Unit Requesting Service
14	ERBOE	☐	ERBOE	ORGID	CHAR	8	0	IS-H: Organizational Unit that Performs the Service
15	PREIS	☐	ISH_MPREIS	ISH_WERTV6	CURR	11	2	IS-H MM: Price of material
16	WAERS	☐	ISH_WAERS	WAERS	CUKY	5	0	IS-H: Currency Key
17	ABRKZ	☐	ISH_MABRKZ	ISH_MABRKZ	CHAR	1	0	IS-H: Indicator whether Material can be Billed for
18	MENGE	☐	ISH_MENGE	MENGV8	QUAN	15	3	IS-H MM: Quantity of Material
19	MEINS	☐	ISH_MEINS	MEINS	UNIT	3	0	IS-H: Unit of Measure	T006
20	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
21	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application
22	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
23	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
24	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
25	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
26	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
27	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
28	AUSSMEN	☐	N1AUSSMEN	N1ISH_MENGE	QUAN	5	0	Scrap Quantity
29	AUSSMEINH	☐	N1AUSSMEINH	MEINS	UNIT	3	0	Scrap Unit of Measure
30	VARBKZ	☐	N1VARBKZ	XFELD	CHAR	1	0	'Processed' Indicator
31	ENDDATE	☐	N1ENDDATE	DATE	DATS	8	0	Closing Date
32	WERKS	☐	ISH_MWERKS	WERKS	CHAR	4	0	IS-H MM: Issuing Point for Material (e.g. Pharmacy)
33	SHKZG	☐	ISH_MSHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
34	STBEL	☐	ISH_LNRLPREF	ISH_LNRLM	CHAR	10	0	IS-H MM: Reference to Cancellation Doc. of Mat. Consumption
35	LNRLS_M	☐	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
36	SERNR	☐	N1SERNR	TEXT20	CHAR	20	0	Serial Number
37	FRTXT	☐	N1MATFRTXT	TEXT80	CHAR	80	0	Free Text for Material

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_N1MATVM	FALNR	NFAL	FALNR	KEY	1	N
2	V_N1MATVM	MANDT	T000	MANDT	KEY	1	CN
3	V_N1MATVM	MEINS	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in