what is Primary key and unique key and what is the
Difference?
Answer Posted / arun prasad
PRIMARY KEY IS A FIELD WHICH IS USED TO IDENTIFY THE TABLE
AND THESE CANNOT BE CHANGED, IF IT IS CHANGED THE DATA
INTEGRITY WILL GET LOST.
UNIQUE KEY IS A GROUP OR A SINGLE FIELD WHICH IS USED TO
REPRESENT THE NUMERIC FIELDS WHICH DOESNT CHANGE.
THE GROUP OF NUMERIC FIELDS IS THE UNIQUE KEY.
PRIMARY KEY IS USED FOR DATABASE TABLES WHERE AS UNIQUE KEY
IS USED FOR INTERNAL TABLES.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?
What is the major difference between pool tables and transparent tables?
What is the role of ‘refresh’ in internal table?
what is the difference between hashed & sorted internal tables?
Difference between call by value and call by reference? : abap data dictionary
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
What is roll area?
What are screen painter and menu painter? : abap hr
How to convert normal function module to bapi?
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?
Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs
What are the different kinds of lock modes?
what is the t-code to link technical and functional operation?
Explain the difference between a pool table and a transparent table and how they are stored at the database level?