Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Deficiencies • Settings
bw2:adding_and_updating_business_partner_contacts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

bw2:adding_and_updating_business_partner_contacts [2020/12/15 12:25]
akoehler created 		bw2:adding_and_updating_business_partner_contacts [2021/02/05 11:21] (current)
akoehler
Line 1: Line 1:
 ====  Adding and Updating Business Partner Contacts ==== ====  Adding and Updating Business Partner Contacts ====
  
-Following is an example for adding a new Business Partner contact. In this example, the information for the new address is held in a SQL table named “SBO_Contact_Info,” which is in a database named “VersagoData.”+Following is an example for adding a new Business Partner contact. In this example, the new address's information is held in a SQL table named “SBO_Contact_Info,” which is in a database named “VersagoData.”
  
 <code sql>select <code sql>select
Line 14: Line 14:
 </code> </code>
  
-The first part of the query returns the existing contact rows for Business Partner code C99001. The second part of the query, after the UNION ALL statement, returns the row of the contract to be added.+The first part of the query returns the existing contact rows for Business Partner code C99001. After the UNION ALL statement, the second part of the query returns the row of the contract to be added.
  
-This is another example where the rows also use “Change on value …” for the “Create new record on” option. The value created by “RecordBreak” ensures that records are processed for each combination of address name + address type.+This is another example where the rows also use “Change on value …” for the “Create a new record on” option. The value created by “RecordBreak” ensures that records are processed for each combination of address name + address type.
  
 The image below shows the mapping for this process. The image below shows the mapping for this process.
  
-{{:bw:sapimage12.png?423x123}}+{{ :bw:sapimageaddingbp1.png |}}
  
-{{:bw:sapimage13.png?419x212}}+{{ :bw:sapimageaddingbp2.png |}}
  
-In this case it is not necessary to map CardCode for the rows, since it is mapped at the header (Business Partners) level.+In this case, it is not necessary to map CardCode for the rows since it is mapped at the header (Business Partners) level.
bw2/adding_and_updating_business_partner_contacts.1608053130.txt.gz · Last modified: 2020/12/15 12:25 by akoehler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki