When you create a table extension in AL data is stored on a one to one relation, where a new table is created with a foreign key value from the primary key of the original table. This not only helps in data integrity but also aids in faster querying at the same time, reducing the size of earlier witnessed many fields table. Please like & subscribe.