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

[former_member183402]

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.

[former_member185682]

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

[former_member183402]

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.

[former_member185682]

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

[former_member233854]

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