Himanshu Joshi’s Post

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.

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.

New to CDS? ABAP CDS entities are data models based on the data definition language (DDL) specification and are managed by ABAP Dictionary. ABAP CDS provides a framework for defining and consuming semantic data models on the central database of the application server AS ABAP. The specified data models are based on the data definition language (DDL) and the data control language (DCL). So, a CDS entity or the extension of a CDS view is defined as source code in the data definition. Follow along this blog for a quick intro to the Core Data Services in ABAP! https://lnkd.in/gAEEiYxE Also, here is a definitive guide from SAP to get you started on development using CDS from scratch! If you find this useful, feel free to share it ! Keep Learning, Keep Sharing :) #learning #S4HANA #CDS #entity #development #ABAP #code #programming #new #learning #sap #technology #developer

🗓️ 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

🌐 Unmanaged Query in RAP As developers, we play a critical role in handling and implementing Unmanaged Queries to expose data effectively in RAP. While most aspects like managing OData requests/responses, paging, filtering, and sorting are handled directly by us, Unmanaged Queries are incredibly useful in specific scenarios. Here are some use cases where I've found Unmanaged Queries particularly helpful: 1️⃣ When dealing with complex SQL logic that’s difficult to implement via CDS views. 2️⃣ Reusing existing logic for data retrieval, whether it’s in a Class, BAPI, or FM. 3️⃣ Consuming external services via OData/HTTP/REST APIs – for example, accessing BO entity data in BTP ABAP from ECC/S4HANA system. How to Implement? In RAP, we can use a Custom Entity, a type of CDS view entity. However, unlike CDS views, a Custom Entity pulls data from ABAP logic that we define in the custom entity class. More details can be found in this tutorial. https://lnkd.in/gZiNPA9R What is the most unique problem you have solved via Unmanaged Query ? Feel free to share your thoughts or ideas on these points. I’d love to hear your feedback! 😀 #saprap #abapcloud #cdsviews #sapbtpabap #ABAPRESTfulApplicationProgrammingModel #s4hanaextensibility

🗓️ The Select Query Project #6 : Concatenation in Select Query (for fetching data) You can use CONCAT function to concatenate two parameters and fetch in the output in a select query. You can also use CONCAT_WITH_SPACE for concatenating parameters with spaces as shown in the reference image. One more thing, if you have more than two parameters to concatenate then you can use nested concatenation for the same. ****** 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 going through different types of SELECT query statements used in SAP ABAP. #SAP #ABAP #SAPCommunity #TheSelectQueryProject #ABAPonHANA #LinkedinLearning

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

Hello Everyone👋! 𝗔𝗕𝗔𝗣 𝗦𝗤𝗟: 𝗜𝗻𝗱𝗶𝗰𝗮𝘁𝗼𝗿 𝗦𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲𝘀 If you've worked with RAP, you might be familiar with the %𝗰𝗼𝗻𝘁𝗿𝗼𝗹 component group. This structure contains all key and data fields as components, represented as flags. It is used to determine which fields are provided to Create/Update during CREATE or UPDATE operations using EML. A similar concept exists in ABAP SQL with 𝗦𝗤𝗟 𝗜𝗻𝗱𝗶𝗰𝗮𝘁𝗼𝗿𝘀. These indicators are useful for partially updating a database table by setting specific fields. Here's a small example. in an internal table, you can mark the column PRICE in the indicator structure to specify that only this column should be updated. If you don’t use the INDICATORS addition of the UPDATE statement, all other non-key columns of the database table would be initialized since their values are initial in the internal table. For more details, refer to the blog link added in the comments section. If you are already started to use this, share your thoughts here. #abap #abaponhana #sql #sap #s4hana #abapsql #rap

SAP Object Types and Object Node Types #itpfed

How to Replicate Custom CDS Views from S/4 HANA to SAP Datasphere Recently, I explored the process of replicating custom CDS views from S/4 HANA to SAP Datasphere for learning purposes. This is crucial for anyone interested in real-time analytics and seamless data flow across systems. Using ABAP Development Tools (ADT) on Eclipse, I created CDS views and then set up replication flows in SAP Datasphere. This method allows for efficient, automated data synchronization, significantly boosting data availability and analytics capabilities. I've put together a detailed guide on how to create CDS views, configure replication flows, and manage initial and delta data replication. If you're looking to enhance your data integration strategy, you might find this helpful! #SAP #S4HANA #SAPDatasphere #DataIntegration #RealTimeAnalytics #CDSViews #ABAP #DataSynchronization #TechInnovation #BusinessIntelligence