what is different between SQL AND BRTOOLS in sap?
Answers were Sorted based on User's Feedback
Answer / rajesh chowdary pendyala
sql is a structured query language which is useful to do
operations in database.we can execute sql commands by
connecting to the database using the tools like
sqlplus,isqlplus,oem(oracle enterprize manager).these tools
are provided by oracle and specific to oracle.
brtools are the interactive based character user interface
tools(brgui also available and btstudio(webbased also
avaible))using which we can perform batabase operations by
selecting the approptiate options.by using brtools we need
not have the knowledge of sql.
as per my knowledge brtools are specific to oracle.in case
brtools supports other db,s like
db2,informix,sapdb,sqlserver let me know.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / dj
Brtools is oracle specific. Limited tool but good enough for sap admin. SQL in complete database control.
| Is This Answer Correct ? | 0 Yes | 0 No |
-->Sql is structured query language used to perform RDBMS operation.By using sql we can perorm all rdbms operations.
-->Brtools are used only sap specific oracle db operations.These tools are developed by SAp.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to define logon groups?
For example, I want to transfer 50GB of data from DEV to Quality. I am using client export and import method; can you tell me how many hours take for client export and import? And also How many hours take for remote client copy?
If you want check java stack level?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
As a basis consultant what we have to do if a background job is cancelled?
3. What are Unicode and non Unicode in sap?
If a background job runs more than the time it should be completed normally then what action will u take ? Plz Post the Answer
how to check the TRANS directory size and what is its default value?
What is sap netweaver administrator tool?
How to get a transaction history of a user for a period of 6 months? I also wish to know if we can take the report month wise by specifying start and end date.
how to know if there are expensive sql statements running?what will you do then to improve the response time?
I need to change the Company address parameters of a user. The path is SU01 -> <Username> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.
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)