Join OBJK,SER05 and SER02

[Former Member]

Dear All,

Please let me know if it is possible to join the tables to create the queary(sq01,2,3).

If i join OBJK and ser05 it is working fine...if i join three tab;es the system is saying no seltion for data.

Among three tables common field is OBKNR....please let me know how can i join this thress tables ...i want the out put is..

Sales order.....Production order.....serial number....

br,

Chandu

[raymond_giuseppi]

As write use an outer join as records in SER02 are not always related to records in SER05, you must perform the union of both selections OBJK+SER02 (SD orders) and OBJK+SER05 (PP orders)

Try something like

Regards,

Raymond

[iklovski]

Hi,

Normally, it should work. Check that it's left outer join to OBJK table from both SER05 and SER02.

Regards,

Eli