link between t685a and knov table

[Former Member]

hi

i want all the entries in knov table where t685a-kmanu is 'D'

help plz

sravz

[Former Member]

Please check your table name. There is no table with name knov.

Best Regards,

Suresh

[Former Member]

Hi suresh ,

its konv not knov.

[Former Member]

Hi,

First select the fields KAPPL and KSCHL of table T685A with KMANU as 'D' in an internal table. Now read records of this internal table one by one and choose records having these combinations of KAPPL and KSCHL from KONV table into another internal table.

Regards,

Kanupriya

[Former Member]

Hi,

Use like below:

SELECT a_{<fields from Konv> into table itab_konv from KONV as a inner join t685a as b on a}KAPPL = b_{KAPPL AND a}KSCHL = b_{KSCHL where b}KMANU = 'D'.

Thanks and Best Regards,

Suresh

[Former Member]

Hi Shravanthi,

Define two internal tables i_konv and i_t658a with the fields as per your requirement and do the selections as follows.

Select KAPPL

KSCHL

KRECH

KZBZG

KNTYP

From t685a

Into table i_t685a

Where kmanu = 'D'.

If i_t685a is not initial.

Select (name of the fileds you want from KONV table)

Into table i_konv

For all entries in i_t685a

Where KAPPL = i_t685a- KAPPL.

KSCHL = i_t685a- KSCHL

KRECH = i_t685a- KRECH

KZBZG = i_t685a- KZBZG

KNTYP = i_t685a- KNTYP

Hope this will help.

Regards,

Deepa Kulkarni

[Former Member]

Thanks everyone for ur help.the issue is resolved

Regards,

Sravanthi Chilal