Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint
Drag to reposition
Database Questions
I want to know how to join tables in SAP system. Let us say there is a table - VNVK and I want to see all foreign keys in this table?I haven’t been provided with access to front-end system.
I want to execute an Inner join over RFC connection on some database tables. I have following command: I want to convert this into one that works with RFC table.
Can we dynamically create parameters from table entries?  When I use the above code, it throws an error- “example-workarea-field is not a constant”. Can anyone help?
Our company uses both SAP HANA system and as well as ORACLE database. I want to extract data from the HANA database and upload it to ORACLE database. What is the best option to extract data and is there any way I can automate the extraction process as this would be a regular process?
 I am using Native SQL code to insert an order in a system as below When I try to run this code, I get an error so I change the date to SYSDATE as below: This has fixed the error but still, I am not getting order date from the table: //select a order details where order id='2', and assign to orderID, orderDate Write:/1 'Order date: ', orderDate. Write:/1 'Order ID: ', orderID. I am get.....
I used T-code SE11 to change the data element of one column however when I open the table in a SE16N transaction, it shows a description of an older data element. DataElement      Description when show at SE16N NETVR              NET Value I altered the data element as below: DataElement      Description when show at SE16N NET.....
I have to concatenate 2 strings in ABAP and I don’t want to use CONCATENATE. Is there any alternative? Here is my code: I want to CONCATENATE hello 'and' world INTO helloworld SEPARATED BY space.
While using Function module RSAQ_REMOTE_QUERY_CALL via RFC call and using selection parameters I see an Exception: NO_DATA_SELECTED. I have used following selection parameters: Am I using correct parameters with these function module?
I have to get the list of products from SAP system by connecting to the database using a .net application. I am getting an error message that Connection Refused:  Error 10061WSAECONNREFUSED I have developed an app using code from the internet: Following is error message: LOCATION    CPIC (TCP/IP) on local host with Unicode ERROR       partner  'WIN-FHT4V74.....
I have a table which has data like: ABCAbc.Bcd.1223Abc.  Bdh. 144777I need to remove duplicates from each row in C column. Basically, the output should be like: ABCAbc.Bcd.123Abc.Bdh.147Can please someone help on this?
loader
Contribution

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.