What is the difference between select single and select upto
1 rows?
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 4 Yes | 2 No |
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.
| Is This Answer Correct ? | 3 Yes | 3 No |
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.
| Is This Answer Correct ? | 3 Yes | 4 No |
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.
| Is This Answer Correct ? | 4 Yes | 10 No |
what is use of STOP stsment
How many types of tables exist and what are they in data dictionary?
what is eqult Hide?
How does the interection between the dynpro and the abap/4 modules takes place?
What are the attributes of a field that can be activated or deactivated during runtime?
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
What is Group by in Select statement?
What commands are used to change database table entries ?
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
What is the main point while using control break in internal table ?
What are logical data bases used in hr module? : abap hr
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.
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)