LDB-Queries

[Former Member]

Hi ALL,

I need to access logical database PSJ and tables are PROJ and PRPS_R.

The queries are

1. I need to fetch PROFIT CENTER (PRCTR) from PROJ

2. I need to fetch COST CENTER (FKSTL) from PRPS_R.

Based on this PROJ-PRCTR from selection screen , I need to fetch some more fields.

In the beginning , I will mention in the ATTRIBUTES : PSJ

In the program,I will give GET PROJ.

After this , I need to select some fields from PRPS_R.

I dont know how to proceed.

Points will be awards in advance

[Former Member]

Hi ,

In the program , i will give GET PROJ.

But after that, i need to select only the records which i have mentioned in the select-options and retreive the corresponding records.

Kindly help me immediately

[Former Member]

U c that is the beauty of LDB. Use dynamic select option and get PROJ-PRCTR in the selection screen. Now when have GET PROJ which will select only those PC which u have selected in the selection screen. As PRPS_R is below PROJ in LDB it will select all the records for the PROJ-PRCTR. So what u need is another GET PRPS_R.

Hope this helps.

[andreas_mann3]

hi,

look sample report <b>RPSISPE000</b>

and use dynamic (free) selections

hope that helps

Andreas

[Former Member]

HI JAYASREE to get a solution, you use queries and fetch the data from these tables, by using sql ~ key word, and let me know you got it,

thanks,

sudhir.

[Former Member]

HI jayasree

In the Get event, get the data from the LDB and strore it in a Internal table and then you can process the internal table based on the selection.

Even you use another internla table for PRPS_R.