Skip to Content
0

Transaction query bacth number of OINV and INV1 table relation

Apr 01 at 09:19 AM

27

avatar image

Hi ..

SELECT T1.DocDate, T1.CardCode, T1.CardName, T1.NumAtCard, T2.Quantity, T2.Dscription, BATCH_NUMBER
from OINV T1 INNER JOIN INV1 T2 ON T1.DocEntry = T2.DocEntry
WHERE T1.CANCELED = 'N'


How does query show sales transaction from OINV and INV1 table with batch number ??
please help to complete the query with other tables.

Thank you in advance.

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

2 Answers

Edy Simon Apr 02 at 01:03 AM
0

Hi Rizky,

Batch/Serial Numbers are not stored in INV series table.

Please look into the OITL and sub tables + OBTN


Regards
Edy

Share
10 |10000 characters needed characters left characters exceeded
ANKIT CHAUHAN
Apr 02 at 11:13 AM
0

Hi Rizky wawan,

Adding to the Edy's Reply mentioned above:

Always try to search the existing threads before creating your own question. Try to search with "batch number in sales invoice query in sap business one" and you will get a lot of discussions about it that are already there. Here is a thread which might help you:

Batch in Sales Invoice

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support

Share
10 |10000 characters needed characters left characters exceeded