cancel
Showing results for 
Search instead for 
Did you mean: 

Material master upload issue

Former Member
0 Kudos

Hi gurus,

I want to upload material account assignment group in existing material master records. There are n no of material mater records.

It has to be uploaded based on the valuation class.

For each valuation class, a material acct assignment group is created. All materials are extended to 31 plants.

While I try to upload using tcode mm17, I cant upload material acct assignment group using the valuation class since in valuation tab,acct assignment group is not present.

Kindly help to sort out this issue.

Regards,

Vimal

Accepted Solutions (0)

Answers (2)

Answers (2)

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

Try with T.Code:MMZ1

Regards,

Biju K

JL23
Active Contributor
0 Kudos

the account assignment group is on sales org 2 view, table MVKE field KTGRM.

In MM17 you have to select MVKE and MBEW together.

Then you select only records with a certain valuation class.

Finally you update field assignment group

Former Member
0 Kudos

Hi,

I tried it too... But how will you give based on the valuation class? since in that tab account assignement group is not present......

regards,

vimal

JL23
Active Contributor
0 Kudos

in MM17

Select sales org Data for Material - table MVKE

select valuation data for material - table MBEW

Execute.

Enter your selection (you can add further selections e.g. valuation class field by clicking the button choose selection fields on the bottom.

Execute.

now you see all records to be changed.

Click select fields. Pop-up is coming.

Choose Account assignment group field and continue.

Account assignment group field has appeared and you can now enter the new value .

Click the colomn header of the field to be changed.

Then click button change field values.

You can see immediatly the new values in the records below.

If you click save, then the new values are written to the database.

Former Member
0 Kudos

Hi jurgen,

Thanks for ur response. I tried it all..... But I want material acct group to be given with respect to valuation class.

Regads,

vimal

JL23
Active Contributor
0 Kudos

if you select only records based on valuation class xyz, then you have only such records for maintenance available.

I guess you missed a step from my explanation.

Maybe you should try to describe in the same detail what you did and what you see at the same moment. this would help to find the error in the process.