need FM to get 261 mvt against a production Order/plant

[Former Member]

Dears,

I am fetching all the consumed items in production order from MSEG, passing Order number and mvt type.

This is causing report to take more time .. as the fields are not key fields.

can you please share any FM/BADI for the same to reduce run time.

thanks..

BR

RK

[Former Member · Accepted solution]

Dear RK

Try to read table AUFM. It should be considerably faster compared to reading MSEG - even if you do a full table scan.

Regards,

Philipp

[Former Member · Accepted solution]

Hi Philipp,

I have not tried this, but the fields needs to be passed are Mvt type/ plant/Order and these are still not key fields.

I hope to get better results though as table is for orders (all types).

I will share findings.

Thanks..!

BR

RK

[Former Member · Accepted solution]

Hi Phillip,

This has helped in way, number of total entries in MSEG are almost double than  in AUFM, and is lot faster to run query without key fields.

Thanks..!

@Rupesh i tried the BAPIs but AUFNR is missing, i also fot other FM AUFM_CALL, but developer rejected as it can't be used.

Thanks..!

BR

RK

[former_member196530]

Hi

You get the through BAPI -BAPI_GOODSMVT_GETDETAIL. Otherwise , you pass the AUFNR into AUFM where BWART = 261 to get the goods movement documents .

Regards

JH

[haribalakrishna]

Hi

Did you try fetching the details from AUFM where we have both plant & production order?

BR

Raghava

[rupesh_brahmankar3]

Hello,

Please check BAPI_PRODORD_GET_DETAIL or BAPI_GOODSMVT_GETDETAIL but no reference of production order

Best Regards,

R.Brahmankar