Default SAP Report "Stock Status" but in excel format WITH the drill downs?

[Former Member]

There is a built in report in SAP B1 v 9.1 called "Stock Status" which is under Reports > Stock Management.

I need this in excel format which I know is easy enough to do with a right click > Copy Table however you can double click on each row to see open sales orders and purchase orders against that line - I need this information in the excel too..

I cannot begin to start writing in a query in SAP because when I hover over the fields, no tables are mentioned, as it's a form?

What is the best way to achieve this?

A few screenshots attached.

[kothandaraman_nagarajan]

Hi,

Try this query, its similiar to stock status report. But you may need fine tuning.

SELECT T0.[ItemCode], T0.[ItemName], SUM(T1.[OnHand]) as InStock, SUM(T1.[OnOrder]) as 'Ordered Qty', SUM(T1.[IsCommited]) as 'Committed Qty' , 'Ava Qty' = SUM(T1.[OnHand]) + SUM(T1.[OnOrder]) - SUM(T1.[IsCommited]) FROM OITM T0 INNER JOIN OITW T1 ON T0.[ItemCode] = T1.[ItemCode] GROUP BY T0.[ItemCode], T0.[ItemName]

Regards,

Nagarajan

[Former Member]

Hi,

Create one more sheet with in the Report and and all required fields which are there in drill down will solve your issue.

Export all documents as with in single excel with multiple sheets.

Thanks,

Srinu

[jitin_chawla]

Hi,

Unfortunately, it is not possible to get the drill down of each item and get the desired detailed reported exported out of system.

You need to either, double click and open each one of rows and export it and align under each item or write a customized query including the data from table PCH1, POR1, RDR1, INV1, ORDR, OINV, OPCH, OPOR, OITT, ITT1, OWOR, WOR1 etc.

Regards,

Jitin