Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


Hi Experts,

Have a look on this FMS :

SELECT T0.[U_Drg_No] from oitm t0 inner join por1 t1 on t0.itemcode = t1.itemcode

where t0.itemcode =$[por1.itemcode]

This is working properly only for child items, If Production Items comes( BOM Code) then this FMS is not returning any data.

For Example . If Item Code is not a BOM Code then its working if Item Code Also a BOM Code with Drg. No. then FMS is not returning data.

I am sorry if My details creating some confusion.

Plz help with needful changes.




Hello Ravi,

You dont need to joining here because you are pick master data.

Just make FMS like


SELECT T0.U_Drg_No from oitm t0 where t0.itemcode =$[por1.itemcode]




0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question