SAP ABAP View MDUA (View for Stock Transfer Purchase Requisition's Reqmts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

View Type	D	Database View
Database View	MDUA
Short Description	View for Stock Transfer Purchase Requisition's Reqmts
Root table	EBUB	Index for Stock Transport Requisitions for Material

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EBAN	MANDT	JL	EQ				0	0
2	EBUB	MANDT	JR	EQ			AND	0	0
3	EBAN	BANFN	JL	EQ				0	0
4	EBUB	BANFN	JR	EQ			AND	0	0
5	EBAN	BNFPO	JL	EQ				0	0
6	EBUB	BNFPO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EBUB	MANDT		☐	MANDT	☐	Client
2	MATNR	EBUB	MATNR		☐	MATNR	☐	Material Number
3	RESWK	EBUB	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
4	BANFN	EBUB	BANFN		☐	BANFN	☐	Purchase requisition number
5	BNFPO	EBUB	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
6	LOEKZ	EBAN	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
7	BSAKZ	EBAN	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
8	BSART	EBAN	BSART		☐	BBSRT	☐	Purchase Requisition Document Type
9	PSTYP	EBAN	PSTYP		☐	PSTYP	☐	Item category in purchasing document
10	ESTKZ	EBAN	ESTKZ		☐	ESTKZ	☐	Creation indicator (purchase requisition/schedule lines)
11	STATU	EBAN	STATU		☐	BANST	☐	Processing status of purchase requisition
12	WERKS	EBAN	WERKS		☐	EWERK	☐	Plant
13	LFDAT	EBAN	LFDAT		☐	EINDT	☐	Item delivery date
14	WEBAZ	EBAN	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
15	FRGDT	EBAN	FRGDT		☐	FRGDT	☐	Purchase Requisition Release Date
16	MENGE	EBAN	MENGE		☐	BAMNG	☐	Purchase requisition quantity
17	BSMNG	EBAN	BSMNG		☐	BSMNG	☐	Quantity ordered against this purchase requisition
18	KNTTP	EBAN	KNTTP		☐	KNTTP	☐	Account assignment category
19	SOBKZ	EBAN	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
20	KZVBR	EBAN	KZVBR		☐	KZVBR	☐	Consumption posting
21	UMSOK	EBAN	UMSOK		☐	UMSOK	☐	Special stock indicator for physical stock transfer
22	SERNR	EBAN	SERNR		☐	SERNR	☐	BOM explosion number
23	MEINS	EBAN	MEINS		☐	BAMEI	☐	Purchase requisition unit of measure
24	MNG02	EBAN	MNG02		☐	MNG06	☐	Committed quantity
25	DAT01	EBAN	DAT01		☐	DAT05	☐	Committed date
26	CUOBJ	EBAN	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
27	EBAKZ	EBAN	EBAKZ		☐	EBAKZ	☐	Purchase requisition closed
28	KZBWS	EBAN	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
29	TECHS	EBAN	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
30	FRGKZ	EBAN	FRGKZ		☐	FRGKZ	☐	Release Indicator
31	FIXKZ	EBAN	FIXKZ		☐	BAFIX	☐	Purchase requisition is fixed
32	ARSNR	EBAN	ARSNR		☐	ARSNR	☐	Settlement reservation number
33	VORAB	EBAN	VORAB		☐	VORAB	☐	Advance procurement: project stock
34	REVLV	EBAN	REVLV		☐	REVLV	☐	Revision level
35	LGORT	EBAN	LGORT		☐	LGORT_D	☐	Storage location
36	EKORG	EBAN	EKORG		☐	EKORG	☐	Purchasing organization
37	FLIEF	EBAN	FLIEF		☐	FLIEF	☐	Fixed vendor
38	INFNR	EBAN	INFNR		☐	INFNR	☐	Number of purchasing info record
39	KONNR	EBAN	KONNR		☐	KONNR	☐	Number of principal purchase agreement
40	KTPNR	EBAN	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
41	PLIFZ	EBAN	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
42	BERID	EBAN	BERID		☐	BERID	☐	MRP Area
43	RESLO	EBAN	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
44	CHARG	EBAN	CHARG		☐	CHARG_D	☐	Batch Number
45	EMLIF	EBAN	EMLIF		☐	EMLIF	☐	Vendor to be supplied/who is to receive delivery
46	LBLKZ	EBAN	LBLKZ		☐	LBLKZ	☐	Subcontracting vendor

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