how to retrieve data using logical database and custom select options

[Former Member]

Hi all,

I have a selection screen which is displayed by logical database PSJ and I have two select options of my own. I need to retrieve data based on both selection screen of logical database and my own select options. How can I do it?

Thanks in advance.

[Former Member]

Hai Gupta

Check the following Document & Links

1. A logical database is in fact

a program only.

2. This LDB provides two main things :

a) a pre-defined selection screen

which handles all user inputs and validations

b) pre defined set of data

based upon the user selection.

3. So we dont have to worry about from

which tables to fetch data.

4. Moreover, this LDB Program,

handles all user-authorisations

and is efficient in all respects.

5. tcode is SLDB

good info about Logical Database. you can check the link.

http://www.geekinterview.com/question_details/1506

http://help.sap.com/saphelp_46c/helpdata/EN/35/2cd77bd7705394e10000009b387c12/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/9f/db9bed35c111d1829f0000e829fbfe/frameset.htm

Functions for displaying and changing logical databases:

Call Transaction SE36 or

Choose ABAP Workbench -> Development -> Programming environ. -> Logical databases

Interaction between database program and report:

During program processing, subroutines are performed in the database program and events are executed in the report.

To read data from a database tables we use logical database.

A logical database provides read-only access to a group of related tables to an ABAP/4 program.

advantages:-

The programmer need not worry about the primary key for each table.Because Logical database knows how the different tables relate to each other,and can issue the SELECT command with proper where clause to retrieve the data.

i)An easy-to-use standard user interface.

ii)check functions which check that user input is complete,correct,and plausible.

iii)meaningful data selection.

iv)central authorization checks for database accesses.

v)good read access performance while retaining the hierarchical data view determined by the application logic.

disadvantages:-

i)If you donot specify a logical database in the program attributes,the GET events never occur.

ii)There is no ENDGET command,so the code block associated with an event ends with the next event

statement (such as another GET or an END-OF-SELECTION).

1. transaction code SLDB.

2.enter name z<ldb-name>

3.create

4.short text

5.create

6. name of root node (here Ekko)

7. enter short text (f6)

8.node type -> data base table.

9.create

10 change logical DB

riht click on ekko and insert node

here node name ekpo

11.create

12. click on selections

13. press no Should the changed structure of Z<ldb name> be saved first.

14.select tables which you want to join.

15.transfer

16 now you have to o to coding part.

17. save

activate.

19.click to src code

double click on first include and activate

Regards

Sreeni

[dani_mn]

HI,

USE

GET <NODE_NAME>.

to get the data of your logical database it will fill all tables according to selection screen of logical database.

and then you can use 'PROVIDE' statement to select data on the basis of your selection screen form the

internal tables filled by logical database.

REgards,

Wasim Ahmed

[Former Member]

hi wasim,

thanks for reply.

but my problem is that select options which i am using are taken from bkpf and bseg tables which are not there in logical database. i need a link between logical database table prps and bkpf which is not there in PSJ logical database.

[Former Member]

Hi ridhima,

1. since u are having your own select options,

2. u cannot filter directly , using the ldb functionality.

3. in the GET event,

u are getting the data.

4. At this point,

after finding the link between the tables,

u can write some IF condition

to check based upon the SELECT options,

5. If the condition is ok,

u can proceed further for your code.

regards,

amit m.

[Former Member]

Hai Gupta

Check the following Document & Links

1. A logical database is in fact

a program only.

2. This LDB provides two main things :

a) a pre-defined selection screen

which handles all user inputs and validations

b) pre defined set of data

based upon the user selection.

3. So we dont have to worry about from

which tables to fetch data.

4. Moreover, this LDB Program,

handles all user-authorisations

and is efficient in all respects.

5. tcode is SLDB

good info about Logical Database. you can check the link.

http://www.geekinterview.com/question_details/1506

http://help.sap.com/saphelp_46c/helpdata/EN/35/2cd77bd7705394e10000009b387c12/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/9f/db9bed35c111d1829f0000e829fbfe/frameset.htm

Functions for displaying and changing logical databases:

Call Transaction SE36 or

Choose ABAP Workbench -> Development -> Programming environ. -> Logical databases

Interaction between database program and report:

During program processing, subroutines are performed in the database program and events are executed in the report.

To read data from a database tables we use logical database.

A logical database provides read-only access to a group of related tables to an ABAP/4 program.

advantages:-

The programmer need not worry about the primary key for each table.Because Logical database knows how the different tables relate to each other,and can issue the SELECT command with proper where clause to retrieve the data.

i)An easy-to-use standard user interface.

ii)check functions which check that user input is complete,correct,and plausible.

iii)meaningful data selection.

iv)central authorization checks for database accesses.

v)good read access performance while retaining the hierarchical data view determined by the application logic.

disadvantages:-

i)If you donot specify a logical database in the program attributes,the GET events never occur.

ii)There is no ENDGET command,so the code block associated with an event ends with the next event

statement (such as another GET or an END-OF-SELECTION).

1. transaction code SLDB.

2.enter name z<ldb-name>

3.create

4.short text

5.create

6. name of root node (here Ekko)

7. enter short text (f6)

8.node type -> data base table.

9.create

10 change logical DB

riht click on ekko and insert node

here node name ekpo

11.create

12. click on selections

13. press no Should the changed structure of Z<ldb name> be saved first.

14.select tables which you want to join.

15.transfer

16 now you have to o to coding part.

17. save

activate.

19.click to src code

double click on first include and activate

Regards

Sreeni