WBS Elements select using tables

[Former Member]

Hi Experts,

I want to fetch WBS elements Hierarchy with object numbers and i used F.M BBP_PS_PROJECT_GET_LIST TO GET.

But bad thing is my performance is getting effected as i am having 20,000+ WBS to fetch data.

Instead of looping F.M can any one suggest how to get in a single select using tables.

Thanks for your support....

[Former Member]

Hi,

you wont be able to get all the details in single select statement.Instead you can query on the following tables to get the relevant details.

PROJ - Project definition

PRPS - WBS element Details

AUFK - Network details

AFVC - Network Component Details.

Thanks!!

Suvarna

[former_member202771]

Hi Srikanth,

Parallel processing will improve performance when an FM is used inside a loop.

Google for it.

Thanks,

Anil

[Former Member]

Hi,

you wont be able to get all the details in single select statement.Instead you can query on the following tables to get the relevant details.

PROJ - Project definition

PRPS - WBS element Details

AUFK - Network details

AFVC - Network Component Details.

Thanks!!

Suvarna

[Former Member]

Hi, Thanks for your valuable suggestions.. I solved the problem myself. Closing the thread.