topic Re: Error... in Application Development and Automation Discussions

Error...

Former Member — Thu, 06 Jul 2006 20:17:10 GMT

REPORT ZTUSH.

TABLES: VBFA, VBAP.

TYPES: Begin of LINE,

VBELV TYPE VBFA-VBELV,

POSNV TYPE VBFA-POSNV,

POSEX TYPE VBAP-POSEX,

END OF LINE.

DATA: PO_LINE TYPE TABLE OF LINE.

LOOP AT delivery_item.

select single vbfa_{vbelv vbfa}posnv vbap~posex into ( LINE-VBELV,LINE-POSNV,LINE-POSEX )

from vbfa

inner join vbap

on vbfa_{vbelv = vbap}vbeln

and vbfa_{posnv = vbap}posnr

where vbfa~vbeln = 'delivery_item-vbeln'

and vbfa~posnn = 'delivery_item-posnr'

and vbfa~vbtyp_n = 'J'.

ENDLOOP.

APPENd LINE TO PO_LINE

WRITE:/ PO_LINE-VBELV, PO_LINE, PO_LINE-POSEX.

This gives me an error comma without preceding colon...

Re: Error...

Manohar2u — Thu, 06 Jul 2006 20:19:31 GMT

select single vbfa_{vbelv vbfa}posnv vbap~posex into

(LINE-VBELV, LINE-POSNV, LINE-POSEX)

Keep space after variables.

Regds

Manohar

Re: Error...

RichHeilman — Thu, 06 Jul 2006 20:21:47 GMT

Make sure there is no space between the "(" and the field, also put space between the "," and next field name.

 (LINE-VBELV, LINE-POSNV, LINE-POSEX)

Since you are using a structure here you can just do this too, assuming that LINE only contains the three fields being selected..

select single vbfa~vbelv vbfa~posnv vbap~posex
       <b>into line</b>
              from vbfa

Regards,

Rich Heilman

Re: Error...

Former Member — Thu, 06 Jul 2006 20:22:01 GMT

Give space between each variable

Re: Error...

Laxmana_Appana_ — Thu, 06 Jul 2006 20:22:30 GMT

Hi,

Remove space between the brackets :

( LINE-VBELV,LINE-POSNV,LINE-POSEX )

(LINE-VBELV,LINE-POSNV,LINE-POSEX)

Laxman

Re: Error...

Former Member — Thu, 06 Jul 2006 20:25:01 GMT

select single vbfa_{vbelv vbfa}posnv vbap~posex into

CORRESPONDING FIELDS OF LINEfrom vbfa

Re: Error...

Former Member — Fri, 07 Jul 2006 11:44:19 GMT

u do not gave period after line APPENd LINE TO PO_LINE

, so plz do it and check it.

chetan.