Skip to Content
0

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

Apr 26, 2017 at 01:34 PM

64

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Danilo Kasparian Apr 26, 2017 at 02:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
DIEGO LOTHER Apr 26, 2017 at 04:54 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Diego,

I tried to search in view of B1_OinmWithBinTransfer but there is no column of Document which has data of this format IM51

IM52, ...........

The document column in posting stock list is DocNum of stock transfer but I do know where DocNum with prefix comes from.

0

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)
0