Skip to Content
0

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

Mar 09, 2017 at 09:19 AM

49

avatar image
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.

screenshot1.jpg (105.5 kB)
screenshot2.jpg (103.9 kB)
screenshot3.jpg (79.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jitin Chawla
Mar 09, 2017 at 10:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 09, 2017 at 11:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Mar 09, 2017 at 12:48 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded