Mass upload of inforecord scale prices with object 0070 and RV14BTCI or COND_A idoc

[alisa_schlossberg-majer]

hello gurus

I have looked in the forum but I dound little to nothing among the 114 answers that can help my issue.

I am trying to upload scales prices for pricing conditions (which I will transfer to Purchasing ifo records), ; I tried first with RV14BTCI: I used transaction XK15 and in attachmets the settigs of my VAKEY as well as my structure fields. I used a flat field.

I also tried Idoc COND_A, same principles.

my File is a TXT file with Tabulator and is for multiple structure of course.

my issue is in the fact that when I run the batch input or the idoc, I have the exact same issue: the data in my structure, meaning Vendor, material, Porg, plant and infotype, same as in VAKEY, is being read correctly but converted as being one field and I get an error of course where data is not being recognized. any idea of what I am missing?

in attachment the structure, VAKEY, result in batch input and my file

price1.pngprice2.pngprice3.pngprice4.png

[alisa_schlossberg-majer]

this forum used to be very active, it became quite slow, not even one idea?

[Lakshmipathi]

When you create a discussion and start adding additional information as asked by the members, please add the same under Comments and not under Answer as you were not answering but sharing additional information. Also, when you add under comments, a mail will be triggered to who you respond. By the way, I have converted your above Answer to Comment

[FredericGirod]

Honestly, I don't understand your question; is it related to LSMW or to ABAP ?

[chaouki_akir]

There are problems with your LSMW.

Your data seems to not be mapped correctly. For example, your vendor number should have leading zeroes : 0000205007

LSMW is having helpful steps "Display Read Data" and "Display Converted Data". And an ABAPer could easily find them. You are not giving enough informations.

[alisa_schlossberg-majer]

Hello Chaouki

according to examples I found online, nobody has leading zeroes.

Display reading and converted data I always check but what is the Abaper supposed to find there?

as you can see in my previous attachment, my data seems correct in there

here is an example online for VK152023-01-03-08-05-28-lsmw-rv14btci-upload-sales-pri.png

and as you can see, no leading zeroes

[alisa_schlossberg-majer]

hello Frederic Girod

it is LSMW but there is no such tag: LSMW questions are under Abap

[raymond_giuseppi · Accepted solution]

Does domain MATNR carry a conversion-exit in your system (ALPHA or any exit related to an industry solution), in this case you are required to convert your external value for material number to internal format (check also other fields for any required external/internal format conversions)

[alisa_schlossberg-majer · Accepted solution]

hello Raymond

I am not aware of any conversion-exit being implemented for our material.

must be said that the material contains symbols, such as dot and hyphen.

like 107.8765-08 for example

[raymond_giuseppi · Accepted solution]

Just check with SE11 on domains MATNR (ALPHA or MATN1) and LIFNR for (ALPHA) conversion-exit.

Also how did you fill other fields such as VAKEY_VERSION, and what is the exact error message?

[alisa_schlossberg-majer · Accepted solution]

hi Raymond

MATNR is on MAT1 and LIFNR on ALPHA

what does it mean? and in which table do I find the internal number?

[alisa_schlossberg-majer · Accepted solution]

found it and it worked!! I learned something new 🙂

Tables MARA and LFA1 had the internal number, I changed the data in the file and it worked

thank you Raymond

[raymond_giuseppi · Accepted solution]

Happy you found it.

You could also use the input FM (ext -> int) associated to the conversion exits (double-click in SE11 on the domain conversion routine name)

• CONVERSION_EXIT_MATN1_INPUT
• CONVERSION_EXIT_ALPHA_INPUT

[Lakshmipathi]

You have created this discussion only yesterday and need to have some patience please as the members here are volunteering their time apart from their daily official work. If any member see your post and they have any clue, definitely, they will assist you.

Now, coming to your query, please check whether the following OSS notes helps you

1. 1094114
2. 1274076
3. 1480177
4. 1726635

[alisa_schlossberg-majer]

thank you for your reply.

I am part of this forum for the past 20 years....it used to be much more active.

but never mind.

Part of the notes I have already seen, none of them fits the problem/solution.

in attachment you can see the VAKEY field in the converted data: it basically contains all the fields I need for table 017.

but when I run Batch input, even if these fields are part of the file, the system is trying to fill transaction XK15 field VENDOR with the entire content of VAKEYdisplay-converted-data.png