Comma Without preceding colon Error in select query

[Former Member]

Hello Expert ,

can anyone tell me what is wrong with this query

SELECT A_{PARTYP A}PARTNER A_{BUKRS B}NAME1 A_{EPAID B}ORT01 B~ORT02

B_{PFACH B}PSTL2 B_{REGIO B}STRAS B_{LAND1 B}TELFX

INTO(WA_ZDEF_RFS_COMPLY-PARTYP, WA_ZDEF_RFS_COMPLY-PARTNER, WA_ZDEF_RFS_COMPLY-BUKRS,

WA_ZDEF_RFS_COMPLY-NAME1, WA_ZDEF_RFS_COMPLY-EPAID, WA_ZDEF_RFS_COMPLY-ORT01,

WA_ZDEF_RFS_COMPLY-ORT02, WA_ZDEF_RFS_COMPLY-PFACH, WA_ZDEF_RFS_COMPLY-PSTL2,

WA_ZDEF_RFS_COMPLY-REGIO, WA_ZDEF_RFS_COMPLY-STRAS, WA_ZDEF_RFS_COMPLY-LAND1,

WA_ZDEF_RFS_COMPLY-TELFX) FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B

ON

A_{PARTNER = B}KUNNR .

ENDSELECT.

Error : comma without preceding colon .(AFTER SELECT?)

Im really not able to get the error .

Please help.

Regards Renu

[Former Member]

Hi Renu,

Check 2 - 3 statements above this code.you missed something there....

[Former Member]

Hello Renu,

check this corrected code,

 

SELECT A~PARTYP
       A~PARTNER
       A~BUKRS
       B~NAME1
       A~EPAID
       B~ORT01
       B~ORT02
       B~PFACH
       B~PSTL2
       B~REGIO
       B~STRAS
       B~LAND1
       B~TELFX
INTO( WA_ZDEF_RFS_COMPLY-PARTYP WA_ZDEF_RFS_COMPLY-PARTNER
      WA_ZDEF_RFS_COMPLY-BUKRS WA_ZDEF_RFS_COMPLY-NAME1
      WA_ZDEF_RFS_COMPLY-EPAID WA_ZDEF_RFS_COMPLY-ORT01
      WA_ZDEF_RFS_COMPLY-ORT02 WA_ZDEF_RFS_COMPLY-PFACH
      WA_ZDEF_RFS_COMPLY-PSTL2 WA_ZDEF_RFS_COMPLY-REGIO
      WA_ZDEF_RFS_COMPLY-STRAS WA_ZDEF_RFS_COMPLY-LAND1
      WA_ZDEF_RFS_COMPLY-TELFX )
   FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B
     ON A~PARTNER = B~KUNNR
ENDSELECT.

Hope this help to you,

Anil.

[Former Member]

Hi Renu Gusain,

Keep one SPACE between INTO and ( in your code...

See below modified code.. Please have a look on comment too

SELECT A~PARTYP A~PARTNER A~BUKRS B~NAME1 A~EPAID B~ORT01 B~ORT02
B~PFACH B~PSTL2 B~REGIO B~STRAS B~LAND1 B~TELFX
INTO (WA_ZDEF_RFS_COMPLY-PARTYP, " Keep one SPACE between INTO and ( here in ur code as i have modified
WA_ZDEF_RFS_COMPLY-PARTNER, WA_ZDEF_RFS_COMPLY-BUKRS, 
WA_ZDEF_RFS_COMPLY-NAME1, WA_ZDEF_RFS_COMPLY-EPAID, WA_ZDEF_RFS_COMPLY-ORT01,
WA_ZDEF_RFS_COMPLY-ORT02, WA_ZDEF_RFS_COMPLY-PFACH, WA_ZDEF_RFS_COMPLY-PSTL2,
WA_ZDEF_RFS_COMPLY-REGIO, WA_ZDEF_RFS_COMPLY-STRAS, WA_ZDEF_RFS_COMPLY-LAND1,
WA_ZDEF_RFS_COMPLY-TELFX) FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B 
ON
A~PARTNER = B~KUNNR .

ENDSELECT.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[Former Member]

Thanks for the response ..

SELECT A~PARTYP

A~PARTNER

A~BUKRS

B~NAME1

A~EPAID

B~ORT01

B~ORT02

B~PFACH

B~PSTL2

B~REGIO

B~STRAS

B~LAND1

B~TELFX

INTO ( G_T_ZDEF_RFS_EPAREG-PARTYP , G_T_ZDEF_RFS_EPAREG-PARTNER,

G_T_ZDEF_RFS_EPAREG-BUKRS, G_T_ZDEF_RFS_EPAREG-NAME1,

G_T_ZDEF_RFS_EPAREG-EPAID ,G_T_ZDEF_RFS_EPAREG-ORT01,

G_T_ZDEF_RFS_EPAREG-ORT02 ,G_T_ZDEF_RFS_EPAREG-PFACH,

G_T_ZDEF_RFS_EPAREG-PSTL2, G_T_ZDEF_RFS_EPAREG-REGIO,

G_T_ZDEF_RFS_EPAREG-STRAS, G_T_ZDEF_RFS_EPAREG-LAND1,

G_T_ZDEF_RFS_EPAREG-TELFX )

FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B

ON A_{PARTNER = B}KUNNR.

My query .

the error still exist and i did consider the spacing between the brackets.

I commented the select query .. there is no problem above this code as well ..

Regards

Renu ..

[Former Member]

Hi Renu,

You Just do copy paste of this code.

Definetly if will work.

SELECT A~PARTYP
       A~PARTNER
       A~BUKRS
       B~NAME1
       A~EPAID
       B~ORT01
       B~ORT02
       B~PFACH
       B~PSTL2
       B~REGIO
       B~STRAS
       B~LAND1
       B~TELFX
INTO( WA_ZDEF_RFS_COMPLY-PARTYP WA_ZDEF_RFS_COMPLY-PARTNER
      WA_ZDEF_RFS_COMPLY-BUKRS WA_ZDEF_RFS_COMPLY-NAME1
      WA_ZDEF_RFS_COMPLY-EPAID WA_ZDEF_RFS_COMPLY-ORT01
      WA_ZDEF_RFS_COMPLY-ORT02 WA_ZDEF_RFS_COMPLY-PFACH
      WA_ZDEF_RFS_COMPLY-PSTL2 WA_ZDEF_RFS_COMPLY-REGIO
      WA_ZDEF_RFS_COMPLY-STRAS WA_ZDEF_RFS_COMPLY-LAND1
      WA_ZDEF_RFS_COMPLY-TELFX )
   FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B
     ON A~PARTNER = B~KUNNR
ENDSELECT.

ANIL.

[Former Member]

Hi Renu,

I have corrected one mistake then you have made another mistake...

Anyway

Keep SPACE between INTO and (

Remove SPACE between ( and G_T_ZDEF_RFS_EPAREG-PARTYP

SELECT A~PARTYP
A~PARTNER
A~BUKRS
B~NAME1
A~EPAID
B~ORT01
B~ORT02
B~PFACH
B~PSTL2
B~REGIO
B~STRAS
B~LAND1
B~TELFX
INTO ( G_T_ZDEF_RFS_EPAREG-PARTYP , G_T_ZDEF_RFS_EPAREG-PARTNER,  " Remove Space between ( and G_T...
G_T_ZDEF_RFS_EPAREG-BUKRS, G_T_ZDEF_RFS_EPAREG-NAME1,
G_T_ZDEF_RFS_EPAREG-EPAID ,G_T_ZDEF_RFS_EPAREG-ORT01,
G_T_ZDEF_RFS_EPAREG-ORT02 ,G_T_ZDEF_RFS_EPAREG-PFACH,
G_T_ZDEF_RFS_EPAREG-PSTL2, G_T_ZDEF_RFS_EPAREG-REGIO,
G_T_ZDEF_RFS_EPAREG-STRAS, G_T_ZDEF_RFS_EPAREG-LAND1,
G_T_ZDEF_RFS_EPAREG-TELFX )
FROM ZDEF_RFS_EPAREG AS A JOIN KNA1 AS B
ON A~PARTNER = B~KUNNR.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

[Former Member]

Hi Renu,

it's Strange that solution provided by Anil is working for you...

Are you sure it's working ? Because it's giving error here when i try to run code like that...

Which version of SAP you are using ??

Thanks & Regards

ilesh 24x7

ilesh Nandaniya