2007 Sep 11 2:33 PM
Hi experts,
Is it possible to add a date column,such that the date would reflect when the material # first appeared on the report as a "RED" traffic light. Right now, we have no way of determining which items are recently added and which have been red for days. thanks in advance,
regards
Hi experts,
Is it possible to add a date column,such that the date would reflect when the material # first appeared on the report as a "RED" traffic light. Right now, we have no way of determining which items are recently added and which have been red for days. thanks in advance,
regards
2007 Sep 11 2:51 PM
Take a look at this OSS <a href="https://service.sap.com/sap/support/notes/905512">Note 905512 - User exit MD04 not active for sales order stock w/ qty 0</a>
Enhancement M61X0002, EXIT_SAPLM61R_001 User Exit for Evaluation PP-MRP Material Requirements Planning
<i> In the stock/requirements list (MD04) and the MRP list (MD05), you
can use this enhancement to display additional information in
separate columns. You can display up to three extra columns with
additional data in the individual line display and in the totals
display. You can call up the additional data by selecting
pushbuttons.
Function procedure: For technical reasons (user exists can only
refer to one individual outline program), the user exit consists of
two function modules:
EXIT_SAPLM61R_001
EXIT_SAPMM61R_001
These modules must both always be filled.
-EXIT_SAPMM61R_001- is used to determine the description of the
additional columns which are to be filled individually by the
customer. If a column is to be filled, pushbuttons are shown with
the same description.
-EXIT_SAPLM61R_001- is called up for every row of the
stock/requirements list or the MRP list. Here, depending on which
pushbutton was selected, additional information can displayed in the
user exit column.
Repetitive manufacturing planning table (MF50):
The information in the user exit columns 1 and 2 of the period
totals display can also be displayed in rows in the REM planning
table. The columns (after they have been filled and activated in the
function modules) can be shown in the table by selecting View -
Settings - Change/Save. The texts of the columns appear as an
additionalrow type in the screen "Show/Hide Rows".
Please refer to the documentation for the function modules;
'EXIT_SAPLM61R_001' and 'EXIT_SAPMM61R_001'
For the function modules, example coding is delivered in the
following inculudes:
In 'LXM61F04' you can find example coding for the module
'EXIT_SAPMM61R_001'.
In 'LXM61F03', you can find example coding for the module
'EXIT_SAPLM61R_001'.</i>
In this Exit you may fill a specific table to memorize the first "display" of such a record, also if already displayed you can move the date to screen.
Regards
2007 Sep 11 3:12 PM
Hi raymond,
I populated the columns and buttons. But I am not able to meet the specifications i.e. populating the date when the material was first showing red.Can u please help me with the fields and logic. Thanks in advance.
2007 Sep 11 3:44 PM
If you want the first date when the status could have been "red", provided someone called MD04, you have to analyze each and every case where the status is posuitionned from security stock to past date.... (good luck)
If you want the first date when someone actually saw the status "red" you could do it in the include,
if status is not red (L_MDEZX-AUSSL/AUSKT/ABEKZ)
- read a customer ztable,
- - if found delete it
if status is red
- read the ztable,
- - if found use the date stored,
- - else insert a record with today date.Regards
2007 Sep 11 5:56 PM
Hi raymond,
What data should the ztable hold? Please explain me in details. Thanks.
regards,
sriram
2007 Sep 12 7:25 AM