Error, no customer master record exist when create sales order

[Former Member]

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

[Former Member]

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

[RichHeilman]

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

[Former Member]

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.

[RichHeilman]

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

[Former Member]

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