SAP ABAP View VFAPW (View from Producing Plant to Production Order)

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	VFAPW
Short Description	View from Producing Plant to Production Order
Root table	FAPW	Index of production-/issuing plant for production order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FAPW	FAPW
2	AFPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFPO	MANDT	JL	EQ				0	0
2	FAPW	MANDT	JR	EQ			AND	0	0
3	AFPO	AUFNR	JL	EQ				0	0
4	FAPW	AUFNR	JR	EQ			AND	0	0
5	AFPO	POSNR	JL	EQ				0	0
6	FAPW	POSNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FAPW	MANDT		☐	MANDT	☐	Client
2	MATNR	FAPW	MATNR		☐	MATNR	☐	Material Number
3	PWWRK	FAPW	PWWRK		☐	PWWRK	☐	Production plant in planned order
4	AUFNR	FAPW	AUFNR		☐	AUFNR	☐	Order Number
5	POSNR	FAPW	POSNR		☐	CO_POSNR	☐	Order item number
6	PLWRK	AFPO	PWERK		☐	CO_PWERK	☐	Planning plant for the order
7	LGORT	AFPO	LGORT		☐	LGORT_D	☐	Storage location
8	AFTYP	AFPO	DAUTY		☐	AUFTYP	☐	Order category
9	AFART	AFPO	DAUAT		☐	AUFART	☐	Order Type
10	DNREL	AFPO	DNREL		☐	CO_DNREL	☐	Indicator: Order item not relevant for MRP
11	DFREI	AFPO	DFREI		☐	CO_FREI	☐	Indicator: Order released/partially released (for MRP)
12	ELIKZ	AFPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
13	PEDTR	AFPO	DGLTP		☐	CO_GLTRP	☐	Basic finish date
14	PSTTR	AFPO	DGLTS		☐	CO_GLTRS	☐	Scheduled finish
15	WEBAZ	AFPO	WEBAZ		☐	PLWEZ	☐	Goods receipt processing time in days
16	SERNR	AFPO	SERNR		☐	SERNR	☐	BOM explosion number
17	CUOBJ	AFPO	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
18	KNTTP	AFPO	KNTTP		☐	KNTTP	☐	Account assignment category
19	SOBKZ	AFPO	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
20	KZVBR	AFPO	KZVBR		☐	KZVBR	☐	Consumption posting
21	KDAUF	AFPO	KDAUF		☐	CO_KDAUF	☐	Sales order number
22	KDPOS	AFPO	KDPOS		☐	CO_KDPOS	☐	Sales order item
23	KDEIN	AFPO	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
24	PROJN	AFPO	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
25	GSMNG	AFPO	PSMNG		☐	CO_PSMNG	☐	Order item quantity
26	WEMNG	AFPO	WEMNG		☐	CO_WEMNG	☐	Quantity of goods received for the order item
27	PAMNG	AFPO	PSAMG		☐	CO_PSAMG	☐	Scrap quantity in item
28	IAMNG	AFPO	IAMNG		☐	CO_IAMNG	☐	Expected surplus/deficit for goods receipt
29	AMEIN	AFPO	AMEIN		☐	CO_AUFME	☐	Unit of measure for in-house production
30	MEINS	AFPO	MEINS		☐	LAGME	☐	Base Unit of Measure
31	UMREZ	AFPO	UMREZ		☐	UMREZ	☐	Numerator for Conversion to Base Units of Measure
32	UMREN	AFPO	UMREN		☐	UMREN	☐	Denominator for conversion to base units of measure
33	BESKZ	AFPO	BESKZ		☐	BESKZ	☐	Procurement Type
34	SOBES	AFPO	PSOBS		☐	SOBES	☐	Special procurement type
35	WEPOS	AFPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
36	SAFNR	AFPO	SAFNR		☐	SA_AUFNR	☐	Run schedule header number
37	VERID	AFPO	VERID		☐	VERID	☐	Production Version
38	VERTO	AFPO	VERTO		☐	SA_VERTL	☐	MRP Distribution Key
39	QUNUM	AFPO	QUNUM		☐	QUNUM	☐	Number of quota arrangement
40	QUPOS	AFPO	QUPOS		☐	QUPOS	☐	Quota arrangement item
41	ARSNR	AFPO	ARSNR		☐	ARSNR	☐	Settlement reservation number
42	ARSPS	AFPO	ARSPS		☐	ARSPS	☐	Item number of the settlement reservation
43	NDISR	AFPO	NDISR		☐	CO_NDISR	☐	Ind.: Material in order item is not relevant for MRP

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