SAP ABAP Table ATP_AFPO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ATP_AFPO	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	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
4	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
5	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
6	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
7	PSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
8	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
9	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
10	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
11	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
12	PLWRK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
14	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
15	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
16	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
17	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
18	PWWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
19	AFTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
20	PEDTR	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
21	STATF	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
22	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
23	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
24	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
25	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
26	PSAMG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
27	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
28	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
29	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ATP_AFPO	AMEIN	T006	MSEHI	REF	C	CN
2	ATP_AFPO	AUFNR	AUFK	AUFNR	KEY	1	N
3	ATP_AFPO	BWTAR	T149D	BWTAR	REF	C	CN
4	ATP_AFPO	CHARG	MCHA	CHARG	REF	C	CN
5	ATP_AFPO	KDAUF	VBUK	VBELN
6	ATP_AFPO	KDPOS	VBUP	POSNR
7	ATP_AFPO	LGORT	T001L	LGORT	REF	C	CN
8	ATP_AFPO	MANDT	T000	MANDT	KEY	1	CN
9	ATP_AFPO	MATNR	MARA	MATNR	REF	1	CN
10	ATP_AFPO	PLWRK	T001W	WERKS	REF	C	CN
11	ATP_AFPO	PSPEL	PRPS	PSPNR	REF	C	CN
12	ATP_AFPO	PWWRK	T001W	WERKS	REF	1	CN
13	ATP_AFPO	SOBKZ	T148	SOBKZ	REF	C	CN
14	ATP_AFPO	VERTO	T437V	VERTL	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in