Is there a way to use RTB flag as a measure to create shortage table

Summary:

Hi All,

We need to get material shortage for work orders /Demands in a Table format based on Ready to build flag

Can anyone pls suggest as we arent able to find it anywhere apart from supplies and demands .

We tried build plan but expected results arent there.
we also tried to create a report with this flag but the end item demand component items RTB,% are different from one in workbench

Can anyone pls help on this.

Under reports and analytics > we werent able to get the order qty , only Pegged qty was visible

Thanks in advance