topic regarding databse tables in Application Development and Automation Discussions

regarding databse tables

Former Member — Mon, 14 May 2007 04:11:19 GMT

hi experts,

cud u plz tell me in which tables the daily attendance of a particular employee is stored or do u have any idea or is ur esteemed company done some project on time interfacing i mean to say that in my company i have a punching machine but that is not connected to our SAP ,plz let me know is there any certified software through which we can get the attendance data with out doing any coding etc..also if your company implemented this project send me some documentation.......

plz help me.

Re: regarding databse tables

Sougata — Mon, 14 May 2007 04:22:35 GMT

Ravi,

No offence, you sound like one of my customers who wants everything done with a push of a single button without writing a single line of code...ever! lol

It would've been wonderful if we could do that (by rubbing a lamp may be) but unfortunately systems are not designed to read our minds or you can say they are not smart enough... just yet!

Now to answer your queries, attendances are stored via infotype 2002 in SAP, see database table PA2002 structure in respository. System must be configured first to use this infotype in order to store employee attendance data.

Some sort of interface technology has to be implemented so that your punching machine can be connected to your SAP system. There are heaps of "time recording" interfaces available within/outside of SAP...you can find loads of info <a href="https://websmp106.sap-ag.de/">here</a>. See areas like SAP Solutions under Quick Links and Businees Community -> Discussion Forums and search for "time recording interfaces"....I'm sure you'll come across more than one useful document which explains the basic requirements to set up such an interface technology.

Good luck!

Reward points if useful.

Regards.

Re: regarding databse tables

Former Member — Mon, 14 May 2007 04:23:04 GMT

Hi Ravi,

The answer to the initial part of your question is that Attendances are stored in Infotype 2002 (i.e) DB table PA2002.

Regards,

Younus

Reward helpful Answers!!!!