Ansicht
Dokumentation

05674 - Accessing RESB - What is the proper way?

05674 - Accessing RESB - What is the proper way?

CPI1466 during Backup   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,

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?
If the view only contains a few fields, this is correct.

2. When using the view the database will not perform as many checks
against the check tables?
Never are done checks against the check tables! This is only done, if the
ABAP does these checks manually.

3. Some views have multiple files included so the system is doing the
join?
yes

Are these valid reasons to use views over tables instead of a select
with the field names qualified?
It really doesn't matter if you use views or tables. Do, what you prefer,
but try to prevent "select * from" if you don't need a lot fields.

Regards

Volker

-----Original Message-----
From: bfbray [mailto:blakebrayZp...]
Sent: Donnerstag, 11. April 2002 15:58
To: DoNotReply@consolut.eu
Subject: Re: 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.


Durban Tours - Südafrika Safari

CL_GUI_FRONTEND_SERVICES - Frontend Services   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 2456 Date: 20240221 Time: 185502     sap01-206 ( 3 ms )