Overview

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 SE37 (Function Viewer)

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.