SAP ABAP Table MDUA (Generated Table for View)

Basic Data

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

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDUA	BNFPO	EBAN	BNFPO	KEY	1	CN
2	MDUA	EKORG	T024E	EKORG	REF	1	N
3	MDUA	EMLIF	LFA1	LIFNR	REF	1	N
4	MDUA	FLIEF	LFA1	LIFNR	REF	1	N
5	MDUA	FRGKZ	T161S	FRGKZ	REF	1	CN
6	MDUA	INFNR	EINA	INFNR	REF	1	N
7	MDUA	KNTTP	T163K	KNTTP	REF	1	N
8	MDUA	KONNR	EKKO	EBELN	REF	1	N
9	MDUA	KTPNR	EKPO	EBELP	REF	1	N
10	MDUA	LGORT	T001L	LGORT	REF	1	N
11	MDUA	MANDT	T000	MANDT	KEY	1	N
12	MDUA	MATNR	MARA	MATNR	KEY	1	CN
13	MDUA	MEINS	T006	MSEHI	REF	1	N
14	MDUA	PSTYP	T163	PSTYP	REF	1	N
15	MDUA	RESWK	T001W	WERKS	KEY	1	CN
16	MDUA	SOBKZ	T148	SOBKZ	REF	1	N
17	MDUA	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in