Logical Database DBM shows wrong information

[jdallagnese]

Hello, experts!

I need a help with a problem. I created a query using the logical database DBM (SQ02), is a useful tool for to check de exceptions messages.

My problem is specific with the field WRK02 which don't show the information correctly (in the most of the cases is blank, but when is populated sometimes is wrong).

This is an evidence of the problem in my ERP system.

I tried to reproduce the issue in my ERQ system (system for tests) for to identify the problem, but in here it's working correctly. This is the result that I hope.

I've already checked the parameters of the material, master data, material type, parameters of MRP in the master material, info and LOF data (ME1M / ME03) and I left both parameters for these materials equals, but the problem is happening yet. I checked in the MDTB table in both systems:

• In ERP the table MDTB is empty.
• In ERQ the table MDTB has 7 data, but no of them belong for the material that I'm checking. In my opinion, this 7 data isn't useful.

When I checked the info for the field (F1) it shows the below info.

Can anybody help me? I need in ERP system that the query shows the correct plant of supply.

What is the condition for the field WRK02 sometimes shows one data or other data how is mentioned on the field's info (F1)?

Kind regards,

José Henrique Dallagnese

[jdallagnese]

Up

[lpiccinelli]

Detail more your problem, please?

[jdallagnese]

Hi Renato,

I created an InfoSet (SQ02) using a logical database DBM (MRP results). After, I created a Query (SQ00) using this InfoSet and I selected the fields which I want that shows in the report.

The problem is that the field WRK02 is empty in the query, but it's wrong because the purchasing document is a transfer for another plant and in MD04 has a value.

This is happening in ERP system. But, I've created the same scenario in ERQ system (our system for tests), and in this case, the field is filled correctly, how we need.

Kind regards,

José Henrique Dallagnese