topic Re: Usage of GET - Basic LOGICAL database question in Application Development and Automation Discussions

Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:14:27 GMT

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.

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:16:55 GMT

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

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:19:46 GMT

thank you very much.

could you please provide me an example code,

Thanks in advance

bala.

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:24:30 GMT

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

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:25:06 GMT

Hi,

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

Re: Usage of GET - Basic LOGICAL database question

GauthamV — Thu, 23 Oct 2008 05:28:38 GMT

hi,

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

just give logical database in search button and press enter.

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 05:55:39 GMT

Thank you all.

What is the difference between tables and nodes statement,

Thanks in advance,

Bala.

Re: Usage of GET - Basic LOGICAL database question

Former Member — Thu, 23 Oct 2008 06:27:53 GMT


> 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]