Questions tagged as 'sap'

Tagged questions
2
answers

How to make a CASE WHEN from a Nvarchar Field that is sometimes Null or empty?

Well I have the following Query, it is a stored procedure for HANA STUDIO I have the Field A. "NumAtCard" which is of type nvarchar what happens is that many times the field will be empty or it will be null and I would like to know how to make...
asked by 09.11.2018 / 15:54
2
answers

Reports in SAP Crystal Reports with SQL queries

In SAP B1, you already have a report called "Provisional Balance" by default, and it shows you the initial Balance, Debit, Credit and Current Balance. It's the Next: Well here the question is to generate that same report in SAP Cryst...
asked by 05.04.2017 / 19:14
1
answer

What does the getView () function of SAPUI5 do?

Good afternoon, I am in full development of an application using SAPUI5, I have serious doubts with this piece of code and I would like to understand what each function does, what is really being done. this happens inside the "Controller" of...
asked by 01.11.2017 / 15:42
2
answers

Different logo for "company code" in a sapscript configured from transaction FBZP

Scenario of printing from transaction F110 of a sapscript (YSTP_F2021_PYADV) configured in transaction FBZP, where the configured Head Line is as follows: /* define distance of logo from left margin of HEADER-window /: DEFINE &LO...
asked by 31.10.2016 / 21:57
0
answers

SapUI5 Error when filtering by data type BoYesNoEnum

I am adding multiple search filters in my Query App, but the fields of type SAPB1.BoYesNoEnum of the Metadata of the services layer, throw me an error when filtering. EntitySet BusinessPartners property <Property Name="Valid" Ty...
asked by 01.01.2019 / 23:49
0
answers

Extract data from SAP to Excel. Error 619

I have recorded a sequence in SAP, and I have passed the code to the Excel developer. In that sequence, the only thing I intend to do is to open a query about it when opening the Excel workbook. I do not have the loop implemented to get all the...
asked by 27.11.2018 / 10:33
0
answers

Align Sub Report Crystal Reports

Look, I'm doing a report with Crystal Reports and I have seen that the subreports have gone a bit to the right with respect to the table that precedes them. It does not let me align it as if it allows with other elements and when I give right cl...
asked by 26.10.2018 / 16:54
0
answers

Script Capture SAP floating window text

I would like to ask for some help with capturing text from an SAP floating window. I'm working with SAP script and macro excel. at the end of the script, I tried to save it in a text variable, but it brings me the text of the header of the...
asked by 25.09.2018 / 23:06
0
answers

Error calling procedure in query manager sap b1 (hana)

I try to call a procedure with an input parameter, at the base of hana it brings me the data but when calling them in the query manager I do not get anything This is my from my query manager    / * Select * from "@ A1A_HSPC" t0 where t0. "U_c...
asked by 11.09.2018 / 21:23
1
answer

Extract content from DataGridView from SAP to Excel with Macro

I'm having trouble passing the contents of a DataGridView SAP to Excel with a macro. I get the error:    "The object does not support this property" Here where you mark me in the VBA This is the code section: Su...
asked by 09.09.2018 / 06:15