Notes

GOODAFTERNOON I AM KANIKA SHARMA HERE TO GIVE MY SPRINT PRESENTATION ON THE CASE STUDY VENDOR
MY PRESENTATION CONSIST ALL OF THESE TOPICS
IN THIS PROJECT I HAVE TO CEATE INTERACTIVE REPORT SMARTFORM AND CDS VIEW,ALV_IDA,AMDP AND ADBC
I HAVE CREATE THREE TABLES :LFA1 LFB1 LFM1
THIS IS THE GIVEN TMG DATA WHICH I HAVE FILLED IN MY TABLES
REPORT IS AN PROGRAM THAT DISPLAYS DATA FROM THE DATABASE IN REQUIRED FORMAT
I HAVE CREATE HERE INTERACTIVE REPORT IN WHICH I HAVE CREATED EXECUTABLE PROGRAM.
INTERACTIVE REPORT IS  a report where user can interact with the output page of report. IF I CLICK ON THE OUTPUT OF FIRST DETAIL IT WILL DISPLAY THE OUTPUT OF NEXT REPORT
1.IN MY REPORT FIRST I HAVE MENTION TABLES 2.THEN I MAKE STRUCTURE 3. I HAVE USE SELECT-OPTION FOR TAKING RANGE PURPOSE
IN WHICH I HAVE TAKEN MATERIAL AS A VARIABLE
4.I HAVE DECLARE DATA 5. I HAVE USED 3
SUBROUTINES:
CREATE FUNCTIONS WITH FORM GET_BASIC_LIST
GET_DIAPLAY_LAYOUT GET_DISPLAY_LIST CALL THEM WITH PERFORM
THEN I HAVE USED SELECT STATEMENT FOR FETCHING THE DATA OF FIRST TABLE FROM DATABASE
WRITE FUNCTION TO WRITE THE DATA
THEN DEFINE 2ND TABLE DATA SECONDARY TABLE
USE SUBROUTINES
THEN USE SELECT STATEMENT
USE WHERE STATEMENT WHERE LIFNR IS COMMON FIELD
6.USED SELECT STATEMENT FOR SELECTING FIELD FROM TABLE.

OOALV REPORT:IT IS COMBINATION OF OBJECT ORIENTED AND ABAP LIST VIEWR.
OOPS ALV in SAP ABAP is that is flexible and used to build interactive and modern-designing list.
CREATE STRUCTURE
DECLARE DATA OF BOTH THE STRUCTURE
SELECT OPTION
IN DATA I HAVE USED TWO FUNCTIONS
1.CL_GUI_CUSTOM_CONTAINER
2.CL_ALV_GRID
I HAVE USED EVENT DOUBLE CLICK
CREATE A SCREEN
CREATE OBJECT
EXPORT CONTAINER NAME
CALL METHOD FOR DISPLAY THE DATA.
SET USER COMMAND SY- UCOMM: It is a system variable that holds the current function code associated with user actions. FOR THE BACK BUTTON
USE SUBROUTINES

USED FIELD CATALOG TO SHOW THE FIELDS
SET POSITION
SETFIELD
SETFEILDNAME
THEN USE APPEND
THEN CLEAR
I HAVE DONE THIS PROCEDURE UPTIL MY LAST FIELD

SMARTFORMS:SAP Smart Forms is used to create and maintain forms for mass printing in SAP Systems.
THE TRANSACTION CODE IS SMARTFORM
FIRST GRAPHIC
CREATE MAIN WINDOW
DISPLAY VENDOR DETAILS
WE HAVE TO GIVE HEADER.
MAIN MENU :IN MAIN MENU WE USE TO GET THE DATA OF THE FILEDS FIELD WE ARE ENTERING.
3RD WINDOW FOR TERM AND CONDITON.
FOR VENDORS DETAIL I HAVE USED NEW WINDOW
FOR DISPLAYING THE PAGE NUMBER I USE SFSY-FORMPAGES


THEN WE HAVE DRIVER PROGRAM
SELECT-OPTION FOR SETTING THE RANGE
DECLARE DATA OF IT TABLE TABLE TYPE OF STRUCTUTRES OF ALL TABLES
USE SELECT STATEMENT TO TAKE FIELD NAME FROM THIS TABLE FOR DISPLAYING THE DATA

WE HAVE TO CALL FUNCTION:SSF_FUNCTION _MODULE_NAME
IN THAT EXPORTING WE HAVE TO GIVE SMARTFORMNAME
IN IMPORTING WRITE FM_NAME WHICH WE HAVE DECLARED IN DATA
WE HAVE TO CALL FUNCTIONAL MODULE OF OUR SMARTFORM.
AND EXECUTE SO IT WILL DISPLAY DATA
THERE IS COMMAND LP01 FOR PRINT PREVIEW.

CDS VIEW:CORE DATA SEVICES WE USECDS VIEW TO CONNECT BOTH ABAP AND SQL.WE CAN USE AND REUSE IT
I have joined the three tables in cds lfa1 lfb1 lfm1
A CDS view is defined for existing database tables and views, or for other CDS views in the ABAP Dictionary, using the DEFINE VIEW DDL statement
PARAMETER LIFNR WHICH IS COMMON FIELD

WE HAVE USED EXTENDED VIEW TO ADD SOME FIELDS IN OUR EXISTING TABLE IN MY TABLE I HAVE ADDED FIELD ERNAM,STRAS,EKGRP AND SHOW DATA.

WE HAVE USED EXTENDED VIEW TO ADD SOME FIELDS IN OUR EXISTING TABLE IN MY TABLE I HAVE ADDED FIELD ERNAM,STRAS,EKGRP AND SHOW DATA.

ADBC:ABAP DATABASE CONNECTIVITY
IT IS USED TO MAKE ABAP CONNECTION WITH DATABASE
ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. The ADBC methods can be used to pass Native SQL statements to the database interface. They make it possible to
•send database specific SQL commands to a database system and process the result
•to establish and administer database connections.
CL_SQL_CONNECTION:This class represents a database connection.It allows you to establish and manage connections to a database system (such as SAP HANA).You can use it to connect to the database, execute SQL statements, and retrieve results.CL_SQL_STATEMENT:This class is used for executing SQL statements.It provides methods to prepare, execute, and fetch data from SQL queries.You can use it to create and manage SQL statements dynamically within your ABAP program.CL_SQL_RESULT_SET:This class is used to handle result sets obtained from executed SQL statements.It allows you to retrieve data rows, navigate through the result set, and process the data.
 
IN THIS WE HAVE EXCEPTION HANDLING.

ABAP-Managed Database Procedures.
AMDP is specifically for HANA Database.
AMDP is implemented in ABAP class methods
AMDPs allow you as an ABAP developer to write database procedures directly in ABAP. Special ABAP classes (so-called AMDP classes) can contain embedded code (SQL Script) that is used to generate DB procedures in the SAP HANA DB layer.
WE CREATE GLOBAL CLASS
AND CALL CLASS IN OUR AMDP PROGRAM TO ACCESS DATA.