topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Wed, 09 Apr 2008 06:53:57 GMT

Hi,

This is my program.

Here in the select statement(In Bold letters) I had selected KNa1_{KUNNR two times. If I keep the KNA1}KUNNR for only one time iam getting the runtime error.

In the select options I had this statement. SKUNNR FOR ST_OUTPUT-KUNNR.(Instead of st_output-kunnr can i select from TY_OUTPUT-KUNNR).

This is the program.

TYPES:

BEGIN OF TY_OUTPUT,

KUNNR TYPE KNA1-KUNNR,

NAME1 TYPE KNA1-NAME1,

VBELN TYPE VBAK-VBELN,

POSEX TYPE VBAP-POSEX,

ZMENG TYPE VBAP-ZMENG,

NETPR TYPE VBAP-NETPR,

NETWR TYPE VBAP-NETWR,

END OF TY_OUTPUT.

DATA:

ST_OUTPUT TYPE TY_OUTPUT,

IT_OUTPUT TYPE TABLE OF TY_OUTPUT.

SELECT-OPTIONS SKUNNR FOR ST_OUTPUT-KUNNR.

SELECT KNA1_{KUNNR KNA1}KUNNR VBAK_{VBELN VBAP}POSEX VBAP_{ZMENG VBAP}NETPR VBAP~NETWR INTO TABLE IT_OUTPUT

FROM VBAK INNER JOIN KNA1 ON KNA1_{KUNNR EQ VBAK}KUNNR INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN

WHERE KNA1~KUNNR IN SKUNNR.

IF SY-SUBRC EQ 0.

LOOP AT IT_OUTPUT INTO ST_OUTPUT.

WRITE:/ ST_OUTPUT-KUNNR, ST_OUTPUT-NAME1,ST_OUTPUT-VBELN,

ST_OUTPUT-POSEX, ST_OUTPUT-ZMENG,ST_OUTPUT-NETPR,ST_OUTPUT-NETWR.

ENDLOOP.

ENDIF.

Thanks.

Re: Select Statement

Former Member — Wed, 09 Apr 2008 06:59:06 GMT

Hi Keyur

instead of second kna1~kunnr

write kna1~name1

like below

SELECT KNA1_{KUNNR *KNA1}NAME1* VBAK_{VBELN VBAP}POSEX VBAP_{ZMENG VBAP}NETPR VBAP~NETWR INTO TABLE IT_OUTPUT

FROM VBAK INNER JOIN KNA1 ON KNA1_{KUNNR EQ VBAK}KUNNR INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN

WHERE KNA1~KUNNR IN SKUNNR.

Reward if useful

Regards,

Talwinder

Edited by: Talwinder Singh on Apr 9, 2008 12:29 PM

Re: Select Statement

Former Member — Wed, 09 Apr 2008 07:02:02 GMT

Hi,

use

SELECT KNA1_{KUNNR *KNA1}NAME1* VBAK_{VBELN VBAP}POSEX VBAP_{ZMENG VBAP}NETPR VBAP~NETWR INTO TABLE IT_OUTPUT

FROM VBAK INNER JOIN KNA1 ON KNA1_{KUNNR EQ VBAK}KUNNR INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN

WHERE KNA1~KUNNR IN SKUNNR.

SELECT KNA1_{KUNNR VBAK}VBELN VBAP_{POSEX VBAP}ZMENG VBAP_{NETPR VBAP}NETWR INTO CORRESPONDING FIELDS OF TABLE IT_OUTPUT

FROM VBAK INNER JOIN KNA1 ON KNA1_{KUNNR EQ VBAK}KUNNR INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN

WHERE KNA1~KUNNR IN SKUNNR.

rgds,

bharat.