topic Re: Error, no customer master record exist when create sales order in Application Development and Automation Discussions

Error, no customer master record exist when create sales order

Former Member — Fri, 01 Jul 2005 18:17:22 GMT

Hello there,

I am using BAPI BAPI_SALESORDER_CREATEFROMDAT2 to create a sale order from a IDES R/3 server.

The following are data that I enter:

Partner information
German code AG for partner role Sold-to-party SP

orderPartners-PARTN_ROLE = 'AG'.

orderPartners-PARTN_NUMB = '3930'.

APPEND orderPartners.

ORDER HEADER
German code TA for standard order OR

orderHeaderIn-DOC_TYPE = 'TA'.

orderHeaderIn-SALES_ORG = '3000'.

orderHeaderIn-DISTR_CHAN = '10'.

orderHeaderIn-DIVISION = '00'.

orderHeaderIn-PURCH_NO_C = '4500014633'.

APPEND orderHeaderIn.

orderHeaderInX-UPDATEFLAG = 'I'.

orderHeaderInX-DOC_TYPE = 'X'.

orderHeaderInX-SALES_ORG = 'X'.

orderHeaderInX-DISTR_CHAN = 'X'.

orderHeaderInX-DIVISION = 'X'.

orderHeaderInX-PURCH_NO_C = 'X'.

APPEND orderHeaderInX.

Order Items

orderItemsIn-ITM_NUMBER = '10'.

orderItemsIn-MATERIAL = 'V114203967'.

orderItemsIn-COMP_QUANT = '1'.

APPEND orderItemsIn.

orderItemsInX-UPDATEFLAG = 'I'.

orderItemsInX-ITM_NUMBER = '10'.

orderItemsInX-MATERIAL = 'X'.

orderItemsInX-COMP_QUANT = 'X'.

orderItemsInX-GROSS_WGHT = 'X'.

orderItemsInX-NET_WEIGHT = 'X'.

orderItemsInX-UNTOF_WGHT = 'X'.

APPEND orderItemsInX.

call function 'BAPI_SALESORDER_CREATEFROMDAT2'

exporting

ORDER_HEADER_IN = orderHeaderIn

ORDER_HEADER_INX = orderHeaderInX

testrun = 'X'

importing

SALESDOCUMENT = salesDoc

tables

RETURN = myReturn

ORDER_ITEMS_IN = orderItemsIn

ORDER_ITEMS_INX = orderItemsInX

ORDER_PARTNERS = orderPartners

However, when I execute this program, it generates error:

No customer master record exist for customer 3930, eventhough I am sure it's there.

Thank you for your help.

tbluong.

Message was edited by: Thaiba Luong

Re: Error, no customer master record exist when create sales order

RichHeilman — Fri, 01 Jul 2005 18:31:14 GMT

I'm sure that the system does not store the customer number like 3930. In the table, it is stored as 0000003930. You must put zeros in front of your number.

You can do this with a function module. It's something like CONVERSION_ALPHA_INPUT.

Do a search in SE37 for CON*ALPHAINPUT.

Of cousre since you are hard coding in your program, you could just....



orderPartners-PARTN_NUMB = '0000003930'.

Regards,

Rich Heilman

Re: Error, no customer master record exist when create sales order

Former Member — Tue, 05 Jul 2005 20:22:36 GMT

Hello Rich,

Thank you so much for suggest. It works.

However, now, it says "Missing data: Pricing". Do you have any idea where to fill it up?

Thank a lot for your help.

tbluong.

Re: Error, no customer master record exist when create sales order

RichHeilman — Tue, 05 Jul 2005 20:32:57 GMT

I believe that you would fill up the ORDER_CONDITIONS_IN table.

Please mark this post as a question, and if the previous answers were helpful, pleae reward points accordingly. Thanks.

Regards,

Rich Heilman

Re: Error, no customer master record exist when create sales order

Former Member — Tue, 05 Jul 2005 20:56:52 GMT

Hi,

Pricing data may not necessarily be passed in the BAPI. Most of the times it is the customozation settings. so, pls check with your SD consultant.

Deepak Charanyan