Skip to Content
avatar image
Former Member

SAP B One database Link OINS with OITL

Dear all

I have problem in database SAP B1 I want get posting date in table OITL and Now I have data is internalSN in OINS I have no idea how two join these.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 09 at 01:06 PM

    Hi

    try this SQL statement:

    SELECT yourFields FROM OINS T0 INNER JOIN OSRI T1 ON T1.itemcode = T0.itemcode and T0.internalSN = T1.intrserial INNER JOIN ITL1 T2 on T0.itemcode = T2.itemcode AND T1.SysSerial = T2.SysNumber INNER JOIN OITL T3 on T2.logentry = T3.logentry WHERE yourconditions

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded