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 |
Is main window mandatory in smartforms?
If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)
How can we add another field to display in standard SAPSCRIPT? Ex. we have customer address in layout, now we have to add customer Phone no in the same.
how to find out where to create a badi.
When we copy any Driver Program from Nace............when we copy into zprog,when we activate how it was linking to that particular std layout............what happening to the previous driver prog?
What are two different ways to add fields to sap tables?
What do you like best about working for, in this company?
what is ASAP methodology? How many phases are there? what is the percentage of each phase?
Explain what are the different functions used in sap script? What are the parameters used in each function?
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
While Transporting Smartform form Dev to Test to Production, it is possible that Name of the Function Module change, Why? In which case it changes and in which case it remains same?
what are Program Events and Run time Events in Reports
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)