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

SAP Quality Management Transaction Codes

 SAP Quality Management transaction codes are listed here. Quality Management General Transaction Code List T-Codes Function Q000 Quality management QA00 Quality inspection QA01 Create Inspection Lot QA01A  Create Inspection Lot QA02 Change Inspection Lot QA02A  Change Inspection Lot QA03 Display inspection lot QA05 Job planning: Periodic inspection QA06 Job overview: Periodic inspection QA07 Trigger for recurring inspection QA07L  Deadline Monitoring Log QA08 Collective Processing of Insp. Setup QA09 No. range maintenance for insp.lots QA10 Trigger automatic usage decision QA10L  Log for Automatic Usage Decision QA11 Record usage decision QA12 Change usage decision with history QA13 Display usage decision QA14 Change UD witho...
Post a Comment
Read more