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 HANA Articles
Page 6 of 58
Adapter properties dropdown not updated with list even after installation (SAP 7.2 adapter)
When working with SAP 7.2 adapters in BizTalk Server, you may encounter an issue where the adapter properties dropdown remains empty even after successful installation. This is a common problem that occurs when specific assembly files are not properly deployed to the BizTalk group. Root Cause The issue typically occurs because the BizTalkPropertySchema assembly, which is responsible for Microsoft adapter properties, is not deployed correctly during the installation process. This assembly contains the property schema definitions that populate the dropdown options in the adapter configuration. Solution Steps To resolve this issue, follow these manual deployment steps ...
Read MoreIdentify the qualification and Employee relationship table in SAP system
In SAP systems, qualification and employee relationship data is distributed across multiple tables rather than stored in a single location. Understanding these table relationships is crucial for HR data management and reporting. Primary Tables for Qualifications Qualifications in SAP are stored as object type 'Q' in the Personnel Development (PD) tables. The main tables involved are − HRP1000 − Stores qualification master data with object type 'Q' HRP1001 − Captures the relationship between qualifications and employees HRPAD31 − Contains qualification ratings and assessment data ...
Read MoreGetting day of the year from DD/MM/YYYY using function in SAP system
In SAP systems, you can calculate the day of the year from a DD/MM/YYYY date using a simple function. The day of the year represents which day number it is within that specific year (1-366). You can achieve this with the following line of code − DATA(l_day) = m_date - CONV d(m_date(4) && '0101' ) + 1. Where m_date is the input date that needs to be of type d. Note that the format of type d is YYYYMMDD. This code works by: Extracting the year from the input ...
Read MoreMissing SAP Java Connector libraries JCo- librfc32.dll, com.sap.utils and com.sap.mw
Please note that all these library files − librfc32.dll, com.sap.utils and com.sap.mw come under JCo 2.1. With release of JCo 3.0, its classes were also relocated from packages com.sap.mw.jco.* to com.sap.conn.jco.* For running with SAP JCo 3.0, you need these files at runtime − sapjco3.jar and sapjco3.dll (on Windows). You can follow below procedure for installation of JCo files: Installing JCo on Windows Platform In Windows OS, you have to copy sapjco3.jar file into ITDI_HOME/jars/3rdparty/others. Copy the ...
Read MoreCalling external programs using SAP connector
Yes, it is possible to address or call an external program using SAP connector SDK. From ABAP, you can reference external programs by SAP's RFC (Remote Function Call) protocol. RFC protocol enables communication between SAP systems and external applications, allowing seamless integration and data exchange across different platforms and programming languages. There are various SAP connectors available for different programming languages. Few of them are − JCo is the SAP Java connector NCo is the .NET SAP connector NW RFC SDK is the SAP ...
Read MoreIMPORTING, EXPORTING and CHANGING Keywords in ABAP
IMPORTING transfers a value from the caller to the called method by passing an actual parameter. EXPORTING is just opposite to what IMPORTING does. It passes value from the method to caller. CHANGING is transferring the value from caller to method by a variable which is processed or changed and the changed value is passed back to the caller. Thus it combines both IMPORTING and EXPORTING function. CHANGING Parameter Syntax There are a couple of ways in which CHANGING can be used − CHANGING myvar CHANGING VALUE(myvar) By using CHANGING myvar, the ...
Read MoreDetermining table or structure of an ABAP code
In ABAP, you can define variables as either tables (internal tables) or structures using different syntax approaches. Understanding the distinction between these two data types is crucial for effective ABAP programming. Defining Internal Tables To define an internal table, you use the TABLE OF keyword. This creates a table where each line has the structure of the specified type − DATA: abc TYPE TABLE OF PPP. In this declaration, abc would be an internal table and its line will be of type PPP. Each row in the table will have the structure defined by ...
Read MoreUsing SQL statements in ABAP Programming and Database performance
The basic principle for performance in ABAP database operations is that there should be minimal data transferred between the application server and database. SQL Performance Best Practices in ABAP Field Selection Strategy Select only the fields that are required. Avoid using SELECT * unless you need all fields. However, in specific scenarios where you have multiple SELECT statements in different parts of your program querying the same table but different columns, it may be advisable to use SELECT * because the output is stored in a ...
Read MoreStandards for maintaining Customer Repository Objects in SAP
In SAP development, proper namespace management is crucial for maintaining Customer Repository Objects. Understanding the distinction between Y-namespace and Z-namespace helps organizations maintain clean, organized development standards. Y-Namespace vs Z-Namespace The Y-namespace is meant to be used for centrally developed solutions or also known as head office while the Z-namespace is used for local developed solutions or also known as branch office. But at the end of day, it all depends on the developer how he uses it. Standard Repository Object Naming Conventions ...
Read MoreDetermining the current client in SAP using code
You can find the current client in SAP using the system field sy-mandt. This system variable automatically contains the three-digit client number of the current session. Example Here is the code you can write to determine and use the current client − IF sy-mandt = '001'. " Execute logic for client 001 WRITE: 'Current client is production client 001'. ELSE. " Execute logic for other clients WRITE: 'Current client is:', sy-mandt. ENDIF. Practical Usage You can also store the client value in a variable for ...
Read More