topic Re: how to display data from two db table in Application Development and Automation Discussions

how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:36:51 GMT

How to display multiple records from two internal table without using nesting of loop

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:42:15 GMT

Hi,

use joins,to get data from different tables.

SELECT vbak~vbeln

vbak~vkorg

vbap~posnr

vbap~matnr

INTO TABLE t_vbak

FROM vbak AS vbak

INNER JOIN vbap AS vbap

ON vbak_{vbeln = vbap}vbeln

WHERE vbak~auart = p_auart.

Regards,

jaya

Edited by: Jayapradha Neeli on Jun 9, 2009 2:13 PM

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:45:38 GMT

Try to take data(split 2 into 3) in another internal table in such a way that one LOOP statement followed by subsequent READ statements work .

Regards,

Deepthi

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:45:48 GMT

Hi alok srivastava,

As per the requirements and from what tables we are fetching data will make us to decide whether can be done with out Nesting Loops or Not.

So, try to breif your issue for better solutions.

Regards,

Suneel G

Re: how to display data from two db table

former_member222860 — Tue, 09 Jun 2009 08:47:03 GMT

By using LOOP and READ statements

An ex; here:

loop at tb_STAB.
      read table tb_SOSTAB  WITH KEY ebeln = tb_STAB-ebeln.
      if sy-subrc eq 0.
        write :/2 tB_STAB-ebeln color 4,
                20 lv_msg2 color 5,
                70 tb_SOSTAB-vbeln color 4,
                100 lv_msg3  color 5.
      endif.
    endloop.

Pl. search, you'll find more results here

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:47:36 GMT

hi jaya,

you are not getting my point actually i want to show rrecord from two internal tables without using nesting of loop.

is it possible but how?

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:49:07 GMT

If u dont want to use nested loop, u can do it via READ statement.

Foe example.

Loop at itab1.

write the content of itab1.

read table itab2 with key field1 = itab1-field1.

if sy-subrc = 0.

write the content of itab2.

endloop.

Edited by: Sheelesh on Jun 9, 2009 2:19 PM

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:51:22 GMT

ok i agree from u. but when u would show multiple records from two internal tables then how will u display without using nested loop.

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:54:15 GMT

but we use read statement for only one record if we want to show multiple records from second table

then what should i do.

Re: how to display data from two db table

venkatasriram_mygapula — Tue, 09 Jun 2009 08:55:47 GMT

better to use for all entries instead of inner joins to add two more tables.

for example.

select <field names> into table <itab1> from <databasetable 1>

where<condition>.

if itab[] is not initial.

select <field names> into table <itab2> from <databasetable 2>

for all entries in <itab1>

where <condition>.

finally need to display in one table.

loo at itab1.

read table <itab2> wiht key <condition>

itab1-fieldnames = itab2-fieldnames

modify itab1 transporting <new fields>

endloop.

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 08:59:08 GMT

Hi ,

Suppose you want to select records from the SPFLI and SBOOK .To do that - -

1 ) In Join condition select the records from the booth table like - -

PARAMETERS : p_carrid TYPE spfli-carrid.  " parameter that will be used in WHERE condition
DATA : BEGIN OF fs_itab,
         mandt TYPE spfli-mandt,
         carrid TYPE spfli-carrid,
         connid TYPE spfli-connid,
         countryfr TYPE spfli-countryfr,
         customid  TYPE sbook-customid,
      END OF fs_itab,
      t_itab LIKE TABLE OF fs_itab .  " Table to hold the data

SELECT
           spfli~mandt  " Fields from SPFLI
           spfli~carrid
           spfli~connid
           spfli~countryfr
           sbook~customid   " Fields from SBOOK

           FROM spfli INNER JOIN sbook  " Inner join of the tables
           ON spfli~carrid = sbook~carrid AND  " Join condition according to ur requirement
              spfli~connid = sbook~connid         " Join condition
              INTO TABLE t_itab
              WHERE spfli~carrid = p_carrid .  " Where condition

According to your requirement you can use the OUTER JOIN also.

OR ELSE FOLLOW the 2nd -

2) Create a view with the required fields of both the table .

Then use the view in the select .

Regards

Pinaki

Re: how to display data from two db table

Former Member — Tue, 09 Jun 2009 09:04:39 GMT

If ur second internal table has multiple records then you have to process these records in loop because in a single process you can write multiple records of second table.

You can use do enddo statement here to write the multiple records or process them via using nested loop.

loop at itab1

write records from itab1.

read table itab2 with key field1 = itab1-field1.

if sy-subrc = 0.

write ur records.

else.

exit.

endif.

enddo.

endloop.

Re: how to display data from two db table

former_member188686 — Tue, 09 Jun 2009 09:23:46 GMT

Hi Alok,

Plz do as following-

Data tabix like sy-tabix.

Sort itab1 by field1.

Sort itab2 by field1.

Transfer the contents of table itab1 to corresponding field of table itab2 according to their key fields.

then use the write statement.

Loop at itab2.

tabix = sy-tabix.

read table itab1 with key field1 = itab2-field1 binary search.

if sy-subrc = 0.

*move the fields from itab1 to itab2.

move-corresponding fields of table itab1 to itab2. " (field1 to field10 belongs to itab1)

endif.

modify itab2 index tabix.

write 😕 itab2-field1, itab2-field2, ........ itab2-field10, itab2-field11, ................ itab20-field.

clear: itab1, itab2.

endloop.

or u can also use third table itab3 which has the fields from both the tables ie. itab1, itab2

Edited by: madan namdeo on Jun 9, 2009 11:26 AM

Re: how to display data from two db table

Former Member — Wed, 02 Sep 2009 07:29:09 GMT

good