Skip to Content
avatar image
Former Member

Inventory Valuation Report automatic and without modifying last evaluated price

Hallo everybody,

maybe this is a strange request, but vital for my configuration: since we use last evaluated price as base price for a production addon, I need two things:

  1. inventory valuation report to be run in automatic at certain hours
  2. Possibility to run the report without modifying last evaluated price

We do not use stock continuous.

For the request n.2, all I really need is to have the SQL query/procedure SAP uses to do the report, then I can manage it myself.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 04, 2016 at 01:26 PM

    Hi

    You can find the stored procedure in SBO-COMMON.dbo.SCSP table.

    You cannot modify, you have to make a CR report or a query for your requirements.

    Kind regards

    Agustín Marcos Cividanes

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the reference to SCSP table, but could you be more specific?

      There are 1780 rows and none explicitily refers to the inventory valuation report...

  • Apr 04, 2016 at 11:39 AM

    Hi Damiano,

    You best bet is probably to use SQL Server Profiler from MS SQL Management Studio (Tools menu), to see what queries B1 runs to get the data.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2016 at 06:47 AM

    Up! Nobody can help?

    Add comment
    10|10000 characters needed characters exceeded

    • Okay, well moving average is in itself a simple calculation, it is just that you need the entire purchase- and production history of the item.

      The report just looks at all purchase and production transactions that get quantities into warehouse stock, and at what price.

      The system report takes all possible transactions into account, because it has to, but you may be able to limit the tables, if you do not use all possible methods of increasing an item's stock.

      Which transaction types do you (possibly) use to increase stock, and/or change the value of stock ? Just to name a few:

      • Goods Receipt P/O (OPDN, PDN1)
      • A/P Invoice (OPCH, PCH1)
      • (A/R) Returns (ORDN, RDN1)
      • A/R Credit Memo (ORIN, RIN1)
      • Goods Receipt (OIGN, IGN1)

      but there are quite a few more transactions with which you can influence stock and its value.

      Does your process apply to all items, or only to say component items ? This in turn may limit the sort of transactions that you need to take into account.

      P.S. A simple way to get the trace result into Excel, is to select all rows (select first row, hold shift, select last row) from the trace window, and copying them (CTRL+C). Then open Excel, change all columns, except B to Text, and paste (CTRL+V).