topic Re: customer master upload in Application Development and Automation Discussions

customer master upload

Former Member — Fri, 29 Feb 2008 11:07:17 GMT

Hi,

i ws trying to upload customer master data via LSMW.

i planned to upload the data part by part. i mean first i planned to upload kna1 data, later knbk,knvv,knvb etc etc. i thought of developing new object for each upload.

when i'm trying to upload only KNA1 data, its also asking for fields from knvv or knbk i.e mandatory fields. so its not going further giving error.

how to upload the data in this scenario like uploading table after table

full points assured..

Thanks in advance

shekhar

Re: customer master upload

Former Member — Fri, 29 Feb 2008 12:24:19 GMT

If you are loading via a script / BDC : what checkboxes did you mark on the first screen.

Did you fill in company code or sales data even though you were only trying to load the general data screen(s) ?

Re: customer master upload

Former Member — Fri, 29 Feb 2008 12:31:47 GMT

Hi ,

I dont think that is it posible to upload data table by table when you are using a BDC for a transaction.

In case you want to upload data table by table then better option would be to use a report , but this can result in data inconsistency as the system will not be checking for consistency as it does when you upload data using a transaction.

Regards

Arun

Re: customer master upload

Former Member — Fri, 29 Feb 2008 12:37:00 GMT

You can not do table by table, indeed. But you can do view by view.

e.g. first general data = related to KNA1,

afterwards sales data = related to KNVV

then bank data, company code data, etc...

Re: customer master upload

Former Member — Fri, 29 Feb 2008 12:45:38 GMT

Hi,

i'm doing this through LSMW (direct input method).. i was gives files separately for KNVV data KNA1 data ; so basically a file for each table or rather a view.

now i have to upload that data... whats the best way to do that in lsmw?

Kris,

if you remember some time back i have asked this question, so basically just trying to do what you suggested...

uploading first kna1 data later knb1, knb5 ...............

i'm getting error when i'm trying to do like that

Regards

shekhar

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:02:33 GMT

It s all a matter of mapping.

Some tips when mapping KNA1 :

- Target structure BGR00 : make sure you enter a / in the nodate field

- Target structure BKN00

STYPE = 1

TCODE = XD01 or XD02 for changing

KUNNR = external number

BUKRS = '/'

VKORG = '/'

VTWEG = '/'

SPART = '/'

KTOKD = cust group

KKBER = '/'

- Target structure BKNA1 : fill a / in the fields you don t want to update

- All other target structures : no mapping

(make sure these are not present in your converted file)

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:16:53 GMT

Hi Kris,

i am passing the kna1 data to the kna1 structure; for BKN00 structure, i'm passing the kunnr,vkorg,vtweg,spart and account group.

but when i ran the transaction in foreground mode, i observed that apart from the KNA1 data, its going to the other screens as well i.e screens in which fields are from knb1 or other table and also mandatory fields

Regards

Mahesh

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:19:38 GMT

Don't pass vkorg,vtweg,spart (this is meant for KNVV-fields)

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:33:59 GMT

Hi Kris,

when i create a customer with the KNA1 data, later when i want to add sales area data to the existing customer via LSMW giving the tcode 'XD02', its not allowing to do so; its giving me the error 'Customer has not been created for the sales org ' ' distri channel ' ' and division ' '

thats the reason, i'm giving the sales area data at the starting itself

i need your suggestion as to how i should go about uploading the multiple files

Regards

shekhar

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:42:03 GMT

> when i create a customer with the KNA1 data,

Here use XD01 and don t specify sales org, distr ch and division.

> later when i want to add sales area data to the existing customer via LSMW giving the tcode 'XD02', its not allowing to do so;

Use XD01 instead XD02 and fill in sales org, distr ch and division

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:53:49 GMT

Hi Kris,

if we give XD01, its giving error 'Account already exists....

Re: customer master upload

Former Member — Fri, 29 Feb 2008 13:58:45 GMT

Which step?

The kna1 creation (step 1) or the knvv creation (step 2) ?

Possible scenarios:

1 ) KNA1 and KNVV exists already.

No create possible

2 ) KNA1 exists, KNVV does not exist.

Step 1 not possible

Step 2 : use XD01 to create sales view

3 ) KNA1 and KNVV does not exist

step 1 : use XD01

step 2 : use XD01

Re: customer master upload

Former Member — Fri, 29 Feb 2008 14:08:26 GMT

Kris,

i' m talking about the step 2.

customer already exists : i have uploaded the kna1 data through lsmw; tcode : XD01

next i tried to upload the knvv data thru lsmw : tcode XD01

here its giving the error which i mentioned earlier

Re: customer master upload

Former Member — Fri, 29 Feb 2008 14:16:47 GMT

Did you create KNVV data during the first step or only KNA1 data? I mean did you fill in sales org during the KNA1 load?

Cause if it says that the customer already exists for the mentioned sales org, then it was already created.

Do you specify a customer number in the second step?

Re: customer master upload

Former Member — Fri, 29 Feb 2008 14:38:43 GMT

kris,

i have created the kna1 in the first step. i did not give any sales area data when uploading kna1 and the tcode i used in XD01

later i have tried to upload KNVV data giving sales area data

i have checked. customer is there but not assigned to any sales area but still giving the error

Re: customer master upload

Former Member — Fri, 29 Feb 2008 14:44:02 GMT

Step 2

When loading KNVV, fill in BKN00 like this

STYPE = 1

TCODE = XD01

KUNNR = Customer number

BUKRS = '/'

VKORG = Sales org

VTWEG = vtweg

SPART = spart

KTOKD = '/'

KKBER = '/'

If you get the error

'Customer has not been created for the sales org ' ' distri channel ' ' and division ' '

then it means that sales org/distr ch and division were not filled in in BKN00.