Regarding Customer Master

[Former Member]

Hi,

I want to delete a Partner function (let us assume PY with no.12345) from around 300 customer master records. Is there any solution for it.

Except deleting one by one manually.

Thanks in advance,

Bhaskar.K

[Former Member]

Option 1: Mass change through T.Code : XD99

Option 2: BDC

OPtion 3: Develop Program through Abaper to meet the requirement.

Regards,

Rajesh Banka

[Former Member]

Hi Bhaskar,

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].

Regards

Pratheb Nadarajah

[Former Member]

Hi Pratheb,

Can you eloberate the process in SCAT.

[Former Member]

Hi Bhaskar,

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

<u><b>I have explained the procedure step by step and do note the following explanation is specific to your problem</b></u>

<b>Creation of CATT Test Case:</b>

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 Partner functions tab

7)Select the Partner function using Partner function position field and delete the line

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 deleting a partner function with a sample data.

<b>Download of source data file</b>

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. If you have to execute the partner deletion across multiple Sales Area you need to do the same for the Sales Area fields too

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

<b>Modify the source data file</b>

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 partner function has to be removed.

4)Save the file as Text Delimiter

Now the data to be uploaded as been prepared.

<b>Upload the data from source file</b>

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.

Hope this helps.

Regards

Pratheb Nadarajah

[Former Member]

Hi Pratheb,

Thats a nice explanation !!!!

Regards

Sadhu Kishore

[Former Member]

hi Bhaskar,

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 partner functions PY. You can display all the payer partner functions.

hope this will help you out.

[Former Member]

Hi Rajesh,

My requirement is to remove that partner function from all customer records. But in your suggestion at T.Code XD99\ MASS Customer mass maintenance, we are not able to delete the fields. We can change the fields only.

Is there any other way to do it.