Skip to Content
0
Former Member
Jan 11, 2006 at 10:14 PM

select statement n joining condtion..

79 Views

Hi Friends,

In a Report, I have the Material Numbers dispayed as of now. I have to select/display the rate(condition amount) for each Material Number that is on the list....

I have realized that I can relate the Mat. No with the Rate by using 3 tables....

1.MARA

2.A505

3.KONP.

I'm thinking to relate this rate(KONP-KBETR) with Mat No(MARA-MATNR) like this....

JOIN the MARA-MATNR with A505-MATNR and then A505-KNUMH with KONP-KNUMH and then retrieve KONP-KBETR...

but i dont know how to write the select and joining condition...

as of now... i have a INTERNAL TABLE :- i_matdata.

which contains the mat. no's

help me, plz...

thanks,

raj