Skip to Content
0
Former Member
Apr 14, 2008 at 06:07 AM

ALV Grid output problem

23 Views

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