SAP Business One

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:

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:

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.

Sana does not support the custom user-defined fields of the "General" type, both the "Link" and "Image" structures.

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 repair the user-defined tables and fields, stored procedures, and restart the DI Server. For more information how to repair UDT/UDF/SD, see "Web Store Parameters".

 NOTE

In SAP Business One the values of different item fields can be translated to other languages. For example, you can add item descriptions in different languages. If your web store is multi-lingual, item descriptions in different languages can be shown from SAP Business One in your web store. Currently, Sana does not support translations of the user-defined fields. Only the default values of the user-defined fields can be shown in the web store. You can use "In-site editor" to change the values of the user-defined fields directly in the web store or translate the values of the user-defined fields to other languages.