Read all material components from activity

[Former Member]

Hi

I need to read all the material components for an activity.

For this i have read the table AFVC with the WBS of the activity and found my activity.For this activity i went to table RESB and read with key RESB-AUFPL = AFVC-AUFPL and RESB-VORNR = AFVC-VORNR and finally i get the informations needed for my material components.

My problem is that by reading RESB with these 2 parameters ,the query lasts very long.For just one record i have to wait 1-2 minutes until something is found.

Does anyone know how to read the RESB faster,when i know the WBs element and the activities.

Thank you.

[Former Member]

Just a comment. Would it be simpler for you to run a standard report CN52N if your goal is to get a list of materials??

[Former Member]

Hello

I have a migration project and cannot use that transaction since i have to automatise everything.

[Former Member]

Hi

i found the solution for this

I read with WBS element in AUFK

AUFK-AUFNR = AFKO-AUFNR

AUFK-PSPEL = AFVC-PROJN

And then read table RESB with key

RESB-RSNUM = AFKO-RSNUM

RESB-AUFPL = AFVC-AUFPL

RESB-VORNR = AFVC-VORNR

Read all my records in 2 sec.

thanks