Hi Santosh
Please check the table DWH_FIN_PLAN, it will contain the Cost and Budget plans and you should then be able to join with DWH_FIN_PLAN_SUMMARY_FACTS or DWH_FIN_PLAN_PERIOD_FACTS.
As you didn't specify your CA PPM version, please make sure that if don't have this flag enabled in PPM - Administration - System Options -Data Warehouse Options, this will reduce the number of financial plans brought to DWH:
Also, for more information about all the DWH tables, check the documentation here:
https://docops.ca.com/ca-ppm/14-3/en/administration/reference/technical-reference
You can check the ERD and "CA PPM Advanced Reporting and Database Schema Index" link referenced, it will get to the download page for the zip file with all schema information.
Hope this helps -Nika