topic Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners in Application Development and Automation Discussions

BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Tue, 15 Mar 2016 23:17:37 GMT

Hello,

How I have not found any documentation that tells how to do what I am about to ask you. If there is any, please share with me.

In VA01 (Create Sales Order), there is a way to add more communication data to one or more of the partners, example, add email address to partner function Ship-to party. This is done manually in the Header -> Partners. We can even add more than one email addresses by double-clicking on the partner function.

How is this done with BAPI_SALESORDER_CREATEFROMDAT2? If not thru this bapi, what does the job?

Thank you,

Huntr

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

juan_suros — Tue, 15 Mar 2016 23:38:10 GMT

The TABLES parameter PARTNERADDRESSES in bapi Function Module BAPI_SALESORDER_CREATEFROMDAT2 is the place to do this.

For email addresses, use field PARTNERADDRESSES-E_MAIL. There are many other fields that can be set this way.

When you enter your Ship-To party in the TABLES parameter ORDER_PARTNERS, set field ADDR_LINK. Set field PARTNERADDRESSES-ADDR_NO to the same value.

This is documented in the Bapi viewing transactions SE80 for Function Group 2032 and in SE37 for the Bapi FM.

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Wed, 16 Mar 2016 00:47:28 GMT

Hi Juan,

Thank you for your response.

Would the ADDR_LINK for the Ship-to be the KNAI-ADRNR ?

Regards,

Huntr

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

juan_suros — Wed, 16 Mar 2016 01:55:18 GMT

For a customer based partner like a Ship-To, yes. There are four types of partner relationship keys. See table VBPA.

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Wed, 16 Mar 2016 01:59:16 GMT

Hi Juan,

The email address that needs to be added is sales order based only. We are not changing the customer master for the Ship-to.

Thanks,

Huntr

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Wed, 27 Jul 2016 21:18:42 GMT

Hi Juan,

Thank you for your response. The challenge I am having with is the address number link for the Buyer partner (EK). It does not have a KUNNR in VBPA, but it has a PARNR and the ADRNP does not work.

Would you know how to make this work correctly for partner EK?

Many thanks,

Huntr

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

Ryan-Crosby — Thu, 28 Jul 2016 00:17:56 GMT

Hi Huntr,

If this is a one-time address entry type of thing then I think you can do automatic numbering as long as you fill the same value in the EK partner of the partners table. What the system does is uses that key to link the two table entries and in that case it would only be linked to the order without any accompanying master data. If you are unsure let me know and I will check a slightly different scenario where I have used that table for one-time shipping address information.

Regards,

Ryan Crosby

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Thu, 28 Jul 2016 03:27:08 GMT

Hi Ryan,

Thanks for the response. The email address is to be added directly to the sales order only during the create using the bapi....if that is what you meant by "one-time" address entry.

ORDER_PARTNERS-ADDR_ORIG = 'B'

ORDER_PARTNERS-ADDR_LINK = ??? -> Are you saying that I can use any number here as long as I use the same in the other table parameter?

PARTNERADDRESSES-ADD_NO = same as ORDER_PARTNER-ADDR_LINK

PARTNERADDRESSES-E_MAIL = 'person001@email.com'

I have tried using number '0000000001' before and this did not work.

Regards,

Huntr

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

Ryan-Crosby — Thu, 28 Jul 2016 11:45:43 GMT

Hi Huntr,

I was able to conclude that the one-time address logic that I mentioned does work but the catch is that you have to provide enough address fields for it to be an actual physical address if it's based on a regular partner. I provided name, street, city, zip, region and country along with email and it attached that to a partner on my order. If you are looking for only an email address then you may want to look at the field 'ADDR_TYPE' of the BAPIPARNR structure and see if you can use '3' for contact person and supply only an email address. You'd probably have to do some experimentation there as it's not well described on how to use it.

Regards,

Ryan Crosby

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

Ryan-Crosby — Thu, 28 Jul 2016 12:48:15 GMT

Hi Huntr,

I was able to test a bit further and these are my findings:

You would use the ADDR_LINK & ADDR_NO fields as the link between the two tables (doesn't have to be an existing value from master data) and the ADDR_ORIG field is not required. What you do need is the email value as well as a value for LANGU in the partner addresses table. That actually makes sense because if you are going to communicate with someone electronically you would really need to know what language to use. As long as those two fields are included it should create a one-time buyer address linked to the document - that worked in my test scenario.

Regards,

Ryan Crosby

Re: BAPI_SALESORDER_CREATEFROMDAT2 and additional partners

reyleene_hunt1 — Thu, 28 Jul 2016 19:54:05 GMT

Hi Ryan,

I used both of your recommendations and the test worked perfectly. Once that was successful, it created the proper address link in VBPA and I was able to add multiple email addresses to the same sales order using the ADDR_*COMM* function modules and the VBPA address number.

Many many thanks for your help!

Regards,

Huntr