Microsoft .NET Data Provider for mySAP Business Suite

[former_member290321]

Can some one explain me; where i should ask ABAP developer to put @variable in SAP so i can use it in my SSIS package.

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.

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

[Former Member]

tell the abaper to create a function module with import parameter @variable and table it_spfli so you can take the values of the internal table

example:

function z_retrun.

import variable

tables

it_spfli

select * into corresponding fields

of table it_spfli from spfli where

WHERE cityfrom='NEW YORK' AND cityto=variable.

end function.

[former_member290321]

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.

[JayChan]

Q1. I think it is quite simple, but you have to convince your abaper to modify his/her RFC to let @table_name and @field_name be input parameters.

Q2.You could use "SE37" on SAP R/3 to find a RFC called "BAPI_CUSTOMER_GETLIST"