Notes

Good Afternoon EVERYONE, I Nikita Chamoliof SAP ABAP HANA 12TH DEC BLR BATCH IS HAVING BILLING OF MATERIAL AS CASE STUDY FOR MY SPRINT AND I WILL BE BREIFING YOU ABOUT IT IN UPCOMING SLIDES of MY PRESENTATION.THE PRESENTATION CONSISTS OF FOLOWING TOPICS.MY PROBLEM STATEMENT INCULDES CREATING AND DISPLAYING DATA IN the OOALV, ADOBE FORM in the range of bill of material STLNR
CDS VIEW,ALV_IDA , ADBC AND AMDP . Calculating priority field based on the given caseTHESE ARE THE THREE customized TABLES MAST , STKO AND STOP THROUGH WHICH I WILL FETCH THE DATAFOLLOWING IS THE DATA SET THAT IS USED AND IS STORED USING TMG THAT IS TABLE MAINTAINCE GENERATOR WHICH HELPS TO IMPORT BULK DATA INTO OUR TABLES.I HAD TO CREATE AN EXCECUTABLE TYPE PROGRAM TO DISPLAY OOALV AND ADOBE FORM.THIS IS THE LAYOUT CREATED IN SCREEN PAINTER HAVING TRANSACTION CODE SE51 .
IN THE LAYOUT I HAVE USED 2 CUSTOM CONTROL AND 1 PUSHBUTTON .
CUSTOM CONTROL IS THE SET OF LAYOUT IT WILL GIVE SAPCE TO ALV OUTPUT and ONE IS FOR Capgemini’s LOGO Also the push button as back button to go back to the previous screen.
This is my Selection screen displaying input for Select options for the field STLNR that is Bill of Material , Submit as pushbutton and OOALV AND AF radio buttons to display the output in thatparticularformat.This displays the data and is output for ooalv.

Which is object oriented ABAP LIST VIEWER.IN THE LAYOUT OF ADOBEFORM Transaction code for adobe form is SFP in this we display how the output data is positioned, its appearance in graphics, and the design of the page here

1.First we create an interface and declare the internal tables and quantity fields in import.
2.We activate and then we create a form for that same interface (the name for form and interface should be same for a good practice)
3.In form we drag the internal tables from import section to context section and create the layout.
4.In data view section we design our layout using suborms.
5.After we activate we get a function module using which we can run our driver program dynamically.HERE IS THE OUTPUT FOR ADOBE FORM which is PDF-base print form.This is output for CDS VEIW STANDS FOR CORE DATA SERVICES This view is used when the data needs to be accessed from multiple sources.
This helps users leverage SAP HANA’s powerful in-memory database and fulfil the requirement for fast, real-time performance by performing maximum operations at database level enabling users to retrieve data fast, cutting down on application execution time. This is output for CDS Extended view I have added WERKS and BMENG field on the existing CDS VEIW.
ALV_IDA Means, you generate the ALV for the DB table we don’t select the data and send that to the ALV.

The IDA framework then analyze the required columns, analyze the filters to get the required (where condition) and then executes the select query.
It retrieves only the data that is needed to display the grid, rather than retrieving all the data from each table and performing joins in memory .This shows my output for ABAP DB CONNECTION it serves as an API (Application Programming Interface) for the SQL interface of the Application Server ABAP.
The core idea is to write database procedures directly in ABAP.

1.cl_sql_connection-> get connection to get connection to database.
2.Create_statement() to intiallize sqlstatement.
3.We prepare sqlstatement to select the field to be displayed and store it in a variable.
4.Issue the sql as execute_query(pass the select statement).
5.Result->set_param_table we are passing target variable for result set.
6.Result->next_package() we retrieve the result.
7.Close_query-> close() to close the query.
8.Connection->close() to close the database connection.

The main classes used
CL_SQL_CONNECTION which class represents a database connection It allows you to establish and manage connections to a database system (such as SAP HANA).
CL_SQL_STATEMENT is used for executing SQL statements. It provides methods to prepare, execute, and fetch data from SQL queries.
CL_SQL_RESULT_SET is used to handle result sets obtained from executed SQL statements.This is OUTPUT for AMDPs which allow ABAP developers to write database procedures directly
These procedures are implemented within special ABAP classes called AMDP classes.
The embedded code in these classes generates database procedures in the SAP HANA DB layer.
The fundamental idea behind AMDP is to manage SAP HANA procedures and their lifecycle within the AS ABAP server.
AMDP provides a powerful way to optimize ABAP code for SAP HANA by leveraging native database procedures. It’s a recommended approach for performance enhancement and efficient data processing