Relationship between PRPS and FPLT table

[Former Member]

How to arrive to a billing plan in FPLT table with project ID or WBS ID in PRPS table.

Thanks,

Vaishnavi

[Former Member]

Joining sales and project systems table using VBKD.

[Former Member]

Hi,

Check the VBRP table. This might help you.

Best Regards,

Gokul

[virendra_pal]

the common element should be billing plan number

note - you can have billing plan without milestone hence the previous comment is partially correct

The field is FPLNR - this is in FPLT and PRPS

[raghavendra_praveen]

Hi

I hope there is no common element in both tables..extract the mile stone data from FPLT and MLST tables and then WBS element data from PRPS and MLST tables (first two gives the mile stone and next two tables gives the WBS element to which mile stone is attached)..

thanks