bw2:adding_and_updating_business_partner_addresses

Differences

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

Link to this comparison view

bw2:adding_and_updating_business_partner_addresses [2020/12/15 12:25]
akoehler created
bw2:adding_and_updating_business_partner_addresses [2021/02/05 11:15] (current)
akoehler
Line 1: Line 1:
 ==== Adding and Updating Business Partner Addresses ==== ==== Adding and Updating Business Partner Addresses ====
  
-Following is an example for adding a new Business Partner address. In this example, the information for the new address is held in a SQL table named “SBO_Address_Info,” which is in a database named “VersagoData.”+Following is an example for adding a new Business Partner address. In this example, the new address's information is held in a SQL table named “SBO_Address_Info,” which is in a database named “VersagoData.”
  
 <code sql>select <code sql>select
Line 20: Line 20:
 </code> </code>
  
-The first part of the query returns the existing address rows for Business Partner code C99001. The second part of the query, after the UNION ALL statement, returns the row of the address to be added.+The first part of the query returns the existing address rows for Business Partner code C99001. After the UNION ALL statement, the second part of the query returns the row of the address to be added.
  
-This is an 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 an 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.
  
 The image below shows the mapping for this process. The image below shows the mapping for this process.
  
-{{:bw:sapimage11.png?424x284}} +{{ :bw:sapimageaddingbp.png |}}
bw2/adding_and_updating_business_partner_addresses.1608053107.txt.gz · Last modified: 2020/12/15 12:25 by akoehler