Restricting excess raw material consumption ducring confirmation

[former_member222667]

Dear Experts

Scenario

The production of the finished product comprises of many raw materials. The goods issue is done by backflushing. After few days , it is noticed that some of the raw materials consumed are a bit more and some are less .

The Plant manager insists that this needs to be restricted . Please advise how do we restrict this phenomenon . Your guidance will be highly appreciated . Thanks

Kind regards

Aman

[ajitkumar · Accepted solution]

. i feel its not a good idea to restrict excess consumption to BOM only in system when there is no mechanism in place to restrict the acutal consumption on the shop floor

Rather you can have a Z report to record the excess consumption and can even have a workflow on that for subsequent approvals

[former_member222667 · Accepted solution]

Dear Jeevan and Ajith

Thanks for your inputs . I seek to know , can a system generate a warning message for the same . Also please advice if we generate a z report what fields and tables can we consider .

Thanks & regards

Aman

[sjeevan · Accepted solution]

You can change the message M7 (application area) 362 (message number) in OMCQ to W (Warning) but the best way would be to implement the BAdI and create a custom authorization object in SU21 (eg: Y_OVER_ISSUE) and in the BAdI you this authorization object like following

AUTHORITY-CHECK OBJECT 'Y_OVER_ISSUE'
         ID 'ACTVT' FIELD '01'  "Create

IF SY-SUBRC = 0.
 " User has authority to over issue
ENDIF.

Assign the authorization object only to certain users like plant manager or supervisor etc. so that normal users cannot over issue but plant manage and supervisor can over issue.

[sjeevan · Accepted solution]

 Also please advice if we generate a z report what fields and tables  can we consider . 

If you want to create a report program which will show the unplanned issues and over issues of components, you need to read the bom components from table RESB also, but the is problem users can add extra/new components manually in CO02 so you need to look at field STLNR to see if it came from BOM or manually added and then you need to get all the goods issues done to the production order using MSEG, use the quantities of STPO and subtract them from issued quantities of MSEG (mvt type 261) you will get the report you want. Use SE16N and look at all the fields you will understand.

Edited by: Jeevan Sagar on Feb 11, 2012 2:22 AM

[ajitkumar · Accepted solution]

you may have to use , AFKO AFPO AUFM and AUFK for order related data, JEST for status

MAST STAS STPO STKO MARA MSEG, MKAL if youa re using production versions

[former_member222667 · Accepted solution]

Thanks every for your valued comments I am closing this thread . Points are awarded.

Kind regards

Aman

[former_member186193]

Hi,

PLEASE apply the below user exit:

CONFPP05 User Exit EXIT_SAPLCORF_105

Ask your ABAPer that while confirmation CO11N during backflush system should check for + or u2013 (plus or minus) tolerance % in goods issue deviation in quantity only with movement type 261.

The same thing we have done in our implementation.

Regards,

Alok Tiwari

[sjeevan]

You can issue goods even after TECO, So, one solution would be, is to change the message M7 (application area) 362 (message number) in OMCQ to E (Error). But then the side effect would be you cannot over issue even for manual reservation (any reservation in general).

Or Else you'd have to implement BAdI WORKORDER_GOODSMVT