Skip to main content

Data Definition Language (ABAP Dictionary ) VS Actual Data


Let's understand more about DML , DDL and Actual Data.

DML is Data Manipulation Language which consists of update commands such as SELECT, INSERT, UPDATE , DELETE etc and ABAP Programs handle these commands.

DDL is Data Definition Language consists of commands such as CREATE TABLE, CREATE INDEX, DROP TABLE, ALTER TABLE, etc. and ABAP Dictionary handles the DDL part of SQL. It can be viewed as metadata.

Diving deep in ABAP Dictionary :-

1. Data Elements : Elementary type of definition the data type , length and possibly decimal places.

2. Structures : Components that can have any type.

3. Table Types describe the structure of an internal table.

The Dictionary supports the definition of user-defined types and these types are used in ABAP programs. They also define the structure of database objects such as tables, views and indexes. These objects are created automatically in the underlying database in their Dictionary definitions when the objects are activated. The Dictionary also provides editing tools like Search Help and locking tool like Lock Objects.

Data of the table / Actual Data : So what is store in that table is the actual data or data of table.

Those who have been following the migration series or understand migration , R3LDCTL takes care of ABAP Data Dictionary that is DDL part of SQL and RLOAD take care of the actual data that is stored in the tables. Just to add up in case of JAVA system, We only have JLOAD that manages both.

Source of ABAP Dictionary

Read About Domains

Read about Data Elements


Labels:

Comments

Post a Comment

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...
Post a Comment
Read more