How to creating foreign keys in SAP Table

Whats is foreign keys Foreign keys describe the relationship between the tables in the ABAP Data Dictionary. Foreign keys can also be used to create value checks for the input fields, and when a foreign key relationship is maintained for particular field To create foreign keys you can use SE11 SAP Transaction code. Open you […]

Read More

How to create Domain in ABAP Dictionary

An Introduction to Domain in ABAP Dictionary A Domain is a central object which defines the technical attributes of a field such as data type, length, decimal places, conversion routine and value table. The domain is assigned to the data element, so all the fields that use the data element have technical setting defined by […]

Read More

How to create Text Table and Assign to Main Table

What is Text Table A text table a special table that contains text in multilingual format, text table also contain the language field ( SPRAS ) as a key field. A table is said to be the text table of another table if it contains all the key fields along with the additional language key field. […]

Read More

How to create pooled tables and table pool in SAP

What is Pooled Tables A pooled tables has many to one relationship with database table. There are many tables in the data dictionary for one table in the database. Unlike a transparent table, a pooled table has different name, different number of fields, and different name of fields in the database. The data from several […]

Read More

The Introduction of Structures in ABAP Dictionary

What is the structure in ABAP Dictionary A structure or structure type consists of fields or component, A component can refer to a built-in type, elementary type, reference type or complex type. A component of the structure can refer to a data element, another structure or table type. Structure can be define globally in ABAP […]

Read More

How to create table maintenance generator

Maintenance dialogs are the system generated programs that allows you to add,change and delete records in your table using SM30 SAP Transaction code. To create a maintenance dialog/ table maintenance generator , open your table for changes using SE11 SAP Transaction code. Note :Please don’t forget to change Delivery and Maintenance -> Display/Maintenance Allowed . […]

Read More

How to create Nested Structure in ABAP Dictionary

What is the Nested Structure in ABAP Dictionary A Nested structure is a structure that refers at least to one other structure but do not refer to table type. To create the nested structure is the same with flat structure you can use SE11 SAP Transaction code. You can entered the name of Data Type, […]

Read More

How to create secondary Index

What is Index.  The Index is copy of database having few number of fields, this copy is always in sorted form. as you know the sorted data would always have speed read access, and the index also contain pointer to actual database table. There are two types of indexes in SAP i.e Primary Index and […]

Read More

How to create Flat Structure in ABAP Dictionary

What is Flat Structure in ABAP Dictionary As we mentioned before, The flat structure is a structure that refers only to an elementary type or reference type. It do not refer to other structure or table type. Now, we can use SE11 SAP Transaction to create Flat Structure in ABAP Dictionary. Please select Data Type and […]

Read More