About former_member651578

former_member651578

I'm using SAP B1, v10.00.120 PL2, with Coresuite customizations. I'd like to run an MS Access procedure, passing an UDF value as parameter. The help file suggests to use an Easy Function (like SQLQuery) with EXEC xp_cmdshell. Once enabled the above...

former_member651578

Hi there, I'm quite new in SAP, I have created a new tab in Business Partner form, using coresuite grid configurator, displaying data from OSPP and additional related tables. Now I'd like to put a golden arrow link near one UDF field and run an exter...

former_member651578

I'm creating a VIEW (to be used as Excel pivot source) that collects data from five different tables. I coded it in MS SQL Server Management Studio and it works fine, but when I copy it to the VIEW I get the error (Unable to parse). The SQL is like...

former_member651578

I found an example on the web: SQL Query code with variable declaration https://answers.sap.com/questions/660853/sql-query-code-with-variable-declaration-does-not-.html/* select * from ORDR x */Declare @Num as INTSet@Num = /* x.DocNum */ [%0]Select...

Re: Query Manager Syntax

Well, I tried to apply the above tip, but it fails. The code: DECLARE @Year AS NVARCHAR(10) DECLARE @Month AS NVARCHAR(10) SET @Year = /* select year from OACP T0 where T0.year = */ '[%0]' SET @Month = /* select DocNum from OINV where DocNum = */ ...

User Statistics

User Activity

Run external program

Arrow link to external program, with parameter

create a VIEW with UNION and WHILE

Set parameters for Query Manager using a "complex" query and not just a SAP table

Re: Query Manager Syntax