Found 1044 Articles for SAP

Extracting data from SAP ERP for a Third Party SystemExtracting data from SAP ERP for a Third Party System

Nitya Raut
Updated on 30-Jul-2019 22:30:20

220 Views

Let’s talk the standard way - It would be a great option to opt for creating a REST based ODATA services. You can expose the SAP functionalities mainly BAPI or any RFC as a service with SAP gateway. SAP gateway lets applications to exchange data across a variety of technologies and applications.In case the requirements are not extensive and can be catered by existing API’s exposed by SAP, then you can just enable the required services for usage. These APIs will require good hands-on knowledge of SAP Services.You can build an SAP source data plugin using JAVA and JAVA SAP ... Read More

Architecture for Deploying SAP HR module

Nishtha Thakur
Updated on 30-Jul-2019 22:30:20

72 Views

It would be good to separate the HR from other modules as not only the load and usage is high on HRmodule but the business and security requirements differ for HR module as well.In such scenarios, other module can be customized in terms of security and configured as per theirneeds. Also separating the Central instance and database to different machine is a very commonapproach but can be avoided too by configuring the Central instance to adjust the load.

Error Message: Unsupported xstream found: (“HTTP Code 200:OK”)” while consuming SAP Web Service

Amit Sharma
Updated on 30-Jul-2019 22:30:20

718 Views

I think this is related to incorrect HTTP destination configuration. You can check Web Service using T-Code: SOAMANAGER to verify if HTTP destination is configured properly.

Accessing table data from SAP system

Amit Sharma
Updated on 14-Feb-2020 11:28:35

422 Views

Using Select statement you can read data with a dynamic table name. Try using below code &areDATA: lv_tablename TYPE string,    ev_filelength TYPE i. lv_tablename = 'mara'. "e.g. a parameter DATA dref TYPE REF TO data. CREATE DATA dref TYPE TABLE OF (lv_tablename). FIELD-SYMBOLS: TYPE ANY TABLE. ASSIGN dref->* to . SELECT * FROM (lv_tablename) INTO TABLE .

In SAP database, Importing table columns with /’s in the name

Johar Ali
Updated on 28-Jan-2020 05:49:51

102 Views

I would suggest you to use BCP utility to perform an import/export of data to a text file in SQL Server. When you run below command, it loads data to a text file.BCP Db.TN out "Location of the text file " -c -S ServerName –TNow if you want to load data to SQL Server from a flat file, you can use this:BCP Db.TN in "Location of the text file " -c -S ServerName –TYou can also try editing Mappings while loading data from a flat file.

Finding CUID in a SAP BO Webi report in Formula Editor

Rahul Sharma
Updated on 30-Jul-2019 22:30:20

498 Views

In Business Object, a CUID is a key to identify Universe or report in the same cluster when you publish an object first time in the repository. CUID is part of metadata stored in repository and data actually exists in the report.I don’t think you can find CUID from a webi report while you are editing in modify mode. This could be possible with the use of SDK.You can find CUID by opening object properties in CMC.

Writing a material on SAP system via .NET Connector

Johar Ali
Updated on 11-Dec-2019 06:37:48

207 Views

Once you create material, you need to call BAPI- BAPI_TRANSACTION_COMMIT. “BAPI_TRANSACTION_COMMIT” is called to COMMIT a database operation. As COMITT statement can’t be called inside BAPI, we call this BAPI to complete COMMIT.Let us say you are editing some table fields in BAPI- as per failure or success, you can perform a COMMIT or ROLLBACK.To perform a COMMIT call BAPI_TRANSACTION_COMMIT. Below is sample COMITT:CALL FUNCTION 'BAPI_TRANSACTION_COMMIT' * EXPORTING * wait =    "bapita-wait    IMPORTING    return = "bapiret2 . " BAPI_TRANSACTION_COMMITYou can see full documentation about BAPI_TRANSACTION_COMMIT:FU BAPI_TRANSACTION_COMMIT____________________________________________________Short TextExecute external Commit when using BAPIsFunctionality:This method executes a COMMIT WORK ... Read More

Open a Workbook require loading SAPBEX.xla file

Amit Sharma
Updated on 14-Feb-2020 10:28:54

112 Views

Copy the below code in PERSONAL.XLSM module of your workbook and then refresh −Private WithEvents App As Application Private Sub Workbook_Open()    Set App = Application End Sub Try adding below code, in your module: Private Sub App_WorkbookOpen(ByVal Wb As Workbook)    MsgBox "New Workbook: " & Wb.Name End Sub

Parsing SAP Logon ticket with .NET

Johar Ali
Updated on 14-Feb-2020 10:23:49

159 Views

SAP provides SAP SSO EXT Lib for parsing SAP Logon ticket. SAP SSO EXT library supports SAP logon tickets as a part of the java based application.You can download SAP SSO EXT library from SAP service marketplace http://service.sap.com/swdc and then search here for SAPSSOEXT.

Running a SQL query from specific month in SAP DB

Johar Ali
Updated on 28-Jan-2020 05:13:37

192 Views

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

Advertisements