Sometimes you need to search on data from database table, which are not defined as key fields. In such case, selecting would not be optimal and select may take too much time. Example Lets say we want to use following SELECT on non key fields NAME_LAST, NAME_FIRST and NAME_WHOLE: SELECT * FROM zaa_bd_wpo_vol INTO table lt_wpo_vol FOR ALL ENTRIES IN lt_name_search WHERE ( name_last = lt_name_search-last AND name_first = lt_name_search-first )...
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...
If you have imported your own developments from different SAP system, you may have run into issue that you are not able to edit your older programs. This is the workaround how you can still access your programs in edit mode: Do you want to run your own SAP system locally even today?
Lately, I was having a call with one company representative working as a senior ABAP developer who is also in charge of running job interviews. I asked him questions that are important for us since we are helping people to grow their careers as efficiently as possible. That’s why I’m in charge also of creating strategic connections to...
Big News! I am proud to announce that our ABAP Academy Community Member Shervin Soleymanpoor has published the first version of FREE ABAP Editor Online! There have been endless discussions on forums on how to get access to any SAP system for practicing and learning ABAP. Now, for ABAP beginners/explorers it’s again easier to start with...
Our ABAP Academy Community member is already working on a web-based ABAP Editor and will share it with us soon! This is how it looks like: In the background of this ABAP Editor is our Fully Pre-Installed Local SAP System for Practicing ABAP on our ABAP Academy coding projects. See his quick demonstration from our discussion:...
Last time I was asked by one of my coaching clients to demonstrate the way on how I am approaching such project + with coding best practices. Let me share that with you as well: Are you interested to get such coding sessions regularly? Join our Community by signing up our Personalized Roadmap for FREE…
Find out what are the most used approaches when it comes to creating output on the screen in the ABAP program. In this video, you will create your first Help Library Program as a future reference for your later ABAP programs. Learn more about Help Library Programs and ABAP Academy Teaching System.
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...
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...
