Skip to Content
avatar image
Former Member

SAP PM Relationships

I have a 2 maintenance orders, I have gone into the operation of each order and within the relationships tab, I have linked the orders.

I am trying to find the relationship in the tables and cannot find them, I have checked tables, AFAB, AFVC, AUFK and had no luck in finding the relationship

Any help would be appreciated

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 13, 2017 at 04:48 PM
    -1

    Hi Bav - AFAB should gove you the relationship. There isnt any data in the table currently?

    Plan number in AFVC matches the predecessor ID in AFAB.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 13, 2017 at 12:14 PM

    See table "AFKO" and field "MAUFNR" which provides the 'Superior'-Order, marking the Difference between Main and Sub-Order ...

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2017 at 12:38 PM

    Hi Bav,

    operations are identified by fields AUFPL and APLZL, so you cannot simply search in tables AFVC and AFAB using the order number.

    First you need to read field AUFPL from table AFKO for your order number (field AUFNR).

    Then you can determine APLZL from table AFVC (using AUFPL and the operation number VORNR).

    Then read table AFAB with field AUFPL_VOR = AUFPL and APLZL_VOR = APLZL or AUFPL_NCH = AUFPL and APLZL_NCH = APLZL, depending if the order is the predecessor ("_VOR") or the successor ("_NCH").

    Kind regards,

    Bernd

    Add comment
    10|10000 characters needed characters exceeded