SAP ABAP Table MCAFPO (Order Item)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-IS (Application Component) Information System
     ⤷ MCF (Package) R/3 application development: Shop Floor Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCAFPO	Table Relationship Diagram
Short Description	Order Item

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	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
2	POSNR	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
5	ETRMP	☐	CO_ETRMP	DATUM	DATS	8	0	Opening date of the planned order
6	STRMP	☐	CO_STRMP	DATUM	DATS	8	0	Start date of the planned order
7	LTRMP	☐	CO_LTRMP	DATUM	DATS	8	0	Delivery date from planned order
8	LTRMI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
9	PAMNG	☐	MC_AVMNG	MENGV15_3	QUAN	15	3	Fixed quantity of scrap from production
10	PGMNG	☐	MC_GSMNG	MENGV15_3	QUAN	15	3	Total planned order quantity
11	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
12	MCPAMNG	☐	MC_MCPAMNG	MENGV15	QUAN	15	3	Fixed production scrap qty in unit of in-house production
13	MCPGMNG	☐	MC_MCPGMNG	MENGV15	QUAN	15	3	Total planned order quantity in unit of in-house production
14	PSAMG	☐	MC_PSAMG	MENGV15_3	QUAN	15	3	Scrap quantity in item
15	PSMNG	☐	MC_PSMNG	MENGV15_3	QUAN	15	3	Order item quantity
16	WEMNG	☐	MC_WEMNG	MENGV15_3	QUAN	15	3	Quantity of goods received
17	IAMNG	☐	MC_IAMNG	MENGV15_3	QUAN	15	3	Actual scrap quantity from an order item
18	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
19	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
20	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
21	DFZEH	☐	DFZEH	EINHEIT	UNIT	3	0	Unit of measure for execution time
22	S_DFZ	☐	S_DFZ	DAUER_6_1V	QUAN	7	1	Target execution time
23	I_DFZ	☐	I_DFZ	DAUER_6_1V	QUAN	7	1	Actual execution time
24	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
25	KSUMS	☐	MC_KSUMS	DAUER_6_1V	QUAN	7	1	Total target capacity requirements
26	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
27	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
28	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	*
29	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
30	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
31	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
32	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
33	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
34	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
35	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
36	SOPNR	☐	SAFNR	SAFNR	CHAR	10	0	SOP order number
37	PLCHK1P	☐	MC_PLCHK1P	CHAR1	CHAR	1	0	Plausibility check: item w/o actual start
38	PLCHK2P	☐	MC_PLCHK2P	CHAR1	CHAR	1	0	Plausibility Check: Actual Finish Date before Start Date
39	DFZEXEH	☐	DFZEXEH	EINHEIT	UNIT	3	0	Unit for execution time (exact)
40	S_DFZ_EX	☐	S_DFZ_EX	DAUER_10_2V	QUAN	12	2	Target execution time (exact)
41	I_DFZ_EX	☐	I_DFZ_EX	DAUER_10_2V	QUAN	12	2	Actual execution time (exact)
42	S_DLZ_EX	☐	S_DLZ_EX	DAUER_10_2V	QUAN	12	2	Target lead time (exact)
43	I_DLZ_EX	☐	I_DLZ_EX	DAUER_10_2V	QUAN	12	2	Actual lead time (exact)
44	BUDAT	☐	MC_LTRMI	DATUM	DATS	8	0	Posting date delivery/finish date, actual
45	GRUND	☐	SA_GRUND	CO_AGRND	CHAR	4	0	Reason for scrap	*
46	PSPNR	☐	REM_PSPNR	PS_POSNR	NUMC	8	0	Production lot (WBS element)	*
47	P_DLZ	☐	P_DLZ	DAUER_6_1V	QUAN	7	1	Planned lead time
48	S_DLZ	☐	S_DLZ	DAUER_6_1V	QUAN	7	1	Target lead time
49	I_DLZ	☐	I_DLZ	DAUER_6_1V	QUAN	7	1	Actual lead time
50	PS_FREI	☐	PS_FREI	DAUER_6_1V	QUAN	7	1	Planned/target deviation in scheduled release date
51	PI_FREI	☐	PI_FREI	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled release date
52	SI_FREI	☐	DSI_FREI	DAUER_6_1V	QUAN	7	1	Target/actual deviation in scheduled release date
53	PS_STAR	☐	PS_STAR	DAUER_6_1V	QUAN	7	1	Planned/target deviation in start date
54	PI_STAR	☐	PI_STAR	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled start date
55	SI_STAR	☐	DSI_STAR	DAUER_6_1V	QUAN	7	1	Target/actual schedule deviation in start date
56	PS_LIEF	☐	PS_LIEF	DAUER_6_1V	QUAN	7	1	Planned/target deviation in scheduled delivery date
57	PI_LIEF	☐	PI_LIEF	DAUER_6_1V	QUAN	7	1	Planned/actual deviation in scheduled delivery date
58	SI_LIEF	☐	DSI_LIEF	DAUER_6_1V	QUAN	7	1	Target/actual deviation in scheduled delivery date
59	.INCLUDE	☐				0	0	Details: Order Item
60	A	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
61	VDATU	☐	MC_VDATUM	DATUM	DATS	8	0	Date of update for statistics updating
62	.INCLUDE	☐				0	0	User Structure: Order Item
63	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCAFPO	AMEIN	T006	MSEHI
2	MCAFPO	AUFNR	AUFK	AUFNR
3	MCAFPO	CHARG	MCH1	CHARG
4	MCAFPO	GSBER	TGSB	GSBER
5	MCAFPO	KDAUF	VBUK	VBELN
6	MCAFPO	KEINH	T006	MSEHI
7	MCAFPO	LGORT	T001L	LGORT
8	MCAFPO	MATNR	MARA	MATNR
9	MCAFPO	MEINS	T006	MSEHI
10	MCAFPO	PLNUM	PLAF	PLNUM
11	MCAFPO	PWERK	T001W	WERKS
12	MCAFPO	SAFNR	SAFK	AUFNR
13	MCAFPO	SERNR	SNUM	SERNR
14	MCAFPO	VERID	MKAL	VERID

History

Last changed by/on	SAP	20020219
SAP Release Created in