topic Re: Error. in Application Development and Automation Discussions

Error.

Former Member — Mon, 16 Jul 2007 05:59:35 GMT

Hi,

I am writing the program to innerjoin KUNNR and VBAK.

iam getting the error that Select options ended unexpectedly. Plz correct me.

TYPES:

BEGIN OF TY_OUTPUT,

KUNNR TYPE KNA1-KUNNR,

LAND1 TYPE KNA1-LAND1,

VBELN TYPE VBAK-VBELN,

AUDAT TYPE VBAK-AUDAT,

AUART TYPE VBAK-AUART,

NETWR TYPE VBAK-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}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO TABLE IT_OUTPUT.

FROM KNA1 INNERJOIN VBAK ON KNA1_{KUNNR EQ VBAK}KUNNR WHERE KNA1~KUNNR IN SKUNNR.

WHERE KNA1~KUNNR IN SKUNNR.

IF SY-SUBRC EQ 0

LOOP AT IT_OUTPUT INTO ST_OUTPUT

WRITE:/ ST_OUTPUT.KUNNR, ST_OUTPUT.LAND1,

ST_OUTPUT_NAME1, ST_OUTPUT.VBELN,ST_OUTPUT.AUDAT,AT_OUTPUT.AUART,ST_OUTPUT.NETWR.

ENDLOOP.

This is my program.

Also plz tell me what is SKUNNR and why we r using that.

Re: Error.

Former Member — Mon, 16 Jul 2007 06:01:37 GMT

hi,

change the code as:

SELECT-OPTIONS SKUNNR FOR ST_OUTPUT-KUNNR.

remove the comma after select option and put a period.

Re: Error.

Former Member — Mon, 16 Jul 2007 06:02:39 GMT

hi..

1)keep full stop at the end of select options..

SELECT OPTIONS SKUNNR FOR ST_OUTPUT-KUNNR.

2)[b]KUNNR - its the field in VBAK table for Sold-to-party

u r using KUNNR field here in ur code to retrive the sold-to-party..

Reward points if useful

Regards

Ashu

Re: Error.

Former Member — Mon, 16 Jul 2007 06:03:52 GMT

Hi Rams

select option should end with . but not ,

Try like this

TYPES:
BEGIN OF TY_OUTPUT,
KUNNR TYPE KNA1-KUNNR,
LAND1 TYPE KNA1-LAND1,
VBELN TYPE VBAK-VBELN,
AUDAT TYPE VBAK-AUDAT,
AUART TYPE VBAK-AUART,
NETWR TYPE VBAK-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. <-- here u made mistake

SELECT KNA1~KUNNR KNA1~LAND1 KNA1~NAME1 VBAK~VBELN VBAK~AUDAT VBAK~AUART VBAK~NETWR INTO TABLE IT_OUTPUT.
FROM KNA1 INNERJOIN VBAK ON KNA1~KUNNR EQ VBAK~KUNNR WHERE KNA1~KUNNR IN SKUNNR.

WHERE KNA1~KUNNR IN SKUNNR.
IF SY-SUBRC EQ 0
LOOP AT IT_OUTPUT INTO ST_OUTPUT
WRITE:/ ST_OUTPUT.KUNNR, ST_OUTPUT.LAND1,
ST_OUTPUT_NAME1, ST_OUTPUT.VBELN,ST_OUTPUT.AUDAT,AT_OUTPUT.AUART,ST_OUTPUT.NETWR.
ENDLOOP.

Reward all helpfull answers

Regards

Pavan

Re: Error.

Former Member — Mon, 16 Jul 2007 06:04:02 GMT

also change the select statement as follows:

SELECT KNA1_{KUNNR KNA1}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO TABLE IT_OUTPUT

FROM KNA1 INNERJOIN VBAK ON KNA1_{KUNNR EQ VBAK}KUNNR WHERE KNA1~KUNNR IN SKUNNR.

Message was edited by:

Navneeth Bothra

Re: Error.

Former Member — Mon, 16 Jul 2007 06:04:08 GMT

Hi,

Now it is showing error here .

SELECT KNA1_{KUNNR KNA1}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO TABLE IT_OUTPUT.

Error "FROM ...", "CONNECTION ...", "BYPASSING BUFFER", "PACKAGE SIZE ...", or "UP TO ... ROWS" expected after "IT_OUTPUT".

Re: Error.

Former Member — Mon, 16 Jul 2007 06:04:11 GMT

try

SELECT OPTIONS SKUNNR FOR kna1-kunnr.

Re: Error.

seshatalpasai_madala — Mon, 16 Jul 2007 06:07:14 GMT

Hi,

TYPES:

BEGIN OF TY_OUTPUT,

KUNNR TYPE KNA1-KUNNR,

LAND1 TYPE KNA1-LAND1,

VBELN TYPE VBAK-VBELN,

AUDAT TYPE VBAK-AUDAT,

AUART TYPE VBAK-AUART,

NETWR TYPE VBAK-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}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO CORRESPONDING FIELDS OF TABLE IT_OUTPUT

FROM KNA1 INNERJOIN VBAK ON KNA1_{KUNNR EQ VBAK}KUNNR WHERE KNA1~KUNNR IN SKUNNR.

WHERE KNA1~KUNNR IN SKUNNR.

IF SY-SUBRC EQ 0

LOOP AT IT_OUTPUT INTO ST_OUTPUT

WRITE:/ ST_OUTPUT.KUNNR, ST_OUTPUT.LAND1,

ST_OUTPUT_NAME1, ST_OUTPUT.VBELN,ST_OUTPUT.AUDAT,AT_OUTPUT.AUART,ST_OUTPUT.NETWR.

ENDLOOP.

Regards,

Sesh

Re: Error.

Former Member — Mon, 16 Jul 2007 06:10:17 GMT

hi..

now u use the syntax INTO CORRESPONDING FIELDS OF

SELECT KNA1_{KUNNR KNA1}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO CORRESPONDING FIELDS OF TABLE IT_OUTPUT

FROM KNA1 INNERJOIN VBAK ON KNA1_{KUNNR EQ VBAK}KUNNR WHERE KNA1~KUNNR IN SKUNNR.

Reward points if useful

Regards

Ashu

Re: Error.

Former Member — Mon, 16 Jul 2007 06:11:24 GMT

Hi Ram,

Pls correct ur code as below:

TYPES:
BEGIN OF TY_OUTPUT,
KUNNR TYPE KNA1-KUNNR,
LAND1 TYPE KNA1-LAND1,
VBELN TYPE VBAK-VBELN,
AUDAT TYPE VBAK-AUDAT,
AUART TYPE VBAK-AUART,
NETWR TYPE VBAK-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~LAND1 KNA1~NAME1 VBAK~VBELN VBAK~AUDAT VBAK~AUART VBAK~NETWR INTO TABLE IT_OUTPUT
FROM KNA1 INNER JOIN VBAK ON KNA1~KUNNR EQ VBAK~KUNNR WHERE KNA1~KUNNR IN SKUNNR.


IF SY-SUBRC EQ 0.
LOOP AT IT_OUTPUT INTO ST_OUTPUT.
WRITE:/ ST_OUTPUT-KUNNR, ST_OUTPUT-LAND1,
ST_OUTPUT-VBELN,ST_OUTPUT-AUDAT,sT_OUTPUT-AUART,ST_OUTPUT-NETWR.
ENDLOOP.
endif.

pls reward pts fi found usefull :)

Regards

Sathish

Re: Error.

Former Member — Mon, 16 Jul 2007 06:11:26 GMT

hI,

STILL THIS IS INCORRECT.

SELECT KNA1_{KUNNR KNA1}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO TABLE IT_OUTPUT FROM KNA1

INNERJOIN VBAK ON KNA1_{KUNNR EQ VBAK}KUNNR WHERE KNA1~KUNNR IN SKUNNR.

Error is

Wrong expression "INNERJOIN" in FROM clause . . .

Re: Error.

Former Member — Mon, 16 Jul 2007 06:13:31 GMT

Try This:

TYPES:

BEGIN OF TY_OUTPUT,

KUNNR TYPE KNA1-KUNNR,

LAND1 TYPE KNA1-LAND1,

VBELN TYPE VBAK-VBELN,

AUDAT TYPE VBAK-AUDAT,

AUART TYPE VBAK-AUART,

NETWR TYPE VBAK-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}LAND1 KNA1_{NAME1 VBAK}VBELN VBAK_{AUDAT VBAK}AUART VBAK~NETWR INTO corresponding fields of TABLE IT_OUTPUT

FROM ( KNA1 INNER JOIN VBAK ON KNA1_{KUNNR = VBAK}KUNNR )

WHERE KNA1~KUNNR IN SKUNNR.

*WHERE KNA1~KUNNR IN SKUNNR.

IF SY-SUBRC EQ 0.

LOOP AT IT_OUTPUT INTO ST_OUTPUT.

WRITE:/ ST_OUTPUT-KUNNR, ST_OUTPUT-LAND1,

ST_OUTPUT-VBELN,ST_OUTPUT-AUDAT,sT_OUTPUT-AUART,ST_OUTPUT-NETWR.

ENDLOOP.

endif.