Answer / manu gowdru

select single:it selects the first record which matches the condition defined in WHERE clause.so if there many records which matches the criteria will be ignored,so its not unique

select upto 1 rows:it retrieves all the records which matches the condition mentioned in WHERE clause and puts aggregate,average and gives the result

Answer / sumit0312

select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.

Answer / silverage

Both will fetch 1 record from table. Select single is used when all the key of the table are to be matched in where condition. Select upto is used when any of the key is missing in the where condition.

Answer / nigesh

Select Single * will pickup only one matching record from
the database into the buffer, and returns the same to the
internal table.

Select upto 1 rows will pickup all the records matching the
condition into the buffer, but return the top record to the
internal table.

Answer / gagan

in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.

While in select upto 1 rows , it returns the first
occurrence of the record.

what is use of STOP stsment

2 Answers   Mind Tree,

How many types of tables exist and what are they in data dictionary?

0 Answers  

what is eqult Hide?

4 Answers   HCL, TCS,

How does the interection between the dynpro and the abap/4 modules takes place?

0 Answers  

What are the attributes of a field that can be activated or deactivated during runtime?

0 Answers  

Hi to all abap guru's my querry is as follows How to trigger the page break in smartforms forcibly ? and how to trigger the page break in the scripts forcibly ? means for every 10 records i have to trigger the page break ? and in smart form also ? thanks in advance

1 Answers   PWC,

What is Group by in Select statement?

0 Answers  

What commands are used to change database table entries ?

1 Answers  

What is an implementation project?In any job openings they desire people with at least one project with an end to end implementation. Could u give me the details of project implementation and the role of an abapper in the implementation? And what type of questions do the recruiters normally ask for implementation projects? Plz reply me with a suitable answer. Regards, Rahul

2 Answers   TCS,

What is the main point while using control break in internal table ?

3 Answers  

What are logical data bases used in hr module? : abap hr

0 Answers  

2 Table Maintenance generation & validation using events Create table lets say ZXXXX hold Object Locations. Field key data element Type Length Dec text MANDT x MANDT Clnt 3 0 Client ZCTRY x LAND1 Char 3 Country Key ZOLOC x ZOLOC Char 15 Object Location ZOLOC20 ZOLOC20 Char 20 Object Location short text ZOLOC40 ZOLOC40 Char 40 Object Location long text ZAWSYS LOGSYSTEM Char 10 Logical System ZSTREET AD_STREET Char 60 Street ZSTREET2 AD_STRSPP1 Char 40 Street 2 ZPOSTAL_CODE AD_PSTCD1 Char 10 City postal code ZCITY AD_CITY1 Char 40 City ZCOUNTRY ZLAND Char 3 Address Country ZOBJ_SIGN ZOBJ_SIGN Char 10 Object Sign ZREF1 ZREF1 Char 10 Reference 1 ZREF2 ZREF2 Char 10 Reference 2 ZREF3 ZREF3 Char 10 Reference 3 ZREF4 ZREF4 Char 10 Reference 4 ZNOTE1 ZNOTE1 Char 20 Note 1 ZNOTE2 ZNOTE2 Char 20 Note 2 ZCREAETDATE CREATEDATE Dats 8 Creation/Change Date ZCREATETIME CREATIETIME Tims 6 Creation/Change Time Create a table maintenance generator for ZXXXX. Create two events in Table Maintenance Generator: - To update the filed value SAP in ZAWSYS and creation date and time - To update change date and time after saving the entry Event ‘21’ – At Create: ZXXXX-ZAWSYS = SAP. ZXXXX-ZCREATEDATE = sy-datum. ZXXXX-ZCREATETIME = sy-uzeit. Event ‘01’- After Save ZXXXX-mandt = extract+0(3). ZXXXX-zctry = extract+3(3). ZXXXX-zoloc = extract+6(15). ZXXXX-zoloc20 = extract+21(20). ZXXXX-zoloc40 = extract+41(40). ZXXXX-zawsys = log_sys. ZXXXX-zstreet = extract+91(60). ZXXXX-zstreet2 = extract+151(40). ZXXXX-zpostal_code = extract+191(10). ZXXXX-zcity = extract+201(40). ZXXXX-zcountry = extract+241(3). ZXXXX-zobj_sign = extract+244(10). ZXXXX-zref1 = extract+254(10). ZXXXX-zref2 = extract+264(10). ZXXXX-zref3 = extract+274(10). ZXXXX-zref4 = extract+284(10). ZXXXX-znote1 = extract+294(20). ZXXXX-znote2 = extract+314(20). ZXXXX-zcreatedate = sy-datum. ZXXXX-zcreatetime = sy-uzeit. modify ZXXXX.

1 Answers   Wipro,