Edit

Apply seed data

  • Article

Data seeding is the process of populating a database with an initial set of data. The SAP Procurement apps and flows require that key seed data be added to and managed by the SAP Administrator model-driven app. Adding seed data ensures an efficient and localized integration with SAP.

Manage menu options

You can manage the menu options for one or more of the following apps that are part of the SAP Procurement template:

  • SAP Vendor Management
  • SAP Purchase Requisitions
  • SAP Purchase Order Management

Managing the menu options enables you to determine which users will be able to view and access specific navigation items in the canvas apps deployed.

You need to have Data.

You can store and manage menu items in Dataverse and associate them with configured Dataverse Group Teams to control access and visibility to apps and components.

Manage menu options in Dataverse.

Set up application menus

Follow these steps to set up application menus:

  1. Open the SAP Administrator app that was part of the SAP Administrator Base solution.
  2. Select Menu Items.
  3. Select +New.
  4. Populate the fields.

To help you set up application menus, a list of the fields with examples and descriptions are provided in this table.

Field Examples Description
Menu Item Name "Vendors", "Requisitions", "Purchase Orders" The short descriptive name of the menu item.
Used By Team "Vendor Management Team", "Requisition Management Team", "Purchase Orders Team" The Dataverse group that you previously set up. Select the appropriate group.
Menu Group "Purchasing" A logical grouping of menu items. Typically, this is a process domain area.
Order 1, 2, 3, 4 The order in which the menu items should be displayed.
Capability "Vendors", "Requisitions", "Purchase Orders" The capability or app that corresponds to each menu item.
Launch URL "https://apps.powerapps.com/play/e/2359c141-01e4-ec77-8e6f-7efd2f5c7308/a/7d0062b0-922b-454e-8154-295ef726d54d?tenantId=fe2dcd3b-6648-914a-8c8e-8761944769ce" The URL of the corresponding app to launch when the menu item is selected. You obtain it by copying the Web link value from the respective app details page. Note, this URL is unique for a given app per environment.
Menu Icon Purchase Orders Menu Icon The icon to be displayed with the menu item in the app. You can select your own or the one that is contained in the SAP Procurement solution located underneath web resources.

Apply SAP's list of values

SAP requires a constrained list of values on transactions. These values need to be seeded and administered in the apps so they can be bound to the combobox or dropdown controls. This enables your users to make selections from the list of available values.

The constrained list of values varies according to what business process is being implemented. Work with your SAP admin and functional analyst to:

  • Identify the necessary values from SAP.
  • Extract the values from SAP and import through the SAP Administrator app.

Tip

The Export to Excel Online capability available in the administrator app is the most efficient way to load and maintain these values in bulk.

Manage list values in the SAP Administrator app.

Create and manage list of values

  1. Open the SAP Administrator app that was installed as part of the SAP Base solution.

  2. Select List of Values.

  3. Select Export to Excel | Open in Excel Online.

    Export list values to Excel.

    To help you create and manage the list of values, a list of the fields with examples and descriptions are provided in this table.

    Field Examples Description
    Display Value "United States", "German", "Mexico" The localized version of the display value the user will see in combo box app controls.
    Language "en", "de", "es" The language code of the display value. The app combo box controls filter the appropriate values based on the user's browser language from the app. More languages can be created by extending the Dataverse choice values.
    Value Code "US", "DE", "MX" The language independent code that SAP expects within the API.
    Domain "Country", "State", "Payment Terms" Constrained value representing the domain that the list of values is mapped to. The app combo box controls filter the appropriate values based on mapped domain. More domains can be added by extending the Dataverse choice values.
    Parent Value Allows for parent-child relationships of values. For example, specific state/province domain values can be parented to a single country domain value.
    Description General description of what the value represents.

  4. Select Save and monitor the import progress.

More information: Open your app data in Excel Online

Note

If your requirements call for more domains, extend the SAP List of Value Dataverse entity by adding possible values to the domain choices list.

Tip

When a value is no longer in use, a best practice is to deactivate a list-of-value record rather than delete it. The app combo box controls will only show Active status values for selections going forward.

String localization administration

All strings in the canvas apps are defaulted to English. However, the canvas apps are localization ready. This means all Text, Accessible Label, Tool Tip, HintText, InputPlaceHolderText, and Notifications have Power Fx functions built in to check whether a localized string is present for the user's logged-in browser language code. These strings are administered and maintained via the SAP Solution Administrator app. The most efficient way to load and maintain these values is by using the Export to Excel Online capability available in the administrator app in bulk rather than manually entering each one.

More information: Localization and global app support

Manage SAP string localizations.

Create localization strings

  1. Open the SAP Administrator app that was installed as part of the SAP Base solution.

  2. Select Localizations.

  3. Select Export to Excel | Open in Excel Online.

    Export SAP string localizations to Excel.

  4. Create or update rows with the following attributes:

    Field Examples Description
    English Value Cancel The English version of the string that serves as the string key that the application will always look up to see if there's a corresponding localized value to display.
    Language de The language ISO code of the display value. The apps will automatically look up to see if there are localized strings to display based upon the user's browser language code.
    Localized Value Abbrechen The localized string value to display for the given English value.
    String Type Label Not required, but helps categorize what control/property the string is, noting that one localization entry can support multiple property types so just choose the primary property type in that situation.

Note

List of Values localizations are not impacted by these strings because combo box items behave differently than standard strings. Refer to the List of values section to administer localized dropdown values.

Import default English strings

To help you quickly identify localization strings you need to prepare for your required language, you can access a CSV file available on GitHub that contains all the app default English strings. You can import the CSV file into your environment using the Import data capability that is part of the SAP Administrator app.

To further accelerate the string localization creation process, create a cloud flow to trigger off of Dataverse English imported localization records selected in the SAP Administrator app. This flow can use AI Builder action steps to automatically translate the English records to your target language and directly load them into the SAP Localizations table.

More information: Use text translation pre-built model in Power Automate

Next step

Customize the SAP Procurement solutions

See also