topic Re: MD04 modifcations in Application Development and Automation Discussions

MD04 modifcations

Former Member — Tue, 11 Sep 2007 13:33:49 GMT

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

Re: MD04 modifcations

RaymondGiuseppi — Tue, 11 Sep 2007 13:51:18 GMT

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

Re: MD04 modifcations

Former Member — Tue, 11 Sep 2007 14:12:23 GMT

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.

Re: MD04 modifcations

RaymondGiuseppi — Tue, 11 Sep 2007 14:44:15 GMT

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

Re: MD04 modifcations

Former Member — Tue, 11 Sep 2007 16:56:41 GMT

Hi raymond,

What data should the ztable hold? Please explain me in details. Thanks.

regards,

sriram

Re: MD04 modifcations

RaymondGiuseppi — Wed, 12 Sep 2007 06:25:35 GMT

Ztable should look like

- Client

- Key to find the record : basically the level at which you want to maintain the Exception date : material, plant

- Exception code (look previous post)

- Date first displayed

- What information you want (who look at it first time, etc..)

Regards