MASS MAINTENANCE OF TRANSACTON VK34

[Former Member]

HI,

Could you please tell me how to perform a mass change in transaction VK34.

For each pricing conditions, I have to maintain a new price, a new validity date and an amount in the condition supplements.

I Have hundreds of records to change so I'd like to know if there were a tool to carry out a mass change...

Thanks

[skrishen9]

The Mass Changes required by you for updating the pricing conditions you can use lsmw.

which is the best way to do the mass changes required to be done in vk34.Following steps may be useful to you.

You can create lsmw for data migration as follows (using session method):

Example for VK11 (Create Condition Record)

Initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.

1. TCode : LSMW.

2. Enter Project name, sub project name and object name.

Execute.

3. Maintain object attributes.

Execute

select Batch Input recording

goto->Recording overview

create

recording name.

enter transaction code.

start recording

do recording as per ur choice.

save + back.

enter recording name in lsmw screen.

save + back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

Here you have to enter the name of internal table.

display change

create

save + back

3. MAINTAIN SOURCE FIELDS.

display change

select structure

source_fields->copy fields.

a dialogue window will come .

select -> from data file

apply source fields

enter No. of fields

length of fields

attach file

save + back

4. MAINTAIN STRUCTURE RELATIONS

display change

save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE

display change

click on source field, select exact field from structue and enter

repeat these steps for all fields.

save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

execute

save + back

7. SPECIFY FILES.

display change

click on legacy data

attah flat file

give description

select tabulatore

enter

save + back

8. ASSIGN FILE

execute

display change

save + back

9. IMPORT DATA.

execute

display change

save + back

10. DISPLAY IMPORTED DATA

enter ok, it willl show records only.

back

11. CONVERT DATA

execute

display change

save + back

12. DISPLAY CONVERTED DATA

execute

display change

save + back

13. CREATE BATCH INPUT SESSION

tick keep batch input folder

F8

back

14. RUN BATCH INPUT SESSION.

sm35 will come

Object name will be shown here

select object & process

Hope this will help you.

thanks

Sushant

[Former Member]

Hi,

Thanks for your answers.. But I have already tried to do this by recording through transaction SECATT ( ecatt).

The problem is that at the beginning , I have to click on the field " Price at sold to party" in the transaction VK34. But it seems that the recording is not able to do that...

In the input fields, it shows something like....BDC_OKCODE =%_GC 118 25 for this step.

So when I launch the recording, It can't go accross this step.. Any idea about that ?

[Former Member]

try to use LSMW