Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 09, 2017 at 10:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 11:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 12:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded