‎2007 Dec 12 1:00 PM
Hi guys,
How to upload the customer master data through SECATT?
Regards,
Chandra.
‎2007 Dec 12 3:35 PM
Hi,
1) Start tcode SCAT
2) Give the test case name and create
3) Give title, component then save and come back
4) Select the test case and go to change mode
5) Start record and provide the tcode to be recorded
1st button is for normal record (button with arrow key)
2nd button is for remote (to record in remote server of our landscape)
Give all the mandatory fields in the transaction without errors and without using f4 and f1 just like recording
After entering entire data click save button
Then click end recording
Then double click on the test case TCD
Then double click on the first report (SAPMF02D)
It will open the recorded transaction code
Import all the fields which we are going to provide in flatfile
There should not be any default values in the fields after importing
Click on next screen button
Same way import for all screens
Then go back and click save then go to GOTO -> VARIANTS -> EXPORT DEFAULT
Then give the path to be transferred in our local sys and transfer as excel file (save with .xls type)
Then open the excel file
Select 1st 2 columns right click and delete
It should contain only the field headings and description
Leave one empty line and enter our records from 4th row onwards
Enter all the records and save the excel file
Then execute our test case
Then select the type of mode (foreground/background) and variants from external file
Select our excel file and then execute (click remote execution if its a remote server)
Finally check the data is uploaded or not
Thanks
Sivaparvathi
Please reward points if its helpful.
‎2007 Dec 12 1:47 PM
Hi
first of all you need to get flat file format for customer master from SECATT. Once you get that, you can upload that data into SAP(customer master) using BDC, LSMW as per ur requirement. If you use BDC, u need to do the recording for customer master tcode using SHDB tcode. after that need to create internal tables as like flat file. then get flat file data into this itabs. finally assign this itabs to screen fields(which are available in recording code ).
Reward if it is helpful.
Thanks
Siva Kuamr
‎2007 Dec 12 3:35 PM
Hi,
1) Start tcode SCAT
2) Give the test case name and create
3) Give title, component then save and come back
4) Select the test case and go to change mode
5) Start record and provide the tcode to be recorded
1st button is for normal record (button with arrow key)
2nd button is for remote (to record in remote server of our landscape)
Give all the mandatory fields in the transaction without errors and without using f4 and f1 just like recording
After entering entire data click save button
Then click end recording
Then double click on the test case TCD
Then double click on the first report (SAPMF02D)
It will open the recorded transaction code
Import all the fields which we are going to provide in flatfile
There should not be any default values in the fields after importing
Click on next screen button
Same way import for all screens
Then go back and click save then go to GOTO -> VARIANTS -> EXPORT DEFAULT
Then give the path to be transferred in our local sys and transfer as excel file (save with .xls type)
Then open the excel file
Select 1st 2 columns right click and delete
It should contain only the field headings and description
Leave one empty line and enter our records from 4th row onwards
Enter all the records and save the excel file
Then execute our test case
Then select the type of mode (foreground/background) and variants from external file
Select our excel file and then execute (click remote execution if its a remote server)
Finally check the data is uploaded or not
Thanks
Sivaparvathi
Please reward points if its helpful.
‎2007 Dec 18 6:29 AM
Hi Siva,
Thanks for the reply.SCATT as well as SECATT. Your are mentioned process is SCAT. But I want upload the through SECATT? Tell me the process plz?
Regards,
Chandra.