topic Re: Query + code in Application Development and Automation Discussions

Query + code

Former Member — Mon, 10 Jul 2006 13:42:13 GMT

Dear all,

I want to select value in one table, with the value I got from the query

EX:

3 fields on my table F1(P0001-GSBER), F2(P0001-BTRTL), F3.

I extract with query F1 and F2 and I want to display F3.

Can you pls Help me

Tell me if i'm not clear.

Thx

Re: Query + code

Former Member — Mon, 10 Jul 2006 13:54:02 GMT

You may want to try a subquery. Put your cursor on a select statement and press F1 (Help). Subquery (in 4.7) is one of the options.

rob

Re: Query + code

Former Member — Mon, 10 Jul 2006 14:26:38 GMT

Thx Rob but i'm not using query a lot. Can you tell me step by step

sq01...

Thx

Re: Query + code

Former Member — Mon, 10 Jul 2006 14:32:27 GMT

I use 4.6

Re: Query + code

Former Member — Mon, 10 Jul 2006 14:39:01 GMT

The help on subquery is in the same spot in the 4.6C help.

Without knowing more detail about your requirements, it's hard to provide more information.

Rob

Re: Query + code

Former Member — Mon, 10 Jul 2006 14:52:16 GMT

I'll trie to be clear,

I had to make a report with Area, sub-Area. I had to display an other information depending to Area and sub-Area.

This information is store in a table.

Structure of that one is Area, Sub-Area and the famous data.

Where should I go to find subquery?

Thw rob

Re: Query + code

Former Member — Mon, 10 Jul 2006 15:02:25 GMT

What's the third table?

Rob

Re: Query + code

Former Member — Mon, 10 Jul 2006 15:03:39 GMT

It's a table I created with 3 fields:

-Area

-Sub-Area

-Room

Re: Query + code

former_member181966 — Mon, 10 Jul 2006 15:12:24 GMT

Are you talking about Adhoc query /Infoset ?

If yes Goto->SQ02.. Then click extras->Create. a pop-up will come asking additional fields/additional table etc.. Choose field and code it . Don’t forget to give the sequence of field . give sequence of field accordingly .

FYI

http://www.sappoint.com/abap/ab4query.pdf

Hope this’ll give you idea!!

<b>Pl... award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: Query + code

Former Member — Mon, 10 Jul 2006 15:48:41 GMT

OK - you may not need the subquery. See if this helps:


REPORT ztest NO STANDARD PAGE HEADING LINE-SIZE 255
  MESSAGE-ID 00.

TABLES pa0001, ztab.

SELECT-OPTIONS: s_gsber FOR pa0001-gsber,
                s_btrtl FOR pa0001-btrtl.

DATA: BEGIN OF itab OCCURS 0,
        gsber LIKE pa0001-gsber,
        btrtl LIKE pa0001-btrtl,
      END   OF itab.

DATA: BEGIN OF itab1 OCCURS 0,
        gsber LIKE pa0001-gsber,
        btrtl LIKE pa0001-btrtl,
        room  LIKE ztab-room,
      END   OF itab1.

SELECT gsber btrtl
  FROM pa0001
  INTO TABLE itab
  WHERE gsber IN s_gsber
  AND   btrtl IN s_btrtl.

CHECK NOT itab[] IS INITIAL.

SELECT gsber btrtl room
  FROM ztab
  INTO TABLE itab1
  FOR ALL ENTRIES IN itab
  WHERE gsber = itab-gsber
  AND   btrtl = itab-btrtl.

Rob

Re: Query + code

Former Member — Mon, 10 Jul 2006 15:57:04 GMT

Where should I put that code?

Re: Query + code

Former Member — Mon, 10 Jul 2006 18:18:43 GMT

That's entirely up to your requirements. Without them, I really can't say. What I've written is a complete program that uses select-options to try to mimic what you are trying to do. You will have to adapt the code to fit your situation.

Rob