topic Re: logical database in Application Development and Automation Discussions

logical database

Former Member — Mon, 13 Oct 2008 05:38:39 GMT

Hi all,

Im using the logical database F1S to get and write some flight details.

but when I say

nodes : f1s

it says it is not defined.

but in sldb transaction the F1S exists....

how can i resolve this.

2.What is the difference between using nodes and tables.

Regards,

Sagar

Edited by: sandeep sagar on Oct 13, 2008 7:38 AM

Re: logical database

Former Member — Mon, 13 Oct 2008 13:10:59 GMT

any inputs??

Re: logical database

Former Member — Mon, 13 Oct 2008 13:12:57 GMT

both nodes and tables are same

but only in logical database nodes is used instead of tables

Re: logical database

Former Member — Mon, 13 Oct 2008 13:14:28 GMT

After NODES : keyword

u have to give TABLE (node) name , not the LDB name ,

NODE name u can find by go through Structure of LDB , t.code SE36.

Regards

Sachin

Re: logical database

Former Member — Mon, 13 Oct 2008 13:17:34 GMT

HI Sagar,

You declare the node of the structure using the TABLES statement.

This creates the necessary interface work areas as table work areas.

You can also use the NODES statement to define database tables as nodes.

If a node of a logical database is not a database table, you must use the NODESstatement.

The interface work areas are shared by the database program and the user, and so act as an interface for passing data.

The term u201Cuseru201D here can mean either an executable program to which the logical database is linked, or the function module LDB_PROCESS.

Regards.

Eswar.

Re: logical database

Former Member — Mon, 13 Oct 2008 13:20:14 GMT

thanks for your inputs, but when i say

nodes : f1s is that incorrect?

Re: logical database

rainer_hbenthal — Mon, 13 Oct 2008 13:23:46 GMT

Again: F1S is the logical database and SPFLI, SFLIGHT and SBOOK are the nodes of that LDB.

Re: logical database

Former Member — Mon, 13 Oct 2008 13:24:52 GMT

YES , F1S is LDB name not a node name .

node name u define when u create structure.

Re: logical database

Former Member — Tue, 14 Oct 2008 04:44:06 GMT

Nodes : F1s (cannot be defined according to you)

Even if I say Tables : spfli or Nodes : Spfli in order to access the LDB it says it is not available.

Any idea??

Sagar

Re: logical database

Former Member — Tue, 14 Oct 2008 05:24:19 GMT

Hi,

Try like:

Attributes~~>logical database~~>give the logical database name then activate the program

Also,

Declare table name which comes under the top of F1S in 'nodes'

and using 'GET' stmt, you can fetch the corresponding data.

Regards,

Neenu

Re: logical database

Former Member — Tue, 14 Oct 2008 10:05:47 GMT

Thanks Neenu..that works!