Positive time accouting

Positive accounting is a tricky thing. Seems to be easy – come in/go out – check in/out and everything should work fine, But.. Positive accounting is when time is registered by actual time worked in days or hours, with time events (in, out, lunch). There are special statuses in infotype 7th, special time evaluation schemas TM00, TM01. How does it work?

We’ve implemented positive accounting with biometric fingerstamps. When an employee comes he enters personnel number, swipe finger and time event is stored in SAP. 3rd party vendor collects time events, process them to avoid errors and post to SAP every 5 minutes. It’s performed with standard SAP interface PDC – PT80 transaction.

Read More


STVARV variables

Here is a deal. You can simplify users’ life with STVARV transaction. You can store variables in STVARV. Most developers are aware of this transaction while consultants are not. Convenience is in the ability to create variables, define their values and (bonus!) assign variables to fields in report variants.

Let’s say we create variable “Gross wages” where put all wage types referenced to gross income. Than we use this variable in all payroll reports in variants. Old style way is to define wage types directly in each variant in each report. In case you add even one wage type you need to adjust all variants for all reports. Nightmare!

New way is to create one variable, assign wage types and next time you need to add just one wage type to gross income you just do one change in STVARV and it works everywhere. Brilliant!

So…

Read More


Extending renumeration statement (PE51)

Hi!

Are you ready to break renumeration statement form. You can add your own fields in PE51 transaction that are lack in standard system.

You need to do three steps to add your field or table into PE51 form.

  1. Add structure definition into include RPCEDDZ9
  2. Fill that structure in include RPCEDSZ9
  3. Add that structure in PE51_CHECKTAB transaction.

Here is a note to help you with :) 320257 – HR-EDT: Print of customer-specific data and infotypes

And some examples: http://scn.sap.com/docs/DOC-40350


FAQ. Netweaver vs NWBC

Question:

What’s the difference between SAP Netweaver and SAP Business client?

Answer:

SAP Netweaver is a server that holds SAP (like portal).

SAP Business Client is a program that runs on a user desktop and replaces GUI functions in a new interface based on a web technologies.

Let’s say we can work with ESS/MSS in a browser, opening SAP portal ling or in a Netweaver Business Client (NWBC) without portal as it renders business logic in a NWBC without Netweaver Server.


Customizing Enterprise Portal theme

This is the best doc regarding portal theme customizing I’ve seen so far. Recommended.

Portal theme customizing


Standard payroll posting variant

Did you know that deleting “SAP” posting variant (V_T52E2 view) is a cause of system dumps? SAP support confirmed that.

Don’t ever delete this variant, just copy to yours and use it.


Unlock tables in SAP

My students have found really good way to solve problem when two or more consultants want to work with the same table in edit mode.

Author is unknown.

REPORT ZSENQOFF MESSAGE-ID MT.
CALL ‘C_ENQUEUE’ ID ‘OPCODE’ FIELD ‘F’.
CALL ‘C_WRITE_SYSLOG_ENTRY’ ID ‘TYP’ FIELD ‘C’
ID ‘KEY’ FIELD ‘GES’.
MESSAGE S900 WITH ‘Table locking turned off’.

***
REPORT ZSENQON MESSAGE-ID MT.
CALL ‘C_ENQUEUE’ ID ‘OPCODE’ FIELD ‘T’.
CALL ‘C_WRITE_SYSLOG_ENTRY’ ID ‘TYP’ FIELD ‘C’
ID ‘KEY’ FIELD ‘GER’.
MESSAGE S900 WITH ‘Table locking turned on’.

Don’t use in production system. Only for trainings!


Connect to external database

Once I needed to create a program to download data fro external database into my own. It happened to be very easily.

In DBACOCKPIT transaction create a new connection to a database.

And user it in ABAP like this:

EXEC SQL.
CONNECT TO ‘BSK’
ENDEXEC.
EXEC SQL.
SET CONNECTION ‘BSK’
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / ‘current database name’, DBN.
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / ‘current database name’, DBN.

It’s basic Native SQL в ABAP. Some SAP notes for reference.

Note 178949 – MSSQL: Database MultiConnect
Note 323151 – Several DB connections with Native SQL


Run payroll simulation from ABAP

Sometime you’ll need this module to run payroll simulation from ABAP program. It won’t change any data but will provide you with cluster results or remuneration statement, that could be useful.

Here it is HRTO_AU_PAY_PROCESS_SIMULATION. Adjust it for your country and be happy.

Basically, it runs payroll simulation function module with some wrapping around it.

Read More


Customize HR Process Workbench (PUST)

Hi.

I hope most of you have heard about PUST transaction. This is convinient  tool to build payroll close process. It’s idea is a chain of steps build from programms that we use in payroll close procedure. We can set variants for each program, build them in a sequence and run all at once (or step by step autmatically). User all needs is to hit Run button and watch it. While it’s running it will show logs for each step/programm and user will understand possible issues with easy.

There is no need to explain all customizing in detail as it’s pretty simple. At first setup Workflow as some particular elements use it for notifications. To do this run though SAP Note 133182 – Process Manager: No process is started.  Program starts – event fires. Program stops – event fires. It allows to run several programms in parallel and use workflows for example to payroll agreements.

For a user it will look like.

pust_2

Read More