SAP ABAP View /ISDFPS/MEMMVRQ1 (Index: Requisition/PReq with Material)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-MA-MM (Application Component) Mobile Materials Management
     ⤷ /ISDFPS/ME_MM (Package) Mobile Applications: MM

Basic Data

View Type	D	Database View
Database View	/ISDFPS/MEMMVRQ1
Short Description	Index: Requisition/PReq with Material
Root table	EBAN	Purchase Requisition

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EBAN	EBAN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EBAN	BSTYP		EQ	'B'		AND	0	0
2	EBAN	PACKNO		EQ	'0000000000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	EBAN	MANDT		☐	MANDT	☐	Client
2	DOC_NUM	EBAN	BANFN		☐	BANFN	☐	Purchase requisition number
3	POS_NUM	EBAN	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
4	DOC_KEY_R3	EBAN	BSART		☐	BBSRT	☐	Purchase Requisition Document Type
5	MATERIAL	EBAN	MATNR		☐	MATNR	☐	Material Number
6	MAT1_S_MPN	EBAN	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
7	QUANTITY	EBAN	MENGE		☐	BAMNG	☐	Purchase requisition quantity
8	ORDERED	EBAN	BSMNG		☐	BSMNG	☐	Quantity ordered against this purchase requisition
9	UNIT	EBAN	MEINS		☐	BAMEI	☐	Purchase requisition unit of measure
10	DELETE_IND	EBAN	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
11	CREATE_IND	EBAN	ESTKZ		☐	ESTKZ	☐	Creation indicator (purchase requisition/schedule lines)
12	CLOSED	EBAN	EBAKZ		☐	EBAKZ	☐	Purchase requisition closed
13	PLANT	EBAN	WERKS		☐	EWERK	☐	Plant
14	STORE_LOC	EBAN	LGORT		☐	LGORT_D	☐	Storage location
15	SUPPL_PLANT	EBAN	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
16	SUPPL_STORE_LOC	EBAN	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
17	CREATED_BY	EBAN	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
18	CREATED_DATE	EBAN	BADAT		☐	BADAT	☐	Requisition (request) date
19	CHANGED_DATE	EBAN	ERDAT		☐	AEDAT	☐	Last Changed On

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	20130529
SAP Release Created in	470