Thursday 4 August 2011

Stock/Requirement List API

Hello,

I guess we all faced the same issue. Sometimes you need to collect
data from stock/requirement list for reporting topics. A wrong
approach would be to try to select data from database and reproduce
standard calculation. This is almost impossible due to the complexity
of the current MRP design, moreover if you do that it will be more
complex to explain the calculation to the users and of course to fix
issues. The second option is to follow SAP strategy and use service/
API for this purpose.

In standard SAP, we have function module MD_*_API (sorry I don't
remember right now the exact name :-(, in AFS we have
J_3AM_DISPOSITION_DISPL. The standard one calls the AFS FM and then
performs a mapping between standard MRP element and AFS MRP element.
Standard and AFS stock/requirement list are based on those functions.
In release 6.0, view filter was added to AFS MD04, which is nice,
however from my opinion the best thing would have been to add
selection rules as this speed up a lot data processing. If you just
want to pick up supply elements (whatever the MRP status), SAP always
load everything such as demand & supply. In standard, selection rules
are filter before database selection.

Of course, I understand that this kind of changes would require an
effort in the AFS PP-MRP are.

2 comments:

AFS-User-Network said...

Hello Mehdi,

Once again, all good questions !
J_3AM_DISPOSITION_DISPL is indeed the correct function module for AFS Stock Requirement List.
Selection Rules and Display filters have been supported for AFS from AFS 6.3.
I guess you're gonna get what you have asked for.

Best Regards,
Umer Zeeshan

AFS-User-Network said...

Hello Mehdi,

You have my full support. We also face performance problems when using FM J_3AM_DISPOSITION_DISPL..


Kind regards,
Klaus Leisgang