Error message on select

Former Member — Sun, 13 May 2007 01:47:06 GMT

hi,

i am trying to execute following program and getting error message, comma without preceding colon (after select?)

can someone help me with this?

DATA : BEGIN OF ITAB OCCURS 0,

KUNNR LIKE VBAK-KUNNR, "Account Number

MATNR LIKE VBAP-MATNR, "Item

ARKTX LIKE VBAP-ARKTX, "Description

NETPR LIKE VBAP-NETPR, "Price

BMENG LIKE VBEP-BMENG, "Quantity

VBELN LIKE VBEP-VBELN, "Order Number

EDATU LIKE VBEP-EDATU, "GIVES DUE DELIVERY DATE FOR ITEM

END OF ITAB.

SELECT A_{KUNNR B}MATNR B_{ARKTX B}NETPR C_{BMENG C}VBELN C~EDATU INTO CORRESPONDING FIELDS OF ITAB

FROM VBAK AS A, VBAP AS B, VBEP AS C

WHERE A_{VBELN = B}VBELN AND B_{VBELN = C}VBELN

ENDSELECT.

Re: Error message on select

Former Member — Sun, 13 May 2007 02:35:28 GMT

Use below select query :

SELECT A~KUNNR

B_{MATNR B}ARKTX B~NETPR

C_{BMENG C}VBELN C~EDATU INTO table ITAB

FROM VBAK AS A inner join VBAP AS B on A_{vbeln = b}vbeln

inner join VBEP AS C on c_{vbeln = a}vbeln.

Reward Points if it is helpful

Thanks

Seshu