Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV Grid output problem

ak_upadhyay
Contributor
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

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

0 Kudos

Hi Arun,

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

Thanks

AK

Former Member
0 Kudos

Hi,

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

Former Member
0 Kudos

Hi,

Check the fieldcatalog?

Thanks,

Sriram Ponna.