topic Adding new Customer data KNA1 in Application Development and Automation Discussions

Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:05:19 GMT

Hi,

I'm looking for a function or a Bapi that let you add new Customer data. And I have to specify the new customer number being used ( comes from an import file )

The tables that seem to be getting populated are

TABLES: KNA1,

*KNA1,

KNVP,

KNVV,

KNVK,

T151T,

T077X,

ZPAFDFLT.

TABLES KNB1.

The important bit is also specifying the customer number I want to use and not having SAP give me the number.

Thanks

Re: Adding new Customer data KNA1

RichHeilman — Tue, 08 Nov 2005 21:09:26 GMT

There is one BAPI. BAPI_CUSTOMER_CREATEFROMDATA1 This may not update all of your required tables.

Regards,

Rich Heilman

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:09:33 GMT

You have to create a new customer account group using transaction SPRO (the IMG).

IMG->Financial Accounting->AR&AP-Master Records->Preparations for Creating...->Define Account Groups.

Check the documentation first.

Here you define whether you use internal or external number assignment. Then as Rich says, it's probably batch input.

Rob

Message was edited by: Rob Burbank

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:14:04 GMT

This BAPI does not seem to let you specify the Cusomer number, it exports it back to you, I need to specify the customer number, I can't use this one.

Is there any which let you specify the customer number?

Re: Adding new Customer data KNA1

RichHeilman — Tue, 08 Nov 2005 21:15:08 GMT

Your only option may be to do a BDC over transaction XD01.

Regards,

Rich Heilman

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:18:14 GMT

I did notice that there is a field called REF_CUSTMR

in the PI_COPYREFERENCE, which goes in, could I use this for the customer number?

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:20:34 GMT

External customer number assignment is a configuration setting. If your account group allows for assigning external customer numbers, then you should be able to do it.

I don't think this BAPI supports external number assignment, but if this is your custom program that you are working on, why don't you do it in LSMW?

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:21:23 GMT

What this customer does is get a file of potential customers , which it adds to the system as prospect customers, abd when they place an order then they become full customers.

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:21:28 GMT

> I did notice that there is a field called REF_CUSTMR

> in the PI_COPYREFERENCE, which goes in, could I use

> this for the customer number?

No, you cannot. That is the number of the customer from which you are creating the new one.

Srinivas

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:23:21 GMT

True, but even your prospect customers should have some kind of account group assigned. Check with the functional/configuration experts to find out what that group is and if that account group allows external numbering.

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:24:51 GMT

don't understand the last comment. What I did notice was in XD03 I cannot see prospect customers ubtil they are turned into real customers, is this where it gets the propect customer number from in this field?

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 21:41:24 GMT

But did you create one prospect customer manually in the system using XD01? That is where you will have to give the account group. Another way to find out is, if you have any prospect customers in KNA1 table, see what is the value of KTOKD is.

Or is it entirely a different transaction that you use to create these prospect customers? Are you in R/3 or CRM?

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 23:02:43 GMT

Hi,

I'm on R3 not CRM. I think I need to do a bit more digging, and come back with more of a specific question

Re: Adding new Customer data KNA1

Former Member — Tue, 08 Nov 2005 23:35:58 GMT

Hi,

I've just had a look at the code, and this is what is happening.

When a prospective customer is added to the system, the details are present in KNA1 and KNVV. This is how it is imported in the system. When the preospect customer is converted to an actual customer, a new customer with the same details is created and assigend a new customer id by the sap system. I just want to be able the initial customer record , with a specified customer number.

Help!

Re: Adding new Customer data KNA1

Former Member — Wed, 09 Nov 2005 17:54:21 GMT

Hi Sims,

I see that you marked the post as answered, but there was an open ended question in your latest post. Did you find an answer or you still need help?

Standard SAP's account group for prospect customer is 0005. This is what you should see in your KNA1 record for all the prospective customers. If not, then you must be a using a custom account group. In config, this account group must have been configured to allow external numbering. Here is the path in config for verifying that(tcode SPRO).


Implementation Guide for R/3 Customizing (IMG)
-->Financial Accounting
   -->Accounts Receivable and Accounts Payable
      -->Customer Accounts
         -->Master Records
            -->Preparations for Creating Customer Master Records
               -->Create Number Ranges for Customer Accounts
               -->Assign Number Ranges to Customer Account Groups

Next thing is to load them into your system automatically. How are prospective customers registered? Do you get a file or do prospective customers register online? If they are registered online, then you need some kind of connectivity with SAP(so what is it) and a suitable RFC or BAPI. Right now, I don't see any standard BAPI or RFC that will enable you to create customers with external numbering. So you may have to use IDOC functions or a custom RFC function for the purpose.

If you are getting this information on a file, then you can use LSMW to load the customers. Please let me know your scenario so that we can come up with a solution.

Srinivas