Select count (*)

[Former Member]

Hi all,

I have got 3 tables to select data from, how can I join them, and also need to check a field on each table,get the total count of the records!

Regards,

Bharat

[sudhindra_chandrashekar]

Hi,

Use this to get used to joins:

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/frameset.htm

To get the total count of the records you can use the system field SY-TABIX.

Hpoe this helps,

Sudhi

[Former Member]

Here is how you Join 3 tables.

MARA. MAKT, MARC are the tables to join.

select a_{matnr b}aedat b_{maktx c}werks

from ( mara as a inner join makt as b

on b_{matnr = a}matnr )

inner join marc as c

on c_{matnr = a}matnr

into table itab.

For joining more than two tables, the result set of a join of two tables has to be joined to the third and the same continues for more tables.

To get the total number of records of field, you can use the System defined data object SY-DBCNT after the select statement.

[former_member194669]

If you have proper key for select then go for join

other wise

make 3 separate select and

use describe command to count.

aRs

[Former Member]

Thats done. Thanks for all inputs.