topic ALV Grid output problem in Application Development and Automation Discussions

ALV Grid output problem

ak_upadhyay — Mon, 14 Apr 2008 06:07:53 GMT

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...

Re: ALV Grid output problem

Former Member — Mon, 14 Apr 2008 06:12:44 GMT

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

Re: ALV Grid output problem

Former Member — Mon, 14 Apr 2008 06:14:35 GMT

Hi,

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

Re: ALV Grid output problem

Former Member — Mon, 14 Apr 2008 06:15:33 GMT

Hi,

Check the fieldcatalog?

Thanks,

Sriram Ponna.

Re: ALV Grid output problem

ak_upadhyay — Mon, 14 Apr 2008 06:17:46 GMT

Hi Arun,

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

Thanks