Hello rahul , gooday hope u doing well, I want to know that if we define any one field as unique key and we are searching for a record for another key (having non unique records) will it work. eg. in video we defined 'ono' as unique key and if we search for 'pm = c' , provided that 'pm' may have non unique values how will it respond.
hello sir, the explanation was good but i have came across of one condition that in standard table also they have used WITH NON-UNIQUE KEY please elaborate is it applicable or not.
As SAP considers, append as a Index based operation and index is not allowed with HASHED internal table. When you check the error, SAP is clearly mentioning - internal and explicit Index is not allowed with hashed internal table.
bro in hashed table it returns directly address of searched key so why cant we append ??u said at last ono 1 8 5 12 10 so these are not sorted so we can use append also right?? only insert?
In Hashed Internal Table- If you Use APPEND, System will give you error - Implicit or Explicit Index operations are not allowed, So SAP is considering APPEND as INDEX based operation and INDEX is not allowed for Hashed Internal Table.
Dear Rahul, Your explanations are exceptionally superb. Thanks a lot.
Thank you for your kind words.
Can we delete hashed table row with non-unique key value with where condition ?
Yes you can delete.
Hello rahul , gooday hope u doing well, I want to know that if we define any one field as unique key and we are searching for a record for another key (having non unique records) will it work. eg. in video we defined 'ono' as unique key and if we search for 'pm = c' , provided that 'pm' may have non unique values how will it respond.
It will work and return the first matching record based upon payment mode C.
hello sir, the explanation was good but i have came across of one condition that in standard table also they have used WITH NON-UNIQUE KEY please elaborate is it applicable or not.
Standard internal table is based upon non-unique key only, so specifying will not make any impact.
respected sir please upload one video for resume building session fresher and intermidiate level resume building its help for resume selection .
Hello - Resumes always varies from individual to individual skills and it can not be generalized for freshers, intermediate and experienced.
Why we didn't use APPEND Statement in hashed table?
As SAP considers, append as a Index based operation and index is not allowed with HASHED internal table. When you check the error, SAP is clearly mentioning - internal and explicit Index is not allowed with hashed internal table.
Ok sir, Thank you
bro in hashed table it returns directly address of searched key so why cant we append ??u said at last ono 1 8 5 12 10 so these are not sorted so we can use append also right?? only insert?
In Hashed Internal Table- If you Use APPEND, System will give you error - Implicit or Explicit Index operations are not allowed, So SAP is considering APPEND as INDEX based operation and INDEX is not allowed for Hashed Internal Table.
@@sapabapbyrahulmehta ohh okk ✌🏼