Skip to Content
author's profile photo Former Member
Former Member

Extracting data from CATSDB

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 01:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded