i have 4 primary keys and i want to use only one primary key for select single.

i have 4 primary keys and i want to use only one primary key
for select single.What changes will occur in the system?can
i use it?

Question Posted / shankar

4 Answers
9940 Views
Siemens, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have 4 primary keys and i want to use only one primary key for select single.What changes will oc..

Answer / jagadish

In select single, you have to mention all the key fields in
where condition. Only in Select upto n rows there is no
need to specify all the key fields

Is This Answer Correct ?

13 Yes

0 No

i have 4 primary keys and i want to use only one primary key for select single.What changes will oc..

Answer / sainath

There wont be many primary keys.only one primay key with
many fields combination.so you can use select single for the
field u want.

Is This Answer Correct ?

5 Yes

7 No

i have 4 primary keys and i want to use only one primary key for select single.What changes will oc..

Answer / rams

when ever you are using select single you have to use all
primary key's, other wise it will give syntax error,

when you are using select UPTO N rows, there is no need to
use all primary key

Is This Answer Correct ?

0 Yes

3 No

i have 4 primary keys and i want to use only one primary key for select single.What changes will oc..

Answer / ramjan shaik

A TABLE MUST HAVE ONLY ONE PRIMARY KEY.MORE THAN ONE
PRIMARY KEY NOT POSSIBLE TO GIVE TO THE TABLE.IF
GIVES,ERROR MESSAEG WILL DISPLAYS

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More SAP ABAP Interview Questions

What is Routine in ABAP and Types of routines?x

2 Answers

What are the data types of the external layer? : abap data dictionary

0 Answers

if u take one worst program,in this program user write the logic is session method.in that program user can get some errors ,that errors we will see in call transaction method,how it is possible.?

0 Answers IBM, Satyam,

In Dialog Prog,i have created a screen and places one input/output box and named it was "A".In PBO i have given A=0 and In PAI A=1.when i run i program what i'll get and when i press enter(execute) wat i'll get output?

1 Answers IBM,

What are the aggregate objects in data dictionary? : sap abap data dictionary

0 Answers

what is the use of field symbol?

3 Answers

What do you mean by correction and Transportation system?

1 Answers

Explain what are standard layouts sets in the sap script?

0 Answers

create a Report to print Stock & Valuated Stock for Plant (ALV Grid) Selection Screen Ranges: Material Number (MARA-MATNR) Material Type (MARA-MTART) Valuation Class (MBEW-BKLAS) Storage Location (MARD-LGORT) Parameter filed plant (MARD-WERKS) Selection condition: Total valuated stock – MBEW-LBKUM – should be greater than zero Table to be used MAKT,MARD,MBEW,MARA,T001L.. (Use inner joins) Display output: Storage location: (TOO1L-LGORT) Description (T001L-LGOBE) Material No (MARA-MATNR), Material Description (MAKT- MAKTX), Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), IF MBEW-VPRSV = 'S'. Price – MBEW-STPRS ELSEIF DTAB-VPRSV = 'V'. Price – MBEW-VERPR. ENDIF. Subtotal of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), Grand Total of Total valuated stock (MBEW-LBKUM), Val of tot valuated stock (MBEW-SALK3), In the ALV grid display keep a button in the tool bar which on clicking navigates through the screen to the next grid which displays the grand total. Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button.

1 Answers

What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary

0 Answers

What is the difference between a structure and a table? : abap data dictionary

0 Answers

Parameters used in Functions?

4 Answers IBM,

For more SAP ABAP Interview Questions Click Here