Skip to Content

How can I get values of Document and Doc. Row displayed in Stock Listing Price in SAP B1?

Hi all,

How can I get values of Document and Doc. Row displayed in Stock Listing Price in query of SAP B1?

What are the tables store below values (Document and Doc. Row)

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 26, 2017 at 02:40 PM

    Try to run the SQL Profiler before running this "Report", you can check the queries there and look for your table

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 04:54 PM

    Hi Rurangwa,

    Probably this information is from the view B1_OinmWithBinTransfer, in this view you are able to see all movements of stock.

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rurangwa,

      Probably IM is the initials of the description of some object type.

      Probably this field is a concat of the description of object type that is stored on TransType field with the id of the document stored on field CreatedBy.

      Hope it helps.

      Kind Regards,

      Diego Lother

      img.png (29.0 kB)