06-05-2009 9:34 AM
hi
i want all the entries in knov table where t685a-kmanu is 'D'
help plz
sravz
06-05-2009 9:50 AM
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
06-05-2009 9:39 AM
Please check your table name. There is no table with name knov.
Best Regards,
Suresh
06-05-2009 9:41 AM
06-05-2009 9:50 AM
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
06-05-2009 9:55 AM
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
06-05-2009 10:01 AM
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
06-05-2009 10:22 AM
Thanks everyone for ur help.the issue is resolved
Regards,
Sravanthi Chilal