Skip to Content

Logical Database DBM shows wrong information

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

plant-wrong-v2.jpg (456.3 kB)
plant-ok-erq.jpg (455.7 kB)
f1-wrk02.jpg (79.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 09, 2017 at 01:58 AM

    Detail more your problem, please?

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Sep 04, 2017 at 01:12 PM


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.