Mass upload

[Former Member]

Hi All,

Please let me know I would like to do mass changes to customer master fields below

KUNNR Customer

NAME1 Name 1

COUNTRY Cty

VKBUR SOff.

KVGR3 C Grp3

KVGR4 CGrp4

KVGR5 C Grp5

KDGRP CGrp

VKORG SOrg.

BZIRK SDst

PARVW PFunct

I have maintained the final data excel sheet. Now I would like to upload the data

Please let me know the process or steps.

Regards

Aditya

[Former Member · Accepted solution]

Hi Adi,

I suggest to use T-code MASS and object KNA1.

There you can change all the data which you mention in the post.

Hope it helps,

Regards,

MT

[Former Member · Accepted solution]

Hi,

I put object type KNA1 and I am not given any variant and executed it takes me. Tables and fields tabs

Please let me know I have to select any table ex: General Data in Customer Master KNA1

Customer Master Sales Data KNVV.

After table tab fields tab is there I have select any fields here.

Can please tell me clearly.

Aditya

[Former Member · Accepted solution]

Hi Adi,

Let me take example of two fields change, which you already mentioned.

Country and Customer name

Go to T-code MASS --> Object Type KNA1 --> Execute --> Both the fields available in table "General Data in Customer Master" --> Select it --> Execute --> on next screen give your customer number --> Execute

On next screen, lower side you can see your customers

On the middle left side of screen, you can see the icon "Select fields" --> click on that --> A popup window will come and will show you all the fields --> once you find the required fields --> double click on that field --> it will automatically add in the left side --> after selecting all the fields --> Enter

Now in the section you can see the the field is blank.

Fill up the field in "New value column" --> Now just before the UNDO icon there is a icon "Carry out MASS change" --> click on that --> might be it will show you the information "Select at least one column" --> select the old value fields colunm vertically --> click on that icon.

Hope it helps,

Regards,

MT

[Former Member]

Hi,

Goto the transaction code MASS

and select the OBJECT TYPE as KNA1

in the next screen you can find all the tables for the customers

select the specific table and choose the tab FIELDS

for example

KNA1- NAM1 and choose Execute (F8)

it will lead to another screen in which we can enter the details of all the customers to whom you want to change the data

Please check the same transaction code for the rest of the field and revert

[sidi_reghioui]

Hi

You should upload customer data through LSMW

for recording:

http://wiki.sdn.sap.com/wiki/display/ERPLO/DataMigrationwith+LSMW

http://wiki.sdn.sap.com/wiki/display/ABAP/Completescenarioof+LSMW

I suggest you better use, BDI Business object 0050, method 00000 instead of recording.

Regards

Sidi