Skip to main content

Posts

Showing posts from April, 2023

Changing Column Description in Table Maintenance Generator

SAP Table Maintenance Generator (TMG) is a tool used to generate a user interface for maintaining table data in SAP. The tool generates a screen that can be used to add, modify or delete data in a database table. Changing Column Description Step 1: Go to transaction code SE54 and input the table name. Click on Create/Change button after selecting Generated Objects. Step 2: Go to Environment > Modification > Maintenance Screen Step 3: Select the screen you want to change and press enter. Step 4: Click on the Layout button. Step 5: Double click on the column description you want to change. Step 5: Change the text field in the pop up window. Step 6: Now activate the changed screen Step 7: Now go to SM30 to check the change.

Assigning Check Table to Specific Field in the Custom Table

In SAP, a check table is a table that is used to define the domain of a data element. A data element is a technical object that is used to describe a field in a SAP database table. The check table is used to ensure that data entered in a field conforms to certain predefined values or ranges. Assigning Check Table in a Custom Table Field Step 1: Go to the custom table in change mode from the transaction code SE11. Select the required field for which we are going to assign a check table. Then click on the foreign key button. Step 2: A pop window will open. Provide the check table name and press enter. SAP will automatically create a proposal considering the data elements. You can change the proposal or you can keep the proposed one. Then click on copy button. After that activate the table. Step 3: Now chck the table in SM30. If you input any data which is not available in the check table (in this case MARA table), system will through an error.

Creating a Search Help and Assigning it to Another Table in SE11

In SAP ABAP, a search help is a feature that provides a user interface for searching and selecting data values from a list. A search help is essentially a dialog box that displays a list of possible values for a particular field or selection criterion. Once a search help is defined and assigned to a data element or domain, it can be used in various SAP applications, such as data entry screens, reports, and dialog programs. To use a search help in a program or report, you can call the function module "F4_HELP" or "F4IF_INT_TABLE_VALUE_REQUEST" to display the search help dialog box and retrieve the selected values. You can also customize the search help behavior and appearance using various parameters and options. There are two types of search help available in SAP ABAP: elementary search help and collective search help. Elementary search help is used to display a list of possible values for a single input field. It is used when the user needs to select a single valu