topic Extracting data from CATSDB in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-catsdb/m-p/1488500#M227575 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>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?</P><P></P><P>Thanks,</P><P>sss</P></BODY></HTML> Thu, 03 Aug 2006 13:23:35 GMT abdulazeez12 2006-08-03T13:23:35Z Extracting data from CATSDB https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-catsdb/m-p/1488500#M227575 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>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?</P><P></P><P>Thanks,</P><P>sss</P></BODY></HTML> Thu, 03 Aug 2006 13:23:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-catsdb/m-p/1488500#M227575 abdulazeez12 2006-08-03T13:23:35Z Re: Extracting data from CATSDB https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-catsdb/m-p/1488501#M227576 <HTML><HEAD></HEAD><BODY><P>Hi Shakir,</P><P> I guess you can use this select query .</P><P>select field names from catsdb where pernr in selection-pernr and workdate bt begda and endda.</P><P></P><P>Reward points if it is helpful.</P><P>reagrds,</P><P>Krian i</P></BODY></HTML> Thu, 03 Aug 2006 13:29:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/extracting-data-from-catsdb/m-p/1488501#M227576 Former Member 2006-08-03T13:29:51Z