SAP ABAP Table IOAFPO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	IOAFPO	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	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
5	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
6	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
7	DAUTY	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
8	DAUAT	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
9	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	PWERK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
12	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
13	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
14	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
15	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
16	GSTRP	☐	PM_ORDGSTRP	DATUM	DATS	8	0	Basic Start Date
17	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
18	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
19	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
20	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
21	GLTRI	☐	CO_LTRMI	DATUM	DATS	8	0	Actual delivery/finish date
22	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
23	CY_SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
24	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
25	VERID	☐	VERID	VERID	CHAR	4	0	Production Version

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IOAFPO	AUFNR	AUFK	AUFNR	KEY	1	N
2	IOAFPO	DAUAT	T003O	AUART	REF	1	CN
3	IOAFPO	DISPO	T024D	DISPO	REF	1	CN
4	IOAFPO	FEVOR	T024F	FEVOR
5	IOAFPO	KDAUF	VBUK	VBELN
6	IOAFPO	KDPOS	VBUP	POSNR
7	IOAFPO	MANDT	T000	MANDT	KEY	1	CN
8	IOAFPO	MATNR	MARA	MATNR	REF	1	CN
9	IOAFPO	PROJN	PRPS	PSPNR	REF	C	CN
10	IOAFPO	PWERK	T001W	WERKS	REF	C	CN
11	IOAFPO	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in