04-21-2009 2:56 AM
Hi all,
I am new to LSMW.
I did recording for PA30, and created excel file with Per. No., last name, first name, SSN and DOB.
When i was executing last step "Run Batch Input Session", every fields were coming from excel sheet to screen, except SSN field. In addition to that i was getting "Fill in all required entry fields" message at the bottom.
And i had to manually enter SSN for each employee.
Does anyone can tell me why SSN was not coming up automatically from excel sheet like other fields?? Where did i make mistake?
Please help me. I really appreciate any help.
Thanks You!!
04-21-2009 5:08 AM
hi Mala
just check whether field names in Source fields are matching wtvr u entered in Excel sheet....
both should be same...otherwise u wil face this problm...
n also check while recording
check steps 10(Display Read Data) and 12(Display Converted Data)
check whether it is taking all the fields.....
let me know if u need further help....
Regards
Smitha
04-21-2009 5:08 AM
hi Mala
just check whether field names in Source fields are matching wtvr u entered in Excel sheet....
both should be same...otherwise u wil face this problm...
n also check while recording
check steps 10(Display Read Data) and 12(Display Converted Data)
check whether it is taking all the fields.....
let me know if u need further help....
Regards
Smitha
04-21-2009 5:19 AM
Hiii,
chk whether the source structure and input structure are properly mapped. chk steps 10 and 12 to chk whether data is coming properly in the fileds or not. if the data is not coming properly then u have to redesign the structure.
Regards,
Anil N.
04-21-2009 6:47 AM
Hi Mala,
Also check step 5 'Maintain Field Mapping and Conversion Rules' , if u have correctly mapped the SSN field of ur source structure to that of ur recording. Check if u have defined the SSN field in ur source structure with appropriate data type.
And then check step 10 if the data is read into ur source stucture, step 12 to see if it is assigned to the recording.
Also check ur input file for the seperators, if they are properly maintained.
Regards
Kalyani
05-16-2009 5:22 PM