two different results from MB51

[cathy_liang]

Hi experts.

I need to obtain the posting data (movement type 601 & 602) against specific customer or material code. I try running MB51 through two ways. It shows different results. Pls help to solve. Thx.

1. It only captures the material documents against posting dates in May as well as the customer code. In the material document list, "special stock" shows blank.

selection crietria I have entered in MB51:

"customer" = customer code, say ABC.

"movement type" = 601, 602

"data source" = database

"specification of database access for best runtime" = database determines optimum access

2. It can capture the material documents against posting date on the specific date. But not all the customer codes can be indicated under "customer" column in the material document list, such as ABC.

selection crietria I have entered in MB51:

"movement type" = 601, 602

"posting date" = April 7

"data source" = database

"specification of database access for best runtime" = database determines optimum access

Question1:

For way 1, why NON-special stock posting can be captured if the selection criterion "customer" is selected? U know, this criterion is used for managing customer special stocks (press F1).

For way 1, why posting in April cannot be captured?

For way 2, why not all the customer codes can be captured?

[Lakshmipathi]

I am not clear on your explanation. Anyway, assuming that I have understood your requirement to some extent, let me try to give my explanation.

For way 1, why NON-special stock posting  
  can be captured if the selection criterion 
   "customer"  is selected?

In MB51, if you give movement type and customer code, system will generate all delivery documents generated with that movement type and for that customer. On the other hand, if you have not maintained movement type, but maintained customer code, then system will generate all deliveries (if you have maintained multiple movement types in schedule lines) raised for that customer.

For way 1, why posting in April cannot be captured

?

System will generate delivery list based on the "Actual GI Date" which is nothing but your inventory posting date.

For way 2, why not all the customer codes can be captured?

Dont give customer code but just maintain the related period and execute. I am sure, system will generate all deliveries to all customers

thanks

G. Lakshmipathi

[cathy_liang]

Hi Lakshmipathi, nice to hear from you again.

I agree with you. On the contratry, the system (ECC 6.0) does not work as what our understanding. Even MM consultant on my side has not provided an answer. And the customer is pusing.

I would like to provide an example. Pls help further.

Customer ABC has material document no. 123. And this material document's posting date is April 7 (E stock, movement type 601).

In MB51, materail documents against May only is captured if specifying ABC. As long as I specify posting date in April, such as April 7, no data lists.

If not specifying ABC, April posting data for ABC can be captured, such as no. 123. But ABC is not indicated under "customer" column (not the selection criterion) in the material document list.

PS. In April, MTO is applied. In May, MTS is applied. April data have not been archived in the system.

Edited by: Cathy on May 14, 2009 4:57 PM

Edited by: Cathy on May 14, 2009 4:57 PM