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...
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...
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...
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...
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...
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...
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...
How to change SAP Easy Access Screen Picture Step By Step as Follows: Step 1: Enter transaction code >SMW0. Step 2: Click on >Binary data for WebRFC applications >Hit Enter. 3) >Hit Execute Button. 4) Go to >Settings >Define MIME Types 10) New Picture of SAP Easy Access . Congratulations! Don’t forget to hit like...
When you need to download records from database table into CSV file, you need to tweak a bit around to get the final file, because SAP does not provide straightforward function on how to do it. So, how to download records from database table into CSV file? Here is how you do it.
Sometimes you need to change specific database record but you don’t have ability to edit record in database directly using edit button, because database table has defined Delivery and Maintenance parameter to ‘Display/Maintenance Not Allowed’. In such case you can do the small hack using Debugger. How to change record in database table using debugger?
