Skip to Content
0

SAP B One database Link OINS with OITL

May 09 at 11:14 AM

19

avatar image
Former Member

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.

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

1 Answer

Agustin Marcos Cividanes May 09 at 01:06 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded