Ansicht
Dokumentation

05651 - Accessing RESB - What is the proper way?

05651 - Accessing RESB - What is the proper way?

BAL_S_LOG - Application Log: Log header data   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

Accessing RESB - What is the proper way?

Hi Blake,

a lot questions to answer ...

1. Is my understanding of Pool and Cluster files correct?
yes, absolutely!

2. Is RESB a Cluster Table?
NO! (Otherwise you couldn't read anything with RPG programs)

3. What is the preferred method of accessing RESB?
SAP always tells customers to access the database via RFC. Then you call via
RFC a function module (ABAP), that does the DB-reads and returns the needed
data. Mostly, this is too much effort in the eyes of the customers. So, they
act as you do. Then you should know, that this can change in every release
and you will have to maintain your RPG (?) pgms at every release change (you
would perhaps have to maintain the function module as well)

4. If they exist, What are the "Index" Tables for RESB?
I don't know, if for RESB do exist such index tables, I don't think so. But
RFBLG is a cluster as well. There you find BSIS, BSAD ... all these are
"physically index tables" which contain the real data in duplicates to RFBLG
in order to have faster access to this.

5. Are there other "Cluster" Tables we should know about?
RFBLGis the most popular. But you really can't access it from outsie, you
will see ...

6. What is a index table?
Parts of the cluster table are extracted to some other tables, that are
alyways maintained in parallel from the SAP system automatically. You would
then "hunt" for the correct index table and would read that one instead of
RFBLG.

Hope, it helps a bit,

Volker

-----Original Message-----
From: bfbray [mailto:blakebrayZp...]
Sent: Mittwoch, 10. April 2002 16:07
To: DoNotReply@consolut.eu
Subject: Accessing RESB - What is the proper way?


It was suggested to us that we should not access RESB directly due to
it being a "Cluster" table. It was suggested to use the "Index"
tables to access RESB or the "Views" into RESB. I've looked around in
the system and can not find any "Index Tables" for RESB.

My understanding of Cluster Tables is "They are tables which have
parent/child (many to one) records combined into single rows of data,
thus they are large in record number as well as large in row size.
They are used to combine the parant/child records into one row so you
only have one table instead of two".

My understanding of Pool tables is "A physical table which contain
multiple individual tables. These are used to have 1 file which
contain many logical files. Each record has a field indicating what
logical file it belongs to."

I'm guessing a index table is a real physical table which cotains the
index for another table. The index is maintained in a real file by
the application instead of the system maintaining a index.

Can someone please answer/clarify the following questions:
1. Is my understanding of Pool and Cluster files correct?
2. Is RESB a Cluster Table?
3. What is the preferred method of accessing RESB?
4. If they exist, What are the "Index" Tables for RESB?
5. Are there other "Cluster" Tables we should know about?
6. What is a index table?

We have alot of programs reading RESB and none of them are especially
fast. Before we create indexes over RESB I would like to know how we
are suppose to be acessing this file. And are there other tables we
should be aware of.




Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net


Durban Tours - Südafrika Safari

PERFORM Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 4499 Date: 20240328 Time: 093835     sap01-206 ( 5 ms )