11-27-2007 5:40 AM
hi,
i am the beginner to ABA/4,
i want to learn how to create alv reports .
can u people help me?
11-27-2007 6:02 AM
Hi Sravanthi,
if u want learn theory please go through this website,
http://abapprogramming.blogspot.com/search/label/ALE%20BASICS%20FAQ%27S
Ex:
TYPE-POOLS : SLIS.
TABLES : VBAK.
Internal Table for Sales Document Header Data.
DATA : BEGIN OF I_VBAK OCCURS 0,
VBELN LIKE VBAK-VBELN,
ERNAM LIKE VBAK-ERNAM,
AUDAT LIKE VBAK-AUDAT,
NETWR LIKE VBAK-NETWR,
VKORG LIKE VBAK-VKORG,
VTWEG LIKE VBAK-VTWEG,
SPART LIKE VBAK-SPART,
END OF I_VBAK.
Internal Table for Sales Document Item Data.
DATA : BEGIN OF I_VBAP OCCURS 0,
VBELN LIKE VBAP-VBELN,
POSNR LIKE VBAP-POSNR,
MANTR LIKE VBAP-MATNR,
NETWR LIKE VBAP-NETWR,
LGORT LIKE VBAP-LGORT,
END OF I_VBAP.
Work area and Body for Sales Document Header Data.
DATA : TY_VBAK TYPE ZSVBAK,
T_VBAK TYPE STANDARD TABLE OF ZSVBAK.
Object Reference for the ZCLASS_VBAK.
DATA : OBJ TYPE REF TO ZCLASS_VBAK.
For Fieldcatalog, Top of Page, and Layout.
DATA : FIELD TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,
FIELD1 TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,
TOP TYPE SLIS_T_LISTHEADER WITH HEADER LINE,
TOP1 TYPE SLIS_T_LISTHEADER WITH HEADER LINE,
LAYOUT TYPE SLIS_LAYOUT_ALV.
For get Select options lower and Higher Values.
DATA : L_VBELN TYPE VBELN_VA,
H_VBELN TYPE VBELN_VA.
Selection screen Declarations.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-000.
SELECT-OPTIONS S_VBELN FOR VBAK-VBELN.
SELECTION-SCREEN END OF BLOCK B1.
values move to temp variable from select-options table fields.
L_VBELN = S_VBELN-LOW.
H_VBELN = S_VBELN-HIGH.
Initialization event
INITIALIZATION.
Assign Values to top page internal tables.
TOP-TYP = 'H'.
TOP-INFO = 'Sales Document Details'.
APPEND TOP.
CLEAR TOP.
TOP1-TYP = 'H'.
TOP1-INFO = 'Sales Document Item Details'.
APPEND TOP1.
CLEAR TOP1.
Start of selection Event.
START-OF-SELECTION.
Object creation for ZCLASS_VBAK.
CREATE OBJECT obj.
SELECT VBELN
ERNAM
AUDAT
NETWR
VKORG
VTWEG
SPART FROM VBAK INTO TABLE I_VBAK
WHERE VBELN BETWEEN L_VBELN AND H_VBELN.
Values moves to I_VBAK from T_VBAK.
MOVE T_VBAK[] TO I_VBAK[].
To call field, Layout, Display Subroutines.
PERFORM FIELD.
PERFORM LAYOUT.
PERFORM DISPLAY.
Definition for top subroutine.
FORM TOP.
To call REUSE_ALV_COMMENTARY_WITE function module,
and Pass the top internal table and logo name.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
it_list_commentary = TOP[]
I_LOGO = 'LOGO'
I_END_OF_LIST_GRID =
I_ALV_FORM =
.
ENDFORM.
&----
*& Form LAYOUT
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Layout subroutines.
form LAYOUT .
Enable the Layout field Zebra.
LAYOUT-ZEBRA = 'X'.
endform. " LAYOUT
&----
*& Form FIELD
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Field Subroutine.
form FIELD .
To call a REUSE_ALV_FIELDCATALOG_MERGE function module, and Pass
Program name, Internal table name, and Include name, and get
fieldcatalog internal table.
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
EXPORTING
I_PROGRAM_NAME = SY-REPID
I_INTERNAL_TABNAME = 'I_VBAK'
I_STRUCTURE_NAME =
I_CLIENT_NEVER_DISPLAY = 'X'
I_INCLNAME = SY-REPID
I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =
CHANGING
ct_fieldcat = FIELD[]
EXCEPTIONS
INCONSISTENT_INTERFACE = 1
PROGRAM_ERROR = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
endform. " FIELD
&----
*& Form DISPLAY
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Display subroutine.
form DISPLAY .
To call a REUSE_ALV_GRID_DISPLAY function module, Pass
callback_program, pf_status subroutine, user_command sobroutine, top-of-page subroutine,
layout, and Field catalog internal tables, and get
Sales document Header Data details.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '
I_CALLBACK_PROGRAM = 'ZCLASS_VBAK01'
I_CALLBACK_PF_STATUS_SET = 'STATUS'
I_CALLBACK_USER_COMMAND = 'SECOND'
I_CALLBACK_TOP_OF_PAGE = 'TOP'
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '
I_GRID_TITLE =
I_GRID_SETTINGS =
IS_LAYOUT = LAYOUT
IT_FIELDCAT = FIELD[]
IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP = 0
I_HTML_HEIGHT_END = 0
IT_ALV_GRAPHICS =
IT_HYPERLINK =
IT_ADD_FIELDCAT =
IT_EXCEPT_QINFO =
IR_SALV_FULLSCREEN_ADAPTER =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =
TABLES
t_outtab = I_VBAK[]
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
endform. " DISPLAY
Definition for Status subroutine.
FORM STATUS USING EXTAB TYPE SLIS_T_EXTAB.
Set pf status value.
SET PF-STATUS 'SALES' EXCLUDING EXTAB.
ENDFORM.
Definition for secondary list subroutine.
FORM SECOND USING OK_CODE LIKE SY-UCOMM SELFIELD TYPE SLIS_SELFIELD.
Check the function code using case statement.
CASE OK_CODE.
WHEN '&IC1'.
DATA : V_VBELN TYPE VBELN_VA.
Check the Clicked field name with VBELN and if its true then move value
to V_VBELN Variable.
IF SELFIELD-FIELDNAME = 'VBELN'.
V_VBELN = SELFIELD-VALUE.
DATA : V_VBELN(10) TYPE N.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = VBELN
IMPORTING
OUTPUT = V_VBELN
.
SELECT VBELN
POSNR
MATNR
NETWR FROM VBAP INTO CORRESPONDING FIELDS OF TABLE I_VBAP
WHERE VBELN = V_VBELN.
IF SY-SUBRC = 0.
To call REUSE_ALV_FIELDCATALOG_MERGE function module .
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
EXPORTING
I_PROGRAM_NAME = SY-REPID
I_INTERNAL_TABNAME = 'I_VBAP'
I_STRUCTURE_NAME =
I_CLIENT_NEVER_DISPLAY = 'X'
I_INCLNAME = SY-REPID
I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =
CHANGING
ct_fieldcat = FIELD1[]
EXCEPTIONS
INCONSISTENT_INTERFACE = 1
PROGRAM_ERROR = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
To call REUSE_ALV_GRID_DISPLAY function module, and pass
callback_program, pf_status, user_command, top-of-page,
layout, fieldcatalog internal tables and
get Sales Document Item Details.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '
I_CALLBACK_PROGRAM = 'ZCLASS_VBAK01'
I_CALLBACK_PF_STATUS_SET = ''
I_CALLBACK_USER_COMMAND = ''
I_CALLBACK_TOP_OF_PAGE = 'TOP1'
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '
I_GRID_TITLE =
I_GRID_SETTINGS =
IS_LAYOUT = LAYOUT
IT_FIELDCAT = FIELD1[]
IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP = 0
I_HTML_HEIGHT_END = 0
IT_ALV_GRAPHICS =
IT_HYPERLINK =
IT_ADD_FIELDCAT =
IT_EXCEPT_QINFO =
IR_SALV_FULLSCREEN_ADAPTER =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =
TABLES
t_outtab = I_VBAP[]
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
ENDIF.
ENDIF.
ENDCASE.
ENDFORM.
Definition for top subroutine .
FORM TOP1.
To call REUSE_ALV_COMMENTARY_WRITE function module, and pass
commentary, and logo values.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
it_list_commentary = TOP1[]
I_LOGO = 'LOGO'
I_END_OF_LIST_GRID =
I_ALV_FORM =
.
ENDFORM.
Regards,
Vijay
11-27-2007 6:01 AM
Hi Sravanthi
WELCOME TO SDN COMMUNITY
For beginners
if u have got access to R/3 system.. check transaction ABAPDOCU..
Go for Siemens material. Check the following link:
http://www.sapbrainsonline.com/TUTORIALS/TECHNICAL/ABAP_tutorial.html
http://sapabap.iespana.es/sapabap/manuales/learnabap/
Use function module ABAP_DOCU_DOWNLOAD..
This will download 1100 documents to your local drive .
Please check also the foll links to start learning ABAP.
http://www.sappoint.com/abap.html
http://cma.zdnet.com/book/abap/index.htm
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm
U can also get help from below links
Please chk the below links
This is link from SAP about ABAP certification
http://www50.sap.com/useducation/certification/curriculum.asp?rid=351
http://www.sapteched.com/india/confactivities/certexam.htm
http://www50.sap.com/useducation/certification/curriculum.asp?rid=351
There is a pdf called ABAP certification.
http://www.esnips.com/web/SAP-ABAP?
You can try www.sapdoamin.com
They provide Certification simulation questions which are very useful and a must try site.
Have a look at below link for mySAP Technology - ABAP Workbench
https://websmp206.sap-ag.de/~sapidp/011000358700000746472003E
Have a look at below link for SAP NetWeaver - ABAP Workbench
http://www30.sap.com/hk/services/education/pdf/cert/ABAPWB.pdf
http://www.sap-img.com/ab040.htm
this is link from SAP about ABAP certification
http://www50.sap.com/useducation/certification/curriculum.asp?rid=351
ABAP Materials
http://sapabap.iespana.es/sapabap/manuales/learnabap/
http://help.sap.com/saphelp_nw2004s/helpdata/en/43/41341147041806e10000000a1553f6/frameset.htm
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm
http://www.geocities.com/victorav15/sapr3/abapfun.html
http://www.sapgenie.com/abap/index.htm
http://www.sap-img.com/abap.htm
http://www.sapdevelopment.co.uk/tips/tipshome.htm
http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm
http://sap.ittoolbox.com/nav/t.asp?t=322&p=322&h1=322
http://sap.ittoolbox.com/nav/t.asp?t=448&p=448&h1=448
http://www.kabai.com/abaps/q.htm
http://www.geocities.com/mpioud/Abap_programs.html
http://www.sapgenie.com/abap/tips_and_tricks.htm
http://www.sapassist.com/code/d.asp?whichpage=1&pagesize=10&i=10&a=c&o=&t=&q=&qt=
In this link You can find Step by Step Scren Shot document :
http://www.201interviewquestions.com/docs/User%20exits.ppt
http://erpgenie.com/abaptips/component/option,com_docman/task,doc_details/gid,27/
Reprots
http://www.sapgenie.com/abap/reports.htm
http://www.allsaplinks.com/material.html
http://www.sapdevelopment.co.uk/reporting/reportinghome.htm
http://www.sapfans.com/forums/viewtopic.php?t=58286
http://www.sapfans.com/forums/viewtopic.php?t=76490
http://www.sapfans.com/forums/viewtopic.php?t=20591
http://www.sapfans.com/forums/viewtopic.php?t=66305 - this one discusses which way should you use - ABAP Objects calls or simple function modules.
Dictionary
http://sapabap.iespana.es/sapabap/manuales/learnabap/
http://help.sap.com/saphelp_nw2004s/helpdata/en/43/41341147041806e10000000a1553f6/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf
ABAP objects
Please check this online document (starting page 1291).
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCABA/BCABA.pdf
Also check this links as well.
http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/b518b6513611d194a50000e8353423/frameset.htm
http://www.sapgenie.com/abap/OO/
http://www.futureobjects.de/content/intro_oo_e.html
http://www.sap-img.com/abap/business-add-in-you-need-to-understand-abap-oo-interface-concept.htm
/people/ravikumar.allampallam/blog/2005/02/11/abap-oo-in-action
SAPScripts
http://esnips.com/doc/1ff9f8e8-0a4c-42a7-8819-6e3ff9e7ab44/sapscripts.pdf
http://esnips.com/doc/1e487f0c-8009-4ae1-9f9c-c07bd953dbfa/script-command.pdf
http://esnips.com/doc/64d4eccb-e09b-48e1-9be9-e2818d73f074/faqss.pdf
http://esnips.com/doc/cb7e39b4-3161-437f-bfc6-21e6a50e1b39/sscript.pdf
http://esnips.com/doc/fced4d36-ba52-4df9-ab35-b3d194830bbf/symbols-in-scripts.pdf
SAP SCRIPT FIELDS
http://help.sap.com/saphelp_erp2005vp/helpdata/en/d1/8033ea454211d189710000e8322d00/content.htm
scripts easy material
http://www.allsaplinks.com/sap_script_made_easy.html
Check these step-by-step links
for Smartforms material
http://www.sap-basis-abap.com/sapsf001.htm
http://www.sap-press.com/downloads/h955_preview.pdf
http://www.ossincorp.com/Black_Box/Black_Box_2.htm
http://www.sap-img.com/smartforms/sap-smart-forms.htm
http://www.sap-img.com/smartforms/smartform-tutorial.htm
http://www.sapgenie.com/abap/smartforms.htm
How to trace smartform
http://help.sap.com/saphelp_47x200/helpdata/en/49/c3d8a4a05b11d5b6ef006094192fe3/frameset.htm
http://www.help.sap.com/bp_presmartformsv1500/DOCU/OVIEW_EN.PDF
http://www.sap-img.com/smartforms/smart-006.htm
http://www.sap-img.com/smartforms/smartforms-faq-part-two.htm
check most imp link
http://www.sapbrain.com/ARTICLES/TECHNICAL/SMARTFORMS/smartforms.html
step by step good ex link is....
BAPI
http://help.sap.com/saphelp_46c/helpdata/en/9b/417f07ee2211d1ad14080009b0fb56/frameset.htm
http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html
Checkout !!
http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci948835,00.html
http://techrepublic.com.com/5100-6329-1051160.html#
http://www.sap-img.com/bapi.htm
http://www.sap-img.com/abap/bapi-conventions.htm
http://www.sappoint.com/abap/bapiintro.pdf
http://www.sapgenie.com/abap/bapi/example.htm
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCMIDAPII/CABFAAPIINTRO.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CABFABAPIREF/CABFABAPIPG.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE8/BCFESDE8.pdf
List of all BAPIs
http://www.planetsap.com/LIST_ALL_BAPIs.htm
http://www.sappoint.com/abap/bapiintro.pdf
http://www.sappoint.com/abap/bapiprg.pdf
http://www.sappoint.com/abap/bapiactx.pdf
http://www.sappoint.com/abap/bapilst.pdf
http://www.sappoint.com/abap/bapiexer.pdf
http://www.planetsap.com/Bapi_main_page.htm
http://www.topxml.com/sap/sap_idoc_xml.asp
http://www.sapdevelopment.co.uk/
http://www.sapdevelopment.co.uk/java/jco/bapi_jco.pdf
ALV programs.
http://www.geocities.com/mpioud/Abap_programs.html
. How do I program double click in ALV?
http://www.sapfans.com/forums/viewtopic.php?t=11601
http://www.sapfans.com/forums/viewtopic.php?t=23010
How can I use ALV for reports that are going to be run in background?
http://www.sapfans.com/forums/viewtopic.php?t=83243
http://www.sapfans.com/forums/viewtopic.php?t=19224
ALV
http://www.sapfans.com/forums/viewtopic.php?t=58286
http://www.sapfans.com/forums/viewtopic.php?t=76490
http://www.sapfans.com/forums/viewtopic.php?t=20591
http://www.sapfans.com/forums/viewtopic.php?t=66305 - http://www.sapgenie.com/abap/reports.htm
http://www.allsaplinks.com/material.html
http://www.sapdevelopment.co.uk/reporting/reportinghome.htm
Top-of-page in ALV
ALV Group Heading
http://www.sap-img.com/fu037.htm
ALV
http://www.geocities.com/mpioud/Abap_programs.html
RFC Destination
ALE/ IDOC
http://help.sap.com/saphelp_erp2004/helpdata/en/dc/6b835943d711d1893e0000e8323c4f/content.htm
http://www.sapgenie.com/sapgenie/docs/ale_scenario_development_procedure.doc
http://www.netweaverguru.com/EDI/HTML/IDocBook.htm
http://www.sapgenie.com/sapedi/index.htm
http://www.sappoint.com/abap/ale.pdf
http://www.sappoint.com/abap/ale2.pdf
http://www.sapgenie.com/sapedi/idoc_abap.htm
http://www.allsaplinks.com/idoc_sample.html
http://www.sappoint.com/abap.html
http://www.netweaverguru.com/EDI/HTML/IDocBook.htm
http://www.sapgenie.com/sapedi/index.htm
http://www.allsaplinks.com/idoc_sample.html
Table Control
ABAP transactions
http://www.easymarketplace.de/transactions-a-e.php?Area=4soi&name=volker&pw=vg&;
www.sap-basis-abap.com/books.htm
http://www.abovesoft.com/start.html
http://www.sappoint.com/abap.html
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/ranges.htm
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/ranges.htm
http://www.sapdevelopment.co.uk/
http://www.geocities.com/victorav15/sapr3/abapfun.html
http://sapr3.tripod.com/abap011.htm
http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3df8358411d1829f0000e829fbfe/frameset.htm
http://www.geocities.com/sap_interviewquestions/
http://itcompleteguide.tripod.com/sap.html
http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3df8358411d1829f0000e829fbfe/frameset.htm
http://www.geocities.com/sap_interviewquestions/
http://itcompleteguide.tripod.com/sap.html
http://cma.zdnet.com/book/abap/index.htm
http://www.sapdevelopment.co.uk/
http://juliet.stfx.ca/people/fac/infosys/abap.htm
http://help.sap.com/saphelp_46c/helpdata/en/d3/2e974d35c511d1829f0000e829fbfe/frameset.htm
http://help.sap.com/saphelp_46c/helpdata/en/d6/0db357494511d182b70000e829fbfe/frameset.htm
http://www.henrikfrank.dk/abapexamples/SapScript/sapscript.htm
http://www.sapgenie.com/abap/example_code.htm
http://www.geocities.com/SiliconValley/Campus/6345/abapindx.htm
http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm
http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm
http://www.sap-img.com/abap-function.htm
http://www.sapgenie.com/abap/code/abap19.htm
http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm
http://www.planetsap.com/Tips_and_Tricks.htm
http://help.sap.com/saphelp_40b/helpdata/ru/d6/0dc169494511d182b70000e829fbfe/applet.htm
http://www.henrikfrank.dk/abapexamples/SapScript/symbols.htm
http://www.henrikfrank.dk/abapexamples/index.html
http://sap.ittoolbox.com/documents/document.asp?i=752
http://members.aol.com/_ht_a/skarkada/sap/
http://members.tripod.com/abap4/SAP_Functions.html
http://members.ozemail.com.au/~anmari/sap/index.html
http://www.planetsap.com/Userexit_List.htm
http://www.planetsap.com/Tips_and_Tricks.htm
http://www.kabai.com/abaps/q.htm
http://www.planetsap.com/Userexit_List.htm
http://help.sap.com/saphelp_bw21c/helpdata/en/c4/3a8090505211d189550000e829fbbd/frameset.htm
http://www.sapgenie.com/abap/bapi/example.htm
http://help.sap.com/saphelp_45b/helpdata/en/65/897415dc4ad111950d0060b03c6b76/content.htm
http://www.sap-basis-abap.com/index.htm
http://help.sap.com/saphelp_40b/helpdata/en/fc/eb2c46358411d1829f0000e829fbfe/frameset.htm
http://help.sap.com/saphelp_46c/helpdata/en/aa/aeb23789e95378e10000009b38f8cf/frameset.htm
http://www.geocities.com/ResearchTriangle/1635/system.html
http://www.sapdesignguild.org/resources/MiniSG/3_Managing/3_Functions_Table_Control.htm
http://help.sap.com/saphelp_45b/helpdata/en/d1/801bdf454211d189710000e8322d00/content.htm
http://www.sapfans.com/sapfans/repos/saprep.htm
http://www.planetsap.com/howdo_a.htm
http://help.sap.com/saphelp_util464/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm
http://www.sapgenie.com/abap/smartforms_detail.htm
http://www.sap-img.com/abap.htm
http://help.sap.com/saphelp_46c/helpdata/en/fc/eb2d67358411d1829f0000e829fbfe/content.htm
http://www.geocities.com/victorav15/sapr3/abap.html
http://www.henrikfrank.dk/abapexamples/SapScript/sapscript.htm
http://abap4.tripod.com/Other_Useful_Tips.html
http://help.sap.com/saphelp_45b/helpdata/en/cf/21ee2b446011d189700000e8322d00/content.htm
http://www.sap-basis-abap.com/sapmm.htm
http://sap.ittoolbox.com/nav/t.asp?t=303&p=448&h1=303&h2=322&h3=448
http://cma.zdnet.com/book/abap/ch03/ch03.htm
http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm
http://www.henrikfrank.dk/abapuk.html
http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm
http://www.sapgenie.com/abap/index.htm
http://www.sap-img.com/abap.htm
http://www.sapdevelopment.co.uk/tips/tipshome.htm
http://help.sap.com/printdocu/core/Print46c/en/Data/Index_en.htm
http://sap.ittoolbox.com/nav/t.asp?t=322&p=322&h1=322
http://sap.ittoolbox.com/nav/t.asp?t=448&p=448&h1=448
http://www.kabai.com/abaps/q.htm
http://www.geocities.com/mpioud/Abap_programs.html
http://www.sapgenie.com/abap/tips_and_tricks.htm
http://www.sapassist.com/code/d.asp?whichpage=1&pagesize=10&i=10&a=c&o=&t=&q=&qt=
For FAQ
http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm
http://www.sapgenie.com/faq/abap.htm
Check this sample coding part
*&---------------------------------------------------------------------*
*& Report ZALVTOTAL *
*& *
*&---------------------------------------------------------------------*
*& *
*& *
*&---------------------------------------------------------------------*
REPORT ZALVTOTAL .
TYPES :
BEGIN OF ty_vbak,
vkorg TYPE vbak-vkorg, " Sales organization
kunnr TYPE vbak-kunnr, " Sold-to party
vbeln TYPE vbak-vbeln, " Sales document
netwr TYPE vbak-netwr, " Net Value of the Sales Order
waerk TYPE vbak-waerk, " Document currency
END OF ty_vbak.
DATA:
vbak TYPE vbak,
gt_vbak TYPE TABLE OF ty_vbak.
SELECT-OPTIONS :
s_vkorg FOR vbak-vkorg, " Sales organization
s_kunnr FOR vbak-kunnr, " Sold-to party
s_vbeln FOR vbak-vbeln. " Sales document
SELECTION-SCREEN :
SKIP, BEGIN OF LINE,COMMENT 5(27) v_1 FOR FIELD p_max.
PARAMETERS p_max(2) TYPE n DEFAULT '20' OBLIGATORY.
SELECTION-SCREEN END OF LINE.
*---------------------------------------------------------------------*
INITIALIZATION.
v_1 = 'Maximum of records to read'.
*---------------------------------------------------------------------*
START-OF-SELECTION.
PERFORM f_read_data.
PERFORM f_display_data.
*---------------------------------------------------------------------*
* Form f_read_data
*---------------------------------------------------------------------*
FORM f_read_data.
SELECT vkorg kunnr vbeln netwr waerk
UP TO p_max ROWS
INTO TABLE gt_vbak
FROM vbak
WHERE kunnr IN s_kunnr
AND vbeln IN s_vbeln
AND vkorg IN s_vkorg.
ENDFORM. " F_READ_DATA
*---------------------------------------------------------------------*
* Form f_display_data
*---------------------------------------------------------------------*
FORM f_display_data.
TYPE-POOLS: slis. " ALV Global types
DEFINE m_fieldcat.
add 1 to ls_fieldcat-col_pos.
ls_fieldcat-fieldname = &1.
ls_fieldcat-ref_tabname = 'VBAK'.
ls_fieldcat-do_sum = &2.
ls_fieldcat-cfieldname = &3.
append ls_fieldcat to lt_fieldcat.
END-OF-DEFINITION.
DEFINE m_sort.
add 1 to ls_sort-spos.
ls_sort-fieldname = &1.
ls_sort-up = 'X'.
ls_sort-subtot = &2.
append ls_sort to lt_sort.
END-OF-DEFINITION.
DATA:
ls_fieldcat TYPE slis_fieldcat_alv,
lt_fieldcat TYPE slis_t_fieldcat_alv,
lt_sort TYPE slis_t_sortinfo_alv,
ls_sort TYPE slis_sortinfo_alv,
ls_layout TYPE slis_layout_alv.
m_fieldcat 'VKORG' '' ''.
m_fieldcat 'KUNNR' '' ''.
m_fieldcat 'VBELN' '' ''.
m_fieldcat 'NETWR' 'X' 'WAERK'.
m_fieldcat 'WAERK' '' ''.
m_sort 'VKORG' 'X'. " Sort by vkorg and subtotal
m_sort 'KUNNR' 'X'. " Sort by kunnr and subtotal
m_sort 'VBELN' ''. " Sort by vbeln
ls_layout-cell_merge = 'X'.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
is_layout = ls_layout
it_fieldcat = lt_fieldcat
it_sort = lt_sort
TABLES
t_outtab = gt_vbak.
ENDFORM. " F_DISPLAY_DATA
Regards
Pavan
11-27-2007 6:02 AM
Hi Sravanthi,
if u want learn theory please go through this website,
http://abapprogramming.blogspot.com/search/label/ALE%20BASICS%20FAQ%27S
Ex:
TYPE-POOLS : SLIS.
TABLES : VBAK.
Internal Table for Sales Document Header Data.
DATA : BEGIN OF I_VBAK OCCURS 0,
VBELN LIKE VBAK-VBELN,
ERNAM LIKE VBAK-ERNAM,
AUDAT LIKE VBAK-AUDAT,
NETWR LIKE VBAK-NETWR,
VKORG LIKE VBAK-VKORG,
VTWEG LIKE VBAK-VTWEG,
SPART LIKE VBAK-SPART,
END OF I_VBAK.
Internal Table for Sales Document Item Data.
DATA : BEGIN OF I_VBAP OCCURS 0,
VBELN LIKE VBAP-VBELN,
POSNR LIKE VBAP-POSNR,
MANTR LIKE VBAP-MATNR,
NETWR LIKE VBAP-NETWR,
LGORT LIKE VBAP-LGORT,
END OF I_VBAP.
Work area and Body for Sales Document Header Data.
DATA : TY_VBAK TYPE ZSVBAK,
T_VBAK TYPE STANDARD TABLE OF ZSVBAK.
Object Reference for the ZCLASS_VBAK.
DATA : OBJ TYPE REF TO ZCLASS_VBAK.
For Fieldcatalog, Top of Page, and Layout.
DATA : FIELD TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,
FIELD1 TYPE SLIS_T_FIELDCAT_ALV WITH HEADER LINE,
TOP TYPE SLIS_T_LISTHEADER WITH HEADER LINE,
TOP1 TYPE SLIS_T_LISTHEADER WITH HEADER LINE,
LAYOUT TYPE SLIS_LAYOUT_ALV.
For get Select options lower and Higher Values.
DATA : L_VBELN TYPE VBELN_VA,
H_VBELN TYPE VBELN_VA.
Selection screen Declarations.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-000.
SELECT-OPTIONS S_VBELN FOR VBAK-VBELN.
SELECTION-SCREEN END OF BLOCK B1.
values move to temp variable from select-options table fields.
L_VBELN = S_VBELN-LOW.
H_VBELN = S_VBELN-HIGH.
Initialization event
INITIALIZATION.
Assign Values to top page internal tables.
TOP-TYP = 'H'.
TOP-INFO = 'Sales Document Details'.
APPEND TOP.
CLEAR TOP.
TOP1-TYP = 'H'.
TOP1-INFO = 'Sales Document Item Details'.
APPEND TOP1.
CLEAR TOP1.
Start of selection Event.
START-OF-SELECTION.
Object creation for ZCLASS_VBAK.
CREATE OBJECT obj.
SELECT VBELN
ERNAM
AUDAT
NETWR
VKORG
VTWEG
SPART FROM VBAK INTO TABLE I_VBAK
WHERE VBELN BETWEEN L_VBELN AND H_VBELN.
Values moves to I_VBAK from T_VBAK.
MOVE T_VBAK[] TO I_VBAK[].
To call field, Layout, Display Subroutines.
PERFORM FIELD.
PERFORM LAYOUT.
PERFORM DISPLAY.
Definition for top subroutine.
FORM TOP.
To call REUSE_ALV_COMMENTARY_WITE function module,
and Pass the top internal table and logo name.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
it_list_commentary = TOP[]
I_LOGO = 'LOGO'
I_END_OF_LIST_GRID =
I_ALV_FORM =
.
ENDFORM.
&----
*& Form LAYOUT
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Layout subroutines.
form LAYOUT .
Enable the Layout field Zebra.
LAYOUT-ZEBRA = 'X'.
endform. " LAYOUT
&----
*& Form FIELD
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Field Subroutine.
form FIELD .
To call a REUSE_ALV_FIELDCATALOG_MERGE function module, and Pass
Program name, Internal table name, and Include name, and get
fieldcatalog internal table.
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
EXPORTING
I_PROGRAM_NAME = SY-REPID
I_INTERNAL_TABNAME = 'I_VBAK'
I_STRUCTURE_NAME =
I_CLIENT_NEVER_DISPLAY = 'X'
I_INCLNAME = SY-REPID
I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =
CHANGING
ct_fieldcat = FIELD[]
EXCEPTIONS
INCONSISTENT_INTERFACE = 1
PROGRAM_ERROR = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
endform. " FIELD
&----
*& Form DISPLAY
&----
text
----
--> p1 text
<-- p2 text
----
Definition for Display subroutine.
form DISPLAY .
To call a REUSE_ALV_GRID_DISPLAY function module, Pass
callback_program, pf_status subroutine, user_command sobroutine, top-of-page subroutine,
layout, and Field catalog internal tables, and get
Sales document Header Data details.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '
I_CALLBACK_PROGRAM = 'ZCLASS_VBAK01'
I_CALLBACK_PF_STATUS_SET = 'STATUS'
I_CALLBACK_USER_COMMAND = 'SECOND'
I_CALLBACK_TOP_OF_PAGE = 'TOP'
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '
I_GRID_TITLE =
I_GRID_SETTINGS =
IS_LAYOUT = LAYOUT
IT_FIELDCAT = FIELD[]
IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP = 0
I_HTML_HEIGHT_END = 0
IT_ALV_GRAPHICS =
IT_HYPERLINK =
IT_ADD_FIELDCAT =
IT_EXCEPT_QINFO =
IR_SALV_FULLSCREEN_ADAPTER =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =
TABLES
t_outtab = I_VBAK[]
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
endform. " DISPLAY
Definition for Status subroutine.
FORM STATUS USING EXTAB TYPE SLIS_T_EXTAB.
Set pf status value.
SET PF-STATUS 'SALES' EXCLUDING EXTAB.
ENDFORM.
Definition for secondary list subroutine.
FORM SECOND USING OK_CODE LIKE SY-UCOMM SELFIELD TYPE SLIS_SELFIELD.
Check the function code using case statement.
CASE OK_CODE.
WHEN '&IC1'.
DATA : V_VBELN TYPE VBELN_VA.
Check the Clicked field name with VBELN and if its true then move value
to V_VBELN Variable.
IF SELFIELD-FIELDNAME = 'VBELN'.
V_VBELN = SELFIELD-VALUE.
DATA : V_VBELN(10) TYPE N.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = VBELN
IMPORTING
OUTPUT = V_VBELN
.
SELECT VBELN
POSNR
MATNR
NETWR FROM VBAP INTO CORRESPONDING FIELDS OF TABLE I_VBAP
WHERE VBELN = V_VBELN.
IF SY-SUBRC = 0.
To call REUSE_ALV_FIELDCATALOG_MERGE function module .
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
EXPORTING
I_PROGRAM_NAME = SY-REPID
I_INTERNAL_TABNAME = 'I_VBAP'
I_STRUCTURE_NAME =
I_CLIENT_NEVER_DISPLAY = 'X'
I_INCLNAME = SY-REPID
I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE =
CHANGING
ct_fieldcat = FIELD1[]
EXCEPTIONS
INCONSISTENT_INTERFACE = 1
PROGRAM_ERROR = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
To call REUSE_ALV_GRID_DISPLAY function module, and pass
callback_program, pf_status, user_command, top-of-page,
layout, fieldcatalog internal tables and
get Sales Document Item Details.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '
I_CALLBACK_PROGRAM = 'ZCLASS_VBAK01'
I_CALLBACK_PF_STATUS_SET = ''
I_CALLBACK_USER_COMMAND = ''
I_CALLBACK_TOP_OF_PAGE = 'TOP1'
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '
I_GRID_TITLE =
I_GRID_SETTINGS =
IS_LAYOUT = LAYOUT
IT_FIELDCAT = FIELD1[]
IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =
IT_EVENTS =
IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP = 0
I_HTML_HEIGHT_END = 0
IT_ALV_GRAPHICS =
IT_HYPERLINK =
IT_ADD_FIELDCAT =
IT_EXCEPT_QINFO =
IR_SALV_FULLSCREEN_ADAPTER =
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =
TABLES
t_outtab = I_VBAP[]
EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
ENDIF.
ENDIF.
ENDCASE.
ENDFORM.
Definition for top subroutine .
FORM TOP1.
To call REUSE_ALV_COMMENTARY_WRITE function module, and pass
commentary, and logo values.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
it_list_commentary = TOP1[]
I_LOGO = 'LOGO'
I_END_OF_LIST_GRID =
I_ALV_FORM =
.
ENDFORM.
Regards,
Vijay
11-27-2007 6:05 AM
Hi
goto this site here will find all ALV programs with screen shots
http://www.sapdev.co.uk/reporting/alvhome.htm
TREE ALV
http://www.sapdev.co.uk/reporting/alv/alvtree.htm
http://www.sapdev.co.uk/reporting/alv/alvgrid.htm
<b>Reward if usefull</b>
11-27-2007 6:06 AM
11-27-2007 6:11 AM
Hi
Leave your mail id here so that i can forward you some documents
Regards
Pavan