Table linking

[Former Member]

Hi,

we are trying to link 2 tables named ESSR & MSEG while making a query, on table ESSR field name "External document number" & in table MSEG "Material document No." is having same data but the sys is not allowing to link them

can any one help how we can link this 2 table?

[Former Member]

Hi,

we are trying to link 2 tables named ESSR & MSEG while making a query, on table ESSR field name "External document number" & in table MSEG "Material document No." is having same data but the sys is not allowing to link them

can any one help how we can link this 2 table?

[Former Member]

The fields which you are linking may not have the same data characteristics.

One is have 10 Characters and i think the other is having more than 10 characters.

Better to write two different select statements instead of a join statement.

1. Get the details from ESSR.

2. Get the details from MSEG--> for all entries in ESSR.

Here in the where condition map those relation ship. But even here you will get a syntax error becasue of the field mismatch.

While declaring the internal table which store ESSR value Use the "Material document No" data type instead of the original one.

Raj