topic ABAP Query Using LDB in Application Development and Automation Discussions

ABAP Query Using LDB

Former Member — Mon, 07 Jun 2010 08:06:35 GMT

Hello Frn's

I need to develop a abap Query using LDB , for this a Infoset is allready created , which uses PNPCE LDB .

Below i am Descrbing the scenerio , for which we need to develop the query ....

Dept/Div Transfer

Employees who transferred dept or division within specified date range:

EmpID

Last Name, First Name

Date of transfer

New department

New division

Current supervisor

Old department

Old division

How can i fitler out the data of our requirment ... because i want to use same infoset in diffrent query .

Please provide some solution

Thanks and Regards..

Priyank Dixit

Re: ABAP Query Using LDB

Former Member — Mon, 07 Jun 2010 18:48:39 GMT

Hi Priyank,

First you need to check whether all the required fields are available there in the LDB PNPCE(I guess you are using the same).

I think old department, old division must not be available there. Then you need to add it in your Infoset and write custom code for these fields. Once you are done with custom coding, you can use this infoset for creating queries.

Use trnx SQ02 to create queries, either SAP or Infoset.

Hope it helps. Let me know if you need some more help.

Raveesh

Re: ABAP Query Using LDB

Former Member — Mon, 07 Jun 2010 18:51:16 GMT

Hi ,

If you are asking how to create queries, then it is very simple.

You can go to SQ02 as i mentioned above, and while creating the query, you can put which infoset you are going to use.

In this way, you can use the same infoset for multiple queries.

Raveesh

Re: ABAP Query Using LDB

Former Member — Tue, 08 Jun 2010 04:22:55 GMT

HI Ravish ,

Because Old department and New Department are the same field (Werks) of a infotype 0001 . For this i need to fetch the Reords of 2 diffrent time period ....latest time period record will have new department and old Record wil have old have old reocrd ....now i need this old department in output display .

The same infoset we are using in some more query .....so for this particuler query ....where i will write some piece of code .

Thanks and Regards...

Priyank Dixit

Re: ABAP Query Using LDB

Former Member — Mon, 21 Mar 2011 13:58:35 GMT

Thanks..