Knowledge Management

Question:
What is the meaning of a cluster table ? How it is different from transparent table ? How to fetch the data from cluster table BSEG faster as there no scope of creating an index on it . Our check printing prg takes a lot of time to run . Also this prg shows an expensive sql command while fetching from BSEG . Please post your suggestions at the earliest if somebody knows about it .
Regards
Raka
Answer:
yes, try to avoid cluster tables like bseg and and use tables like bsid, bsik, bsis, bsad, bsak, bsas,... instead
greets,
M
Answer:
Thanks a lot for your valuable suggestions . I am really grateful to you . But in my prg foll statement is used :
SELECT bukrs rebzg rebzj wrbtr
FROM bseg
INTO CORRESPONDING FIELDS OF TABLE itab_bseg
WHERE bukrs EQ regup-zbukr
AND rebzg EQ regup-belnr
AND rebzj EQ regup-gjahr.
Can you give an idea about what are the tables which can fetch me correct data .
Thanks in advance .
Regards
Raka
Answer:
Hi!
If regup-lifnr is not empty, use BSIK.
If regup-kunnr is not empty, use BSID.
Marina