Table linking

Former Member — Tue, 08 May 2007 14:33:40 GMT

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?

Re: Table linking

Former Member — Tue, 08 May 2007 14:43:59 GMT

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

topic Table linking in Application Development and Automation Discussions

Table linking

Re: Table linking