John SAP

John SAP

88 Articles Published

Articles by John SAP

Page 6 of 9

Installing SAP Sybase client on Windows server 2012 R2

John SAP
John SAP
Updated on 17-Feb-2020 773 Views

Try checking installer file again. I would recommend that you download it from SAP Market Place. Navigate to below path for getting installer file:https://support.sap.com/swdc → Installation and Upgrades → A-Z list → search for SAP ADAPTIVE SERVER ENTERPRISE → SYBASE ASE 15.7 → Installation → Microsoft Windows → 51044415.zipAlso note that you need to have following before you proceed with installation:Microsoft Visual C++ 2010 Redistributable Package (x64)Microsoft Visual C++ 2005 Redistributable Package (x86)Microsoft Visual C++ 2005 Redistributable Package (x64)Check out this SAP thread:SAP thread

Read More

Jmeter server error while perform load testing on SAP application

John SAP
John SAP
Updated on 17-Feb-2020 918 Views

Load testing is performed to see volume of traffic your website or an application can handle. Apache Jmeter is an open source, free, java based and configurable tool to perform performance and load testing. You can download Jmeter from the following link:LinkNow to test SAP application using Jmeter, you need to follow below steps for recording:First it to right click on the thread group and you need to choose “Add → Logic controller → Recording Controller”. This will store the recording in the new node named Recording controller.Next step is to right click on “WorkBench”, choose “Add → Non-test elements ...

Read More

Not able to save a SAP Crystal Report for Enterprise 4.2

John SAP
John SAP
Updated on 17-Feb-2020 210 Views

Note that you need to check if Crystal Report for Enterprise 2016 support specific IBM DB2 version and for this you need to check product compatibility guide for development.Are you using Universe developed on IBM DB2 then you need to ensure that you are using correct version of drivers JDBC/ODBC in IDT to create a Relational connection. You also need to ensure that connection is also published to SAP BI repository. If your version of DB2 and Crystal Reports is ok, I would recommend you follow below steps:First steps is to start, you need to create a System DSN in ...

Read More

nQuery in Analytic view creating unexpected results in SAP HANA

John SAP
John SAP
Updated on 17-Feb-2020 327 Views

You haven’t provided complete details what you are trying to achieve. Refer SAP OSS note 1993033 Wrong result for query on analytic viewDuring activation of an analytic view, column view is generated. However, there are some artifacts that cannot be calculated in this column view. In this case, one additional calculation view is generated on top of it. The generation of the calculation view has to be performed if the following elements are defined in the analytic view:Input parametersCalculated attributesUnit or currency conversionsIf at least one of these elements is defined in the analytic view, the activation creates one OLAP ...

Read More

Upgrading to SAP ECC 6.0 from 4.6C

John SAP
John SAP
Updated on 13-Dec-2019 684 Views

We have recently upgrade from SAP 4.6C to SAP ECC 6.0. We didn’t use r3 copy as it is recommended to use on same database. Solaris 10 is similar to Solaris 8 however database version will prevent the use of it.Also note that you can have multiple instances of SAP on single host and user. Following steps we followed:First is to install ECC and database on the target server.Next is to copy ( backup and restore ) the database from the source system.Upgrade the database to Oracle 10. Read sap documentation on this process. Some updates will be needed for ...

Read More

Difference between Dev and Pro while configuring Transport system in SAP

SAP
John SAP
John SAP
Updated on 13-Dec-2019 304 Views

Note that both production and development system should point to same directory. SAP never transfer files from one transport directory to another. Below is the process:You release a request from dev system. This create files in /usr/sap/trans/(data & cofiles).When STMS Transport Management System is configured correctly, you immediately see the request on the production system import queue and can import it.Incase route in Transport Management System is not configured it is possible to add a request to queue and then import to production.STMS is complex process in SAP system. I would suggest you refer this link:SAP Help link

Read More

Creating xls file in ASP.NET to be imported to SAP

John SAP
John SAP
Updated on 13-Dec-2019 170 Views

Note that in SAP system, you can import Arrays via a Web Service or using .NET Connector. It shouldn’t be an xls file when you structure the data properly.You can upload an excel file into internal table using an ABAP code: 

Read More

Getting memory error while doing UNION in SAP HANA

John SAP
John SAP
Updated on 13-Dec-2019 390 Views

The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.To use this UNION clause, each SELECT statement must haveThe same number of columns selectedThe same number of column expressionsThe same data type andHave them in the same orderWhile performing UNION you need to note that what data it will bring. To perform UNION ALL you need to ensure that views should be fully materialized.To know more about SAP HANA Modeling, you can refer SAP Guide:SAP HANA Guide

Read More

Difference between Open SQL, Native SQL in SAP HANA

John SAP
John SAP
Updated on 13-Dec-2019 2K+ Views

As you know SAP was not providing any db for ECC and it had to be purchased separately. When you call your database in ABAP program, you need to write a SQL. As R/3 from SAP works with most relational databases, a common set of features had to be used, with some SAP specific extensions which are translated by the ABAP kernel to be understood by the actual DB. This language is known as Open SQL language.When you develop only for one database, it uses native instructions. IT is developed in Native SQL. Now when you use SAP HANA as ...

Read More

Calculate TVA amount in SAP T-Code: FB01

SAP
John SAP
John SAP
Updated on 13-Dec-2019 1K+ Views

Note that T-Code: FB01 (Post Document) is known as Financial Accounting module under application component Financial Accounting and runs Documentation FI posting program SAPMF05A upon execution.SAP TCODE                         :               FB01Transaction Description:               Post DocumentSAP Module ID                  :               FISAP Module Description:              Financial AccountingYou can refer SAP FI POST Document guide for more details.

Read More
Showing 51–60 of 88 articles
« Prev 1 4 5 6 7 8 9 Next »
Advertisements