SAP ABAP View MGV_M_ORDBW (Process Orders for Ingredient/Material Produced)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR_LAMA (Package) LAMA: Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_M_ORDBW
Short Description	Process Orders for Ingredient/Material Produced
Root table	AFPO	Order item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFPO	AFPO
2	AFKO
3	RESB
4	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFPO	MANDT	JL	EQ				0	0
2	AFKO	MANDT	JR	EQ			AND	0	0
3	AFPO	AUFNR	JL	EQ				0	0
4	AFKO	AUFNR	JR	EQ			AND	0	0
5	AFKO	MANDT	JL	EQ				0	0
6	RESB	MANDT	JR	EQ			AND	0	0
7	AFKO	RSNUM	JL	EQ				0	0
8	RESB	RSNUM	JR	EQ			AND	0	0
9	AFPO	MANDT	JL	EQ				0	0
10	MATERIALID	MANDT	JR	EQ			AND	0	0
11	AFPO	MATNR	JL	EQ				0	0
12	MATERIALID	MATNR_INT	JR	EQ			AND	0	0
13	RESB	MANDT	JL	EQ				0	0
14	MATERIALID	MANDT	JR	EQ			AND	0	0
15	RESB	MATNR	JL	EQ				0	0
16	MATERIALID	MATNR_INT	JR	EQ			AND	0	0
17	AFPO	DAUTY		EQ	'40'		AND	0	0
18	RESB	BDART		EQ	'AR'		AND	0	0
19	RESB	SHKZG		EQ	'H'			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	RSNUM	RESB	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
5	RSPOS	RESB	RSPOS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
6	RSART	RESB	RSART		☐	RSART	☐	Record type
7	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
8	GLTRP	AFKO	GLTRP		☐	CO_GLTRP	☐	Basic finish date
9	GSTRS	AFKO	GSTRS		☐	CO_GSTRS	☐	Scheduled start
10	GLTRS	AFKO	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
11	GSTRI	AFKO	GSTRI		☐	CO_GSTRI	☐	Actual start date
12	GLTRI	AFKO	GLTRI		☐	CO_GLTRI	☐	Actual finish date
13	GETRI	AFKO	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
14	PROD_MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
15	CONS_MATNR	RESB	MATNR		☐	MATNR	☐	Material Number
16	WERKS	RESB	WERKS		☐	WERKS_D	☐	Plant
17	LGORT	RESB	LGORT		☐	LGORT_D	☐	Storage location
18	PROD_MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☑	External Long Material Number
19	CONS_MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☑	External Long Material Number
20	PROD_MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☑	Material Version Number
21	CONS_MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☑	Material Version Number

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	600