Notes

GOODMORING SIR,I am Sakshi and from batch sap abap hana 12th dec I AM HERE TO PRESENT MY SPRINT PRESENTATION
HERE IS CONTENT I HAVE……
HERE IS LOGIC REGARDING MY PROJECT IN WHICH I HAVE TO CREATE SELECTION SCREEN OOALV REPORT ,ADOBE FORM,CDS VIEW,ALV_IDA,ADBC,AMDP.
HERE ARE THE DATATABLES WHICH I HAVE CREATED FOR MY PROJECT.VTTK,VTTP,VTTS
DATASET I HAVE FILLED USING TABLE MAINTAINANCE GENERATOR.TMG DATA IS USED to customize the data.
EXECUTABLE PROGRAM FOR MY SELECTION SCREEN IN THIS I
CREATED OOALV REPORT
ADOBEFORM BUTTON AND OOALV BUTTON
CREATED LAYOUT ONE FOR THE CAPGEMINI LOGO AND ONE FOR DISPLAYING THE REPORT SO DATA WILL WE STORE IN THE CONTAINER.
CREATED ONE BACK BUTTON.
THIS IS THE OUTPUT OF THE REPORT.HERE WE TAKE THE RANGE AND AFTER THAT IT DISPLAY THE DATA BETWEEN THE RANGE.
ADOBEFORM:DATA WILL WE SHOW THE DATA IN THE FORM OF PDF.
FIRST WE HAVE TO CREATE INTERFACE
THEN WE HAVE TO CREATE FORM
IN INTERFACE
I HAVEASSIGN PARAMETER NAME TO THE EACH TABLE
I HAVE MADE TABLE TYPE USING STRUCTURE
IN THE FORM I HAD DRAG PARAMETER TO CONTEXT
AND CREATE LAYOUT
IN LAYOUT I HAVE CREATED MAINFORM AND SUBFORM
ADD SAP LOGO.AFTER CREATING LAYOUT
CREATE DRIVER PROGRAM OF ADOBEFORM

JOIN ON THE VTTK VTTP VTTS,
THEN SHOW PARTICULAR FIELD DATA FROM EVERY TABLE.
WE HAVE THREE CALL FUNCTIONS IN ADOBEFORM
FIRST I HAVE CALLED FP_JOB_OPEN
THEN CALL FP_FUNCTION_MODULE_NAME
THEN CALL FP_JOB_CLOSE .
‘DISPLAY OUTPUT USING LP01 FOR PRINT PREVIEW.
ADOBEFORM:DATA WILL WE SHOW THE DATA IN THE FORM OF PDF.
FIRST WE HAVE TO CREATE INTERFACE
THEN WE HAVE TO CREATE FORM
IN INTERFACE
I HAVEASSIGN PARAMETER NAME TO THE EACH TABLE
I HAVE MADE TABLE TYPE USING STRUCTURE
IN THE FORM I HAD DRAG PARAMETER TO CONTEXT
AND CREATE LAYOUT
IN LAYOUT I HAVE CREATED MAINFORM AND SUBFORM
ADD SAP LOGO.AFTER CREATING LAYOUT
CREATE DRIVER PROGRAM OF ADOBEFORM

JOIN ON THE VTTK VTTP VTTS,
THEN SHOW PARTICULAR FIELD DATA FROM EVERY TABLE.
WE HAVE THREE CALL FUNCTIONS IN ADOBEFORM
FIRST I HAVE CALLED FP_JOB_OPEN
THEN CALL FP_FUNCTION_MODULE_NAME
THEN CALL FP_JOB_CLOSE .
‘DISPLAY OUTPUT USING LP01 FOR PRINT PREVIEW.
CDS VIEW:CORE DATA SEVICES WE USE CDS VIEW TO CONNECT BOTH ABAP AND SQL.WE CAN USE AND REUSE IT
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
I have joined the three tables in cds VTTK VTTP VTTS AND THIS IS THE OUTPUT OF THE CDS VIEW.
WE HAVE USED EXTENDED VIEW TO ADD SOME FIELDS IN OUR EXISTING TABLE IN MY TABLE I HAVE ADDED FIELD ROUTE TSRFO ERNAM ERZET AND SHOW DATA.
SALV IDA stands for SAP ABAP LIST VIEWER – INTEGRATED DATA ACCESS
SALV IDA (Integrated Data Access) works more on code push-down concept.
WE CREATE CDS DRIVER PROGRAM AND USE ALV_IDA TO ACCESS THE 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.

IN THIS WE HAVE EXCEPTION HANDLING
ABAP-Managed Database Procedures.
AMDP is specifically for HANA Database.
AMDP is implemented in ABAPclassmethods
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 (SQLScript) 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.