Found 1044 Articles for SAP

Difference between Open SQL, Native SQL in SAP HANA

John SAP
Updated on 13-Dec-2019 06:44:16

1K+ 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

John SAP
Updated on 13-Dec-2019 06:42:44

699 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.

Getting memory error while doing UNION in SAP HANA

John SAP
Updated on 13-Dec-2019 06:45:39

209 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

Adding a Page break/new page in SAP Script

John SAP
Updated on 17-Feb-2020 12:47:45

998 Views

To add a new page, you can use Control command NEW-PAGE in Transaction SE71.SyntaxNEW-PAGE [page_options] [ spool_options]EffectThis statement creates a new page in the current list and writes the subsequent list output into a spool list.In T-Code: SE38 Print Program, you can use Function Module CONTROL_FORM to call NEW-PAGE command as below −CALL FUNCTION 'CONTROL_FORM' EXPORTING COMMAND = 'NEW-PAGE' EXCEPTIONS UNOPENED = 1 UNSTARTED = 2 OTHERS = 3.

Upgrading to SAP ECC 6.0 from 4.6C

John SAP
Updated on 13-Dec-2019 07:01:39

415 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

John SAP
Updated on 13-Dec-2019 06:51:46

159 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 linkRead More

Values are not readable while calling RFC method in .net via SAP.NET Connector 2.0

John SAP
Updated on 30-Jul-2019 22:30:20

114 Views

Please check if you have same Unicode encoding in SAP and .NET Connector.

Fetching data from transparent tables in SAP system

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:20

368 Views

Try checking length of variable if it is meeting minimum variable length required, if not append zeroes in end.

Demo version of SAP BW

Anil SAP Gupta
Updated on 17-Feb-2020 10:33:54

352 Views

Note that SAP doesn’t provide demo version of BI tool. Only trial available is for SAP Basis and Java Stack and these doesn’t include any ERP modules. Without availability of any ERP module, it hardly makes sense to use SAP BW demo version as there won’t be any sensible scenario to be used in BI.I would suggest you to use IDES which comes with fully configured business scenarios and BW functionality for demo.To know more about SAP BI 7.0 IDES system, you can refer this SAP thread −SAP Thread

With use of SAP .NET Connector to perform an upgrade

Anil SAP Gupta
Updated on 17-Feb-2020 10:36:46

148 Views

You have SAP Portal Development Kit PDK for .NET that can be used to connect SAP to Visual Studio 2003, 2005, 2008. SAP Portal Development Kit PDK for Microsoft.NET (PDK for .NET) is a set of tools that enables .NET developers to build portal content for SAP NetWeaver Portal. Using PDK for .NET allows organizations to leverage their existing investments in the Microsoft .NET technology and developer skills, as well as to take advantage of the SAP NetWeaver technology.SAP Portal Development Kit PDK for .NET package contains below components −PDK contains a Portal Add-in for Visual Studio VSIt also has ... Read More

Advertisements