syntax error

[Former Member]

Dear abap experts,

TABLES: SFLIGHT,SPFLI.

DATA: BEGIN OF ITAB_SFLIGHT,

CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID,

FLDATE LIKE SFLIGHT-FLDATE,

PRICE LIKE SFLIGHT-PRICE,

CURRENCY LIKE SFLIGHT-CURRENCY,

CITYFROM LIKE SPFLI-CITYFROM,

AIRPFROM LIKE SPFLI-AIRPFROM,

PLANETYPE LIKE SFLIGHT-PLANETYPE,

END OF ITAB_SFLIGHT.

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON SFLIGHT-CARRID = SPFLI-CARRID .

in the above syntax the error is

comma without preecding colon(after select?)line no 16

[Former Member]

Hi,

Dont use comma without using Braces.

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE, ITAB_SFLIGHT-PRICE,ITAB_SFLIGHT-CITYFROM ,ITAB_SFLIGHT-AIRPFROM)

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON SFLIGHT-CARRID = SPFLI-CARRID .

endselect.

i think it is useful for you.

Reward points if useful.

Thanks & regards

Deepika.

[RaymondGiuseppi]

Remove the comma in the select add brackets

SELECT A~CARRID A~FLDATE A~PRICE B~CITYFROM B~AIRPFROM INTO
(ITAB_SFLIGHT-CARRID, ITAB_SFLIGHT-FLDATE, ITAB_SFLIGHT-PRICE,
ITAB_SFLIGHT-CITYFROM, ITAB_SFLIGHT-AIRPFROM)
FROM SFLIGHT AS A INNER JOIN SPFLI AS B
ON SFLIGHT-CARRID = SPFLI-CARRID .

Try to use a INTO CORRESPONDING FIELDS OF TABLE ITAB, to reduce use of SELECT...ENDSELECT is usually a good idea. (in your case, use the same sequence of fields remove the need to use a CORRESPONDING FIELD clause)

Regards

[amit_khare]

You miss the brackets after INTO

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM )

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON SFLIGHT-CARRID = SPFLI-CARRID .

[Former Member]

Hi,

Use like this

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

(TAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM)FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON SFLIGHT-CARRID = SPFLI-CARRID .

Reward if useful.

Regards,

Swetha.

Edited by: swetha r on Jun 20, 2008 8:00 AM

[Simha_]

Hi,

Use this below code.

SELECT A~CARRID A~FLDATE A~PRICE B~CITYFROM B~AIRPFROM INTO ITAB_SFLIGHT
(ITAB_SFLIGHT-CARRID,  ITAB_SFLIGHT-FLDATE,  ITAB_SFLIGHT-PRICE ,
ITAB_SFLIGHT-CITYFROM, ITAB_SFLIGHT-AIRPFROM)
FROM SFLIGHT AS A INNER JOIN SPFLI AS B 
ON a~CARRID = b~CARRID .
ENDSELECT.

Cheers,

SImha.

[Former Member]

Hi,

You write code like this.

TABLES: SFLIGHT,SPFLI.

DATA: BEGIN OF ITAB_SFLIGHT,

CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID,

FLDATE LIKE SFLIGHT-FLDATE,

PRICE LIKE SFLIGHT-PRICE,

CURRENCY LIKE SFLIGHT-CURRENCY,

CITYFROM LIKE SPFLI-CITYFROM,

AIRPFROM LIKE SPFLI-AIRPFROM,

PLANETYPE LIKE SFLIGHT-PLANETYPE,

END OF ITAB_SFLIGHT.

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

( ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM )

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON SFLIGHT-CARRID = SPFLI-CARRID .

append itab_sflight.

endselect.

Mainly for the field list put the brackets. Observe in the code. You have to write the endselect.

Reward.

[Former Member]

Hi,

I corrected your code, it is working fine.

TABLES: sflight,spfli.

DATA: BEGIN OF itab_sflight,

carrid LIKE sflight-carrid,

connid LIKE sflight-connid,

fldate LIKE sflight-fldate,

price LIKE sflight-price,

currency LIKE sflight-currency,

cityfrom LIKE spfli-cityfrom,

airpfrom LIKE spfli-airpfrom,

planetype LIKE sflight-planetype,

END OF itab_sflight.

SELECT a~carrid

a~fldate

a~price

b~cityfrom

b~airpfrom

INTO (itab_sflight-carrid,

itab_sflight-fldate,

itab_sflight-price,

itab_sflight-cityfrom,

itab_sflight-airpfrom)

FROM sflight AS a INNER JOIN spfli AS b

ON a_{carrid = b}carrid .

ENDSELECT.

Reward points if it is helpful.

[Former Member]

Hi,

Please change the code as below:

SELECT A~CARRID A~FLDATE A~PRICE B~CITYFROM B~AIRPFROM INTO
(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,
ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM)
FROM SFLIGHT AS A INNER JOIN SPFLI AS B 
ON SFLIGHT-CARRID = SPFLI-CARRID .

Thanks,

Sriram POnna.

[Former Member]

Hi Ansuman Parhi,

TABLES: SFLIGHT,SPFLI.
 
DATA: BEGIN OF ITAB_SFLIGHT1, " This is only Work Area
CARRID LIKE SFLIGHT-CARRID,
CONNID LIKE SFLIGHT-CONNID,
FLDATE LIKE SFLIGHT-FLDATE,
PRICE LIKE SFLIGHT-PRICE,
CURRENCY LIKE SFLIGHT-CURRENCY,
CITYFROM LIKE SPFLI-CITYFROM,
AIRPFROM LIKE SPFLI-AIRPFROM,
PLANETYPE LIKE SFLIGHT-PLANETYPE,
END OF ITAB_SFLIGHT1.
 
DATA : ITAB_SFLIGHT LIKE ITAB_SFLIGHT1 OCCURS 0 WITH HEADER LINE. " Declare internal table if u want to fill all the data in one table
 
SELECT A~CARRID A~FLDATE A~PRICE B~CITYFROM B~AIRPFROM INTO
(ITAB_SFLIGHT-CARRID, "Put the small brackets here ( )
 ITAB_SFLIGHT-FLDATE,
 ITAB_SFLIGHT-PRICE,
ITAB_SFLIGHT-CITYFROM, 
ITAB_SFLIGHT-AIRPFROM ) "Put the small brackets here ( )
FROM SFLIGHT AS A INNER JOIN SPFLI AS B
ON A~CARRID = B~CARRID . 
* Write ur logic here...Begin
  WRITE : ITAB_SFLIGHT-CARRID, ITAB_SFLIGHT-FLDATE, ITAB_SFLIGHT-PRICE,
ITAB_SFLIGHT-CITYFROM, ITAB_SFLIGHT-AIRPFROM.
 
APPEND ITAB_SFLIGHT.
* Write ur logic here...End
 
ENDSELECT.

Hope it will solve your problem..

Reward points if useful..

Thanks & Regards

ilesh 24x7

[Former Member]

Hi,

Try using into corresponding fields of...

Regards,