select

[Former Member]

1.What are the ways to find out the tables used in the program?

2.what is the difference between select single * and select up to 1 rows??

3. What are Extracts?

[Former Member]

Shree,

1.What are the ways to find out the tables used in the program?

You will have to debug and find out.

2.what is the difference between select single * and select up to 1 rows??

Single will rely on the key you speicfy and get the first record it counters. UP TO 1 row, will fetch all the rows and give you one.

3.

Since internal tables have fixed line structures, they are not suited to handle data sets with varying structures. Instead, you can use extract datasets for this purpose.

An extract is a sequential dataset in the memory area of the program. You can only address the entries in the dataset within a special loop.

Regards,

Ravi

Note : Please mark the helpful answers

Message was edited by: Ravikumar Allampallam

[former_member188685]

Hi,

1. You can find using the Sql Trace or Debugging the Program.

2. Select single you need to specify the key fields, it will fetch the single record which satisfies the key conditions. select up to 1 rows will give you one and first record which satisfies the correct condition.

Regards

vijay

[Former Member]

for finding the tables:

1.use sql trace ST05 and activate the trace and run ur transaction and then go back and deactivate and it'll list u all the tables affected...

2.SE80

upto 1 row..will fetch all the records satisfying the where clause and then fetch u the first record from them

single single * will give u the very first record that satisfies the where clause..

reward points if it helps

gunjan

[former_member927251]

Hi Shree,

1. Goto SE80 to find the tables used in the program.

2. <a href="http://www.sapsuperusers.com/forums/showthread.php?t=4867">http://www.sapsuperusers.com/forums/showthread.php?t=4867</a>

3. Extracts are used to replace internal tables. It is basically used when there is a large volume of data.

Field groups are used for this purpose.

Reward points if it helps.

[former_member184569]

1.

Open your program in editor.

Utilities -> display object list

Select Dictionary STructures.

YOu will get teh list of tables used in the program

2. These posts will answer this question

3. An extract is a sequential dataset in the memory area of the program. Greater than 500 KB are stored on O/s

http://help.sap.com//saphelp_470/helpdata/EN/9f/db9ed135c111d1829f0000e829fbfe/content.htm

Thanks,

Susmitha.

Dont forget to reward points for useful answers.

[Former Member]

Hi,

1)debugging the program

2)<b>difference between select single & select upto 1 rows:</b>When you say SELECT SINGLE, it means that you are expecting only one row to be present in the database for the condition you're going to specify in the WHERE clause. so that means, you will have to specify the primary key in your WHERE clause. Otherwise you get a warning.

SELECT UP TO 1 ROWS is used in cases where you just want to make sure that there is at least one entry in the database table which satisfies your WHERE clause. Generally, it is meant to be used for existence-check.

3)<b>Extracts:</b>

Since internal tables have fixed line structures, they are not suited to handle data sets with varying structures. Instead, you can use extract datasets for this purpose.

An extract is a sequential dataset in the memory area of the program. You can only address the entries in the dataset within a special loop. The index or key access permitted with internal tables is not allowed. You may only create one extract in any ABAP program. The size of an extract dataset is, in principle, unlimited. Extracts larger than 500KB are stored in operating system files. The practical size of an extract is up to 2GB, as long as there is enough space in the filesystem.

An extract dataset consists of a sequence of records of a pre-defined structure. However, the structure need not be identical for all records. In one extract dataset, you can store records of different length and structure one after the other. You need not create an individual dataset for each different structure you want to store. This fact reduces the maintenance effort considerably.

In contrast to internal tables, the system partly compresses extract datasets when storing them. This reduces the storage space required. In addition, you need not specify the structure of an extract dataset at the beginning of the program, but you can determine it dynamically during the flow of the program.

You can use control level processing with extracts just as you can with internal tables. The internal administration for extract datasets is optimized so that it is quicker to use an extract for control level processing than an internal table.

Procedure for creating an extract:

Define the record types that you want to use in your extract by declaring them as field groups. The structure is defined by including fields in each field group.

Defining an Extract

Fill the extract line by line by extracting the required data.

Filling an Extract with Data

Once you have filled the extract, you can sort it and process it in a loop. At this stage, you can no longer change the contents of the extract.

Processing Extracts

Message was edited by: Latheesh Kaduthara

Message was edited by: Latheesh Kaduthara