Inner join on four tables

[KK07]

hi all,

i am facing the problem with the inner join in the select query for 4 tables.

can i use the inner join for tables in SAP 6.0 version,

it is going to dump.

here is my code

SELECT DISTINCT a_{pernr a}begda a_{endda a}wagetype a_{amount a}currency

a_{ltrctry b}rufnm b_{anred b}vorna b_{nachn c}groupcode d~vdsk1

FROM pa9011 AS a INNER JOIN pa0002 AS b ON b_{pernr = a}pernr

INNER JOIN pa9013 AS c ON c_{pernr = b}pernr

inner join pa0001 as d on d_{pernr = c}pernr

INTO CORRESPONDING FIELDS OF TABLE it_bonus

WHERE a~pernr IN s_pernr AND

a~begda IN s_date AND

a~subty EQ s_subty AND

a~wagetype EQ wa_perbonus AND

a~ltrctry = gc_ind AND

a~amount > 0 AND

b~endda = '99991231' AND

c~groupcode IN s_loc AND

c~endda = '99991231' and

d~endda = '99991231'

ORDER BY a~pernr.

[JozsefSzikszai]

hi,

normally 4 tables can be joined, however I would never join PA... tables (because of the begda, endda fields). But the main question is: what the dump says?

ec

[KK07]

hi this is the dump ,

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

[JozsefSzikszai]

you should check 1. if all the fields you select are defined in the internal table (it_bonus) you select into 2. all the definitions in the internal table are correct (for example you select pernr, than you have to check if pernr is defined the same way in your internal table, like it is defined in the database table you select from)

[Former Member]

better go for for all entries statement

[Former Member]

If you are doing all this for Reporting, why don;t you use the LDB PNP or PNPCE ??

A

[KK07]

thanks all,

i had found my mistake.

Edited by: krishna kishore on Sep 11, 2008 11:43 AM