Change field contents (from SM30) from uppercase to as it is.

One day, my user need to maintain 1 table from SM30, when they entered a description of tax service code, it changed automatically to upper case caps. Actually they need that description as it is.

What I have to change ?

1. SE11, open the table
2. Change the field type using a Data Element
3. Create a Domain from those data element.
4. This is the important thing : Tick the Lowercase option.

The Lowercase option means let the word as it is, not changed to uppercase caps.

Select a table between two clients using RFC Function

1. Create RFC Destination

• Technical Settings
  Connection Type : 3 Abap Connection
  Target Host : cpidev03
  IP Address : xxxxxxxxx
• Logon & Security
  Input target Client, user dan password, or u can choose using Current User
• Test Connection using Connection Test

2. SE37 - Function TABLE_ENTRIES_GET_VIA_RFC RFC
Target sys : input the RFC Destination

You can use WHERE clause in this field :

The result :

The Structure stored in NAMETAB

The Records stored in TABENTRY
1 record will be store in 1 string, so u need to offset them by their structure.