Skip to Content
avatar image
Former Member

Transaction query bacth number of OINV and INV1 table relation

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 02 at 01:03 AM

    Hi Rizky,

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

    Please look into the OITL and sub tables + OBTN


    Regards
    Edy

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02 at 11:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded