A quary in abap

[Former Member]

Hai

i am new to abap . I had a query that ,Is it possible  to get a same field data in diff tables  in to single output field .

plz help me to solve this process

Moderator message : Search for available information, discussion locked.

Message was edited by: Vinod Kumar

[Former Member]

Hi,

see , your having the field name called pernr in pa0001, that field contains some data like 11111.

If you check the same field name in pa0006, same will be der na..

Regards,

vijay

[Former Member]

tnx for ur reply  .

can u plz provide me a simple code for fetch matnr  from tables a304 ,a004,a3005 in to  single output field it should be in selection screen and output field

plz help .for this solution ..

thank u .

[Former Member]

Hi,

First try it, in that your getting any doubts, start discuss.

Regards,

vijay

[vinoth_aruldass]

hi,

you can use join for this ,

ex

select matnr from a304

into lv_matnr

join a004 on a004-matnr = a304-matnr

join a3005 on a3005-matnr = a304-matnr.

now the lv_matnr will display the material no which there in all the tables.

hope it helps,

Vinoth

[vinoth_aruldass]

hi,

it is possible . do some basic study in select statement in SCN and google out.

hope it helps,

Vinoth.