Skip to Content

Inventory List division wise

Jan 13 at 10:03 AM


avatar image

Dear Experts,

We have a client who is having single Plant 1001 and Material type Raw Material, Semi-Finished and Finished Goods. Now we have mapped according to this requirement in the system. Later on, Client informed us that Plant 1001 has two division - Div A and Div B, and Raw Material which is procured is used for Demoestic Use RM for Domestic Client and Export Use RM for Export Client. Now he want to see to see Inventory, on the basis the Plant wise, Division wise as well Domestic Use or Export Use wise.

Kindly suggest me.. for above problem.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jürgen L
Jan 13 at 10:17 AM

In short, there is no such report in SAP. The main inventory report is transaction MB52.

An ABAPer can create your own inventory report based on your company specific requirements.

However, you have to keep in mind that a report is actually based existing data. Where do you specify the required information e.g. division or usage in your inventory in your design that your ABAPer can know that a part of a raw material belongs to Division A and the other part to Division B? Where do you define the usage of a part of a material stock?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Yes, this another challenge where to specify division and usage information and both things client decide during GR time.


"client decide during GR time"

How does he do it? and where does he record this info?


In existing ERP they are managing, however, they have two blocks A & B and so they put any block at GR.

Salman Mazhar Jan 15 at 06:43 AM

Create two different materials where you can maintain division separately for each division in master data. You may differentiate materials while having a key after description as DU for Domestic Use and EU for Export Use. This will help you to see inventory as per client requirement furthermore, it will also make you able to run on different costing and pricing strategies.

Appreciate if you would share reason on not having different material as a solution.

Kind Regards,


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Need to maintain description as it is and so it is not feasible to make two materials of same description.


Can you maintain separate location on base of division so that inventory can be segregated accordingly?