SAP ABAP View IOAFPO (View on AFPO for data base IOC)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COIS (Package) Order Information System

Basic Data

View Type	D	Database View
Database View	IOAFPO
Short Description	View on AFPO for data base IOC
Root table	AFPO	Order item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFPO	AFPO
2	AUFK
3	AFKO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AUFK	MANDT	JL	EQ				0	0
2	AFPO	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFPO	AUFNR	JR	EQ			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFKO	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFKO	AUFNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFPO	MANDT		☐	MANDT	☐	Client
2	AUFNR	AFPO	AUFNR		☐	AUFNR	☐	Order Number
3	POSNR	AFPO	POSNR		☐	CO_POSNR	☐	Order item number
4	KDAUF	AFPO	KDAUF		☐	CO_KDAUF	☐	Sales order number
5	KDPOS	AFPO	KDPOS		☐	CO_KDPOS	☐	Sales order item
6	MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
7	DAUTY	AFPO	DAUTY		☐	AUFTYP	☐	Order category
8	DAUAT	AFPO	DAUAT		☐	AUFART	☐	Order Type
9	PROJN	AFPO	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
10	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
11	PWERK	AFPO	PWERK		☐	CO_PWERK	☐	Planning plant for the order
12	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
13	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
14	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
15	GLTRP	AFKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
16	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
17	FTRMS	AFKO	FTRMS		☐	CO_FTRMS	☐	Scheduled release date
18	GLTRS	AFKO	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
19	GSTRS	AFKO	GSTRS		☐	CO_GSTRS	☐	Scheduled start
20	GSTRI	AFKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
21	GLTRI	AFPO	LTRMI		☐	CO_LTRMI	☐	Actual delivery/finish date
22	FTRMI	AFKO	FTRMI		☐	CO_FTRMI	☐	Actual release date
23	CY_SEQNR	AFKO	CY_SEQNR		☐	CY_SEQNR	☐	Seq. number order
24	APRIO	AFKO	APRIO		☐	CO_APRIO	☐	Order priority
25	VERID	AFPO	VERID		☐	VERID	☐	Production Version

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in