topic Re: Regarding ALV in Application Development and Automation Discussions

Regarding ALV

Former Member — Fri, 12 Jan 2007 10:27:03 GMT

Hi Experts,

I want to print two different internal tables data into one ALV report. I am having one data base table and i am having one Ztable with same data elements but ztable every fields is starting with Z.

like data base table : PERNR

ztable fields : ZPERNR

Re: Regarding ALV

Former Member — Fri, 12 Jan 2007 10:45:23 GMT

so and what is the problem. you define a structure for you're alv with the same fields as you're tables and you append them to you're internal table with format you're defined alv structure

something like this

select * from pernr into corresponding fields of table zalvpernr.

select * from zpernr into corresponding fields of table zalvpernr.

or use append otherwise

Re: Regarding ALV

Former Member — Fri, 12 Jan 2007 10:53:33 GMT

Hello,

Join these two table into a single tablle like this.

SELECT A_{PERNR ...... into table itab from table as a inner join ZPERNR as b on a}pernr = b~zpernr.

If useful reward.

Vasanth

Re: Regarding ALV

Former Member — Fri, 12 Jan 2007 10:53:59 GMT

sorry i cant get your proper requirement but as you told you cant print 2 itab in single alv list or grid display.

you have to use alv block list for that.

if there any situation that you can take the data from two tables to single itab then try it in simple list or grid display.

regards

shiba dutta

Re: Regarding ALV

Former Member — Fri, 12 Jan 2007 10:59:57 GMT

tell me ur exact requirement.....

>> u want to show in separate 2 table in output or

>> u want to show both table contents in one single table ???

pls explain clearly...

Ramesh.