Payroll | Time | OM & PA | Portal | Payroll Fixes | Career Tips | SuccessFactors |
#1
|
|||
|
|||
Handling Date in LSMW
Fist go to Systems-User Profile-Own data-Defaults(TCode: SU3) and change the date format to DD.MM.YYYY, save and logg out from system.
Log in again and now you start doing the LSMW recording once again. The recoding which you have mentioned is absolutely correct,but the start date you have given is 01.01.1900(this you need to check from when you are going to create the position or relationship and give the actual date) and save. Now when it comes to field mapping, you have do decide whether you want to map the date using source field you have defined in third step of LSMW or you want to give a default date. If its a default date then go to Constant which is there in the heading top right and give the start date as 01011900 and end date as 31129999 and save Now you try reading the data, i hope it will work, if not please let me know. |
Payroll | Time | OM & PA | Portal | Payroll Fixes | Career Tips | SuccessFactors |
#2
|
|||
|
|||
Things are looking far better.
I went to Systems-User Profile-Own data-Defaults. made some changes there for the date format. Chose yyyy.mm.dd and it worked. And after recording gave default value for BEGDA and ENDDA. and in " Display converted Data" I was able to see it as "1900-01-01" and "9999-12-31" But but but, when I am finally executing it in foreground, data is not getting placed on the screen field. 1900 is changing to 2000. Its considering only 00. and 9999 is changing to 1999. And I am getting the error., " Start date is greater than enddate" I tried constant in the step " Field mapping and conversion rules", but it wasn't taking date as yyyy.mm.dd Is there anything that the basis guys need to fix. I mean date configuration for the system. I knew I was in trouble when BEGDA was the the year 1900. Obviously there will be conflict. Its picking up 00 and changing it to year 2000. Any inputs will be valuable. |
Payroll | Time | OM & PA | Portal | Payroll Fixes | Career Tips | SuccessFactors |
#3
|
|||
|
|||
Y dont you change the text file format?
Instead of passing 19000101 ,pass 01011900. |
Payroll | Time | OM & PA | Portal | Payroll Fixes | Career Tips | SuccessFactors |
#4
|
|||
|
|||
I will do that. Try to insert couple of records
and get back to you. |
Payroll | Time | OM & PA | Portal | Payroll Fixes | Career Tips | SuccessFactors |
#5
|
|||
|
|||
Could you please sent me the details of activity you have done, I hope I can hlep you.
|