SAP ABAP View V_MMIM_EN2 (View of Sales Order Stocks (Without Quantity Update))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

View Type	D	Database View
Database View	V_MMIM_EN2
Short Description	View of Sales Order Stocks (Without Quantity Update)
Root table	MSKA	Sales Order Stock

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MSKA	MSKA
2	MARA
3	MARC
4	T001W
5	T134M

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MSKA	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MSKA	MATNR	JR	EQ			AND	0	0
5	MARC	MANDT	JL	EQ				0	0
6	MSKA	MANDT	JR	EQ			AND	0	0
7	MARC	MATNR	JL	EQ				0	0
8	MSKA	MATNR	JR	EQ			AND	0	0
9	MARC	WERKS	JL	EQ				0	0
10	MSKA	WERKS	JR	EQ			AND	0	0
11	T001W	MANDT	JL	EQ				0	0
12	MSKA	MANDT	JR	EQ			AND	0	0
13	T001W	WERKS	JL	EQ				0	0
14	MSKA	WERKS	JR	EQ			AND	0	0
15	T134M	MANDT	JL	EQ				0	0
16	MSKA	MANDT	JR	EQ			AND	0	0
17	T134M	BWKEY	JL	EQ				0	0
18	T001W	BWKEY	JR	EQ			AND	0	0
19	T134M	MTART	JL	EQ				0	0
20	MARA	MTART	JR	EQ			AND	0	0
21	T134M	MENGU		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MSKA	MANDT		☐	MANDT	☐	Client
2	MATNR	MSKA	MATNR		☐	MATNR	☐	Material Number
3	WERKS	MSKA	WERKS		☐	WERKS_D	☐	Plant
4	LGORT	MSKA	LGORT		☐	LGORT_D	☐	Storage location
5	CHARG	MSKA	CHARG		☐	CHARG_D	☐	Batch Number
6	SOBKZ	MSKA	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
7	VBELN	MSKA	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
8	POSNR	MSKA	POSNR		☐	POSNR	☐	Item number of the SD document
9	LFGJA	MSKA	LFGJA		☐	LFGJA	☐	Fiscal Year of Current Period
10	LFMON	MSKA	LFMON		☐	LFMON	☐	Current period (posting period)
11	KZILL	MSKA	KAILL		☐	KZILL	☐	Physical inventory indicator for whse stock in current year
12	KZILQ	MSKA	KAILQ		☐	KZILQ	☐	Phys. inventory ind. f. stock in qual. insp. in current year
13	KZILS	MSKA	KAILS		☐	KZILS	☐	Physical inventory indicator for blocked stock
14	KZVLL	MSKA	KAVLL		☐	KZVLL	☐	Physical inventory indicator for stock in previous year
15	KZVLQ	MSKA	KAVLQ		☐	KZVLQ	☐	Phys. inventory ind. f. stock in qual. insp. in prev. period
16	KZVLS	MSKA	KAVLS		☐	KZVLS	☐	Phys. inventory indicator for blocked stock in prev. period
17	MTART	MARA	MTART		☐	MTART	☐	Material type
18	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
19	ABCIN	MARC	ABCIN		☐	ABCIN	☐	Physical inventory indicator for cycle counting
20	LABST	MSKA	KALAB		☐	LABST	☐	Valuated Unrestricted-Use Stock
21	INSME	MSKA	KAINS		☐	INSME	☐	Stock in Quality Inspection
22	SPEME	MSKA	KASPE		☐	SPEME	☐	Blocked stock
23	EINME	MSKA	KAEIN		☐	EINME	☐	Total Stock of All Restricted Batches

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in