topic Re: SAP-.Net @variable in Application Development and Automation Discussions

SAP-.Net @variable

former_member290321 — Tue, 24 Jun 2008 19:23:58 GMT

The following SELECT statement returns all the columns in the SPFLI table for flights from New York to a city that is specified by the value of a variable. Where ABAP developer should add this variable.

To execute this statement, you must create a SAPParameter with the name @variable, specify its value, and add the SAPParameter to the SAPCommand object corresponding to the query.

[link|http://technet.microsoft.com/en-us/library/ms141761.aspx]

Code SnippetSELECT * FROM SPFLI WHERE cityfrom='NEW YORK' AND cityto=@variable

Re: SAP-.Net @variable

matt — Wed, 25 Jun 2008 06:07:21 GMT

So what's the question?

Re: SAP-.Net @variable

former_member290321 — Wed, 25 Jun 2008 08:43:36 GMT

Where to add the variable in SAP so i can pull the table using that variable.

Re: SAP-.Net @variable

matt — Wed, 25 Jun 2008 10:14:36 GMT

Not an ABAPers task. SAPParameter and SAPCommand are part of ADO.NET interfaces.

http://msdn.microsoft.com/en-us/library/cc185328.aspx

Re: SAP-.Net @variable

former_member290321 — Thu, 26 Jun 2008 16:14:15 GMT

I have thought other option please tell me whether it will work of not.

Say if I ask ABAP developer to make custom RFC with simple select statment

i.e.

select * from Table_Name

where Field_Name between @StartDateofLastMonth and @EndDateofLastMonth.

The aforesaid select statment will get the calculated startdate and enddate from sap system date.

where as i have to give @Table_Name and @Field_Name from my end as variable...

What do u think will it work and how much time it will requir to develop.

One more favor where i can get sample RFC for the aforesaid.