Category: Data Dictionary

What is Size Category?

In this article, you will find answers to the most asked questions from newbies about Size Category that we are getting in ABAP Academy. Notice: We will use the abbreviation SC for Size Category in this article. Q: What is Size Category? The SC is basically our “estimation” of how many records the database table...

What is the difference between database table and internal table?

What is the difference between database table and internal table?

In today’s Coaching Session we are discussing what is the difference between database table and internal table within SAP. Do you know what is the difference between them? Here are all the questions we are discussing on this call: What’s the difference between internal tables and transparent tables? How can I access transparent tables? What’s the...

How to Create a Left Join View in SE11? + Explain Inner Join and Left Outer Join with Example

Question How to create database view in SE11 with LEFT OUTER JOIN? Original Question: Can I create Search Help / VIEW with all the existing ICPNs + information about ORDER_ID from Ordered Items database table. Required output: ICPN MODEL STORE PRICE CURRENCY ORDER ID 978-0997082302 SEDAN BRATISLAVA 45.000,00 EUR 12 978-0997082303 SEDAN BRATISLAVA 50.000,00 EUR 12...

How to Create a Database Table?

In this article, we are going to create a table to store records about cars step-by-step from scratch. Here is the information about cars that we are going to use in the table: Car ID Model: a model of a car such as Sedan, Hybrid, Hatchback, etc. Store: to which store the car belongs to Price Currency The...

What is Data Class?

Data Class defines the space for database table where it should be stored physically on the hard drive of a database server. The setting for the Data Class is within the definition of Database Table in Techincal Settings. When you define the data class for the table that you create, the table is assigned to the...

What is Delivery Class?

Delivery Class defines how database table is going to be transported during installation, upgrade, and copies within landscapes, clients and customer systems. Types and use of Delivery Class: A Application table for master data and transaction data. Data is maintain by application. These tables are delivered to customer as empty tables. C Customer table used...

Data Elements vs. Domains

Lets start with explaining what are these two terms needed for. When we are defining database tables within SAP, each and every field needs to contain specific type. Lets say that we create a database table called Store. Along with other fields the store also needs to contain information when it is opened and closed. In...