SAP ABAP View MDUP (View Between PLPW and PLAF)

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

View Type	D	Database View
Database View	MDUP
Short Description	View Between PLPW and PLAF
Root table	PLPW	Index of the production/delivery plant in the planned order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PLPW	PLPW
2	PLAF

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PLAF	MANDT	JL	EQ				0	0
2	PLPW	MANDT	JR	EQ			AND	0	0
3	PLAF	PLNUM	JL	EQ				0	0
4	PLPW	PLNUM	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PLPW	MANDT		☐	MANDT	☐	Client
2	MATNR	PLPW	MATNR		☐	MATNR	☐	Material Number
3	PWWRK	PLPW	PWWRK		☐	PWWRK	☐	Production plant in planned order
4	PLNUM	PLPW	PLNUM		☐	PLNUM	☐	Planned order number
5	OBART	PLAF	OBART		☐	OBART	☐	Object type
6	PLSCN	PLAF	PLSCN		☐	PLSCN	☐	Planning Scenario of Long-Term Planning
7	PLWRK	PLAF	PLWRK		☐	PLWRK	☐	Planning Plant
8	PAART	PLAF	PAART		☐	PAART	☐	Order type
9	BESKZ	PLAF	BESKZ		☐	BESKZ	☐	Procurement Type
10	SOBES	PLAF	SOBES		☐	SOBES	☐	Special procurement type
11	GSMNG	PLAF	GSMNG		☐	GSMNG	☐	Total planned order quantity
12	AVMNG	PLAF	AVMNG		☐	AVMNG	☐	Fixed quantity of scrap from production
13	ABMNG	PLAF	ABMNG		☐	ABMNG	☐	Reduced quantity in the planned order
14	MEINS	PLAF	MEINS		☐	MEINS	☐	Base Unit of Measure
15	PSTTR	PLAF	PSTTR		☐	PSTTR	☐	Order start date in planned order
16	PEDTR	PLAF	PEDTR		☐	PEDTR	☐	Order finish date in the planned order
17	PERTR	PLAF	PERTR		☐	PERTR	☐	Planned opening date in planned order
18	WEBAZ	PLAF	WEBAZ		☐	PLWEZ	☐	Goods receipt processing time in days
19	DISPO	PLAF	DISPO		☐	DISPO	☐	MRP controller
20	UMSKZ	PLAF	UMSKZ		☐	PLUMS	☐	Conversion indicator for planned order
21	AUFFX	PLAF	AUFFX		☐	PLAFX	☐	Firming indicator for planned order data
22	STLFX	PLAF	STLFX		☐	PLSFX	☐	Fixing indicator for BOM explosion
23	KNTTP	PLAF	KNTTP		☐	KNTTP	☐	Account assignment category
24	KDAUF	PLAF	KDAUF		☐	KDAUF	☐	Sales Order Number
25	KDPOS	PLAF	KDPOS		☐	KDPOS	☐	Item number in Sales Order
26	KDEIN	PLAF	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
27	KZVBR	PLAF	KZVBR		☐	KZVBR	☐	Consumption posting
28	SOBKZ	PLAF	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
29	PSPEL	PLAF	PSPEL		☐	PS_POSNR	☐	WBS Element
30	ARSNR	PLAF	ARSNR		☐	ARSNR	☐	Settlement reservation number
31	ARSPS	PLAF	ARSPS		☐	ARSPS	☐	Item number of the settlement reservation
32	LGORT	PLAF	LGORT		☐	LGORT_D	☐	Storage location
33	SERNR	PLAF	SERNR		☐	SERNR	☐	BOM explosion number
34	REVLV	PLAF	REVLV		☐	REVLV	☐	Revision level
35	RSNUM	PLAF	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
36	VERTO	PLAF	VERTO		☐	SA_VERTO	☐	Distribution key for quantity produced
37	FRTHW	PLAF	FRTHW		☐	FRTHW	☐	Production note in the planned order
38	QUNUM	PLAF	QUNUM		☐	QUNUM	☐	Number of quota arrangement
39	QUPOS	PLAF	QUPOS		☐	QUPOS	☐	Quota arrangement item
40	FLIEF	PLAF	FLIEF		☐	FLIEF	☐	Fixed vendor
41	KONNR	PLAF	KONNR		☐	KONNR	☐	Number of principal purchase agreement
42	KTPNR	PLAF	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
43	EKORG	PLAF	EKORG		☐	EKORG	☐	Purchasing organization
44	PALTR	PLAF	PALTR		☐	PALTR	☐	Explosion date
45	TECHS	PLAF	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
46	STLAN	PLAF	STLAN		☐	STLAN	☐	BOM Usage
47	STALT	PLAF	STALT		☐	STALT	☐	Alternative BOM
48	STSTA	PLAF	STSTA		☐	STLST	☐	BOM Statuses
49	AENNR	PLAF	AENNR		☐	AENNR	☐	Change Number
50	VERID	PLAF	VERID		☐	VERID	☐	Production Version
51	AUFNR	PLAF	AUFNR		☐	SA_AUFNR	☐	Run schedule header number
52	TRART	PLAF	TRART		☐	TRART	☐	Scheduling type of the planned order
53	PLGRP	PLAF	PLGRP		☐	FEVOR	☐	Production Supervisor
54	TERST	PLAF	TERST		☐	TERST	☐	Start date for production
55	TERED	PLAF	TERED		☐	TERED	☐	Finish date for production
56	BEDID	PLAF	BEDID		☐	BEDID	☐	ID of the capacity requirements record
57	AUFPL	PLAF	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
58	TRMKZ	PLAF	TRMKZ		☐	TRMFL	☐	Scheduling indicator
59	TRMER	PLAF	TRMER		☐	TRMER	☐	Scheduling error
60	REDKZ	PLAF	REDKZ		☐	REDKZ	☐	Reduction indicator for scheduling
61	TRMHK	PLAF	TRMHK		☐	TRMHK	☐	Scheduling source
62	PLNNR	PLAF	PLNNR		☐	PLNNR	☐	Key for Task List Group
63	PLNAL	PLAF	PLNAL		☐	PLNAL	☐	Group Counter
64	NUMVR	PLAF	NUMVR		☐	NUMVR	☐	Version number
65	PLNTY	PLAF	PLNTY		☐	PLNTY	☐	Task List Type
66	RGEKZ	PLAF	RGEKZ		☐	CO_RGEKZ	☐	Indicator: Backflushing for order
67	CUOBJ	PLAF	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
68	RATID	PLAF	RATID		☐	RATID	☐	Index for the results of scheduling production rates
69	GROID	PLAF	GROID		☐	GROID	☐	Index for rough scheduling results
70	RATER	PLAF	RATER		☐	RATER	☐	Scheduling error in scheduling production rates
71	GROER	PLAF	GROER		☐	GROER	☐	Scheduling error in rough scheduling
72	SBNUM	PLAF	SBNUM		☐	SBNUM	☐	Simulation requirements number
73	KBNKZ	PLAF	KBNKZ		☐	KBNKZ	☐	Kanban Indicator
74	KAPFX	PLAF	KAPFX		☐	KAPFX	☐	Indicator: capacity for planned order dispatched
75	PSTTI	PLAF	PSTTI		☐	PSTTI	☐	Start Time of Planned Order
76	PEDTI	PLAF	PEDTI		☐	PEDTI	☐	End Time of Planned Order
77	MONKZ	PLAF	MONKZ		☐	MONKZ	☐	Indicator: for assembly order procedures
78	PRNKZ	PLAF	PRNKZ		☐	PRNKZ	☐	Ind.: Leading order in collective order is planned ordre
79	MDPBV	PLAF	MDPBV		☐	MDPBV	☐	Planned order: confirmation of availability
80	VFMNG	PLAF	VFMNG		☐	VFMNG	☐	Planned order: committed quantity
81	MDACH	PLAF	MDACH		☐	MDACH	☐	Action control: planned order processing
82	MDACC	PLAF	MDACC		☐	MDACC	☐	Action: planned order processing
83	MDACD	PLAF	MDACD		☐	MDACD	☐	Date of action: planned order
84	MDACT	PLAF	MDACT		☐	MDACT	☐	Time of action: Planned order processing
85	GSBTR	PLAF	GSBTR		☐	GSBTR_PLAF	☐	Total commitment date of plnd ord. after ATP check f.comps.
86	PLETX	PLAF	PLETX		☐	PLETX	☐	Planned order shift quantities exist
87	PRSCH	PLAF	PRSCH		☐	MD_PRSCHED	☐	Planned order: scheduling using production dates
88	LVSCH	PLAF	LVSCH		☐	MD_LVSCHED	☐	Planned order: leading scheduling level (determines dates)
89	SEQNR	PLAF	SEQNR		☐	CY_SEQNR	☐	Seq. number order
90	VRPLA	PLAF	VRPLA		☐	VRPLA	☐	Indicator: planning without final assembly
91	PBDNR	PLAF	PBDNR		☐	PBDNR	☑	Requirements Plan Number
92	KZBWS	PLAF	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
93	EDGNO	PLAF	EDGNO		☐	EDGNO	☐	Internal number for edge of object dependencies tree
94	BERID	PLAF	BERID		☐	BERID	☐	MRP Area
95	RESLO	PLAF	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in