Information

Title	What files hold the AWR notes and how do you review them?

Summary	What files hold the AWR notes and how do you review them?

URL Name	Whatfiles-hold-the-AWR-notes-and-how-do-you-review-them

Resolution

- AWR Notes are contained in files E3MSGC and E3MSGF
- The file E3MSGF contains the message plus a control number and sequence number.
- The file E3MSGC has the same control number and a key that is a combination of company, item, vendor and warehouse.
- In both files, the MFKEY/MCKEY is how the item and notes are linked together.
- To find note that will link files together from MFKEY to MCKEY
Example:
SELECT * FROM E3MSGF
WHERE MFKEY LIKE 'Do not%'

Products	Advanced Warehouse Replenishment Client Server

Module

Version	All

Error Message Code

Cause

Additional Information

Publication Status	Published

What files hold the AWR notes and how do you review them?

Information