Skip to main content

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.


Labels:

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

Transporting Data Migration Cockpit Project between Clients

SAP Data Migration Cockpit (DMC) is a tool provided by SAP to assist in the process of migrating data from legacy systems or external sources into an SAP system. The DMC offers a user-friendly interface for designing, executing, and monitoring data migration activities. Steps to Transport Data Migration Cockpit Project There are two ways to transport data migration cockpit project between clients. They are Export/import method Transport request generation method Export/Import Method Process steps for export/import method are Exporting the Project Go to transaction code "LTMOM" Then go to "Go to>Export/Import Project". If this functionality is not available in this t-code, go to transaction code "SE38" and run the report "/LTB/MC_PROJ_Q2P" Select the "Export Project" radio button and provide "Mass Transfer ID". Then click on execute. Show the location on your PC and click on save. Project will be exported. Importing the Proj...
Post a Comment
Read more

Adding New Button in ALV Grid (Example: Refresh Button)

 Steps to add a refresh button in ALV grid display. 1. Copying status "STANDARD" from program "SAPLKKBL". Go to transaction code SE41 and follow the screenshot to copy the status. 2. Assign refresh button in the status. Go to SE41. Put the custom program and status name we have just copied. Click on the "Change" button. Add the refresh button with function code and icon. 3. Set PF STATUS in the program just before the "REUSE_ALV_GRID_DISPLAY" function module. 4. Enable  i_callback_user_command and  i_callback_pf_status_set  in the "REUSE_ALV_GRID_DISPLAY" function module 5. Write the subroutine for get data which will populate the internal table after click on refresh button. 6. Write the subroutine for "USER_COMMAND_LOG". FORM  user_command_log  USING  u_ucomm      TYPE  sy - ucomm                        ...
Post a Comment
Read more