Hi,
Go to XD99 t.code and select- customer master partner functions.
.
Execute you will get a menu to enter the sales area and partner functions.
select sales area and change it.
Alternatively:
You can use the Computer Aided Testing Tool (CATT) to delete the partner function across multiple records.
You will have to record the transaction of deleting the partner function for one customer number in XD02 or VD02 and then input the remaining customer numbers from a file.
The TCODE for accessing CATT is SCAT.
Although CATT is primarly a testing tool it can be used for mass upload of data. The CATT works as if an user is updating the values one by one.
The procedure to upload the data using CATT is done in four steps
a) Creating the CATT Test Case & Recording the sample data input
b) Download of source data file
c) Modify the source data file
d) Upload the data from source file
I have explained the procedure step by step and do note the following explanation is specific to your problem
Creation of CATT Test Case:
1)Go to TCODE SCAT
2)Create a Test Case by entering a name and clicking the TCD button in application tool bar
3)Enter the TCODE you want to execute VD02 or XD02
4)Enter the customer number and sales area data.
5)Go to sales area view
6)Click SALES AREA tab
7)Select the sales area using saleas area position field and change it.
8)Click on Save
9)End Recording
10)Click on Save and save as local object
11)Press Exit button and save changes while exiting
Now we have created a recording for modifying the sales area function with a sample data.
Download of source data file
1)In the SCAT screen select your test case and click on change
2)Click on choose button in the application tool bar
3)Click on field list in the application tool bar
4)Double click on the customer number and change the parameter name as &CUSTNO. Any field starting with & would be treated as an input field from a file.
5)Remove the default value
6)Press Exit and save the test case
7)In the SCAT screen select your test case and in the menu bar Goto -> Variant -> Export Default
8)You would get a text file.
Now you have downloaded a source data file
Modify the source data file
1)Open the text file in Excel and load the remaining data
2)Remove the fourth line which starts with three asterisks
3)Below the customer number heading (&CUSTNO) load all the customers for which the sales area is changed.
4)Save the file as Text Delimiter
Now the data to be uploaded as been prepared.
Upload the data from source file
1)Go to SCAT, select the test case and press F8
2)Select the processing mode as background
3)Chose variant as external from file
4)Click on choose and select the path of the text file
5)Press F8 for the remaing records to be updated
After execution press Enter to see the log. Any line highlighted in Red is an Error for which you need to do further analysis to find out the error reason.
But you should have the authorization for the same.
regards,
Siddharth.
Edited by: SD on Apr 1, 2008 11:05 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.