topic Re: select statement. in Application Development and Automation Discussions

select statement.

Former Member — Wed, 28 Nov 2007 06:40:41 GMT

Hi friends,

Lat me know how to write the select query to get the fields PLANS and ENAME from table PA0001 by checking the field PERNR = IHPA-PARNR .

Because pernr and parnr are not same type and same length.

Thanks in advancce.

Re: select statement.

pavel_parshenkov2 — Wed, 28 Nov 2007 06:50:41 GMT

Hi, try like this:

DATA: BEGIN OF lt_ihpa OCCURS 0

, parnr LIKE pa0001-pernr

if need other fields

, END OF lt_ihpa.

DATA lt_pa0001 LIKE pa0001 OCCURS 0.

REFRESH lt_ihpa[].

REFRESH lt_pa0001[].

SELECT parnr

if need other fields

INTO TABLE lt_ihpa

FROM ihpa.

CHECK NOT lt_ihpa[] IS INITIAL.

SELECT *

INTO TABLE lt_pa0001

FROM pa0001

FOR ALL ENTRIES IN lt_ihpa

WHERE pernr = lt_ihpa-parnr

if need other fields conditions

Re: select statement.

Former Member — Wed, 28 Nov 2007 06:53:02 GMT

you need to get the PARNR number from IHPA

select PARNR from IHPA into itab1 where some condition

if itab1 is not initial

select data from PA0001 into itab2 for allentries in itab1 where pernr = itab1-PARNR

endif.

<b>Reward if usefull</b>

Re: select statement.

Former Member — Wed, 28 Nov 2007 06:53:39 GMT

in the itab declaration put

parnr LIKE pa0001-pernr

Re: select statement.

Former Member — Wed, 28 Nov 2007 06:57:01 GMT

Hi Praveen,

I think PERNR is for Partner name and PARNR is for personal number.So you can't check with this condition.Better clarify with functionals for the checking of these two fields really needed or not.

If is it so..please take an internal table and declare both the fields with type C and fetch the corresponding values and check in your select statement.

Reward if helpful.

Re: select statement.

Former Member — Wed, 28 Nov 2007 07:15:24 GMT

Hi Praveen,

you can try this.

Make a table say 'it_ihpa' only field PARNR but of type PERNR .

Now loop at IHPA and get all PARNR in your table 'it_ihpa' .

Now select PLANS and ENAME from table PA0001 by checking the field PERNR = IT_IHPA-PARNR .

Rewards pts if helpful

Regards,

Manish

Re: select statement.

Former Member — Wed, 28 Nov 2007 07:51:49 GMT

It is giving the dump.

in select query what should i mention in where condition to get teh field parnr FROM table ihpa table.

Re: select statement.

Former Member — Wed, 28 Nov 2007 07:56:27 GMT

Thanks for your reply.

But i am getting the dump.

Let me know what should i mention in WHERE condition in the following query.

SELECT parnr

if need other fields

INTO TABLE lt_ihpa

FROM ihpa.

Re: select statement.

pavel_parshenkov2 — Wed, 28 Nov 2007 07:57:19 GMT

DATA: BEGIN OF lt_ihpa OCCURS 0

, parnr LIKE ihpa-parnr

, parnr_2 LIKE pa0001-pernr

, END OF lt_ihpa.

DATA lt_pa0001 LIKE pa0001 OCCURS 0.

FIELD-SYMBOLS <fs> LIKE LINE OF lt_ihpa.

REFRESH lt_ihpa[].

REFRESH lt_pa0001[].

SELECT parnr

INTO CORRESPONDING FIELDS OF TABLE lt_ihpa

FROM ihpa.

LOOP AT lt_ihpa ASSIGNING <fs>.

<fs>-parnr_2 = <fs>-parnr(8).

ENDLOOP.

CHECK NOT lt_ihpa[] IS INITIAL.

SELECT *

INTO TABLE lt_pa0001

FROM pa0001

FOR ALL ENTRIES IN lt_ihpa

WHERE pernr = lt_ihpa-parnr_2.

Re: select statement.

Former Member — Wed, 28 Nov 2007 09:59:48 GMT

Thank you...itw working fine now..

Re: select statement.

pavel_parshenkov2 — Wed, 28 Nov 2007 10:03:17 GMT

mark thread as answered

Re: select statement.

Former Member — Wed, 28 Nov 2007 10:50:48 GMT

answered

Re: select statement.

abhijeet_gupta2016 — Tue, 16 Jul 2013 16:22:14 GMT

Thanks, a lot! it worked.