Query Supply Plan Dynamic PDS table in a BIP Report

Summary:

we have requirement to get data from dynamic PDS tables related to planning module. These table names change from one environment to another

environment

and also different for each plan.

Please suggest, how we can achieve this using BI Publisher data model?

we can hardcode these table name and query data. with this approach, we need to modify query every time we migrate code from one

environment to another environment.

Content (please ensure you mask any confidential information):

Table MSC_PLAN_TABLES will have dynamic table information for each supply plan. For Example, below query give dynamic table name for one supply plan id.