How to link the two tables MIATTR and MPDMAT or how to link a component from a structure with their

Our engineering department looks for a way to create a report that shows the structure from pds002 together with the attributes from ats120, thats attached to the structures components.
I found the attribute number column ATNR in both tables but it doesnt seem to be the same number in both tables.

Does anyone have the information on how M3 links those two tables to display the attributes in PDS002 -> "attribute values" ?

Find more posts tagged with

Comments

antonio-caria

Exactly.

PMATNR in MVXJDTA.MPDMAT is usually zero.

I think You cann't related the 2 table with a third table in the join.

Legacy Contributor

found the issue: its not MIATTR its MOATTR, there the reference number works perfectly.. took me a while. though

antonio-caria

in Join confirm the where clause with possible Index's used.

MIATTR00/10... and MOATTR00/10/20... for instance

Important Links

Community Hubs
Discussion Forums
Groups
Community News

Copyright © 2025 Infor. All rights reserved.