How to ensure the relation between Maintenance Order and Activity

[Former Member]

Dear all,

Now, I am using LDB PSJ to create a report which can display a tree view for any project. But, I found a problem that is I don't know how to insure the hierarchical relation between maintenance order and activity. As you know, the info of maintenance order store in node AUFK and info of activity store in node ACT01. Sometimes, a maintenance order can be a sub item of an internal activiy. an activity also can be a sub item of a maintenance order. I don't know what table field can be indicator to insure their relationship.

It's quite urgent for me! Looking forward to receiving your helps!

Thanks,

Justin - Xiongjunwen

[former_member201206 · Accepted solution]

Hi Justin,

In the AFKO (type 30 for PM order), the fields AUFNT & APLZT refer the assigned PS activity. This relation is not stored at PS activity (at least not in database), since multple PM orders can assigned to the same PS activity.

A PS activity can NOT be a subitem of maintenace (PM) order, if in the database has such constellation, it is an error.

Please reward, wenn the information is useful.

Kind regards,

Zhenbo