SAP ABAP View PLIX (Join view for planned order access to WBS element)

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	PLIX
Short Description	Join view for planned order access to WBS element
Root table	PSPL	Index project -> planned order

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PLAF	*		☐		☐
2	MANDT	PLAF	MANDT		☐	MANDT	☐	Client
3	PLNUM	PLAF	PLNUM		☐	PLNUM	☐	Planned order number
4	MATNR	PLAF	MATNR		☐	PLMAT	☐	Planning material
5	PLWRK	PLAF	PLWRK		☐	PLWRK	☐	Planning Plant
6	PWWRK	PLAF	PWWRK		☐	PWWRK	☐	Production plant in planned order
7	PAART	PLAF	PAART		☐	PAART	☐	Order type
8	BESKZ	PLAF	BESKZ		☐	BESKZ	☐	Procurement Type
9	SOBES	PLAF	SOBES		☐	SOBES	☐	Special procurement type
10	GSMNG	PLAF	GSMNG		☐	GSMNG	☐	Total planned order quantity
11	TLMNG	PLAF	TLMNG		☐	TLMNG	☐	Partial lot quantity
12	AVMNG	PLAF	AVMNG		☐	AVMNG	☐	Fixed quantity of scrap from production
13	BDMNG	PLAF	BDMNG		☐	BDMNG	☐	Requirement Quantity
14	PSTTR	PLAF	PSTTR		☐	PSTTR	☐	Order start date in planned order
15	PEDTR	PLAF	PEDTR		☐	PEDTR	☐	Order finish date in the planned order
16	PERTR	PLAF	PERTR		☐	PERTR	☐	Planned opening date in planned order
17	WEBAZ	PLAF	WEBAZ		☐	PLWEZ	☐	Goods receipt processing time in days
18	DISPO	PLAF	DISPO		☐	DISPO	☐	MRP controller
19	UMSKZ	PLAF	UMSKZ		☐	PLUMS	☐	Conversion indicator for planned order
20	AUFFX	PLAF	AUFFX		☐	PLAFX	☐	Firming indicator for planned order data
21	STLFX	PLAF	STLFX		☐	PLSFX	☐	Fixing indicator for BOM explosion
22	KNTTP	PLAF	KNTTP		☐	KNTTP	☐	Account assignment category
23	KDAUF	PLAF	KDAUF		☐	KDAUF	☐	Sales Order Number
24	KDPOS	PLAF	KDPOS		☐	KDPOS	☐	Item number in Sales Order
25	KDEIN	PLAF	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
26	PROJN	PLAF	PROJN		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
27	RSNUM	PLAF	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
28	QUNUM	PLAF	QUNUM		☐	QUNUM	☐	Number of quota arrangement
29	QUPOS	PLAF	QUPOS		☐	QUPOS	☐	Quota arrangement item
30	FLIEF	PLAF	FLIEF		☐	FLIEF	☐	Fixed vendor
31	KONNR	PLAF	KONNR		☐	KONNR	☐	Number of principal purchase agreement
32	KTPNR	PLAF	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
33	EKORG	PLAF	EKORG		☐	EKORG	☐	Purchasing organization
34	LGORT	PLAF	LGORT		☐	LGORT_D	☐	Storage location
35	NUMVR	PLAF	NUMVR		☐	NUMVR	☐	Version number
36	KZVBR	PLAF	KZVBR		☐	KZVBR	☐	Consumption posting
37	SOBKZ	PLAF	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
38	PSPEL	PLAF	PSPEL		☐	PS_POSNR	☐	WBS Element
39	SERNR	PLAF	SERNR		☐	SERNR	☐	BOM explosion number
40	PALTR	PLAF	PALTR		☐	PALTR	☐	Explosion date
41	TECHS	PLAF	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
42	STLAN	PLAF	STLAN		☐	STLAN	☐	BOM Usage
43	STALT	PLAF	STALT		☐	STALT	☐	Alternative BOM
44	STSTA	PLAF	STSTA		☐	STLST	☐	BOM Statuses
45	AENNR	PLAF	AENNR		☐	AENNR	☐	Change Number
46	ARSNR	PLAF	ARSNR		☐	ARSNR	☐	Settlement reservation number
47	ARSPS	PLAF	ARSPS		☐	ARSPS	☐	Item number of the settlement reservation
48	VERTO	PLAF	VERTO		☐	SA_VERTO	☐	Distribution key for quantity produced
49	VERID	PLAF	VERID		☐	VERID	☐	Production Version
50	AUFNR	PLAF	AUFNR		☐	SA_AUFNR	☐	Run schedule header number
51	TRART	PLAF	TRART		☐	TRART	☐	Scheduling type of the planned order
52	PLGRP	PLAF	PLGRP		☐	FEVOR	☐	Production Supervisor
53	TERST	PLAF	TERST		☐	TERST	☐	Start date for production
54	TERED	PLAF	TERED		☐	TERED	☐	Finish date for production
55	BEDID	PLAF	BEDID		☐	BEDID	☐	ID of the capacity requirements record
56	AUFPL	PLAF	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
57	LINID	PLAF	LINID		☐	SP_OPID	☐	ID for a schedule record
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	PLNTY	PLAF	PLNTY		☐	PLNTY	☐	Task List Type
65	FRTHW	PLAF	FRTHW		☐	FRTHW	☐	Production note in the planned order
66	RGEKZ	PLAF	RGEKZ		☐	CO_RGEKZ	☐	Indicator: Backflushing for order
67	MEINS	PLAF	MEINS		☐	MEINS	☐	Base Unit of Measure
68	CUOBJ	PLAF	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
69	REVLV	PLAF	REVLV		☐	REVLV	☐	Revision level
70	ABMNG	PLAF	ABMNG		☐	ABMNG	☐	Reduced quantity in the planned order
71	RATID	PLAF	RATID		☐	RATID	☐	Index for the results of scheduling production rates
72	GROID	PLAF	GROID		☐	GROID	☐	Index for rough scheduling results
73	RATER	PLAF	RATER		☐	RATER	☐	Scheduling error in scheduling production rates
74	GROER	PLAF	GROER		☐	GROER	☐	Scheduling error in rough scheduling
75	OBART	PLAF	OBART		☐	OBART	☐	Object type
76	PLSCN	PLAF	PLSCN		☐	PLSCN	☐	Planning Scenario of Long-Term Planning
77	SBNUM	PLAF	SBNUM		☐	SBNUM	☐	Simulation requirements number
78	KBNKZ	PLAF	KBNKZ		☐	KBNKZ	☐	Kanban Indicator
79	KAPFX	PLAF	KAPFX		☐	KAPFX	☐	Indicator: capacity for planned order dispatched
80	SEQNR	PLAF	SEQNR		☐	CY_SEQNR	☐	Seq. number order
81	PSTTI	PLAF	PSTTI		☐	PSTTI	☐	Start Time of Planned Order
82	PEDTI	PLAF	PEDTI		☐	PEDTI	☐	End Time of Planned Order
83	MONKZ	PLAF	MONKZ		☐	MONKZ	☐	Indicator: for assembly order procedures
84	PRNKZ	PLAF	PRNKZ		☐	PRNKZ	☐	Ind.: Leading order in collective order is planned ordre
85	MDPBV	PLAF	MDPBV		☐	MDPBV	☐	Planned order: confirmation of availability
86	VFMNG	PLAF	VFMNG		☐	VFMNG	☐	Planned order: committed quantity
87	MDACH	PLAF	MDACH		☐	MDACH	☐	Action control: planned order processing
88	MDACC	PLAF	MDACC		☐	MDACC	☐	Action: planned order processing
89	MDACD	PLAF	MDACD		☐	MDACD	☐	Date of action: planned order
90	MDACT	PLAF	MDACT		☐	MDACT	☐	Time of action: Planned order processing
91	GSBTR	PLAF	GSBTR		☐	GSBTR_PLAF	☐	Total commitment date of plnd ord. after ATP check f.comps.
92	PLETX	PLAF	PLETX		☐	PLETX	☐	Planned order shift quantities exist
93	PRSCH	PLAF	PRSCH		☐	MD_PRSCHED	☐	Planned order: scheduling using production dates
94	LVSCH	PLAF	LVSCH		☐	MD_LVSCHED	☐	Planned order: leading scheduling level (determines dates)
95	KZAVC	PLAF	KZAVC		☐	KZAVC	☐	Indicator for type of availability check
96	VRPLA	PLAF	VRPLA		☐	VRPLA	☐	Indicator: planning without final assembly
97	PBDNR	PLAF	PBDNR		☐	PBDNR	☐	Requirements Plan Number
98	AGREQ	PLAF	AGREQ		☐	AGREQ	☐	Requirements totaling
99	UMREZ	PLAF	UMREZ		☐	UMREZ	☐	Numerator for Conversion to Base Units of Measure
100	UMREN	PLAF	UMREN		☐	UMREN	☐	Denominator for conversion to base units of measure
101	ERFMG	PLAF	ERFMG		☐	ERFMG	☐	Quantity in unit of entry
102	ERFME	PLAF	ERFME		☐	ERFME	☐	Unit of entry
103	RQNUM	PLAF	RQNUM		☐	RQNUM	☐	Requirements record number
104	KZBWS	PLAF	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
105	WEMNG	PLAF	WEMNG		☐	WEMNG	☐	Quantity of goods received
106	WAMNG	PLAF	WAMNG		☐	WAMNG	☐	Issued quantity
107	EDGNO	PLAF	EDGNO		☐	EDGNO	☐	Internal number for edge of object dependencies tree
108	LBLKZ	PLAF	LBLKZ		☐	LBLKZ	☐	Subcontracting vendor
109	EMLIF	PLAF	EMLIF		☐	EMLIF	☐	Vendor to be supplied/who is to receive delivery
110	BERID	PLAF	BERID		☐	BERID	☐	MRP Area
111	UBERI	PLAF	UBERI		☐	UBERI	☐	Issuing MRP area when transferring stock
112	EMATN	PLAF	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
113	REMFL	PLAF	REMFL		☐	REMFL	☐	Repetitive Manufacturing indicator
114	PSTMP	PLAF	PSTMP		☐	PSTMP	☐	Last Change to Planned Order: Time Stamp
115	PUSER	PLAF	PUSER		☐	PUSER	☐	Last Change to Planned Order: User
116	BADI	PLAF	BADI		☐	MD_BADI	☐	Object change via active Business Add-In
117	STAEX	PLAF	STAEX		☐	MD_STAEX	☐	Status information on BOM explosion in planned order
118	RESLO	PLAF	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
119	SRM_CONTRACT_ID	PLAF	SRM_CONTRACT_ID		☐	SRM_CONTRACT_ID	☐	Central Contract
120	SRM_CONTRACT_ITM	PLAF	SRM_CONTRACT_ITM		☐	SRM_CONTRACT_ITEM	☐	Central Contract Item Number
121	MEDKZ	PLAF	MEDKZ		☐	MEDKZ	☐	Indicator for Distributed Planned Order
122	CNFQTY	PLAF	CNFQTY		☐	MD_MES_CNF_QTY	☐	Total Confirmed Qty Planned Order (Repetitive Manufacturing)

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