topic Re: Compare fields in Application Development and Automation Discussions

Compare fields

Former Member — Thu, 22 May 2008 13:10:11 GMT

Dear all,

I will not use SE38 to create ABAP for simple problem below.

I'd like to compare 2 fields in EKKO table. EKKO-AEDAT and EKKO-BEDAT.

Is there a way to achieve that ? how about SQ01, SQ02, SE16, etc ...

I believe there must be a way just for comparing content of two columns.

Points will be awarded for sure.

Regards,

BWAS

naimesh_patel — Thu, 22 May 2008 13:13:55 GMT

Yes, you can do it with the SQ01.

Create a join on EKKO with EKKO (create aliase like EKKO_1 and table EKKO) and join them on your required dates.

It will give you only those records which have both dates same.

Regards,

Naimesh Patel

naimesh_patel — Thu, 22 May 2008 13:14:05 GMT

Please ignore.

Edited by: Naimesh Patel on May 22, 2008 8:14 AM