Skip to Content
0
Former Member
Mar 27, 2009 at 03:13 PM

Issue with select query join....

40 Views

Hello,

I am facing a problem with a select query. I get a message that itab_data is not long enough.

DATA: itab_data like ptrv_head occurs 0 with header line.

SELECT *    from PTRV_HEAD 
            as a inner join PA0002 as b
            on a~pernr = b~pernr
            inner join PA0001 as c
            on a~pernr = c~pernr
            INTO TABLE itab_data
       where a~PERNR in S_PERNR
       and   a~REINR in S_TRIP
       and   a~ZLAND in S_LAND
       and   a~DATV1 in S_BEGIN
       and   a~DATB1 in S_END
       and   b~NACHN in S_FIRST
       and   b~VORNA in S_LAST
       and   c~BUKRS in S_BUKRS
       and   c~KOSTL in S_KOSTL
       and   c~PERSG in S_EMPGP
       and   c~PERSK in S_SUBGP
       and   c~begda in ldbbegda
       and   c~endda in ldbendda.

Regards,

Jainam.

Edited by: Jainam Shah on Mar 27, 2009 4:13 PM

Edited by: Jainam Shah on Mar 27, 2009 4:13 PM