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 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....
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...
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...
During SAP Netweaver 7.5x installation, you may get to the following error message: “Installation of NPL failed“. The whole error message may look like this: Now, what to do? From our current findings, there is no one straight forward answer. There can be several causes. In this article, I list all the solutions that we came...
After login to SAP system, you click on link at user sample menu, for example: User Menu for John Doe ->Plain ABAP-> ABAP Samples. When browser opens, you get error message, saying is not possible reach the vhcalnplci.dummy.nodomain or vhcalnplci:8000. Everything on server is green and running. Solution [sociallocker id=1191]Update ‘hosts’ File on Your Client...
Updated March 24th 2023! Download the License file here, or directly from SAP.com website here. Updated March 13th 2023! In these days we have received information from SAP about requiring to update ASE license to all of our Fully Pre-Installed SAP systems purchased from ABAP Academy website. That’s why we all need to update licenses...
Problem: When running Extended Syntax Checker, you get the following runtime error: [sociallocker id=1191] Generate manually the following programs: CL_SLIN=======================CP CL_SLIN_CHECKER_I18N==========CP CL_SLIN_CHECKER_SECURITY======CP CL_SLIN_CHECKER_DYNPROS=======CP CL_SLIN_CHECKER_MOD_ENH=======CP Detailed Procedure Go to SE38 Fill in the Program name from the list above Hit ‘Program’ from the menu Hit on ‘Generate’ or press ‘CTRL+F3’ Repeat the same procedure for all...
