Fetch data through LDB and display in ALV

[mustameerahmed_khan]

Hi ALL,

I want to develop a program where i can fetch the data from the LDB and then i want to display this data using the ALV functionality.

There are header and line items that are present in the LDB and the ALV funcionality should be such that if i click on the Header it should take you to the line items in the new screen .

1 . How can i get the data of LDB into the program . Is it through the get paramater or i can use the LDB_PROCESS function module ? beacause using the get parameter single records are fetched.

2. How to display the records that satisfy the header and the line item entries? i know about the REUSE_ALV_GRID_DISPLAY already

Awaiting your valuable inputs

Cheers!!!

[seshatalpasai_madala]

Hi,

You need to goto your Program attributes and attach the LDB there.

Then you can use GET events in your program to get the data.

Regards,

Sesh

[Former Member]

Hi

You have to use GET and GET LATE commands to fetch the data using LDBS

see the doc

A logical database is a special ABAP/4 program which combines the contents of certain database tables. You can link a logical database to an ABAP/4 report program as an attribute. The logical database then supplies the report program with a set of hierarchically structured table lines which can be taken from different database tables.

LDB offers an easy-to-use selection screens. You can modify the pre-generated selection screen to your needs. It offers check functions to check whether user input is complete, correct, and plausible. It offers reasonable data selections. It contains central authorization checks for data base accesses. Enhancements such as improved performance immediately apply to all report programs that use the logical database.

Less coding s required to retrieve data compared to normal internel tables.

Tables used LDB are in hierarchial structure.

Mainly we used LDBs in HR Abap Programming.

Where all tables are highly inter related so LDBs can optimize the performance there.

Check this Document. All abt LDB's

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=...

GO THROUGH LINKS -

http://www.sap-basis-abap.com/saptab.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9bfa35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/c6/8a15381b80436ce10000009b38f8cf/frameset.htm

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_Logical_Database_FAQ.html

www.sap-img.com/abap/abap-interview-question.htm

www.sap-img.com/abap/quick-note-on-design-of-secondary-database-indexes-and-logical-databases.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9bb935c111d1829f0000e829fbfe/content.htm

Gothru the blog which provides info on LDB's:

/people/srivijaya.gutala/blog/2007/03/05/why-not-logical-databases

Reward points for useful Answers

Regards

Anji

[Former Member]

hi

just refer to the link below

http://www.sapmaterial.com/?gclid=CN322K28t4sCFQ-WbgodSGbK2g

regards

ravish

<b>plz dont forget to reward points if helpful</b>

[mustameerahmed_khan]

Hi ALL,

I understand that i can include the LDB name in the Attributes of the program.

But i want to know how to fetch the data here.

A sample would be helpful..

LDB Structure is as follows.

***************************************

TABLE1

-> TABLE2

-> TABLE3

***************************************

Cheers

[mustameerahmed_khan]

Hi,

I had read the nodes using the GET statement.

GET <NODE >

Now i want the data of the Node into a internal table.

Can anyone let me know how do i get it. We cant use loop endloop for this .

?????

Cheers!!!