Report Based on Returnable Packaging Material

[MangeshP]

Dear SD Experts,

I am not a SD Consultant, so please help me. Here is my requirment.

I sale Gas such as Oxygen in cylinders. I sale oxygen to a Customers in 5 cylinders. Each cylinder has unique number.

Now when I post goods issue I mention the Oxygen Gas quantity and as well as Cylinders quantity.

Means

Oxygen M:aterial No:- OXY10001 - 500 Kg.

Cylinders material No:- CY1003 ( Each cylinder has unique Numer say 1312, 1313,1314,1315,1316).

My requirement is is there any standard report in SAP SD which gives me output as the list of all the customers which had been sent this cylinder 1312 in past. or Cylinder 1312 is with which cutomer.

Also when a Post goods issue is done is there any field where we enter cyclinder numbers 1312, 1313,1314,1315,1316.

Hope I have cleared my requirement.

With Warm Regards

Mangesh Pande

[Former Member · Accepted solution]

HI Mangesh,

Go to T.code "MB58" and give the inputs and try.

Thanks

Dasaradha

[MangeshP · Accepted solution]

Dear Dasaradha,

Thanks for your reply. I am able to see that stock. But my requirement is I want to search based on the cylinders serial Number and not cylinders Material Numbers.

Or if standard report is not there is there any field where we can mention the cylinder serial numbers for particular sales order or Post Goods Issue.

Waiting for your reply.

With Warm Regards..

Mangesh Pande

[Jelena]

Serial numbers are rather hard to get to for reporting. They're stored in different tables, take a look at SER* (SER01, etc.), depending on how they're entered. Details will probably be in the table OBJK.

Since material number (MATNR) is known, make sure to start from the material index table (VAPMA for sales or VRPMA for billong documents) for better performance.

Ironically, I am also not an SD consultant. Good luck!