06-24-2008 8:23 PM
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
06-26-2008 4:19 AM
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.
06-26-2008 5:13 PM
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.
10-06-2009 7:51 AM
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"