Found 1039 Articles for SAP

Architecture for Deploying SAP HR module

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

138 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

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

607 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

163 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

766 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

352 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

176 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

255 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

304 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

Accessing Source code of SAP Transport without using SAP system

Abhinanda Shri
Updated on 14-Feb-2020 08:13:04

380 Views

I don’t think it is possible to check source code without SAP system until you understand SAP Binary code. The format in which the data are stored in the data file is AFAIK, an SAP own format and you can use R3trans to read code using the command.R3trans -l [-w ] [-v ]To know more about R3trans, you can refer to this link −https://archive.sap.com/discussions/thread/1277788

Advertisements