SAP ABAP Table MDBA (View: purchase requisition for conversion)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	MDBA	Table Relationship Diagram
Short Description	View: purchase requisition for conversion

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	BANNR	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
2	BANPS	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
3	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	T161
4	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	MENGE	☐	UMMNG	MENGE	QUAN	13	3	Quantity to be converted
9	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
10	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
11	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
12	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
13	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
14	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
15	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
16	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
17	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
18	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
19	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
20	KONPS	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
21	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
22	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
23	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
24	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
25	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
26	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
27	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
28	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
29	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
30	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
31	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
32	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
33	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
34	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
35	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
36	FIXKZ	☐	BAFIX	XFELD	CHAR	1	0	Purchase requisition is fixed
37	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
38	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
39	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
40	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
41	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
42	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
43	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
44	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
45	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
46	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
47	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
48	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
49	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
50	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
51	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
52	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
53	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
54	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
55	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
56	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	T001W
57	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDBA	BESWK	T001W	WERKS	REF	1	N
2	MDBA	BSART	T161	BSART		1	N
3	MDBA	DISPO	T024D	DISPO
4	MDBA	EKGRP	T024	EKGRP	KEY	1	CN
5	MDBA	KNTTP	T163K	KNTTP
6	MDBA	LGORT	T001L	LGORT
7	MDBA	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
8	MDBA	PRIO_URG	PURG	PRIO_URG	REF	1	CN
9	MDBA	SERNR	SNUM	SERNR

History

Last changed by/on	SAP	20110901
SAP Release Created in