SAP ABAP Table VFAPW (Generated Table for View)

Basic Data

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

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number
3	PWWRK	☑	PWWRK	WERKS	CHAR	4	0	Production plant in planned order
4	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AFPO
5	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
6	PLWRK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	AFTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
9	AFART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
10	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
11	DFREI	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
12	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
13	PEDTR	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
14	PSTTR	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
15	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
16	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
17	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
18	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
19	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
20	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
21	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
22	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
23	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
24	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
25	GSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
26	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
27	PAMNG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
28	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
29	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
30	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
31	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
32	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
33	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
34	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
35	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
36	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number
37	VERID	☐	VERID	VERID	CHAR	4	0	Production Version
38	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key
39	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
40	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
41	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
42	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
43	NDISR	☐	CO_NDISR	CHAR1	CHAR	1	0	Ind.: Material in order item is not relevant for MRP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VFAPW	AFART	T003O	AUART	REF	1	CN
2	VFAPW	AMEIN	T006	MSEHI	REF	C	CN
3	VFAPW	AUFNR	AFPO	AUFNR		1	CN
4	VFAPW	KDAUF	VBUK	VBELN
5	VFAPW	KDPOS	VBUP	POSNR
6	VFAPW	KNTTP	T163K	KNTTP	KEY	1	CN
7	VFAPW	LGORT	T001L	LGORT	REF	C	CN
8	VFAPW	MEINS	T006	MSEHI	KEY	1	CN
9	VFAPW	PLWRK	T001W	WERKS	REF	C	CN
10	VFAPW	PROJN	PRPS	PSPNR	REF	C	CN
11	VFAPW	SERNR	SNUM	SERNR
12	VFAPW	SOBKZ	T148	SOBKZ	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in