SAP ABAP Table AFPO (Order item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AFPO	Table Relationship Diagram
Short Description	Order item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☐				0	0	Order item (Include structure)
5	PSOBS	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
6	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
7	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
8	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
9	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
10	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
11	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
12	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	*
13	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	*
14	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
15	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
16	PSAMG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
17	PSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
18	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
19	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
20	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
21	MEINS	☐	CRMT_APO_BASE_UNIT	MEINS	UNIT	3	0	Base Unit of Measure	T006
22	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	*
23	PAMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
24	PGMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
25	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
26	TPAUF	☐	TPAUF	CHAR1	CHAR	1	0	Indicator: Partial conversion
27	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
28	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
29	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
30	UEBTO	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
31	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
32	UNTTO	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
33	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
34	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
35	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
36	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
37	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
38	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
39	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
40	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
41	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
42	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
43	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	*
44	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
45	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
46	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
47	DWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
48	DAUTY	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
49	DAUAT	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
50	DGLTP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
51	DGLTS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
52	DFREI	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
53	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
54	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	*
55	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
56	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
57	WEWRT	☐	CRMT_CO_WEWRT	WERT7	CURR	13	2	Wareneingangswert in Hauswährung
58	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
59	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
60	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
61	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
62	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
63	WEAED	☐	CO_WEAE	XFELD	CHAR	1	0	Indicator: Goods receipt indicator can be changed
64	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
65	KBNKZ	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
66	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
67	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
68	KRSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
69	KRSPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
70	KCKEY	☐	CCKEY	CCKEY	CHAR	23	0	Cost collector key	*
71	RTP01	☐	RTP01	XFELD	CHAR	1	0	Cost collector for repetitive manufacturing
72	RTP02	☐	RTP02	XFELD	CHAR	1	0	Cost collector for KANBAN
73	RTP03	☐	RTP03	XFELD	CHAR	1	0	Cost collector for valuated sales order stock
74	RTP04	☐	RTP04	XFELD	CHAR	1	0	Cost collector for external PPC
75	KSVON	☐	KSVON	DATUM	DATS	8	0	Cost collector valid from
76	KSBIS	☐	KSBIS	DATUM	DATS	8	0	Cost collector valid to
77	OBJNP	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
78	NDISR	☐	CO_NDISR	CHAR1	CHAR	1	0	Ind.: Material in order item is not relevant for MRP
79	VFMNG	☐	CO_VFMNG	MENG13	QUAN	13	3	Committed quantity for order acc. to ATP check components
80	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
81	KZAVC	☐	KZAVC	KZAVC	CHAR	1	0	Indicator for type of availability check
82	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
83	XLOEK	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
84	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
85	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
86	OBJTYPE	☐	OCM_OBJ_TYPE	OCM_OBJ_TYPE	CHAR	1	0	Change indicator
87	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
88	FXPRU	☐	CK_FIXPRKU	XFELD	CHAR	1	0	Fixed-Price Co-Product
89	CUOBJ_ROOT	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
90	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
91	TECHS_COPY	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFPO	AMEIN	T006	MSEHI	REF	C	CN
2	AFPO	AUFNR	AUFK	AUFNR	KEY	1	N
3	AFPO	DWERK	T001W	WERKS	REF	1	CN
4	AFPO	MANDT	T000	MANDT	KEY	1	CN
5	AFPO	MEINS	T006	MSEHI	KEY	1	CN
6	AFPO	OBJNP	ONR00	OBJNR	REF	C	C
7	AFPO	PROJN	PRPS	PSPNR	REF	C	CN
8	AFPO	PWERK	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in