Urgent Coding help required

[Former Member]

Hi Gurus,

I am new to sap abap.please give me coding examples of proper select queries used to extract data from database tables and methods to create function modules(Please do not give me PPT's)....also if u can help me with links for isu related materials like tcodes and standard programs and function modules it would be great.

You can also mail it to me at anandkk99@gmail.com.

P.S. all replies will be rewarded.

[Former Member]

Hi,

Please refer to the documentation of SELECT under:

http://www.sapdb.org/7.4/htmhelp/40/1312152fa511d3a98100a0c9449261/content.htm

Regards,

Renjith Michael.

[Former Member]

Hi

i will forward onr template program to u r mail check it out it contains how to write proper slecet quiries conditions checking for every statement etc etc,,

plzz reward if u find it is usefull to u

[Former Member]

hi anand,

EXAMPLES OF SELECT QUERIES:

a. selecting particular fields from database table to internal table.

select ebeln ebelp matnr txz01 menge meins netpr into corresponding fields of table IT_ITAB from EKPO

where ebeln in s_ebeln.

endselect.

b. selecting a single row from database table to internal table.

select single * into corresponding fields of it_itab1 from ekko where ebeln in s_ebeln .

When ur using 'select single ' , there is no need for endselect.

press F1 on select statement and u will get all syntax's which might help u

Syntax :

SELECT result

FROM source

INTO|APPENDING target

[[FOR ALL ENTRIES IN itab] WHERE sql_cond]

[GROUP BY group] [HAVING group_cond]

[ORDER BY sort_key].

...

[ENDSELECT].

I WILL MAIL ALL THE MATERIAL WHICH WILL DEFINITELY HELP U

thanks and regards

suma sailaja pvn

[Former Member]

hi anand,

commonly used tcodes are:

1. Developing

S001 Abap Workbench

SE09 Workbenche organizer (Transports)

SE11 ABAP/4 Dictionary

SE16 Data browser

SE24 Class builder

SE30 ABAP Runtime analyzes

SE32 ABAP/4 Text Element Maintenance

SE35 ABAP/4 Dialog Modules Maintenance

SE36 Logical Databases

SE37 Function builder

SE38 ABAP/4 Editor

SE39 Program Comparison

SE41 Menu Painter

SE43 Area Menu editor

SE48 Call hierarchy

SE49 Program analysis: Table Manipulation

SE51 Screen Painter: Initial Screen.

SE55 Table maintenance dialog

SE80 Repository browser

SE91 Message Classes

SE93 Maintain transaction

SHDB Batch input recorder

SM30 Maintain table views

SM35 Monitor batch input

ST22 Short dump analysis

2. Monitoring

ST05 SQL Trace

ST07 Application monitor

3.System

SM04 User overview ( Possible to end sessions)

SM12 Table lock Entries

SM21 System log for viewing dumps

SM36 Define background jobs

SM37 View background jobs

SM50 Process Overview

SU53 Display Authorization Values for User

SLG1 View application log

SLG2 Delete application log

SPAD Output devices

SP01 See spool

4. SapScript

SE71 Form painter

SE72 Style maintenance

SE73 SAPscript font maintenance.

SE74 SAPscript format conversion

SE75 SAPscript Settings

SE76 SAPscript Form Translation

SE77 SAPscript Style Conversion

SE78 SapScript Graphics Management

SO10 Create standard text module

5. Workflow

SWDM Workflow explorer

SWDD Workflow builder

SWUS Start workflow - Test enviromnent

SWU0 Simulate event

SBWP Business workplace

PFTC_INS Create Task/Task group

PFTC_CHG Change Task/Task group

SWUD Dagnosis

SWI1 Work item selection

6. Enhancements and modifications

CMOD Enhancementprojects

SMOD List SAP enhancements to use in CMOD

SHD0 Transaction variant maintenance

thanks and regards

suma sailaja pvn