Skip to Content
0

LSMW can’t upload pricing condition record msg.VK523

Dec 20, 2016 at 05:56 AM

416

avatar image

Dear colleagues,

I tried to create LSMW to upload pricing conditions for that i used batch input program RV14BTCI. At the end batch input session is terminated. I don't know where I am wrong.

My setup is like this:

Define Object Attributes

Define Source Fields

Define Structure Relations

Define Field Mapping and Conversion Rules

Specify Files

My file look like this:

Sales org: 1010

DC:10

Material TG10

And txt look like this:

Read data look like this:

And converted like this:

When I try to create Batch Input Session

I get this messages

Could you please help me where I am wrong and how to make proper LSMW for Pricing conditions upload?

In addition, how to upload multiple scales items (like in first line of txt file e.g. for 10PC 47EUR and for 20PC 45 EUR)?

Thank you,

Harry

omovh.png (24.0 kB)
jm7ej.png (93.2 kB)
ftjme.png (37.8 kB)
nb90f.png (124.1 kB)
m6uac.png (131.7 kB)
2rz9m.png (53.3 kB)
1m6kt.png (58.5 kB)
cdkmk.png (9.4 kB)
lqilk.png (6.6 kB)
lr5ju.png (48.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

9 Answers

Harry Haller Dec 20, 2016 at 06:01 AM
0

some screens wasn't transferred so i add them here:

And converted like this:

When I try to create Batch Input Session

I get this messages


o5mnw.png (12.9 kB)
6xoqz.png (56.1 kB)
gzbwr.png (45.9 kB)
3shmh.png (134.0 kB)
a0xms.png (34.8 kB)
gocbq.png (29.5 kB)
cugsv.png (12.2 kB)
utdox.png (15.3 kB)
iowyz.png (12.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

I wanted to document properly because I don't know where i am wrong, and it will help to other members of community in future to easily understand.

Thank you for consideration,

Harry

0
Jürgen L
Dec 20, 2016 at 06:35 AM
0

can you explain the details of field VAKEY

Share
10 |10000 characters needed characters left characters exceeded
Harry Haller Dec 20, 2016 at 08:26 AM
0

1010 is Sales organization (SO)

10 is Distribution Chanel (DC)

TG10 is material number (MN)

1010-10-00000000000000TG10

SO-DC-MN (material numbers with leading zeros)

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Dec 20, 2016 at 08:42 AM
0

A alphanumeric material number does not have leading zeros, only number values have leading zeros.

if TG10 is your material number then the VAKEY should be like this: 101010TG10

Share
10 |10000 characters needed characters left characters exceeded
Harry Haller Dec 20, 2016 at 09:01 AM
0

Thank you Jurgen,

i did as suggested:

But i still have same issue. Process terminated.

Best regards,

Harry


diroa.png (15.3 kB)
majdt.png (32.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Dec 20, 2016 at 09:15 AM
0

Can it be that you are on S4/HANA?

In that case you have to use VAKEY_LONG if I am not mistaken, had not yet the chance to do anything in S4/HANA

You may want to look into OSS notes

2368481 - In SAP S/4HANA table KONV is replaced by PRCD_ELEMENTS

2267308 - S4TWL - Data Model Changes in SD Pricing

Share
10 |10000 characters needed characters left characters exceeded
Harry Haller Dec 20, 2016 at 09:26 AM
0

yes it is S4H.

I will check notes which you sent me, anyway how to make different lines for scale, e.g.

10pc 40 EUR

20pc 35 EUR

30pc 30 EUR

because in my example in file I had situation like this (different scale items marked):

and I got :

with only one BKOND3. does it mean that for each scale line I need to have BKOND2 and BKOND1 as well?

Best regards,

Harry


0ewio.png (10.5 kB)
hjj9f.png (15.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Dec 20, 2016 at 01:15 PM
0

If you have BKOND2 and BKOND1 records for each scale then your program will overwrite the first created transaction with the second and the second with the third, that will not work

You should just have BKOND1 once per transaction, and one BKOND2 per validity period, and many BKOND3 for all scale values.

Having all scales in a single line in the source requires a bit ABAP knowledge in LSMW to make it happen, as you have to fill the same structure again with the values of the second scale after it had submitted the first record.

Looking at you LSMW Mapping rules you are actually far away from that. You have not even the processing times visible, see my blog https://blogs.sap.com/2012/12/27/lsmw-material-master-by-bapi-method-part-1/ especially the part " Prepare your Field mapping and conversion rules"

In the second part of that blog I then explained how to code this around the last screenshot related to

Step 5

Share
10 |10000 characters needed characters left characters exceeded
Veselina Peykova
Dec 21, 2016 at 07:13 AM
0

I hope that you are doing this for educational purposes and you are not really planning to use LSMW for a live S/4 production system. SAP note 2287723 - LSMW in SAP S/4HANA on-premise edition, mentions the following:
"The Legacy System Migration Workbench (LSMW) can only be considered as a migration tool for SAP
S/4HANA using workarounds and careful testing for each and every object. The use of LSMW for data load
to SAP S/4HANA is not recommended and at the customer's own risk".
SAP recommends different tools, which you can get for free. I am yet to test these myself for our 1610 sandbox, but they are probably worth a try. Why did you choose LSMW for S/4? It is a hit&miss in many cases (yes, we tried to get it to work with varying levels of success for different processes). In my humble opinion, the risk of not populating the data correctly is too big to justify the usage of LSMW in this case. If I end up with a similar task as yours, I would rather invest some time into learning the new tools, instead of performing activities, for which, if things go terribly wrong, I won't get help from SAP.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you Veselina, but what is that new tool? and if it is still in testing phase what SAP provides instead of LSMW?

I used LSMW because it is easy to use, and logical.

Best regards,

Harry

0

The tools, mentioned in the SAP note, are not in testing phase, it is me, who did not have the time to play with them in a sandbox :)

LSMW is an easy option for ECC, but for S/4 HANA, if you consider the time, spent on verifying if your upload will cause further problems (if you ever get the old program to upload something), it is better to spend some time in learning to use SAP Rapid Data Migration. I don't think, that LSMW will be coming back.

0