SAP ABAP Table MPPA (View of planned order (MPS))

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

Table Category	INTTAB	Structure
Structure	MPPA	Table Relationship Diagram
Short Description	View of planned order (MPS)

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	OBART	☐	OBART	OBART	CHAR	1	0	Object type
2	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
3	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
4	PWWRK	☐	PWWRK	WERKS	CHAR	4	0	Production plant in planned order	T001W
5	PAART	☐	PAART	PAART	CHAR	4	0	Order type
6	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
7	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
8	GSMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
9	AVMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
10	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
11	PSTTR	☐	PSTTR	DATUM	DATS	8	0	Order start date in planned order
12	PEDTR	☐	PEDTR	DATUM	DATS	8	0	Order finish date in the planned order
13	PERTR	☐	PERTR	DATUM	DATS	8	0	Planned opening date in planned order
14	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
16	AUFFX	☐	FIX01	XFELD	CHAR	1	0	Indicator: Fixing of Lot Size in Planned Order
17	STLFX	☐	FIX02	XFELD	CHAR	1	0	Indicator: fixing explosion in planned order
18	UMSKZ	☐	PLUMS	XFELD	CHAR	1	0	Conversion indicator for planned order
19	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
20	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
21	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
22	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
23	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
24	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
25	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
26	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
27	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
28	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
29	AKTAL	☐	AKTAL	XFLAG	CHAR	1	0	Current explosion available
30	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
31	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
32	PALTR	☐	PALTR	DATUM	DATS	8	0	Explosion date
33	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
34	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
35	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
36	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	*
37	STALT	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
38	STSTA	☐	STLST	STLST	NUMC	2	0	BOM Statuses	*
39	VERTO	☐	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	T437V
40	AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
41	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
42	FRTHW	☐	FRTHW	FRTHW	CHAR	1	0	Production note in the planned order
43	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
44	EBELN	☐	EVRTN	EBELN	CHAR	10	0	Agreement Number	EKKO
45	EBELP	☐	EVRTP	EBELP	NUMC	5	0	Agreement Item	EKPO
46	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
47	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
48	AKTFT	☐	AKTFT	XFELD	CHAR	1	0	Indicator "Detailed scheduling available"
49	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
50	TRMER	☐	TRMER	TRMER	CHAR	2	0	Scheduling error
51	AKTRT	☐	AKTRT	XFELD	CHAR	1	0	Indicator: "scheduling rates of production" available
52	RATID	☐	RATID	BEDID	NUMC	12	0	Index for the results of scheduling production rates	*
53	RATER	☐	RATER	TRMER	CHAR	2	0	Scheduling error in scheduling production rates
54	AKTGT	☐	AKTGT	XFELD	CHAR	1	0	Indicator: "rough-cut scheduling available"
55	GROID	☐	GROID	BEDID	NUMC	12	0	Index for rough scheduling results	*
56	GROER	☐	GROER	TRMER	CHAR	2	0	Scheduling error in rough scheduling
57	PRNKZ	☐	PRNKZ	KREUZ	CHAR	1	0	Ind.: Leading order in collective order is planned ordre
58	KAPFX	☐	KAPFX	XFELD	CHAR	1	0	Indicator: capacity for planned order dispatched
59	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
60	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
61	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
62	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
63	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
64	PLANR	☐	PLANR	PLANR	CHAR	20	0	Planning segment number
65	PLAAB	☐	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
66	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
67	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
68	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
69	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MPPA	AENNR	AENR	AENNR
2	MPPA	AUFNR	SAFK	AUFNR
3	MPPA	EBELN	EKKO	EBELN
4	MPPA	EBELP	EKPO	EBELP
5	MPPA	EKORG	T024E	EKORG
6	MPPA	FLIEF	LFA1	LIFNR
7	MPPA	KDAUF	VBUK	VBELN
8	MPPA	KNTTP	T163K	KNTTP
9	MPPA	KONNR	EKKO	EBELN
10	MPPA	KTPNR	EKPO	EBELP
11	MPPA	LGORT	T001L	LGORT		1	N
12	MPPA	PSPEL	PRPS	PSPNR
13	MPPA	PWWRK	T001W	WERKS		C	CN
14	MPPA	SERNR	SNUM	SERNR
15	MPPA	SOBKZ	T148	SOBKZ
16	MPPA	VERID	MKAL	VERID
17	MPPA	VERTO	T437V	VERTL

History

Last changed by/on	SAP	20140121
SAP Release Created in