Gaurav Singh’s Post

🗓️ The Select Query Project #2 : Using CONCAT (with Joins) If you have a specific requirement to query the data from one table (b) based on some another table (a) with join condition such that two or more parameters of table (a) concatenate together to form the single parameter of table (b), then you can use the given syntax easily and solve your problem. ****** SELECT is the Open SQL statement for reading data from one or more database tables, classic views, or CDS entities into data objects. The statement SELECT creates either a multirow or single-row results set that is assigned to suitable ABAP data objects. In this series, we are going to see different types of SELECT query statements used in SAP ABAP. #SAP #ABAP #SAPCommunity #TheSelectQueryProject #ABAPonHANA

Very useful for fields where there is concatenation of date & doc number.

🗓️ The Select Query Project #4 : Using JOINS (with self-join conditions) I came across this scenario with a requirement to skip records from EKEH table (that was used in joins in a CDS View) where WEMNG and MENGE fields are equal. Then I found that we can write a join condition comparing same table/view parameters on left and right side of the join condition. I simulated and tested the sample query and it was working good. ****** SELECT is the Open SQL statement for reading data from one or more database tables, classic views, or CDS entities into data objects. The statement SELECT creates either a multirow or single-row results set that is assigned to suitable ABAP data objects. In this series, we are going to see different types of SELECT query statements used in SAP ABAP.   #SAP #ABAP #Linkedin #TheSelectQueryProject #ABAPonHANA #LinkedinLearning

🗓️ The Select Query Project #1 : Using SELECT SINGLE (and passing data into different variables) SELECT is the Open SQL statement for reading data from one or more database tables, classic views, or CDS entities into data objects. The statement SELECT creates either a multirow or single-row results set that is assigned to suitable ABAP data objects. In this series, we are going to see different types of SELECT query statements used in SAP ABAP. ****** If you want to select multiple single parameters from a database table or view and assign them to individual variables instead of a common structure or table, then we can use the shown syntax. Here, we are also using ABAP New Syntax for creating three new variables at runtime. #SAP #ABAP #SAPCommunity #TheSelectQueryProject #SAPLearning

😊Let us introduce Enumerated Types in ABAP CDS as part of our #FeatureOfTheDay Initiative for ABAP Platform 7.58. A CDS enumerated type is a CDS user-defined type in ABAP CDS that defines an enumerated type. What are the key advantages? ✅Enhanced Data Definition. Define enumerated types natively in ABAP CDS for improved data structuring and validation. ✅Versatile Usage. Enumerated types can be utilized across CDS data definitions, ABAP SQL, and ABAP code, offering flexibility and consistency in data handling.   ✅Simplified Development. Streamline development processes with predefined allowed values, ensuring data integrity and reducing error-prone input.   🙌Contact us to get your SAP ABAP Platform with basis 7.58 in one click. Stay tuned for more updates and tips to enhance your ABAP development skills! 💡 #ABAP #DevelopmentUpdates #SAPTech 

🗓️ The Select Query Project #3 : Using CASE in Select Query If you have some selective case based requirements, you can use CASE keyword in select query. For example, in the given select query we have conditions on movement type (bwart) field of MATDOC table where we're adding a custom description field and setting another (document) date field based on certain conditions. ****** SELECT is the Open SQL statement for reading data from one or more database tables, classic views, or CDS entities into data objects. The statement SELECT creates either a multirow or single-row results set that is assigned to suitable ABAP data objects. In this series, we are going to see different types of SELECT query statements used in SAP ABAP. #SAP #ABAP #SAPCommunity #TheSelectQueryProject #ABAPonHANA #LinkedinLearning #S4HANA

There are two main approaches to integrating SAP data: ABAP programming and SAP extractors from third-party providers. For developers and IT decision-makers, choosing the right method is crucial for efficient data management and optimized processes. While ABAP programming involves programming to enhance or extend SAP functions, which is usually done by technical developers, it often requires significant programming knowledge. Third-party SAP extractors, on the other hand, are more user-friendly and allow for faster implementation without in-depth programming knowledge. I heard from a customer that he was able to reduce the time he spent on SAP mass data extractions from many days with ABAP programming to 7 hours with a SAP extractor 😲But even such statements depend on many variables and cannot always be transferred 1:1.   Learn the differences in the following blog post and what is the best approach for you👇 #sap #sapintegration #abap #bigdata

💡 Mastering Field Symbols in SAP ABAP 💡 Field symbols in SAP ABAP are powerful tools that allow you to reference data objects dynamically. They act like pointers in other programming languages, enabling efficient data manipulation directly in memory without the need for additional copies. Here's why they're essential: 🔑 Key Benefits: 1.Direct Access: Modify table entries or variables directly without creating extra variables. 2.Performance Boost: Significantly improves performance in loops and large datasets. 3.Flexibility: Can be used with any data type or structure, making your code more dynamic and reusable. 4.Memory Efficiency: Avoids redundant data copying, ensuring optimal memory usage. In below loop example, <fs> directly references each row of the internal table lt_table, allowing immediate updates to the original data. 🚀 Takeaway: If you're working with large datasets or need dynamic data handling, field symbols are your best friend in ABAP development. #SAP #ERP #ABAP #FieldSymbols #PerformanceOptimization #ERP #DataHandling #SAPDevelopment

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

#FeatureOfTheDay on ABAP 7.58: SQL-based and analytical CDS scalar functions. 💡Custom SQL-based scalar functions for the SAP HANA SQL runtime can be created by customers and partners. 💡Analytical scalar functions created by SAP can be used in ABAP CDS. This feature revolutionizes how developers manipulate and analyze data within ABAP CDS, empowering them to craft custom business logic directly within their data models. For Developers. With SQL-based and analytical CDS scalar functions, developers can now perform complex data operations effortlessly, right within their CDS view entities. This streamlines development, boosts productivity, and opens endless possibilities for tailored data processing.  For Businesses. By leveraging these scalar functions, businesses can unlock deeper insights from their data, enabling faster and more informed decision-making.  🙌Contact us to get your SAP ABAP Platform with basis 7.58 in one click! 💼💡 #DataDriven #Innovation #ABAPCDS #ABAP758