Overview

Drop downs allow you to present a list of valid values for a field to a user. They are assigned to the Input page component via the Suggestions property. You can access the properties of each drop down by navigating in ClearWork to Tools > Drop Downs.

Properties

FieldDescription
Drop DownThe name of the drop down.
DescriptionA simple description for your drop down.
Values TableIf the drop down is linked to a backend system, this is the database table from which the drop down values will be retrieved.
Value Field If the drop down is linked to a backend system, this is the field in the Values Table where the drop down key is stored.
Description Field If the drop down is linked to a backend system, this is the field in the Values Table where the drop down label is stored.
Parent Field If the drop down is linked to a backend system and the drop down is dependent on a parent value, this is the parent field in the Values Table.
Grandparent Field If the drop down is linked to a backend system and the drop down is dependent on a grandparent value, this is the grandparent field in the Values Table.
Language Field If the drop down is linked to a backend system and the drop is language-specific, this is the field in the Values Tables where the language is stored.
System If the drop down is linked to a backend system, this is the system from which these values will be read.
Sync Type If the drop down is linked to a backend system, this is the step in the SynchronizeDropDowns API in ClearProcess that will be used to read and save the values.

Creating Drop Downs

To create a new drop down, navigate in ClearWork to Tools > Drop Downs and click the Create button:

Enter the properties and click Save. If you are creating a custom drop down that is not linked to a backend system, you can simply type the values into the page and check the Prevent Sync checkbox:

Synchronizing Drop Downs

If the drop down is linked to a backend system and you need to refresh the values, simply click the Synchronize button. This will call the SynchronizeDropDowns API in ClearProcess:

SAP Drop Downs

Drop downs are the customizing values that you see in SAP when you press F4. ClearWork will already have a majority of your drop downs available when your instance is created. However, in some cases the drop down may not yet exist in ClearWork or you may have your own SAP drop down.

Finding Drop Downs in SAP

From SE37 (Function Viewer)

If you know the name of an API that contains your desired drop down, you can use these steps to navigate to the data element.

Step 1

In the transaction launcher, type SE37 and hit Enter.

SE37 Step 1

Step 2

Enter the API name in the Function Module field and then click the Display button.

SE37 Step 2

Step 3

Click on the Import button to view the parameters passed to the API.

SE37 Step 3

Step 4

Double-click on the associated type of your desired API parameter.

SE37 Step 4

Step 5

In the third column, double-click on the data element. Then follow these steps.

SE37 Step 5

From SE11 (ABAP Dictionary)

Step 1

In the transaction launcher, type SE11 and hit Enter.

SE11 Step 1

Step 2

Enter the table name in the Database Table field and click Display.

SE11 Step 2

Step 3

In the fourth column, double-click on the data element. Then follow these steps.

SE11 Step 3

Drilling into a Domain

Step 1

From the data element display, double-click on the domain.

Drilling into a Domain Step 1

Step 2

Click on the Value Range tab.

Drilling into a Domain Step 2

Step 3

Scroll to the bottom and copy the Value Table.

Drilling into a Domain Step 3

Step 4

In the transaction launcher, type /nse16n and hit Enter.

Drilling into a Domain Step 4

Step 5

Paste the Value Table in the Table field and hit Enter. If a Text Table value appears beneath it, copy the Text Table value.

Drilling into a Domain Step 5

Step 6

Paste the Text Table in the Table field and hit Enter. Press F8 to see the full list of drop down values.

Drilling into a Domain Step 6

Synchronization Procedures

These procedures represent the process by which drop down values will be read and cached from your SAP system. The purpose of caching drop downs is to reduce the burden on your SAP system and to ensure drop down values display immediately in their respective web pages. The following is a comprehensive list of the procedures. If you find that none of these meet your needs, please contact us and our development team will work with you on a new procedure.

Description:

This is by far the most common type of drop down in SAP. It will contain a text table whose primary keys are language and the drop down value.

Example:

The domain LAND1 (Country) has a text values table of T005T with primary keys SPRAS (Language) and LAND1 (Country).

Description:

This type of drop down contains a text table whose primary keys are language, a parent value, and the drop down value.

Example:

The domain REGIO (State) has a text values table T005U with primary keys SPRAS (Language), LAND1 (Country), and REGIO (State).

Description:

This type of drop down is not language-specific and simply contains a key values and labels.

Example:

The domain BUKRS (Company Code) has a text values table T001 with BUKRS as the primary key.

Description:

This type of drop down is also not language-specific and contains a text table whose primary keys are a parent value and the drop down value.

Example:

The domain LGORT (Storage Location) has a text values table T001L with parent of WERKS (Plant).

Description:

This type of drop down is hard-coded by SAP to a specific list of values that customers cannot change.

Example:

The domain FKTYP (Billing Category) is a fixed list of values.

Description:

This type of drop down contains a text table whose primary keys are language, a grandparent value, a parent value, and the drop down value.

Example:

The domain COUNC (County Code) has a text values table T005F with primary keys SPRAS (Language), LAND1 (Country), REGIO (State) and COUNC (County Code).

Description:

This type of drop down is specific to Contract Accounting (FI-CA) and contains the default values for a different types of sub-ledger transactions.

Example:

pa1030 contains default values for Payment Lot postings in FI-CA.

Description:

This type of drop down drives whether a record number is editable or read-only.

Example:

nrKTOKD reads customer account groups from values table T077D and determines whether a specific account group is internally numbered, externally numbered, or both.

Description:

This type of drop down has values that are time dependent.

Example:

The domain ICL_CLTYPE (Internal Claim Type) reads time dependent values from table TICL011T.

Description:

This type of drop down has no description field and its values table has only one field.

Example:

The domain GESTYP (Business Type) has only one field in the values table BUSTYPE.

Description:

These drop downs do not fit any of the procedures described above and only apply to one drop down each. If your drop down does not fit in the above procedures, please contact us and our development team will work with you on a new procedure.

Example:

These drop downs include: salesTaxCode, childBlankParent, standardCompanyCode, houseBank, grandchildNoLanguage, defaultValue, clearingAccount, selectionCategory, partnerFunction, mdTemplate, archiveObject, taxCategory.