topic WBS Elements select using tables in Application Development and Automation Discussions

WBS Elements select using tables

Former Member — Tue, 27 Jan 2015 17:47:06 GMT

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_member202771 — Wed, 28 Jan 2015 06:34:49 GMT

Hi Srikanth,

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

Google for it.

Thanks,

Anil

Former Member — Wed, 28 Jan 2015 06:43:09 GMT

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 — Mon, 09 Feb 2015 05:07:23 GMT

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