Problem creating Material Master sales view with LSMW

[Former Member]

Hello experts,

I have created a LSMW that uses the direct input program RMDATIND to create new material master records. These materials have different material types.

I require fields from different views like Purchasing, Sales, MRP and accounting, among others. But not all the material types have all the view defined. I will like, if it's possible, use the same LSMW program to upload all the materials.

The problem that I'm having if once I ran the program, I got the warning message "The data for the maintenance statuses V cannot be transferred", message no. MG161, and even the material is created the sales view is it not. I check all the sales data in my CSV file and looks good.

I'm also having in some records, the warning message "The data for the maintenance statuses BG cannot be transferred". That indicate problems with the accounting view.

As an extra information, I'm using the following structures BMM00, BMMH1, BMMH2, BMMH5 and BMMH7.

Hope you can help me to solve this issue.

Regards,

Mairo.

[JL23 · Accepted solution]

>

> I'm also having in some records, the warning message "The data for the maintenance statuses BG cannot be transferred". That indicate problems with the accounting view.

.

Each material type has its own set of views, e.g. a FERT has sales views but no pruchasing view, a ROH has purchasing view but no sales view, a NLAG has no storage views and a UNBW no accounting views.

This is defined in customizing of attributs of a material type.

Because of this you have to make sure that you do not transfer sales data for a material type that does not have sales views.

Which views you actually want to create is defined in field PSTAT. Each character stands for a certain view (defined in table T132)

re:The data for the maintenance statuses BG cannot be transferred

Are your matrials split valuated?

if you want create accoutning data in MBEW table with MBEW-PSTAT having BG status, then you have to make sure that MARA and MARC PSTAT field also has the B and G .

[Former Member · Accepted solution]

Hi Jurgen,

Thank you very much for your answer, very helpful. I modified the PSTAT value and added the Sales view.

Now, based on your experience it's recommended to use only one LSMW to upload all the material types? I planned to use only one and fill up the fields depending on which views the particular material type require.

I also require to add different valuation types for each of the plants. I'm planning to do this with another LSMW program.

Please advise,

Thanks,

Mairo.

[JL23 · Accepted solution]

I used just one LSMW object for all material types,

This is easier than having maybe 10 different objects. if you have to correct a general error, then you just do it once instead of 10 times. However, you may have to add material type specific coding then for the one or other field.

Processing this LSMW I usually do per material type, because different busines people may be responsible for the various material types. So it is easier to distribute error lists, and each one can just work on its own errors.

[Former Member · Accepted solution]

Thanks, that what I need.

Now I'm having the error "Field VKORG has been transferred inconsistently or is blank" Message no. MG046

and VKORG for MVKE is ""; previously "" Message no. MG047, for those material types that don't need sales view data.

I have mapped VKORG and VTWEG and reference them to a field I have in my CSV file.

Any idea to solve this?

Mairo.

[JL23 · Accepted solution]

empty fields in a batch input should have a slash / as content.

[Former Member · Accepted solution]

Thank you Jurguen.

I filled up the null values with "/" and works. Too bad I can't give you more points.

Regards,

Mairo.

[Former Member]

Hi

I suggest you to check one record by creating the sales view manually by MM01 and see whether any warning message or error message.

Thanks/Karthik

[Former Member]

Thanks for your suggestion Karthik.