Skip to Content
avatar image
Former Member

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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 09, 2017 at 01:58 AM

    Detail more your problem, please?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Sep 04, 2017 at 01:12 PM

    Up

    Add comment
    10|10000 characters needed characters exceeded