Ansicht
Dokumentation

05673 - Accessing RESB - What is the proper way?

05673 - Accessing RESB - What is the proper way?

ROGBILLS - Synchronize billing plans   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

Accessing RESB - What is the proper way?

Thanks for your quick response, I have one more item to clarify about
RESB or other tables. I'm assuming accessing tables within ABAP using
views over the table give the following benefis:
1. The view returns a small subset of the fields within the table,
thus you do not have to code all the fields in the select.
2. When using the view the database will not perform as many checks
against the check tables.
3. Some views have multiple files included so the system is doing the
join.
Are these valid reasons to use views over tables instead of a select
with the field names qualified? RESB has several views over it, one
is MDRS. Thank you for your responses, I'm trying to figure this
dictionary out so we can code more effiecient SQL.

--- In SAP on System iZy..., "Gueldenpfennig, Volker"
<volker.gueldenpfennigZs...> wrote:
> 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: SAP on System iZy...
> 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
> SAP on System i-unsubscribeZy...
>
> Your use of consolut is subject to
http://www.consolut.net


Durban Tours - Südafrika Safari

ABAP Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 5437 Date: 20240329 Time: 002733     sap01-206 ( 4 ms )