Table to check WBS-Network-Material assigned to this network

[Former Member]

Hi All,

Plz advice. What table should i refer ,to check WBS element, network assigned to this WBS, and material assigned to this network.

Thank you.

Best Regards,

Nies

[Former Member · Accepted solution]

Hi Nies,

Tables are as below:

WBS elements - PRPS

Network -CAUFV or AUFK - Pass the WBS element as PSPEL

Material - RESB .

Pass the reservation number into RESB. Obtain the reservation number from CAUFV table. You can pass WBSE ot Network number also. But RESB being a huge table, it is advisable to pass the key field "Reservation".

Muraleedharan.R

[former_member697170]

I build this query to get material, network number with wbs number
SELECT *

FROM AFVC

LEFT JOIN RESB ON RESB.AUFPL = AFVC.AUFPL

LEFT JOIN AUFK ON AUFK.AUFNR = RESB.RSNUM

LEFT JOIN PRPS ON PRPS.PSPNR = AFVC.PROJN

WHERE PRPS.POSKI = 'WBS_NUMBER';