topic Re: LDB-Queries in Application Development and Automation Discussions

LDB-Queries

Former Member — Fri, 27 Jan 2006 10:44:30 GMT

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

Re: LDB-Queries

Former Member — Fri, 27 Jan 2006 11:05:54 GMT

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

Re: LDB-Queries

Former Member — Fri, 27 Jan 2006 12:08:43 GMT

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.

Re: LDB-Queries

andreas_mann3 — Fri, 27 Jan 2006 14:59:49 GMT

hi,

look sample report <b>RPSISPE000</b>

and use dynamic (free) selections

hope that helps

Andreas

Re: LDB-Queries

Former Member — Fri, 27 Jan 2006 15:29:21 GMT

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.

Re: LDB-Queries

Former Member — Fri, 27 Jan 2006 15:51:03 GMT

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.