Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Usage of GET - Basic LOGICAL database question

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

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

0 Kudos

thank you very much.

could you please provide me an example code,

Thanks in advance

bala.

0 Kudos

hi,

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

just give logical database in search button and press enter.

0 Kudos

Thank you all.

What is the difference between tables and nodes statement,

Thanks in advance,

Bala.

0 Kudos

>

> 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
0 Kudos

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
0 Kudos

Hi,

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