Table Extraction

[Former Member]

Hello,

I need the report in this format

Network Activity Costing Sheet Overhead key

We need all the above fields from oen table.. is it possible to achive.

I got the network orders from AUFK, then keyedin orders in AFKO and gor the routing number - AUFPL ( FIELD)

I Keyed in AUFPL in AFVC table

Activities in this table field name is AFLZL.

Please let us know is there any other way of getting all the fields in one table.

we dont't have hte orde field in AFVC table.

Regards,

Nitin

[Former Member · Accepted solution]

If you use WBS element and network both, then pass the WBS <PROJN> in AFVC Table to get the list of list of network activities, Costing sheet & Overhead Key

Otherwise you have to create query

[former_member203108]

Please let us know is there any other way of getting all the fields in one table.

You cant get everything in a single table , many times you have to connect several tables to get the desired result.

[former_member230675]

Please try to create a query by joining all these tables in SQVI.

Search the forum for how to create a query.