4 weeks ago
Hi Team,
I have used the below query using SORTED table, still the system consumes more time for execution.
Key fields in my custom tables are field_name ,seq ,key_value .
In total, I have around 1000 entries in the custom table.
No Buffering available for this custom table.
Kindly guide me on the same. Thanks.
DATA : lt_data TYPE SORTED TABLE OF tp_data WITH UNIQUE KEY field_name seq key_value .
SELECT field_name,
seq,
key_value,
add_search,
sign,
opti,
low,
high,
begin_date,
end_date FROM ztmdgc_config
WHERE field_name = @iv_field_name
INTO TABLE @LT_data .
Regards,
Karthik S
Request clarification before answering.
User | Count |
---|---|
53 | |
9 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.