Material Management LSMW Error Pertaining to Product Hierarchy

[Former Member]

Hi,

I'm trying to use an LSMW to upload materials.  The first time I started IDoc Processing, I received an error contained in the screenshot below:

So, in my template, I inserted the appropriate value in SPRO/IMG.  And, then I restarted the LSMW to receive the same error above.  However, I received the same error again.

I was told to map the field to both the sales view and the basic data view.  If somone could advise me how to do that, I would appreciate it.  In the alternative, do you have any different advise.

< removed by moderator >

Thanks in advance...

Message was edited by: Jürgen L

[Former Member]

Gentlemen,

Our offshore department wound up fixing the problem for me.  I asked them if Jurgen's final suggestion was the solution.  They said no.  The solution lies in:

changed the mapping rule

I assigned back product hierarchy back in the program

I have no idea what that means.  Maybe one of you two could elaborate.  In the meantime, how can I allocate to you 2 the points you deserve?

I am very greatful for the assistance you 2 have given me.  And, I look forward to helping others in the same way you have helped me.

Paul

[JL23]

actually I have no idea what is meant by:

changed the mapping rule

I assigned back product hierarchy back in the program

you may check again using the table display offered by Ted and see how the mapping rules for the product hierarchy field(s) look now.

[Former Member]

Paul,

In LSMW after assigning Standard Batch/Direct Input select Object 0020 Material Master, go back to main screen and click Object Overview, on the pop up window select display as table, you can use this screen to help map the required fields when you maintain Source Fields

Product hierarchy needs to be mapped to field PRDHA for basic data and PRODH for the sales view.

[Former Member]

Ted,

thanks for the tip.  I did that, and Product Hierarchy is there.  It has the abap code:      *E1BP_MARA-PROD_HIER = ZMATMAST-PROD_HIER. assigned to it.

[JL23]

What IDOC method are you using?

Do you really load material masters into the ERP database or is this a staging load to MDM or MDG?

*E1BP_MARA-PROD_HIER is probably equal to MARA-PRDHA

and ZMATMAST-PROD_HIER is your source file field

if you do not see the product hierarchie in ZMATMAST-PROD_HIER field in step 10, then SAP was not able to move this data from your source into this field when running step 9.

Depending on your definition in step 7 it could be cause by a typo in the field name in your template (to verify that I would need info how your settings are in step 7 and how your source looks like) or it is in the wrong column in your template. Or the length of the source field is not correct defined and it could not take the number.

[Former Member]

Hello,

I'm using an LSMW Idoc.  We are loading right into the ERP database.

Step & should be okay.  I have Data for one source Structure selected, it is "Other" Pipe delimited file.  The field names are at the start of the file and the orders match.  It's a text file, and the code is set to ascii.

Also, I checked, and, there are no spelling errors.  The product hierarchy value is in the appropriate column.  It is set to 18 characters.  Currently, the actual "value" is 4 characters: AB00

[JL23]

okay I see that you are using BAPI method (which finally creates IDOCs), but direct IDOC method would have different structure and field names.

can you confirm that you can see other MARA field values that are located before and after this product hierarchy field in your template   in the right target field in step 10  read data.

btw in my system the field name is E1BPE1MARA-PROD_HIER yours has an underscore  instead of a 1 in  *E1BP_MARA-PROD_HIER .

[Former Member]

Don't forget the product hierarchy is exactly what it says, take care with spacing etc and check the value you are trying to load has already been configured, I have had the same problem myself in the past, and as Jurgen says you get two chances to read and check the data before you loading, if you don't see the value in step 10  and step 12.

Check your source fields in table maintenance step 3, then assign the appropriate fields in step 5, while you are there go to extras and check for any unassugned source field, then check the syntax (Press Shitf+F2)

I always try a load file with one line of data run in the foreground, then a small file of 10 or 12 items run in the background before loading a large amount of data.

[Former Member]

Hi,

I noticed that in my text file, where it should have said "Product Hierarchy," it said AB001.  I made the correction to so that the header now reads "Product Hierarchy."

In step 10, I have all the material related information. When I select a line, I can see Product Hierarchy and the appropriate value. 

However, when I complete running the LSMW, it fails for the same reason.

[Former Member]

Good thoughts, How do I process this IDoc in the foreground? 

Please forgive me for all of the 100 level questions, the data manager is MIA.

[JL23]

you probably missed to set a X in the prooduct hierarchy field in E1BPE1MARAX structure

[Former Member]

When i drill down into a line on Step 12, the produc hierarchy field value is left blank.

[Former Member]

It depends on the method you use to load the data, as far as I am aware you can't run direct input in the foreground, but the method is the same, one line first, then check the data to make sure all is well.

[Former Member]

Forgive me, I meant to say I want to Process errors in the foreground.

[Former Member]

If you can see the product hierarchy against other entries check the load file for blank data, you can also chek the number of lines of data, e.g 1,234 in the load file against the number of records Read, Written and No Written in step 9, they should match, it's not unheard of to miss a trick and load a file with empty records.

[JL23]

you missed to enter a X in the product hierarchy field of Bapi structure 

  E1BPE1MARAX

only those fields will go to the IDOC

[JL23]

process errors in foreground is related to batch input, there is no such feature for Material IDOCs

[JL23]

I do not really understand what you want to say with : So, in my template, I inserted the appropriate value in SPRO/IMG.  And, then I restarted the LSMW to receive the same error above.

I understand that you entered the value for the product hierarchy field  in customizing

but I do not really see what you actually do with the  product hierarchy field  in LSMW

is this product hierarchy number in your source file?

do you move this source value to the right target field in LSMW?

can you see this product hierarchy value in your IDOC?

[Former Member]

Jurgen,

I think there are some typos in my initial post.  What I meant to say is that I inserted the appropriate dummy value for product hierarchy into my template.

Yes, the Product Hierarchy (PH) number is in my source file. 

I see two product hierarchy fields in hte mapping:  1 is under the material view and the other is under the sales data.

I think the issue may be either in placing the source value into the target field.

No, I can't see my product hierarchy value in the IDOC.

[JL23]

go into LSMW step 5 Mapping rules and check what source field(s) you assigned to the PRDHA and PRODH field and what conversion rule you have.

check in step 10 display read data if you can see the product hierarchie value. (click one of the lines in the overview to get to the detail with the individual fields.

check in step 12 display converted data if you can find the product hierarchy number in structure e1maram and e1mvkem

[Former Member]

Hi,

I'm not seeing the fields PRDHA or PRODH.

In Step 10, it is not displayed. 

And, in Step 12, I see no product hierarchy number in external structure esbp_marc002 or internal structure e1bp_marc.