Shubham Annadate – How has ABAP helped him get married…

Why do we even bother in ABAP Academy about such things not related to ABAP? It’s because we treat our coaching clients like family. We don’t start with cold hard ABAP lessons. Instead, we get to know them. Understand who they are… What they want to achieve with ABAP… And more importantly – WHY? Shubham wrote...

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...

“DBTAB_NAME” must be a flat structure. Internal tables, strings, references, and structures cannot be used as components.

Analysis Why SAP treats the table as a structure? Why is this error displayed when “DBTAB_NAME” exists in Data Dictionaty as Database Table? In our case we are dealing with the database table called „ZLR_DDIC_MODEL“: Here is the syntax error: Explanation Lets take a look to the help. (Pressing F1 when cursor is on TABLES statement) In...

System error in program LRSDG_IOBJ_DB_READ

Thank you Carl Gustafsson for solving this issue for ABAP Academy Community ;) Problem: Everytime I try to create a DataStore Object (DSO), this I get a Runtime Error. Solution: There some inconstancies within the BW systems that will trigger the dump when activating the DSO. Found some forum posts when I searched for “regular_iobj_get_for_meta” that might indicate that. Im...

How to Create Function Module in ABAP

What is Function Module? Function Modules are a set of codes that can be reused by other programs. Instead of copying exactly the same statements within programs, it is much more useful and maintainable to create a function module. Function Modules are created with importing, exporting, changing parameters, and exceptions. Function Modules can be executed independently and...

How to Create Function Group

What is Function Group? Function Group is a collection of Function Modules with similar characteristics. E.g. Function Modules with arithmetical logic can be stored into Function Group containing “Arithmetic” in its name. Each Function Module we create needs to be added into one Function Group. For that reason, Function Group is created earlier than Function Module....

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 Size Category?

Let’s start with frequently asked questions from newbies about this topic. Q: What is Size Category? The size category is basically our “estimation” on how many records database table which we are creating is going to contain. Of course, nobody knows the exact number. That’s why we want to shoot our best ;). Q: Why...

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...