cancel
Showing results for 
Search instead for 
Did you mean: 

Standard report on Stock Status

former_member235471
Active Participant
0 Kudos

Hi,

I need stock report in Inventory with the following output fields,

1.Material

2.Material Description

3.Flagged Material For deletion (Yes/No)

4.Plant

5.Storage Location

6.Division

7.Valuated Stock (Qty & Value)

8.Consignment Stock (Qty & Value)

9.Total Stock (Qty & Value)

Any standard reports available to generate this report cantaining all these fields.

Regards,

Baskar

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

Not available in standard SAP. you have to develope it by yourself.

Answers (3)

Answers (3)

former_member197616
Active Contributor
0 Kudos

Hi,

Through there is no standard report for your requirement , for your query creation you can use the tables MARA,MARC,MARD,MBEW for the purpose.

Please check the t code MMBE for reference it will give the stock of all the stock types and use the tables.

Regards,

Former Member
0 Kudos

Bhaskar,

There is no standard report in SAP which will give u all the required information.

I think you have to take help from ABAP team and develop the report.

Former Member
0 Kudos

hi,...

For any kind of damn report.:

In SQVI...

Enter some name..like zxxxxx. Create..

Enter description.

Data source: select table join

Enter

Click the insert table iconu2026enter the first table name

Again Click the insert table iconu2026enter the second table name

Then come back..

You will see all the fields in both the tables with two boxes next to each field..

The first box is the thing which you need to get in the output and the next box is for the inputting stuff..

Put tick mark in the relevant boxes according to ur requirementsu2026and execute...

Now save. Go to system...ststus....copy the program name..

THen go to se93...give the transaction code of your choice. create...paste the program you copied.. then save it as a local object..save...

Regards,

AMit P hiran

njoy SAP....

njoy lyf....