What are logical databases? What are the advantages/
dis-advantages of logical databases?
Answers were Sorted based on User's Feedback
Answer / paramjeet
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).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sunita garbyal
Logical database are special ABAP programs that retrive data & make it available to application programs.
Advantages of Logical database.
• No need of taking care of the key field and the foreign key realtionship between the tables in question.(relationship between diff tables are reflected in tree structure of Logical database).
• A selection screen with appropriate selection criteria is automatically created.
• Program standard authority checks are executed by Logical database itself in reports.
• Logical database improves the performance of reports at runtime.
| Is This Answer Correct ? | 0 Yes | 0 No |
On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
in report gui we are giving customer number if it is wrong entry then how to write the code to restrict wrong entry?
what is difference between (internal table types)standard table and sorted table in sap abap....
What is the difference between a structure and an append structure?
how to placed drop down arrow in the input field of module pool table control/ steploop
what is the difference between transparent, pooled and cluster table
What is the difference between data elements and domains? : abap data dictionary
what is the standard program used to upload/download layout sets in scripts.
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
How to create any functions? How to go about it?
i had to write the code in such a way that duplicate entries should not entered in sap data base
What is Direct Input method?
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)