Skip to content
Developerhome
Product homepage
X3

Reference replacement

  Less than to read

For a node binding definition, by default a reference to another node (foreign key) is determined by the Linked table field defined in the Sage X3 table.

For most cases, the default table setup is expected one on the API to determine reference properties. Sometimes, however, the reference to the node needs to be adjusted. You can do it like this:

  • Fill in the Overwrite property (API) field in the Data models function (GESAWM) to replace the default table definition by the standalone reference defined as a data model link.

Example 1

On the customerAddress node, the entityNumber property (BPANUM) is a generic property (string) in the BPADRESS table definition. The property is not specifically linked to the customer node as the BPADRESS table can be used in multiple contexts.

You can do the following setup in the Data models function to add the expected reference to the customer node in the customerAddress node:

  • The entityNumber (BPANUM) default string property is replaced by the reference to the customer node in the customerAddress node.

Example 2

On the shipToCustomerAddress node, the businessPartner property (BPCNUM) is a reference property in the BPDLVCUST table definition. This property is linked to the businessPartner node.

You can do the following setup to add the expected reference to the customer node in the shipToCustomerAddress node:

  • The businessPartner (BPCNUM) default reference is replaced by a reference to the customer node in the shipToCustomerAddress node. </ul> On the same node, the address property (BPAADD) is a reference property in the BPDLVCUST table definition. This property is linked to the default address node. You can do the following setup to add the expected reference to the CustomerAddress node in the shiptoCustomerAddress node:
    • The address (BPAADD) default reference is replaced by the CustomerAddress reference in the shipToCustomerAddress.