FMS Query to fetch GRPO No to Production Order.

[former_member224264]

Dear Sir/Madam,

Greetings of the day.

We work here on FIFO basis for receipt or issue of raw material. Our requirement is to fetch the GRPO no (PD) of the particular raw material issued in the row level of the Production Order. We would create an UDF (Column) in the row level of the Production Order to get the result. But for that we need help and support for the FMS Query.

Can anyone suggest or help?

Regards.

[former_member224264]

Greetings of the day, Pradnya mam,

Did try with the query, but is not fetching any details and neither is the FMS working.

Regards.

[former_member224264]

Greetings of the day, Pradnya mam,

Thanks for your support and help.

Will try this FMS and confirm you in a days time.

Grateful to you.

Regards.

[narayanis]

Hi,

I tried below FMS on goods issue screen batch management window and it did gave me result. Please try this as per your requirement.

SELECT OPDN."DocNum" From OPDN Inner Join IBT1 On OPDN."DocEntry" = IBT1."BaseEntry" Where IBT1."BatchNum" = $[OBTN."DistNumber"] And IBT1."BaseType" = 20

Hope this will help you.

[former_member224264]

Greetings of the day, mam.

Absolutely right, the material is issued by FIFO if enabled and this is created by issue from production.

As it is, we incorporate the heat code for the manufactured component manually by entering in an UDF we created in production order. This has to be manually fed and there could be typographical errors too. Hence to recheck, validate and review, we need to have the GRPO of the raw material issued in the row level of production order. All manufactured components have a link to the GRPO of the material as "Traceability and Identification".

Hope you have understood my explanation.

Regards.

[narayanis]

Hi,

As far as I understand, issue of the material on FIFO basis happens in the batch management window. Here, system will pick the batches on FIFO by default or you can manually select the material for issue.

How, a UDF created at row level will help you to issue the material on FIFO basis.