LOOK at this once

[Former Member]

i want to get data from tables iseg(matnr,waers...etc and one field from t5d5e(difmg)...

there is no key field here...in both...is it possibel ..?..how can i join these tables to prepare a report...

pls share ur ideas...

Message was edited by: mpr raju

Message was edited by: mpr raju

[Former Member]

Find an extra table which has keyfields in both tables to link them.

[Former Member]

there is no key field related any other table...what i have to do at this situation...

thanks in advance..

raju

[Former Member]

why do you wanna like them ?

If there are no relation betweens them maybe make 2 differents reports

Message was edited by: STEPHAN KAMINSKI

[Former Member]

Raju,

For sure you can not join those two tables not having a common key field.

As Stephen said, you can only seperate those two tables in to two seperate reports.

Reward points to useful answers.

Regards,

[Former Member]

just retrieve data from these tables into internal tables.

create relation between these internal table with extra column.

hope this help

regards

[Former Member]

What is the logical relationship between the two tables in your report? If you have a record from ISEG, how do you determine the corresponding record from t5d5e?

Rob

[Former Member]

HERE the relationship between two table are ...

in t5d5e field called difmg is the difference between the inventory counted qty and booked qty....all the fields for my report is there is iseg execpt DIFMG...this field is not there in any other and also no key field from the t5d5e..

raju

[Former Member]

Raju - are you sure you have the right table? the description for t5d5e-difmg is "Registration reason for difference registrations".

Rob