Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP Articles
Page 66 of 91
Importing data from Pgsql to SAP HANA database
Import and Export using a flat file is the easiest option. You can use CSV file if it is a onetime activity. However, If you think it is a repetitive activity then I would suggest you use HANA ETL options like HANA SLT replication, Smart Data access, etc.SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction ...
Read MoreRunning a SQL query from specific month in SAP DB
When your T0.name is char filed, you should replace Order By as below −order by case when cast(left (T0.Name,2) as int)>=8 then cast(left (T0.Name,2) as int)-8 else cast(left (T0.Name,2) as int)+4 end
Read MoreExploring ERP Modules of Oracle E-Business Suite
The acronym ERP stands for enterprise resource planning. It refers to the systems and software packages used by organizations to manage day-to-day business.Oracle E-Business Suite is one of the most reputed ERP product which is currently available in the market – developed by Oracle. In the world of enterprise resource planning, very few software products have really made to the top ranks when it comes to worldwide implementations. Based on market share – SAP, Microsoft Dynamics are the close vendors who try to get the ERP share in almost all the regions.What is Oracle E-Business Suite?Oracle’s E-Business Suite (also known ...
Read MoreUsing clients in SAP ERP
Several independent companies or subsets of one company can be present in one SAP system. The client separates these companies and their relevant data. Client serves as a key to most of the SAP database tables and used customizing, transactional and master data. To summarise client serves as unique database key for each company. Client concept comes with the following advantages −You can share the same resources with multiple users.You can manage SAP system landscape as you can create multiple clients for DEV, QA and PROD team.You can share your SAP system with a large number of users. You can create clients in an ...
Read MoreTransporting SAP standard text
STEP 1: Create Standard Text. To create standard text, you have to use T-Code SO10.In next window, pass the Text Name -> Click on CREATE Push Button. This will open a new window where you can save the TEXT.Next step is to create the TRANSPORT REQUEST to transport the TEXT. This can be done using T-Code: SE09. Go to Home screen and run T-Code SE09.To create Transport request, you have to click on CREATE button at the top. This will open Transport Organizer as below:This will open Create Request window. Enter the Short Description, Project and click on Save button as ...
Read MoreUsing BU, ZK code in SAP Macros
OK CODE – In SAP, an OK code is used for any functionality. The OK code is used to perform an action executed or will be executed (save, back, exit) etc. BU – This OK function is used to perform SAVE function in an MM01 transaction.ZK – This code is used to get the additional information. To find out a function of each button, you have to navigate to System -> Status -> Double click on GUI Status.
Read MoreTurnoff redirect to mobile pages in SAP Hybris
To start with, first, you need to turn off the cookies on a mobile device. Next is to run the following command to the “project.properties” file of your storefront extension. Example# disabling the mobiles redirects:# uiexperience.level.supported.b2ctelco=DESKTOP uiexperience.level.supported=DESKTOPWhen this function is used, it communicates to SAP Hybris system that only DESKTOP based support is required.
Read MorePrint screen using VBA in SAP
If you are using SendKeys then avoid using it. I had used it in the past project and it seems to be inconsistent and error-prone.You can use the below snippet at the top of the module and call it wherever required.Option Explicit Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal _bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Const KEYEVENTF_KEYUP = &H2 Private Const VK_SNAPSHOT = &H2C Private Const VK_MENU = &H12 Sub PrintScreen() keybd_event VK_SNAPSHOT, 1, 0, 0 End Sub
Read MoreTaking backup of schema in SAP HANA
It is always recommended to back up your critical systems.ExampleFollowing SQL command can be used to export schema in HANA:EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH REPLACE;This can also be directly zipped to Linux as below:tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/
Read MoreFinding location of uploaded file using SAP GUI_upload
When you upload a file using the gui_upload function, the file is not uploaded to the Application server. The file is read from presentation layer to an internal table.ExampleFollowing code can be used to call a gui_upload function to read the file to an internet table:lv_filename = p_filebp. CLEAR lt_data_tab. IF NOT lv_filename IS INITIAL. CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = lv_filename TABLES data_tab = lt_data_tab EXCEPTIONS file_open_error = 1 OTHERS = 17. IF sy-subrc 0. EXIT. ...
Read More