problem in Get Satement

[Former Member]

Hi all,

i have testing Get statement.the code is below...

TABLES: SPFLI, SFLIGHT, SBOOK.

START-OF-SELECTION.

WRITE 'Test Program for GET'.

GET SPFLI.

SKIP.

WRITE: / 'From:', SPFLI-CITYFROM,

'To:', SPFLI-CITYTO.

SKIP.

WRITE: / 'Carrid:', SFLIGHT-CARRID,

'Connid:', SFLIGHT-CONNID.

ULINE.

GET SBOOK.

WRITE: / 'Fldate:', SFLIGHT-FLDATE,

'Bookid:', SBOOK-BOOKID,

'Luggweight', SBOOK-LUGGWEIGHT.

ULINE.

but i m facing a problem on syntax check that

"SPFLI" is not defined for the current logical database.

what will i do.

suggess.

[Former Member]

i think you did not define the logical database name.

go to se38 editor ( change mode) in menu goto--> attributes there give F1S in the logical datbase name and instead of tables use NODES : spfli.

regards

shiba dutta

[Former Member]

You have to give LDB as F1S in attributes of the report...

Attributes -> Logical Database -> F1S..

Reward if useful

Regards

Prax

[Former Member]

HI,

to use logical databases u have to mention the LDB name in the attributes of the program while giving the discription.thw LDB for flights tables is F1S.and need 2 write nodes,not tables

<b>nodes:SPFLI, SFLIGHT, SBOOK.</b>

START-OF-SELECTION.

WRITE 'Test Program for GET'.

GET SPFLI.

SKIP.

WRITE: / 'From:', SPFLI-CITYFROM,

'To:', SPFLI-CITYTO.

SKIP.

WRITE: / 'Carrid:', SFLIGHT-CARRID,

'Connid:', SFLIGHT-CONNID.

ULINE.

GET SBOOK.

WRITE: / 'Fldate:', SFLIGHT-FLDATE,

'Bookid:', SBOOK-BOOKID,

'Luggweight', SBOOK-LUGGWEIGHT.

ULINE.

<b>reward if helpful</b>

rgds,

bharat.

[Former Member]

Hi Shiba,

Can u suggess me why i use nodes instead of Tables.

Sanket.

[Former Member]

Hello Sanket check ldb used .

in goto menu select atributes, there you can see a option for LDB

select appropriate LDB. (You can try using LDB : F1S)

reward points if helpful

[Former Member]

Answered with doubts.

[Former Member]

i think nodes and tables are doing the same purpose but nodes are specially made for data exchange between ldb and abap program. So only i told you to use NODES instead of tables but there is no difference( i think so). Only difference you can use 14 character long name in nodes and 15 character long name in TABLES declaration(i.e. maximum length of the dictionary object name which you are declaring).

regards

shiba dutta