cancel
Showing results for 
Search instead for 
Did you mean: 

update a field in all customer and material master record

Former Member
0 Kudos

Hi dudes,

i am now activating sales info system. to view reports, the huge list of customer and material master records needs to be with '1' in statistics group field. please let me know the fast way of doing this.

and i want to check previous month reports too though i hav activated SIS now.... is there any option ?

regards,

madhav

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear Madhav,

Try with:

T. Code: OLI7 - updating orders,

T. Code: OLI8 - updating deliveries

T. Code: OLI9 - updating billing documents.

[Reference link|]

Best Regards,

Amit

Note: Check with OSS Note: 006436. Hope, this would be helpful.

Former Member
0 Kudos

hi

the t code MASS has to be executed in PROD, right.

Can i go ahead and do it with my ID or this can be executed by end user, so that training him is sufficient

regards

madhav

Former Member
0 Kudos

if you want to include sales orders created before activation of SIS, i think you need to update in IMG. try MC3V. again, maybe somebody can clarify.

cheers.

Former Member
0 Kudos

Hi,

Goto XD99, select table KNVV and click on field tab.

Select the field VERSG ( Customer Statistics Group) execute.

Enter customer range and execute.

Enter the value in new values field. click on carryout mass change button and save.

Do the same thing for material master also. use MM17.

Material table MVKE - VERSG

Regards,

Chandra

Former Member
0 Kudos

for material you can also use MASS. select object BUS1001, table MVKE and field VERSG. for customer master use KNA1.

regards.

Former Member
0 Kudos

hello, friend.

for customer, you can use either MASS or XD99. will get back to you for material master.

regards.