Hello everyone,
I’m trying to create a DMR report in BAQ. My BAQ needs a description of the reason code. And since the DMRHead and DMRActn tables do not have this description field, I linked the Reason table. But, if I link this reason table, I get three identical lines in the query result.
Why does this happen? How do I set it up?
Thanks in advance!
The Reason table can have multiple records with the same Reason Code as you can have the same one for different Reason Types.
Reason Type
Indicates the Type of reason. Can be “S” - Scrap, “R” - Rework, “M” - Inventory Adjustments, “A” - RMA, “D” - DMR, “Q” - Quality Assurance “C” - Service Calls “W” Win CRM “L” - Loss CRM, “T” Task CRM, “H” - Part On Hold, “E” ECO Task, “H” HelpDesk, “C” Service Call, “U” Course Result, "“F” Field Service Contract.
You may want to try filtering the Reason table where ReasonType = D for DMR
Tracy’s explanation is probably correct for one of the duplications but the other may be that fact that this particular DMR appears to have two separate discrepancies of two pieces each (Qty by Reason).
you were correct I solved it with your advice.
