Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Extracting data from CATSDB

abdulazeez12
Active Contributor

‎2006 Aug 03 2:23 PM

0 Likes
604

Dear All,

I have a task of extracting the data from CATSDB depending upon the selection parameters. The selection screen will contain the Personnel number field and BEGDA and ENDDA fields. Now, all those PERNRs have to be extracted from CATSDB within the period of BEGDA and ENDDA. But my problem is I dont find any BEGDA and ENDDA fields in CATSDB database table. so, how to go abt it?

Thanks,

sss

Dear All,

I have a task of extracting the data from CATSDB depending upon the selection parameters. The selection screen will contain the Personnel number field and BEGDA and ENDDA fields. Now, all those PERNRs have to be extracted from CATSDB within the period of BEGDA and ENDDA. But my problem is I dont find any BEGDA and ENDDA fields in CATSDB database table. so, how to go abt it?

Thanks,

sss

Reply
1 REPLY 1
Read only

Former Member

‎2006 Aug 03 2:29 PM

0 Likes
500

Hi Shakir,

I guess you can use this select query .

select field names from catsdb where pernr in selection-pernr and workdate bt begda and endda.

Reward points if it is helpful.

reagrds,

Krian i