SAP ABAP Table MDBPS (Generated Table for View MDBPS)

Basic Data

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

Delivery and Maintenance

Pool/cluster	BLPK
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
6	DATUM	☐	SA_ERDAT	DATUM	DATS	8	0	Created on
7	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
8	REPTP	☐	REPTP	REPTP	CHAR	2	0	Production type
9	STORN	☐	SA_STORN	SA_STORN	CHAR	1	0	Reversal indicator
10	AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
11	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
12	BDENR	☐	SA_BDENR	CHAR12	CHAR	12	0	PDC number (specific ID for all PDC systems)
13	VAART	☐	SA_VAART	CHAR4	CHAR	4	0	Processing type for backflush
14	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
15	USR01	☐	SA_USR01	CHAR12	CHAR	12	0	User group in backflushing
16	SCHIV	☐	SA_SHIFT	NUM01	NUMC	1	0	Shift number
17	MEINH	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
18	VORNE	☐	PZPNR	VORNR	CHAR	4	0	Reporting point operation number
19	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
20	WAKZH	☐	SA_WAKZH	SA_WAKZH	CHAR	1	0	Post goods issues in the background (worklist)
21	FLKZH	☐	SA_FLKZH	SA_FLKZH	CHAR	1	0	Production activities in the background (worklist)
22	KAPKZH	☐	SA_KAPKZH	SA_KAPKZH	CHAR	1	0	Capacity reduction in the background (worklist)
23	PLCNF	☐	SA_PLCNF	CHAR1	CHAR	1	0	Indicator: Backflushing with planned order
24	OBART	☐	SA_OBART	SA_OBART	CHAR	1	0	Object type for reference in document log - repetitive mfg
25	OBNUM	☐	OBNUM	OBNUM	CHAR	20	0	Object reference: Document log - repetitive manufacturing
26	PWERK	☐	WERKS_PL	WERKS	CHAR	4	0	Planning plant
27	ACHARG	☐	SA_CHARG	CHARG	CHAR	10	0	Receiving batch for repetitive manufacturing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDBPS	AUFNR	SAFK	AUFNR
2	MDBPS	MANDT	T000	MANDT	KEY	1	CN
3	MDBPS	MATNR	MARA	MATNR	KEY	1	CN
4	MDBPS	MEINH	T006	MSEHI
5	MDBPS	VERID	MKAL	VERID
6	MDBPS	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20040116
SAP Release Created in