Unique link between tables MAPL and PLKO in SAP QM.

[former_member614600]

Hello there,

Our requirement is to identify and delete all duplicate inspection plans assigned to a material plant combination based on the "Last Call Date" field. This field exists in the table PLKO but I haven't managed to find a unique link between it and MAPL. The only unique links seem to be Group counters, critical counters etc. which do not have a one to one mapping. So if in QP03, i see 4 inspections plans for a material/plant combination and 4 "Last call dates" and I want to keep the most recent date plan and delete the rest, how can I go about doing it?

Thanks,

Nitin

[busyaban7 · Accepted solution]

Hi Nitin,

Please go through one of my answers on the below thread, and take clues to make your query.

http://scn.sap.com/thread/3667568

Thanks,

Arijit

[former_member614600 · Accepted solution]

Thanks Arijit...Looks like might help.

[arunsapqm]

Hi

For linking table Try SAP Query in SQVI

For delete option check with ABAPer to find the exit in table level delete

Thanks

[former_member614600]

Hi Arun,

I have already tried using SQVI. But it won't work in this case because the same group is assigned to multiple material/plant combinations and the counters in tables MAPL and PLKO work differently, i.e. they don't have a one to one mapping.