Found 1044 Articles for SAP

Getting table name in SAP system

V Jyothi
Updated on 18-Feb-2020 07:26:58

3K+ Views

Once your data is displayed on screen please follow the below steps −Position your cursor onto the field.Press “F1” Help option – In “Performance Assistant”.This Dialog will show the information for “Table Name” and “Table Field”.

Loading 3rd party libraries in SAPUI5

Sravani S
Updated on 18-Feb-2020 07:28:51

753 Views

JavaScript includes various third-party libraries that ease the development while working on SAP UI5 app. You can use following jQuery as below −jQuery.sap.require("sap.ui.thirdparty.jqueryui.jquery-ui-core");Other common JavaScript libraries that are in use −MomentJSLoadshTo load a third party library in SAP UI app project, create a folder “libs”. This folder is used to put third-party libraries −You can create a file named- moment.js and paste the code that has been copied from third party library website. This code can be included in your UI5 app using the library - index.html.

Formatting date in SAP system

Ramu Prasad
Updated on 16-Dec-2019 07:34:34

98 Views

You will need to apply new culture to the existing thread as shown below:ExampleDateTime now = DateTime.Now; Console.WriteLine(now); CultureInfo sapCulture = new CultureInfo("en-US", true); sapCulture.DateTimeFormat.ShortDatePattern = "ddMMyyyy"; //sapCulture.DateTimeFormat.FullDateTimePattern =    sapCulture.DateTimeFormat.ShortDatePattern + " HH-mm-ss"; sapCulture.DateTimeFormat.LongTimePattern = "HH-mm-ss"; //sapCulture.DateTimeFormat.ShortTimePattern = "HH-mm-ss"; System.Threading.Thread.CurrentThread.CurrentCulture = sapCulture; //System.Threading.Thread.CurrentThread.CurrentUICulture = sapCulture; Console.WriteLine(now);

Taking backup of schema in SAP HANA

Govinda Sai
Updated on 16-Dec-2019 07:50:51

284 Views

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/

SAP Crystal Report file is not opening in VS2015

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

206 Views

To start with I would suggest you to check SP level on Crystal Report Visual Studio. Try reinstalling Crystal Report and make sure your asp.net application is configured properly. There are various forums that you can search specific for Crystal Reports for VS like this:SAP Tags

Using SAP NetWeaver Recording and Playback features

John SAP
Updated on 13-Dec-2019 06:38:14

99 Views

Note that while using SAP Recording and playback, you get an export option however exporting to spreadsheet has a number of limitations, like the number of rows and columns (note 700206), file size (note 1854956) and many other limitations.700206 - XXL: MAX Size Limit for Excel Export for Table and PivotSAP Note 700206Solution as per SAP Note:Increased the Max Size Limit to 65536 rows and 256 columns for Table and Pivot Table option of Excel Export. This change is available for officeintegration technology only and no adaption is possible to old SAP Macros. To get the correction import the relevant ... Read More

Analyzing code coverage results in SAP Design Studio on top of HANA

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

46 Views

To consume HANA view, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe.Next step is open SAP Design Studio and add a data source by connecting to HANA system and open view as below:This way you can view your SAP HANA view in Design Studio, now to analyze code coverage results, you can refer this SAP blog for step by step process:SAP blog

Query in Analytic view creating unexpected results in SAP HANA

John SAP
Updated on 17-Feb-2020 12:40:49

180 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

Not able to save a SAP Crystal Report for Enterprise 4.2

John SAP
Updated on 17-Feb-2020 12:41:56

106 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

In SAP Business One SDK, filling a gridview and button saves in database

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

313 Views

This can be achieved in multiple ways. You can either use a SAP DI documents, an open SQL or use data transfer workbench for this purpose.You can use a direct SQL write as this is one of straight way to do this. It is also possible to use SAP-DI Documents object to iterate over the Purchase Orders.One more option is using Data Transfer Workbench (DTW), where you export it to a file and then using DTW. It also provides error handling incase any exception occurs.

Advertisements