You use ST05, Trace Request, to do a SQL trace.

When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another session and turn the trace on.

After, or when, the SQL is finished, you can turn the trace off.

Then click on List Trace to see the details.

This is the way to control the traces.

What is the difference betwen abap and sap memories?

Data sending between internal sessions is called abap memory using import and export parameters.
Data sending between main sessions using spa/gpa ie (set /get) parameters called sap memory.

2) What is nast?
nast is a message status database table.

3) How to upload logo in sapscripts?
1... create a logo using paint shop and save it as tifffile then using RSTXLDMC (is a program name) used to upload logo
2.....create a logo using paint shop and save it as bmpfile then using SE78 you can do this.

4) What are symbols explain?
Symbols are constants used to save un nessessary work used in documentation
1. system symbols : example: &date& &time& etc
2. text symbols: they are defined using control statements
protect...endprotect, if endif, etc
3. standard symbols : all the messages are stored in TTDTG table
4. program symbols : used in abap program example: &i_mara-matnr& &i_mara-ernam&

5) Difference b/w call transaction and session.
Call transaction Ssession
1. synchronous updation only synchronous updation
optional
2. errors can handled error log is created
explicitely
3. faster slower
4. less amount of data more can transfer
5. updation takes place updation takes place
during program execution once the session being created

6. Difference b/w smartforms and scripts.
Script Smartforms
client dependant independant
not possible multiple page formats are possible
compulsory without main window it can
labels are used labels cannot
not generated once session created function module

7. Errors hanling in call transaction
Two ways
1)... int table decalred having structure BDCMSGCOLL it is having certain variables not texts. ie msgtyp,megid, msgnr,
msgvar1, msgvar2, msgvar3, msgvar4 etc all the text messages are stored using T100 database table.
2)....int table decalred having structure BDCMSGCOLL it is having certain variables . ie msgtyp,megid, msgnr,
msgvar1, msgvar2, msgvar3, msgvar4 etc by declaring function modules format_message or write_message you can handle.

8. Errors handling in session
In SM35 error log is created, there you can handle.

9. Difference b/w select-options, valueranges, parameters.
par----- singlevalue
select-options----range and itself implicitly creates internal table
value-ranges---- just for ranges

10. How to remove duplicate entries?
using COLLECT
or
DELECT DUPLICATE ENTRIES FROM TABLENAME>

11. What are standard texts?
These are predefined texts used for create change and display tcode SO10
Starting with INCLUDE
These are for TERMS AND CONDITIONS .

12. What is the use of select....for all entries?
Avoid nested select or inner joins
uses
fast processing
sorting
delete duplicate entries

13. What is the difference b/w exit and continue?
exit----if it is in the loop comes out of the loop.
----if it is in the subroutine comes out of the routine.
----if it is in the program comes out of the preogram.
continue-----unconditional jumping out of the loop.

14. What is the diffenrence b/w collect and append.
collect----- checks whether it is there or not. if there adds integer, packed, float otherwise remove
append-----just adding

15) What are barcodes?
For security purpose

Tips by : Ramana

What is meant by "Matchcode"?

Matchcodes are defined in two stages in Abap/4 Dictionary:

LIS stands for Logistics Information System.

It is the information systems used to plan, control, and monitor business events at different stages in the decision-making process.

The Logistics Information System is made up of the following information systems which all have a modular structure:

- Sales Information System
- Purchasing Information System
- Inventory Controlling
- Shop Floor Information System
- Plant Maintenance Information System
- Quality Management Information System

Tools are available in Customizing to allow a self-defined information system to be created and tailored to specific requirements.

2) Reports:

SAP Reports are Programmes which are used to fetch data from SAP database under specified selection criteria and show in list viewer. Later you can view, download & take decisions appropriately.

There are many standard reports in SAP for various modules. For SD Module watchout TCode SD01. You can always code your own report they way you want in some cases.

3) ABAP Queries

These are the report which users can prepare without knowledge of the ABAP programming language to define and execute their own reports. Normally Functional Consultants use these ABAP query tool to create and run simple reports by themselves instead of coding by ABAPer. Its flexible and convinent. However you should be well thorough with different tables to map query and fetch data.

• &%NAME Name of user executing the query
• &%DATE Current date when executing the query
• &%TIME Current time when executing the query
• &%PAGE Current page number (output 6 characters)

In SAP 4.6x, you can used a simplified ABAP query. The Quick Viewer ( SQVI ) can be used to generate simple report without any programming.

You select fields according to your data source that determine the structure of your report. The report can be executed in basis mode with standard layout or may be edited using drag and drop and other toolbox functions available in WYSIWYG mode.

However, only transparent table are allow to be use in SQVI.

e.g. Your cannot use BSEG as it is a cluster table, instead use BSIS.

• BKPF - Accounting Document Header
• BSIS - Accounting: Secondary Index for G/L Accounts

Proxy objects implement message interfaces from Integration Repository. Proxies are executable interfaces, which converts non-language-specific interface descriptions into WSDL. i.e., you use proxies to implement the actual message exchange that is described in the Integration Builder.

Types of Proxy objects: You can use message interfaces to create the following proxy objects:

• ABAP Proxy objects
• JAVA Proxy objects

During the process of ABAP proxy generation, it gets WSDL (Web Service Description Language) description of message interfaces from the Integration Repository by using HTTP communication.

Proxy Generation:

As part of SAP Web AS 6.40

• ABAP proxy generation enables you to generate proxies to communicate by using the Web service infrastructure and by using SAP Exchange Infrastructure
• ABAP proxies that were generated from message interfaces in the Integration Repository (IR) can be used in both infrastructures.
• This means that if none of the Integration Server services are available for a proxy-to-proxy communication scenario in ABAP, you can use a point-to-point connection using the Web service infrastructure instead.

The prerequisites to configure ABAP Proxy include: (landscape dependent)

1. The business systems should be based on SAP Web AS 6.20 and SAP Web AS 6.20 kernel patch level above 1253
2. You have installed the XI Add-On in each of these business systems as described in the Installation Guide SAP Exchange Infrastructure 3.0
3. The business systems and your central Integration Server are maintained in the System Landscape Directory (SLD).

Configuration required on the Business System:

1. Create a HTTP connection in the business system using transaction SM59

Technical Setting:

· Connection Type: H

· Target Host: System name

· Service Number: HTTP Port name

· Path Prefix: /sap/XI/engine/?type=entry

Logon Security

On the Logon/Security tab page, enter the following logon data:

· User: XIAPPLUSER (for example); this user should represent the sending business system (see also the SAP XI Security Guide under Service Users for Message Exchange).

· Password: the password you have specified for this user

· Client: SAP XI Integration server

· Language: Language required

2. Configuration Business system as local Integration Engine.

1. Go to Transaction SXMB_ADM

2. Choose Edit --> Change Global Configuration Data.

3. Select Role of Business System: Application system

4. Corresponding Integration server: dest://. Here XI_XIR_CONNECTION created in step 1. Dest://XI_XIR_CONNECTION.

5. Under Specific Configuration Data you can specify additional configuration data

• Select the relevant category under Specific Configuration Data.
• Choose Change Specific Configuration Data.
• For ABAP Proxies, Add the following configuration:
  1.Category RUNTIME
  2.Parameters: IS_URL
  3.Current Value: dest://XI_XIR_CONNECTION
  
  

3. Connection between Business System and System Landscape Directory

• Create RFC destination (TCP/IP) LCRSAPRFC and SAPSLDAPI for the SLD connection.
• To create RFC Destination: LCRSAPRFC
• Connection Type: T
• Choose the Technical settings tab page and do the following:
  In the Program ID field under Registered Server Program, enter LCRSAPRFC
  This program ID must correspond to a program ID specified in the RFC engine settings of the SAP J2EE Engine on the Integration Server host.
• Repeat the above step for RFC destination for SAPSLDAPI