what are logical and physical databases
Answer / hari
LOGICAL DATABASE:
=================
To read data from a database tables we use logical database.
A logical database provides read-only access to a group of
related tables to an ABAP/4 program.
Advantages: i)check functions which check that user input is
complete, correct,and plausible. ii)Meaningful data
selection. iii)central authorization checks for database
accesses. iv)good read access performance while retaining
the hierarchical data view determined by the application
logic. dis advantages: i)If you donot specify a logical
database in the program attributes,the GET events never
occur. ii)There is no ENDGET command,so the code block
associated with an event ends with the next event statement
(such as another GET or an END-OF-SELECTION).
Logical databases are special ABAP programs that retrieve
data and make it available to application programs. The most
common use of logical databases is still to read data from
database tables by linking them to executable ABAP programs.
Logical databases contain Open SQL statements that
read data from the database. You do not therefore need to
use SQL in your own programs. The logical database reads the
program, stores them in the program if necessary, and then
passes them line by line to the application program or the
function module LDB_PROCESS using an interface work area.
A logical database provides a particular view of
database tables in the R/3 System. It is always worth using
logical databases if the structure of the data that you want
to read corresponds to a view available through a logical
database.
The data structure in a logical database is
hierarchical. Many tables in the R/3 System are linked to
each other using foreign key relationships. Some of these
dependencies form tree-like hierarchical structures. Logical
databases read data from database tables that are part of
these structures.
Physical Database is actual Database.
| Is This Answer Correct ? | 7 Yes | 1 No |
what the Recording Purpose?
How can we handle table control in bdc? : abap bdc
For particular transaction you want to upload the data using any of bdc method...if the transaction contains any of pop window functionaliy and having radio button in the window..Any one of the radio button must be selected then only the next data can be inserted how will you handle this scenario in your program
What is the function of a data element?
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
Some Realtime Examples on Exits .
what is Tool view and Project view?
how to create interactive report from alv ?
Which one of the following statements would occur in the PBO of a dialog program using table control? a) module user_command. b) set screen '0100'. c) loop at itab. d) loop at itab with control itab_tc.
How to transfer a smartform from Development to Quality Server?
Explain the advantages and disadvantages of abap query tool?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)