Usage of GET - Basic LOGICAL database question

[Former Member]

Hi,

I have a few doubts in Logical Databases.

1.) Why should i include a logical database in a abap program.

2.) Can i add more than 1 LDB to a abap program

3.) can Nodes statement used on all nodes on LDB

4.) Please provide a example program based on F1S LDB with small explanation.

Thanks in advance,

Bala.

[Former Member]

Hi,

Logical datbases are the ABAP Programs which serves many functions such data selection, data extraction and authorizations.

In se38, while creating a program set 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.

Edited by: Neenu Jose on Oct 23, 2008 7:17 AM

[Former Member]

thank you very much.

could you please provide me an example code,

Thanks in advance

bala.

[GauthamV]

hi,

you can get lot of information in SCN if you search.

just give logical database in search button and press enter.

[Former Member]

Thank you all.

What is the difference between tables and nodes statement,

Thanks in advance,

Bala.

[Former Member]

>

> Thank you all.
> 
> What is the difference between tables and nodes statement,
> 
> Thanks in advance,
> Bala.

AFAIK, it is expected that we should we the TABLES statement if the node type is a TABLE and if the node type is DDIC type then it is expected that we should use NODES statement, however I found that they can be used interchangeably.

We can find the node type info in the structure defintion of the LDB(in SE36)

Also check this extract from the SAP help

The nodes of the structure are declared with the TABLES statement which generates 
the appropriate 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 NODES statement.

[Example of a Logical Database |http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9be035c111d1829f0000e829fbfe/content.htm]

[Former Member]

Hi

Go through the link given below :

go to saptechnical

Tutorials

HRABAP

you will find demo program for logical database.

http://help.sap.com/saphelp_nw04/helpdata/en/ca/d08606a44f11d1950c0000e82de14a/frameset.htm

With Regards

Nikunj Shah

[Former Member]

Hi,

Link: [http://help.sap.com/saphelp_nw04/helpdata/en/ca/d08606a44f11d1950c0000e82de14a/content.htm]