Skip to Content
0

Where and How to Find Quantity Values of BIN Location

Oct 13, 2017 at 08:16 AM

170

avatar image

Hello Everyone,

Good Day,

May I kindly ask if anyone out here can help me find the location of table 'RBIN' in SAP SQL database ? because i cant seem to locate the quantity value for each BIN Location. Because i would need to find the BIN Location assigned to an Item in a document (ex. Goods Receipt PO )

Hope to hear from you all,

Many Thanks,

Noel

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

1 Answer

Best Answer
DIEGO LOTHER Oct 13, 2017 at 11:42 AM
0

Hi Noel,

You can find this information on OIBQ table.

A query using OIBQ here https://answers.sap.com/questions/84872/index.html

Kind Regards,

Diego Lother

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

Good Day Diego,

First, thank you for you for providing solution which i think is very helpful and enlighting.

( I also got the chance to check the table OIBQ, which is very helpful ).

However, what I am looking for is how am i able to see or find which (table)

specific BIN Location will quantities will be placed ?

For example, If i have two BIN Location namely as "BinOne" & "BinTwo",

then I will create a GRPO which includes 10 Quantity of cigar , then i will

place 7 of the items in "BinOne" and 3 of the items in "BinTwo". Now,

the question is, in which table/s in SAP (if there is one) i will be able to find

which BIN Location the 7 of the items and 3 of the items have fallen ?

If my terminology is correct, my target is to track down in which BIN Location

has the '7' qty and '3' qty of those cigars/item.

Hope to hear from you again.

Thank you

Noel

0

Hi Noel,

If I'm not wrong, you can use the view B1_InvPostListILWithBinView to your purpose.

A sample:

SELECT 
	ApplyType AS 'DocType',
	ApplyEntry AS 'DocEntry',
	ApplyLine AS 'LineNum',
	LocCode AS 'Warehouse',
	T1.BinCode AS 'Bin',
	Quantity AS 'Quantity by Bin Location'
FROM 
	B1_InvPostListILWithBinView T0
	INNER JOIN OBIN T1 ON T0.BinAbs = T1.AbsEntry AND T1.WhsCode = T0.LocCode

DocType is code that represent the document that generated this entry.

A list of object types you can see here:

https://blogs.sap.com/2017/04/27/list-of-object-types/

Hope it helps.

Kind Regards,

Diego Lother

0

Hi Diego,

Thank you very much for re-commenting on this, but i find it confusing why is the table view name "B1_InvPostListILWithBinView" is empty. (so i got no data left to link with table OBIN)

Is there any other option/way to trackdown the bin location per quantity ? Sorry I just think i need to show the image

Hope to hear from you again

Thank you

Kind Regards

Noel

no-data.jpg (151.3 kB)
0

Hi Noel,

Are you sure the query is executed on correct database?

In my case shows correct:

I saw inside this view and found the table that stores the bin transactions. it is OBTL. In OBTL you are able to see the quantity and the bin location of each transaction. To get details of the transaction, you should join the table OBTL.ITLEntry with OITL.LogEntry. In OITL you are able to see the document entry, document line, document type and item code of made the transaction on bin location.

My version is SAP Business One 9.1 PL 13

Hope it helps.

Kind Regards,

Diego Lother

img1.png (38.2 kB)
0

Hi Diego,

Thank you for taking time to test my scenario. However, i did check & re-check my tables and the result is unfortunate. The table "B1_InvPostListILWithBinView" is an empty table. Although, I did the same as your example by opening a sample database (SBODEMOUS) - and it does include some data, however for the live database, it does not show anything.

(At this point , i cannot make a simulation using your sample code due to lack of data in that table)

Are there any table in SAP still be able to provide us such information on BIN Location ?

(we are both using the same SAP version)

Thank You & Kind Regards

Noel

0

Hi Noel,

I performed a lot of transaction and every data about bin transaction was saved on OBTL table.

A correction. On last answer I said to join OBTL with OITL, but this is only for itens with batch/serial management.

Then, after look OBTL table, if you want to get more details about the transaction, you should join OBTL.MessageID with OILM.MessageID.

A sample:

SELECT 
	T1.TransType AS 'DocType',
	T1.DocEntry,
	T1.DocLineNum,
	T1.ItemCode,
	T1.LocCode AS 'Warehouse',
	T2.BinCode AS 'Bin Name',
	T0.Quantity AS 'Quantity By Bin Location'
FROM 
	OBTL T0
	INNER JOIN OILM T1 ON T0.MessageID = T1.MessageID
	INNER JOIN OBIN T2 ON T2.AbsEntry = T0.BinAbs

Hope it helps.

Kind Regards,

Diego Lother

img.png (26.6 kB)
1

Hi Diego,

It is good to hear from you again, I've been looking at the table OILM & OBTL for quite a while since last week,

didn't knew they were related. But now, I'm able to find which bin location did the item got into and the data looks

accurate. (this is amazing). This is what I've been looking for in a while.

Thank you so much for the time and support. :)

Thank you very much

Appreciate the Help. God Bless you

Noel

0

Hi Diego,

Would Like to ask also, If you dont mind.

Where can I trace-back the DocEntry of table OILM ??? the column name "messageid" seems is not the document entry number for it. I would need to trace back where ( what DocEntry and TransNum ) it came from ?

That's the final and only question i got for the thread.

Hope to hear from you

Thank you and Best Regards

Noel

0

Hi Noel,

Look the image above.

Column 1 (MessageId) - Primary key of OILM table

Column 2 (TransType) - Indicates what type of the document generated the register, in this case 20 (Goods Receipt PO). For a full list of document types you can look here.

Column 3 (DocEntry) - It's the primary key of the document table, in this case the docEntry from table OPDN(Goods Receipt PO).

Column 4 (DocLineNum) - It's the LineNum field of the document line, in this case the LineNum of the table PDN1(Goods Receipt PO - Lines). Remember, this sequence start with 0.

Column 5 (ItemCode) - It's the ItemCode field of the document line, in this case the ItemCode of the table PDN1(Goods Receipt PO - Lines).

Column 6 (LocCode) - It's the WhsCode field of the document line, in this case the WhsCode of the table PDN1.

Hope it clears.

Kind Regards,

Diego Lother

img1.png (36.8 kB)
1

Hi Diego,

Your answers cleared my question. This is very helpful. Though i did found one table i can link the table OILM, its a table named "B1_OinmWithBinTransfer". Again, thank you for the support and giving me a clear view.

Many thanks and Kind regards

Noel

0