topic Re: problem in Get Satement in Application Development and Automation Discussions

problem in Get Satement

Former Member — Tue, 24 Jul 2007 09:49:04 GMT

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.

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 09:52:19 GMT

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

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 09:55:12 GMT

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

Attributes -> Logical Database -> F1S..

Reward if useful

Regards

Prax

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 09:55:56 GMT

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.

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 09:58:56 GMT

Hi Shiba,

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

Sanket.

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 10:02:26 GMT

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

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 10:05:39 GMT

Answered with doubts.

Re: problem in Get Satement

Former Member — Tue, 24 Jul 2007 10:15:13 GMT

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