Enabling Custom Database Fields for Usage in SAP Fiori Applications

Prerequisites

The adaption transport organizer (ATO) is set up in the system in which you want to enable database fields for usage in SAP Fiori apps.

Note

If the ATO is not set up, you can either do the setup opening the transaction ATO Setup (S_ATO_SETUP) directly, or following the instructions given in the steps 1 and 2 of this procedure.

Context

Custom fields can be created not only using the SAP Fiori app Custom Fields and Logic but also using back-end transactions to create database fields. You might face the following situation: Custom fields (database fields) are available in the back end already, but need to be used in an SAP Fiori application. To use database fields also to enhance SAP Fiori applications, you need to enable the database fields for usage with SAP Fiori. Once enabled for the SAP Fiori app Custom Fields and Logic, the fields are available in the app together with any newly created custom fields, and can be added to SAP Fiori UIs and reports, form templates and email templates as well as business scenarios in the same way like custom fields.

To enable database fields for usage in SAP Fiori apps, proceed as follows:

Procedure

Open the transaction Enable Fields for Use in App 'Custom Fields and Logic' (SCFD_EUI).
(Optional) To set up the ATO, click ATO Setup.

You are led to the transaction ATO Setup (S_ATO_SETUP). For more information, see Configuration Information: Adaptation Transport Organizer.
In the transaction SCFD_EUI, search for the database field that you want to enable for usage.
By default, the field name selection is restricted to the standard customer namespace patterns ZZ* and YY*. If your company uses, for example, a dedicated ABAP namespace, you can change the field name selection accordingly.

Start the search by pressing F8.

A list of database fields is displayed. These fields were added to database tables using append structures or customer includes. The field status indicates whether a field can be enabled directly, whether it needs to be prepared beforehand, or whether it has already been enabled. The following statuses are available:

Table 1: Statuses of Database Fields
Status	Description	How to Proceed?
Can Be Enabled	You can enable this field directly for usage in SAP Fiori apps.	Click Enable. For more information, see Input Options when Enabling Database Fields for Usage in SAP Fiori Apps.
Preparation Required	The field does not yet fulfill at least one of two requirements for enabling. Either it needs to be moved from its current location to an extension include structure first, or it needs to be typed using a data element with domain, or both.	Click Prepare and follow the step-by-step instructions provided in the dialog that opens. Note If the database table is associated to more than one business context, you need to select the business context beforehand, which fits to the selected database field. Please note that this decision cannot be revoked as soon as the field has been enabled.
Enabled	The field has been enabled already.	To change the package assignment of the field, click Relocate. To prevent the field from being used in SAP Fiori apps, click Disable. Note The field will then also be removed from the UIs, reports, form templates, etc.to which it was added with the help of the app Custom Fields and Logic. The database field itself remains untouched.
Cannot Be Enabled	The field either does not reside in a database table which was prepared by SAP for use in the app Custom Field and Logic, or its ABAP dictionary data type is not supported by the app.	-
Enabling... or Disabling...	The field is currently being enabled or disabled respectively. This process may take a few moments.	-
Enabling Failed or Disabling Failed	The field could not be enabled or disabled.	Retry the operation by clicking Enable or Disable again. If the issue remains, report an incident to the component BC-SRV-APS-EXT-FLD.
Undefined	The field status could not be determined by the system.	Report an incident to the component BC-SRV-APS-EXT-FLD.

After enabling, and before the SAP Fiori app Custom Fields and Logic is used to add the field to UIs, reports or email templates, please check whether your database field was added manually to any Core Data Services (CDS) data definitions delivered by SAP.
(Recommended) Remove the field using ABAP Development Tools for SAP NetWeaver (ADT) if the following applies:
- The database field was added manually to any Core Data Services (CDS) data definitions delivered by SAP.
- The data definitions appear in the SAP Fiori app Custom Fields and Logic as data source for your field.