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
Bluesky
