Interface between informatica and SAP BW

1.Import SAP FUCNTION:

 

At Application Source Qualifier, it’s program flow couldn’t supply the SYSDATE function.You can call the SAP FUNCTION which has the similar function to instead of SYSDATE.

In Source Edit View ,import the SAP FUNCTION as bellows:

 

L_DATE and L_TIME is the system date and time for output.

 

2.Call SAP FUNCTION In Informatcia

 

At Application Source Qualifer ‘s program flow ,click ‘Insert Function’ choose the ‘GET_SYSTEM_TIME_REMORTE’,and create Structure Field Variables(KDATE,KTIME,LDATE,LTIME) as below:

 

 

 

 

 

 

 

3.New ABAP Block

 

As far we only complete the SYSDATE function, If you want to achieve the SYSDATE – 7 ,You must to creat some abap code at New ABAP Block, as below:

 

 

4. to meet the business rule

 

The variable LASTDAY valued SYSDATE – 7 ,Now you can call it in your STATIC FILTER as below:

 

 

 

 

Eg:  Not only the date function in SAP FUNCTION ,you can call other SAP FUNCTION for your own business rule instead of calling bat file to improve the system performance.That’s my practice in integration between SAPBW and OP,If you find some error or better ideas ,Pls contact me.