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

Adding New Input Fields to SAP Confirmations Screen (CO11N/COR6N) Without Coding

It is possible to add additional input fields in the SAP production order confirmation screen without coding. We can do this just adding fields to a structure which is included in AFRU table (Confirmation table). Process Steps Step 1:   Go to below customizing path. SIMG > Production > Shop Floor Control > Operations > Confirmation > Single Screen Entry > Define Single Screen Entry for Confirming Production Order Step 2:  Double click on the standard profile. Add "Customer Specific Fields of CI_AFRU" in the detail area. Step 3:  Go to default tab. Select an option from the "Customer Specific Fields" area. Then click on save button. Step 4:  Go to transaction code "SE11". Select database table and put "AFRU" and click on change button. Step 5:  Go to the include marked in the screenshot and double click on the data element of the include. Step 6:  Double click on "CI_AFRU". Step 7:  Click on "Yes" in the pop u
Post a Comment
Read more

SAP Fiori Data Migration Cockpit Freezing Problem

SAP Data Migration Cockpit is a tool that is used to migrate data from legacy systems to SAP systems. It provides a user-friendly interface for data migration, allowing users to extract, transform, and load data from different sources. Problem Sometimes we face problem during uploading data through data migration cockpit. Problem is data migration cockpit get stuck or frozen while executing a specific task.  Solution To solve this problem we have to execute a program manually through SAP GUI. Step 1: Go to SAP transaction code SE38 Step 2: Paste the program name "/LTB/JOB_DISPATCHER" and then press the execute button. Step 3: Now check the migration cockpit. Problem solved.
Post a Comment
Read more

SAP Production Order Confirmation Table List

SAP Production Order Confirmation is a process that enables companies to confirm the completion of production orders in the SAP system. The confirmation process allows companies to track and manage the progress of production orders, as well as record the actual quantities of materials used and the time taken to complete the production order. Production order confirmation tables are listed here. AFFW                     Goods Movements with Errors from Confirmation AFFWPRO           Log of deleted AFFW entries AFRC                     Incorrect cost calculations from confirmation AFRD                     Default values for collective confirmation AFRH                     Header information for confirmation pool AFRH_DEL           Backup Copy of Header Information for Conf AFRP0                     Table of planned changes for confirmation AFRP1                   Table of planned changes to conf.: Automatic AFRP2                   Table of planned changes for confirmation AFRP3          
Post a Comment
Read more