topic how to fetch data from single database table using 2 internal tables. in Application Development and Automation Discussions

how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 08:43:40 GMT

Hi friends,

i am a new user of ABAP and also SDN.

i need a help.

i want to fetch data from one database table based on primary keys of 2 internal tables. how to put in where clause.

Thanks in advance.

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 08:47:19 GMT

hii

refer to following code ..i hope it will help you

SELECT matnr                         " Material Number
    FROM mara
    INTO TABLE i_mara
   WHERE matnr IN s_matnr.


  IF i_mara[] IS NOT INITIAL.
    SELECT matnr                       " Material Number
           werks                       " Plants
           prctr                       " Profit Center
      FROM marc
      INTO TABLE i_marc
       FOR ALL ENTRIES IN i_mara
     WHERE matnr = i_mara-matnr
       AND werks IN s_werks.

  ENDIF.                               " IF i_mara[] IS NOT INITIAL

  i_output = i_marc.

  IF i_marc[] IS NOT INITIAL.

    SELECT matnr                       " Material Number
           werks                       " Plants
           lgort                       " Storage Location
      FROM mard
      INTO TABLE i_mard
       FOR ALL ENTRIES IN i_marc
     WHERE matnr EQ i_marc-matnr
       AND werks EQ i_marc-werks
       AND lgort IN s_lgort.

  ENDIF.                               " IF i_mara[] IS NOT INITIAL

regards

twinkal

Re: how to fetch data from single database table using 2 internal tables.

naveen_inuganti2 — Mon, 15 Sep 2008 08:47:22 GMT

Hi...

> primary keys of 2 internal tables

Correst your post, because internal table fields never contains primary key and Non-primary key catogories!

Thanks,

Naveen.I

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 08:49:32 GMT

refer

[http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3a1f358411d1829f0000e829fbfe/content.htm]

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 08:52:06 GMT

HI,

Thanks for your message. As per your coding, it is fetching from 2 different tables, but my requirement is to fetch from one table based on 1 field from one internal table and 1 field from another internal table. Please help.

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 08:57:36 GMT

select * from <table name> where <field name1> = <itab1-field> and <field name2> = <itab2-field>.

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 09:02:47 GMT

Hi,

Use FOR ALL ENTRIES keyword

Examples

select * into table it_result from mara

for all entries in <itab>

where matnr eq <itab>-fieldname.

select * into table it_result1 from mara

for all entries in <itab2>

where matnr eq <itab2>-fieldname.

Re: how to fetch data from single database table using 2 internal tables.

Former Member — Mon, 15 Sep 2008 09:04:27 GMT

Thank you so much. I could able to fetch.