SAP ABAP Table MDBP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDBP	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	PRTNR	☑	PRTNR	PRTNR	NUMC	10	0	Confirmation number
3	PRTPS	☑	PRTPS	PRTPS	NUMC	4	0	Document log item
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	PWERK	☐	WERKS_PL	WERKS	CHAR	4	0	Planning plant
7	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
8	DATUM	☐	SA_ERDAT	DATUM	DATS	8	0	Created on
9	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
10	REPTP	☐	REPTP	REPTP	CHAR	2	0	Production type
11	STORN	☐	SA_STORN	SA_STORN	CHAR	1	0	Reversal indicator
12	AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
13	KDAUF	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
14	KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
15	PKNUM	☐	PKNUM	PKNUM	CHAR	7	0	Control cycle number	PKHD
16	PKPOS	☐	PKPOS	PKPOS	NUMC	3	0	Kanban item number / control cycle item
17	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
18	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
19	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
20	COBLN	☐	RP_BELNR	CHAR10	CHAR	10	0	Document number for reporting point posting as line item
21	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
22	BDENR	☐	SA_BDENR	CHAR12	CHAR	12	0	PDC number (specific ID for all PDC systems)
23	VAART	☐	SA_VAART	CHAR4	CHAR	4	0	Processing type for backflush
24	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
25	USR01	☐	SA_USR01	CHAR12	CHAR	12	0	User group in backflushing
26	SCHIV	☐	SA_SHIFT	NUM01	NUMC	1	0	Shift number
27	MEINH	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
28	VORNE	☐	PZPNR	VORNR	CHAR	4	0	Reporting point operation number
29	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
30	WAKZH	☐	SA_WAKZH	SA_WAKZH	CHAR	1	0	Post goods issues in the background (worklist)
31	FLKZH	☐	SA_FLKZH	SA_FLKZH	CHAR	1	0	Production activities in the background (worklist)
32	KAPKZH	☐	SA_KAPKZH	SA_KAPKZH	CHAR	1	0	Capacity reduction in the background (worklist)
33	WEBLNR	☐	WEBLNR	BELNR	CHAR	10	0	Number of a document from a goods movement with errors
34	PLCNF	☐	SA_PLCNF	CHAR1	CHAR	1	0	Indicator: Backflushing with planned order
35	OBART	☐	SA_OBART	SA_OBART	CHAR	1	0	Object type for reference in document log - repetitive mfg
36	OBNUM	☐	OBNUM	OBNUM	CHAR	20	0	Object reference: Document log - repetitive manufacturing
37	RSKZG	☐	SA_RSKZG	SA_RSKZG	CHAR	1	0	Ind.: Reservation or dependent requirements object
38	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
39	ACHARG	☐	SA_CHARG	CHARG	CHAR	10	0	Receiving batch for repetitive manufacturing
40	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDBP	AUFNR	SAFK	AUFNR
2	MDBP	KDAUF	VBUK	VBELN
3	MDBP	KDPOS	VBUP	POSNR	KEY	1	CN
4	MDBP	MANDT	T000	MANDT	KEY	1	CN
5	MDBP	MATNR	MARA	MATNR	KEY	1	CN
6	MDBP	MEINH	T006	MSEHI
7	MDBP	PKNUM	PKHD	PKNUM	KEY	1	CN
8	MDBP	VERID	MKAL	VERID
9	MDBP	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in