Go Back   Wiki NewForum | Latest Entertainment News > Career Forum & Tips > SAP HCM Forum > SAP HCM Portal and other Modules of HR Forum


Topic 70: Data Loading


Reply
Views: 2125  
Thread Tools Rate Thread Display Modes
  #6  
Old 03-28-2010, 09:31 AM
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 81,285
Default

Update 9015 records from file.


7. Click Back (F3) ****on.

Information: The following section details updating the Charge Object Assignment template, steps to open text files and saving the file as a text file (.txt) for upload into BEACON.
Information: An Excel (.xls) template is available on the BEACON help site that can be used when creating the Charge Object Assignment load file. The .xls template must be in the proper format and then saved as a .txt for the upload in transaction ZPTA030 to be successful.

8. Open the upload file in Excel.
Reply With Quote
  #7  
Old 03-28-2010, 09:31 AM
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 81,285
Default

Microsoft Excel - Book1



9. Click File >> Open...

Open



10. Select Charge_Pbject_Assignment_Load.xls in the list box.
11. Click Open ****on.
Reply With Quote
  #8  
Old 03-28-2010, 09:31 AM
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 81,285
Default

Text Import Wizard - Step 1 of 3



12. Click Next > ****on.

Text Import Wizard - Step 2 of 3



13. Click Next > ****on.

Text Import Wizard - Step 3 of 3



14. Press right Arrow ****on to scroll to the last column.
Reply With Quote
  #9  
Old 03-28-2010, 09:31 AM
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 81,285
Default

Text Import Wizard - Step 3 of 3



15. Press and hold Shift and click the last column.

Text Import Wizard - Step 3 of 3



16. Click Text radio ****on.
17. Click Finish ****on.

Information: Upon completion of changes the file needs to be saved as text.

Microsoft Excel - Charge_Pbject_Assignment_Load.xls

Reply With Quote
  #10  
Old 03-28-2010, 09:32 AM
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 81,285
Default

18. Click File >> Save As...

Save As



19. Click the Save as type: dropdown.

Screen Title



20. Select Text (Tab delimited) (*.txt) in the Save as type: list box.

Save As



21. Update the following required and optional fields:

Field Name
Description
R/O/C
Values
File name:
Enter a File name.
R
Enter value in File name:.
Example: Charge_Pbject_Assignment_Load.txt

22. Click Save ****on.

Microsoft Excel



23. Click Yes ****on.
24. The system task is complete.
Reply With Quote
Reply

Latest News in SAP HCM Portal and other Modules of HR Forum


Thread Tools
Display Modes Rate This Thread
Rate This Thread:



Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2020, vBulletin Solutions, Inc.