Author name: CareerAsylum from SAP

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 »

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 »

SAP has Successfully Delivered SAP Build CodeJam at Walmart Global Tech, Bangalore

Hello Everybody, On 16th Feb of this month SAP Developer Advocates team has Successfully Delivered “SAP Build CodeJam” at Walmart Global Tech, Bangalore. Key highlights of CodeJams:  1. One day onsite “Free of Cost” upskilling programs offered by SAP to Upskill SAP Professionals on BTP 2. ABAP Cloud, SAP Build, CAP are the topics offered …

SAP has Successfully Delivered SAP Build CodeJam at Walmart Global Tech, Bangalore Read More »

Scroll to Top