ERP User GuideSAP Business One

SAP Business One

Sana Commerce 9.3
Your connector

User-Defined Fields

Sana is the ERP integrated e-commerce solution. This integration is unique in the sense that all information used in your web store comes directly and in real-time from a single place - your ERP system. As all master data is managed and stored in a single ERP database you can prevent data inconsistency and ensure that all your departments work with the same data.

There is the "GetEntityFields" Sana API method which retrieves all fields for a certain entity. This method takes as a parameter the name of the table in SAP Business One and returns the list of fields of this table. For example, if you request entity fields for the "Product" table (Item Master Data), all item fields and their values, like "Item No.", "Description", "Item Group", "UoM Group", "Price List", etc. will be returned from SAP Business One to Sana.

The purpose of the "GetEntityFields" method is to have the list of fields for a certain table in SAP Business One and to retrieve data from this table.

Sana Commerce Framework requests entity fields only for the product, customer, contact (prospect) and shipping address entities by passing the "Product", "Customer", "Contact" and "ShippingAddress" values as the parameters of the "GetEntityFields" method.

Product (Item Master Data)

The entity fields of the products are used to retrieve item master data from SAP Business One, to show it in a Sana web store, configure catalog search, filtering and sorting, and to create product sets.

Related topics:

ERP Integration
Search
Product Sets

Customer, contact and shipping address (Business Partner Master Data)

The entity fields of the customers, contacts (prospects) and shipping addresses are used to retrieve customer and contact data, and shipping addresses from SAP Business One, to allow customers to create sales orders in a Sana web store.

These fields are also used to set up the registration form for customers, profile forms for different types of customers (consumers, business customers, guests, and prospects), and shipping address fields for consumers and business customers.

Related topics:

Customer
Shipping

User-Defined Fields

A part of the Sana Commerce solution is built on top of and installed inside SAP Business One. Therefore, we added our own user-defined fields to some standard SAP Business One tables. For example, you can see user-defined fields of the Sana Commerce add-on in the item and business partner master data.

The user-defined fields of the item master data can be also used to create catalog for a Sana web store, configure catalog search, filtering and sorting, and to create product sets.

The user-defined fields of the business partner master data can be used to set up the registration form for customers, profile forms for different types of customers (consumers, business customers, guests, and prospects), and shipping address fields for consumers and business customers.

Moreover, if you added your own user-defined fields to item and business partner master data in SAP Business One, they can be also used by Sana. The custom user-defined fields of the item and business partner master data are automatically retrieved by Sana and can be used in your web store.

If you add the custom user-defined fields to the item and business partner master data, and you want to use these fields in Sana, you must refresh the user-defined tables and fields, stored procedures, and restart the DI Server. For more information how to refresh UDT/UDF/SD, see "Web Store Parameters".

Translations

In SAP Business One the values of different item fields can be translated to other languages. You can also translate the values of the user-defined fields. Sana supports translations only of the Item Master Data fields in SAP Business One on-premise but not cloud solution.
ERP User GuideSAP Business One