What is a Check table? How to create a check table in SAP?

What is a check tables in SAP ? Data validations on SAP tables using check table, creating check table in SAP

+ -

What are table validations?

Table validation is a concept through which we can restrict invalid entries in a table.

Possible methods/concepts for table validation

1. Field Level validations: We can validate entries at field level with the help of check table concept.

2. Domain level validations: We can restrict entries at the domain level with the help of fixed values of the domain and value table of the domain.

What is a check table?

It is a table which contains all valid entries of a field.

What is value table?

It is a table which contains all valid entries of a domain, this domain can be reused in multiple tables.

What are fixed values for the domain?

These are allowed values for a domain ex: GENDER (domain).

Creating check table for table validations.

Step1: Go to SE11, create a table ZSTUDENT_CHECK as below

Go to SE11, provide name as ZSTUDENT_CHECK and click on create.

Provide delivery class and display maintenance allowed.

Creating check table in SAP

Go to fields tab and add a field as below

Creating check table in SAP

Click on technical settings button and provide data class and size category.

Creating check table in SAP

Creating check table in SAP

Go to utilities- table contents - create entries add some entries to the table.

Creating check table in SAP

Creating check table in SAP

Similarly add some more entries.

Creating check table in SAP

Step2: Add ZSTUDENT_CHECK as check table for ZSTUDENT_TABLE

Go to SE11, provide table name as ZSTUDENT_TABLE( which we have created already in our previous lessons, if not create a table )

Creating check table in SAP

Go to tab Entry help/check, select city fields and click on 'Foreign key' icon.

Creating check table in SAP

Provide short text, check table name ZSTUDENT_CHECK and click on 'Generate Proposal' and click on copy.

Creating check table in SAP

A Check table will be assigned to CITY field

Creating check table in SAP

Save and activate the table(If you get a warning popup when activating just press no).

Now go to utilities - table entries -> create entries

Provide a city name which is not in ZSTUDENT_CHECK table and try to save, it will trough an error.

Creating check table in SAP

Creating check table in SAP

Learner Questions


No Questions by learners, be first one to ask ..!!

    Please Sign in to ask a question

    Was this lesson helpful to you? Yes No 82 People out of 84 think this lesson helpful


    Lesson Navigation

    ←Previous Chapter
    Next Chapter →