04-14-2008 7:07 AM
Hi All,
I m working on ALV grid reports. m developing a report for HR module.
m fetching the data from 2 tables with innerjoin. first table is
pb9003 & the other is pb0002. m fetching the Applicant first name
& last name from pb0002 and rest of other fields from pb9003 by joining
pb9003pernr = pb0002pernr. but in my output it is showing Pernr (appicant no.)
instead of first name and last name in the first name & last name field.
In classical report output i m getting the correct data means applicant first name
and last name in the fields with the same select query.
my select query is....
SELECT
I~PERNR M~VORNA M~NACHN I~BEGDA I~XCERT I~XMARK I~XIICERT I~XIIMARK I~GRDDG
I~PGDRG I~EXPLT I~OFFLT I~APPLT I~PSLIP I~IDPRF I~ADPRF I~PFOTO
I~PCFOTO I~ANYOTHR I~PRESG I~PFORM I~ESIFO I~GRTUTY I~ODOCS
INTO TABLE IT FROM PB9003 AS I
INNER JOIN PB0002 AS M ON I~PERNR = M~PERNR
WHERE I~PERNR IN PERNR AND I~BEGDA IN BEGDA.
Plz tell me, What is the problem??????
Thanks in Advance...
AK
04-14-2008 7:12 AM
Hi Ak,
Since you told, it coming correctly in Classical report the problem is not with the select query.
Better you check the field catalog you made for the ALV.
I guess you have mis assigned the fields there.
Hope this helps you.
Thanks,
Arun
04-14-2008 7:12 AM
Hi Ak,
Since you told, it coming correctly in Classical report the problem is not with the select query.
Better you check the field catalog you made for the ALV.
I guess you have mis assigned the fields there.
Hope this helps you.
Thanks,
Arun
04-14-2008 7:17 AM
Hi Arun,
I got it. i already assingd the fields but with wrong field name.
Thanks
AK
04-14-2008 7:14 AM
Hi,
send me the fields in the fieldcatalog and also definition of final ALV output table with fields.
04-14-2008 7:15 AM