cancel
Showing results for 
Search instead for 
Did you mean: 

MRP Results

former_member217682
Participant
0 Kudos

Hi all,

Just want to know if i can QUERY out the MRP results table?

where is the MRP results table stored?

Thank you.

View Entire Topic
kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check tables OMSN and MSN2

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

Hi Nagarajan,

Where do can i find the workweek table?

Thank you.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

There is no table for work week. You can work week under calendar settings.

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

Hi Nagarajan,

Msn2.PeriodID - is there anyway i can link it to get the workweek?

Thank you again.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please advice your exact requirement.

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

Hi Nagarajan,

Please refer to attachment.

Thank you.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Is that header dates are due date? If yes, we can create an query same way as MRP forecast.

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

HI Nagarajan,

Yes that is correct.

Can you roughly show me the query of how it works?

Thank you so much again for your help.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please confirm, do you need MRP result or recommendation result?

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

Hi Nagarajan,

I need the forecast query.

Where I can I see the demand and supply from Omsn and msn2 table.

Thank you very much for your help.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this query. Let me know your feedback

SELECT T0.[ItemCode], T3.[ItemName], T1.[DueDate], T3.[IsCommited], T3.[OnHand], T3.[OnOrder], "Final Inventory" = (T3.[OnHand] +T3.[OnOrder]) -   T3.[IsCommited] FROM MSN2 T0 left join ORCM T1 on t0.absentry = t1.docentry and  T0.[ItemCode]  =  T1.[ItemCode] left join OMSN T2 on  t2.absentry = t0.absentry INNER JOIN OITM T3 ON T0.ItemCode = T3.ItemCode WHERE T2.[MsnCode]  = [%0] GROUP BY T0.[ItemCode], T3.[ItemName], T1.[DueDate], T3.[IsCommited], T3.[OnHand], T3.[OnOrder]

Thanks & Regards,

Nagarajan

former_member217682
Participant
0 Kudos

Hi Nagarajan,

That query works as intended.

But it still doesnt show by workweek.

But it's okay. I think there's no way to actually lay it out by workweek.

Thank you anyways.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Thanks for feedback.

If above query meets your purpose, then please close this thread by marking correct answer.

Thanks & Regards,

Nagarajan