Bharathi Sakthivel’s Post

In our previous post, we explored the Message Class and how to create a transaction code for executable programs. Now, let's dive into some key ABAP performance practices you should always keep in mind: 💡 Key Best Practices: Avoid using * in queries. Always fetch only the required columns. Ensure column fetching and where condition sequences align with the data dictionary. Skip JOIN for traditional databases and opt for FOR ALL ENTRIES IN. Use parallel cursors in nested loops to improve performance. Never write a SELECT query inside loops! We’ve answered key questions like why column sequence matters, why you should always check sy-subrc, and the risks of placing SELECT inside loops. 💻 Check out the full post for detailed explanations and best practices! 👇 #ABAP #SAP #PerformanceOptimization #ParallelCursors #SAPDevelopment #CodingBestPractices

👋This SAP's tutorial on CDS Views provides a step by step guide, making it easier for ABAP developers to leverage the power of #CDS for data modeling using #ADT. Here’s a brief overview: ⭐️Create a CDS View - Learn how to define and activate your first CDS view in ADT. ⭐️ABAP Perspective - Utilize the ABAP perspective in Eclipse to streamline your development process. ⭐️Annotations & Elements - Understand the importance of annotations and how to define elements within your view. ⭐️SQL-like Syntax - Harness the familiar SQL-like syntax for defining data models. 👉Why CDS Views? - Performance Optimization - CDS views push data-intensive computations to the database layer. - Enhanced Readability - Simplifies complex SQL queries and provides a clear structure. - Reusability - Promote reusability across different applications and projects. 👉Here is the link for this tutorial https://lnkd.in/efKFhXVz. #SAP #ABAP #SAPABAP #SAPLearning

Hii 😊 Connections Beginning of 60 days ABAP Challenge. #Day 2: 😊 Data Dictionary : Topic: Table Maintenance Generator Table Maintenance Generator: A table Maintenance Generator is a tool that can be used for program table Maintenance . It allow us to Maintenance customized tables. The transaction code for TMG is created SM30 . The Table Maintenance Generator is user interface tool is used to change , Delete or update create entries in a table . How to create a Table Maintenance Generator ?  Generate Table Maintenance -> Step Transaction Code: SE11 Pick the table you want to generate Table Maintenance. Go to utilities -> Table Maintenance Generator Auth Group-> &NC& Input the Function Group –can be the table name. Choose the step (one step and two step) Click on the top button Find the Screen number. Menu-> Generated Objects -> Create and Save , back . Go to Transaction Code: SM30 #SAP #SAPABAP #ABAP #Data #Dictionary #ABAPPROGRAMMING

This SAP's tutorial on CDS Views provides a step by step guide, making it easier for ABAP developers to leverage the power of #CDS for data modeling using #ADT. Here’s a brief overview: ⭐️Create a CDS View - Learn how to define and activate your first CDS view in ADT. ⭐️ABAP Perspective - Utilize the ABAP perspective in Eclipse to streamline your development process. ⭐️Annotations & Elements - Understand the importance of annotations and how to define elements within your view. ⭐️SQL-like Syntax - Harness the familiar SQL-like syntax for defining data models. 👉Why CDS Views? - Performance Optimization - CDS views push data-intensive computations to the database layer. - Enhanced Readability - Simplifies complex SQL queries and provides a clear structure. - Reusability - Promote reusability across different applications and projects. 👉Here is the link for this tutorial https://lnkd.in/efKFhXVz.

Standard Programs That Every ABAP Developer Should Know ✔️ I decided to give you a list of standard SAP programs that every ABAP developer should know. ✔️ As you know, as a consultant or a user, you memorize a lot of transaction codes. But some programs don't have a transaction to run. Those are usually type '1' executable programs. Even it is good to know the program name; therefore, maybe you may want to look at the source code and get some knowledge about SAP structure and logic behind SAP. To run these programs, you have to go to SE38 (the ABAP Editor) or SA38 (ABAP:Execute Program), then type the program name and hit F8 on the keyboard for foreground running. You would also sometimes need to run these program in background processing. 👉 Standard Programs That Every ABAP Developer Should Know ✔️ ✔️ RCSBI010 (Create BOMs using Batch Input) Standard Batch Input program for creating/updating BOM (Bill of material) ✔️ RFBIBL00 (Batch Input Documents) Standard Batch Input input program for creating/updating Financial Documents ✔️ RMDATIND (Transfer Material Master Data by Direct Input) Standard Direct Input program for creating/updating Material Master Data ✔️ RSBDCREO (Batch Input: Reorganize Sessions and Logs) - reorganizes the batch input log file. ✔️ RSBDCSUB (Batch Input: Process All Sessions) - schedules batch input sessions for immediate execution in the background processing system. ✔️ RSBPCOLL (CCMS: Collector for Background Job Run-time Statistics) ✔️ RSBPSTDE (Delete Statistics Data from the Job Run-time Statistics) ✔️ RSBTCDEL (Delete batch jobs) ✔️ RSCOLL00 (Main program: Performance monitor (RFC) collector run) ✔️ RSDBTIME (Time diagnosis) ✔️ RSM13002 (Update request analysis and processing tool) ✔️ RSPARAM - shows which parameters are active for a particular SAP instance. ✔️ RSPO0041 (Delete Old Spool Requests) ✔️ RSSNAPDL (Reorganization Program for Table SNAP of Short Dumps) ✔️ RSTRANSP (Select Report and Variants for Transport) ✔️ RSTXLDMC (Upload TIFF files to SAPscript texts) ✔️ RSTXSCRP (SAPscript Export to Dataset / SAPscript Import from Dataset) #sap #abap #SAPABAP #SAPMM #SAPHANA #SAPTraining

Beginning of 60 days ABAP Challenge. #Day 51: ⭕ LSMW 💠 Transaction Code:   LSMW ⭕ LSMW : - LSMW full form is Legacy System Migration Workbench. The LSMW Workbench is an R/3-based tool that allows us to transfer data once or regularly from non-SAP systems to R/3.It’s a very simple & easy tool that makes mass data migration in a few simple steps. Data imports into R/3 should be of better quality and consistency than data immigration speed and performance 💠How does LSMW work in sap? The LSMW main functions are: Import data ( legacy data in MS Excel or text-format sequential file) Conversion of data (from the source format to the target format) Import the data into the application R/3 database To assist with the SAP LSMW data migration, we’ve listed all the critical steps in the following: 💠Project Prep Before beginning any data transfer project, preparation and planning are essential. This is the time to establish project goals, identify the sources of data and mapping fields, and select the migration strategy. Setting clear objectives, laying the base for success in migration, and ensuring a smooth and efficient experience during the migration process will be in the future. 💠Recording The recording process LSMW documents data exchange processes by recording every operation that occurs within the system that was previously in use. The recorded data is used as a blueprint for future migration runs, and any discrepancies must be inspected for accuracy before moving on. 💠Mapping and Conversion LSMW uses mapping and transformation tools to connect data fields from old software and SAP systems. It also performs any conversions necessary to match the needs of the company. Attention to detail is essential for precise mapping and avoids mistakes in the migration process. 💠Import Data In this stage, LSMW will import the transformed data into the SAP system and then validate it by examining its consistency and conducting validations to identify any inconsistencies or discrepancies that are discovered. After carefully analyzing the import results, businesses can pinpoint problems with the data quickly. 💠Post-Processing Once the data has been imported, further steps should be taken to complete the migration. This could include additional validations, data reconciliation, and confirming its accuracy within the SAP system. Complete post-processing is essential to ensure a successful migration and a seamless transition to new systems. #SAP #ABAP #SAPABAP #LSMW #BDC #DATA #Program #Conversion #import #export #video

📊 Transforming Data into Insights: Formatting Dates for Graphs When working with SAP ABAP, preparing data for visualization is key to effective analysis. Here’s how you can convert a date in YYYYMMDD format into a readable "Oct-2024" format during the processing of an internal table. This approach is especially useful for creating intuitive time-based graphs. 💡 Code Highlights: 1️⃣ Extract the month and map it to its abbreviation (e.g., 10 → Oct). 2️⃣ Combine the formatted month with the year to generate a clear and concise label (Oct-2024). 3️⃣ Seamlessly apply this transformation within the loop for better performance and data readiness. 🎯 Outcome: 1.Display data in user-friendly formats for graphs. 2. Now we can filter data month wise. 🚀 Pro Tip: This method ensures your graphs are not just technically accurate but also visually compelling! #SAPABAP #DataVisualization #DateFormatting #SAPGraphs #ABAPDevelopment #SAPTips 💻 ABAP Code Snippet:

Developing an Unmanaged Transactional Application Using the ABAP RESTful Programming Model:Part 4 Final Data Flow: SAP CDS View Modularity in ABAP RAP #SAP #ABAPRAP #CDSViews #DataModelling #PerformanceOptimization #TechInsights #SoftwareArchitecture #SAPCommunity #ContinuousLearning In the latest entry of our deep-dive into developing unmanaged transactional applications using the ABAP RESTful Programming Model, we unravel the complexities of SAP CDS View data flows. With an emphasis on modularity and clarity, we've streamlined data processing layers to facilitate easier understanding and maintenance, ensuring peak performance and reusability. Discover how the interplay between various CDS Views forms a coherent and robust data model, paving the way for scalable and efficient applications.

I know this is basic, but perhaps one of the most important. It is no coincidence that SAP PRESS also produced an educational video. ❗ Topic: ABAP SHORT DUMP 🅢🅐🅟 🅗🅐🅝🅐 #sap #hana #saphana #s4hana #st22 #abapdump https://lnkd.in/gPCmiA2d

SAP Object Types and Object Node Types #itpfed