ALV Grid output problem

[ak_upadhyay]

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

pb9003_{pernr = pb0002}pernr. 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

[Former Member]

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

[ak_upadhyay]

Hi Arun,

I got it. i already assingd the fields but with wrong field name.

Thanks

AK

[Former Member]

Hi,

send me the fields in the fieldcatalog and also definition of final ALV output table with fields.

[Former Member]

Hi,

Check the fieldcatalog?

Thanks,

Sriram Ponna.