SAP Customizing Tables (SM30); Allow Wildcard (*) Field-Input but still with foreign checks

[master1980]

Hello,

when we have a Customizing-Table, we want the user to enter only allowed values. To achieve this, we define Foreign-Key-Checks in SE11. Excample:

WERKS
LGORT
MY_Z_FIELD

We define a Foreign-Key to Table T001L(Storage-Locations). Very often the Customers want to allow Wildcard-Input (*) like this:

WERKS LGORT MY_Z_FIELD

1000     1000    A

1000     *          B

*            *         C

In ABAP we implement a FALLBACK-LOGIC:

• Read an entry with KEY 1000/1000
• if not found READ an Entry 1000/*
• if not found READ an Entry */*

To do so, we must not definie Foreign-Key's because the Plant * neither the Storage-Location * exist. This has several drawbacks....To create a Plant/Stor-Loc * in the Foreign Tables is not a good solution(....) Lets imagine we have 100 Plants with 100 Storage-Locations each. In this case we would have to create 101 new entries in T001L, all with a description *****DO NOT USE*****

Has someone delt with this Problem before and can offer a simple solution?

[Sandra_Rossi]

There's no screen check of the entered value if you unselect "Check required":

The value help will still be available.

[DominikTylczyn]

Those are data dictionary details, that are copied to screen painter, where they can modified further.