Multi Level Pegging - SQL table

ERP 10
1

Hello all,

Can somebody tell the name of the tables that hold multi level pegging results ?

2

PegDmdMst
PegLink
PegSupMst

2 Likes
3

Thanks Scott

4

Can anyone offer any help on how to join these properly?

5

Casual glace, looks like Company and DemandSeq or SupplySeq depending if you’re linking to PegDmdMst or PegSupMst

6

I can offer the attached BAQ as one way to join the tables.
MultiLevelPeggingAnalysis.baq (27.0 KB)

2 Likes
7

And here is a simple dashboard using publish/filter and 3 BAQs
CUS-PeggingRawData.dbd (220.7 KB)
image

3 Likes
8

Thank you!

9

Thank you as well!