Extra Fields Mapping

NOTE

This is a technical article and it is targeted at the SAP developers.

Sana Commerce Cloud is the ERP integrated e-commerce solution. This integration is unique in the sense that all information used in your webstore 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 Commerce Cloud API method which retrieves all fields for a certain entity. This method takes as a parameter the name of the table in SAP S/4HANA and returns the list of fields of this table. For example, if you request the entity fields for the Product table, all material fields, like Name, Material Type, Item Category Code, Base Unit of Measure, etc. will be returned from SAP S/4HANA to Sana Commerce Cloud.

The purpose of the GetEntityFields API method is to have the list of fields for a certain table in SAP S/4HANA and to retrieve data from this table.

Out of the box, the Sana Commerce Cloud framework requests the entity fields only for the product, customer, contact and shipping address entities by passing the Product, Customer, Contact and ShippingAddress values as the parameters of the GetEntityFields method.

All entities are mapped in SAP S/4HANA to the appropriate SAP table / BAPI structure.

Product

The entity fields of the products are used to retrieve material data from SAP S/4HANA, to show it in the Sana webstore, configure catalog search, filtering and sorting, and to create product sets.

Related Articles

Filter Fields
Keyword Fields
Webstore Search
Product Sets

Customer, Contact and Shipping Address

The entity fields of the customers, contacts and shipping addresses are used to retrieve customer and contact data, and shipping addresses from SAP S/4HANA, to allow customers to place sales orders in the Sana webstore.

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 Articles

B2C Customer Registration
Customer and Prospect Profiles
Customer Shipping Addresses

Set Up Extra Fields

All tables in SAP S/4HANA have a lot of fields and store a lot of data. Thus, with the GetEntityFields method we return the predefined list of fields from SAP S/4HANA to Sana Commerce Cloud.

You can check all fields which are returned from SAP S/4HANA to Sana Commerce Cloud for each entity separately, by requesting the GetEntityFields method for a certain entity. This can be done either in SAP S/4HANA, using Manual Process Requests, or in Sana Admin, using Debug ERP request.

It is possible to add extra fields which will be returned from SAP S/4HANA to Sana Commerce Cloud for each entity, to retrieve the necessary data from your SAP system.

Step 1: Open the Field Mapping Sana app in the SAP Fiori Launchpad and select your webstore. If you have several webstores, you can set up different extra fields for different webstores.

Step 2: On the Extra Fields Mapping tab, you can add any required field to a certain entity. Click Add Extra Field Mapping.

Step 3: Select the Master Data Type. These are different entity types used in Sana Commerce Cloud. You can set up extra field mapping for the following master data types in SAP S/4HANA: product, customer, contact, sales person, address, BOM, order, quote, promotable quote, invoice, return order, return receipt, shipment and credit note.

Step 4: Select the field of the master data type (table in SAP S/4HANA) you want to retrieve data from.

Step 5: When the necessary fields are added, run the General information import task in Sana Admin.

Now, the fields which you have added to the Field Mapping Sana app in SAP Fiori Launchpad will be returned in the GetEntityFields API method for the appropriate entity. You can use these fields in Sana Admin to setup catalog, customer registration and profile forms, shipping address, checkout and sales document header fields.

Material Classification

To manage catalog, the fields of the materials table and material classifications are returned from SAP S/4HANA to Sana Commerce Cloud in the GetEntityFields API method. Using material classifications in SAP S/4HANA, you can add material characteristics which will be shown on the product pages in the Sana webstore.

Manage the Fields of the Material Classifications

Step 1: Call the transaction CL04.

Step 2: Enter the class type and name which you are using to set up material characteristics for the webstore catalog. Click Change.

Step 3: On the Characteristics tab, you can manage the fields which are used to set up material characteristics. These fields are also returned from SAP S/4HANA to Sana Commerce Cloud in the GetEntityFields API method for the product entity.