10-30-2015 6:29 AM
I am getting error in generic buffering help pls
ZACTORS-ACTOR_RANK (Recommended length for field of type CHAR: 0)
This number of key fields is not permitted with generic buffering
10-30-2015 7:58 AM
Check consistency between the number of primary keys and the definition of generic buffering in technical options. (at least one key in buffer generation, but no more than number of primary keys - 1, minus one required else use fully buffering of course.)
Regards,
Raymond
10-30-2015 9:43 AM
i have tow key fileds so im maintning 2 why -1 i have to do pls tell
10-30-2015 9:48 AM
10-30-2015 9:58 AM
Just look at the screen you have three options : per record, whole table and generic area. if you choose generic area give a number of key that make some sense, if you want every primary key then use single record, if you want no key use fully buffered, so logical range from 1 to n-1.
Regards,
Raymond
10-30-2015 10:26 AM
see i have mandt and empid key filed if i enter 1 so left jstfied filed will be consider how it will buffer ,will not buffer any thing ....?
10-30-2015 10:45 AM
Use single record buffering in this case. With only mandt and one key only full and record buffering seems useful, choice depends on size (and frquency of usage) of the table.
10-30-2015 10:52 AM
If you read a record from a generically buffered table, all records whose the left-justified part of the key corresponds to that of this record (generic key fields) are loaded into the buffer.
This left-justified part of the key is determined in this field by entering a number n of key fields. The first n key fields of the table are thus the generic key fields.
The number entered must be between 1 and key field number -1. For example, for a table with 6 key fields, only values between 1 and 5 are allowed.
The value to be entered should be selected so that the generic areas, that is, the set of records corresponding to a record in the generic key fields are not too small.
seee means ..,. ..?
This left-justified part of the key is determined in this field by entering a number n of key fields. The first n key fields of the table are thus the generic key fields.
10-30-2015 11:01 AM
Genric buffering : suppose you have primary keys MANDT, WERKS and LGORT and defined 2 keys for generic buffer. First time you read a record, every storage location associated to the plant will be buffered. Now you read another storage location in same plant, data get read from buffer, then you read in another plant, now every storage location of this new plant get buffered...
10-30-2015 11:07 AM
11-02-2015 5:02 AM
HI
I have
mandt empid
100 111
100 112
genric key 1 , 2Key so
code
selce * fro table into table tab whre empid = 111 whatwil happenb