Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

link between t685a and knov table

Former Member
0 Kudos

hi

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

help plz

sravz

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

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

Best Regards,

Suresh

0 Kudos

Hi suresh ,

its konv not knov.

Former Member
0 Kudos

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

0 Kudos

Hi,

Use like below:

SELECT a<fields from Konv> into table itab_konv from KONV as a inner join t685a as b on aKAPPL = bKAPPL AND aKSCHL = bKSCHL where bKMANU = 'D'.

Thanks and Best Regards,

Suresh

Former Member
0 Kudos

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

0 Kudos

Thanks everyone for ur help.the issue is resolved

Regards,

Sravanthi Chilal