cancel
Showing results for 
Search instead for 
Did you mean: 

Need customised report for list of stock for partially processed materials.

Former Member
0 Kudos

Hi ,

The requirement with process im explaining plz share  the report.

This customised report related to partiallly processed materials:

Suppose , after recieving material  from vendor as raw material they will transfer the mat to vendor for processing agsinst 57f4 challan, after completing the process, they will recieve this material , this process will continues to till becoming finished product, once after the finished product come, they will transfer to finished storage location, from there it will be issued to production.

How to make the report, plz suggest me:

The report format is :

S.no    material      description     pending stock       challan pending stock       actual stock

Pending stock: material to be issued to vendor for proceessing

Challan pending stock: to be recieved from vendor after processing.

Actual stock: pending stock+challan pending stock.

Accepted Solutions (0)

Answers (1)

Answers (1)

binoy_vargis1
Active Contributor
0 Kudos

Have you tried options in standard.

Please check ME2O report in standard and J1IFR(Annexure IV option) for your requirement.

Former Member
0 Kudos

Hi sir,

Thank you for quick answering i have tried in ME2O, MBLB, ok, i need to capture all processses in this report with the above tabular columns

binoy_vargis1
Active Contributor
0 Kudos

You need these three informations

  1. Pending stock: material to be issued to vendor for proceessing

        You have to find all Subcon. POs from Table EKKO,EKPO. Po number need to be passed to EKET Table and need to fetch "Reservation Number". Take this number and goto RESB table to get all components. You can find issue documents from MSEG table by passing 541 and PO Number. You need not consider all 541 documents which have been converted to Challan as it will be already considered with point no. 2

   2. Challan pending stock: to be recieved from vendor after processing.

        From Table J_1IEXCDTL by selecting 57F4 take all the stock from all the Challans which are having "status" P -Inprocess. (Reconciliation and completion not done.)

   3. Actual stock: pending stock+challan pending stock.

        This is just calculation.

I think there are many validations and considerations to be made. I think you can build from here.

Regards

Binoy

Former Member
0 Kudos

Dear Sir,

Can you please share in detail iam new to sap mm, can you explain what are all the input parameters need to give, and if to bring the process description in the report, how can we bring?

Thanks in advaance.

binoy_vargis1
Active Contributor
0 Kudos

Input parameters can be Company code, plant and date range etc. as per business requirement. Contact your Technical team for more help.

Regards

Binoy

Former Member
0 Kudos

Ok, i will contact them then how to bring process description like paintaing, machining, etc in the output report.

binoy_vargis1
Active Contributor
0 Kudos

I think you can maintain it in some text field in PO or Challan and fetch it to the report.

Regards

Binoy