February 2024

concat

Hi, I’m trying to compare the gpa2r field in the dfkkbo table with the concatenation of the OPBEL, OPUPW, OPUPK, OPUBZ fields in the dffkop table. However, a wrong number of arguments in the function error occurs. Can you help me please SELECT *FROM DFFKBOWHERE DOC2R = (SELECT CONCAT(OPBEL, OPUPW, OPUPK, OPUBZ) AS CDFFKOPFROM DFKKOP);

concat

Hi, I’m trying to compare the gpa2r field in the dfkkbo table with the concatenation of the OPBEL, OPUPW, OPUPK, OPUBZ fields in the dffkop table. However, a wrong number of arguments in the function error occurs. Can you help me please SELECT *FROM DFFKBOWHERE DOC2R = (SELECT CONCAT(OPBEL, OPUPW, OPUPK, OPUBZ) AS CDFFKOPFROM DFKKOP);

SAP Build Process Automation data backup and release process

Hello Community!! Looking for help with two queries.. A) How can one backup automation “data” of a productive SBPA environment at frequent intervals. By “data” I mean snapshot of things like MyInbox active task instances (active workflow tasks), Visibility Scenario Dashboard Data, Job logs (completed+active) etc.  Also, once this data snapshot is backed up, looking …

SAP Build Process Automation data backup and release process Read More »

SAP Build Process Automation data backup and release process

Hello Community!! Looking for help with two queries.. A) How can one backup automation “data” of a productive SBPA environment at frequent intervals. By “data” I mean snapshot of things like MyInbox active task instances (active workflow tasks), Visibility Scenario Dashboard Data, Job logs (completed+active) etc.  Also, once this data snapshot is backed up, looking …

SAP Build Process Automation data backup and release process Read More »

-147 Get CurrentUserInfo failed on SAP connection using DI API

On SAP Connection using DI API I’m receiving error: “-147 Get CurrentUserInfo failed”. diCompany.DbServerType = (BoDataServerTypes)Glo.DbServerType;diCompany.Server = Glo.Server;diCompany.DbUserName = Glo.DbUserName;diCompany.DbPassword = Glo.DbPassword;diCompany.CompanyDB = Glo.CompanyDB;diCompany.UserName = Glo.UserName;diCompany.Password = Glo.Password;Glo.retCode = diCompany.Connect(); Can’t find any information regarding this error on connection. Please assist?

-147 Get CurrentUserInfo failed on SAP connection using DI API

On SAP Connection using DI API I’m receiving error: “-147 Get CurrentUserInfo failed”. diCompany.DbServerType = (BoDataServerTypes)Glo.DbServerType;diCompany.Server = Glo.Server;diCompany.DbUserName = Glo.DbUserName;diCompany.DbPassword = Glo.DbPassword;diCompany.CompanyDB = Glo.CompanyDB;diCompany.UserName = Glo.UserName;diCompany.Password = Glo.Password;Glo.retCode = diCompany.Connect(); Can’t find any information regarding this error on connection. Please assist?

Create a oData server and add multiple entity

Hi, I want to create a only ONE Odata service with 4 tables from  SNWD_EPM model. Set A. I can join the following 2 table (SNWD_PD, SNWD_BPA)  and add association SNWD_PDSNWD_BPA Set B.  I can also join following following 2 tables ( SNWD_SO, SNWD_SO_I ) and add assiciation SNWD_SOSNWD_SO_IBut problem is, if there is no relation between Set A and Set B …

Create a oData server and add multiple entity Read More »

Scroll to Top