Run BDC for tcode FB02

[ram_sahoo]

Hi Experts,

I have need to update data for Tcode FB02 from table IDGT_INFO  and  GTSTATUS = ‘4’, collect the date into internal table Filter SENTDATE > = system date.So here my doubt is suppose today i runed this report in background the data will update till todays date, Suppose again tomorrow i want to run same report then report should update between from yesterdays to today's date means latest data. Anyone can help me for this conditions.

Thanks,

[jayanthi_jayaraman]

Hi,

Maintain entry in any specific constant table or TVARC with value as current date every time you execute. Also you need to update the table entry every time whenever the report is executed.

If you need timestamp specific, you need to take care of that as well in maintaining table entry.

Ex: executed 4th Feb 11:30

then 5th feb execution to consider after 11:30 4th Feb.

[ram_sahoo]

Hi Jayanthi,

Can i run SHDB transaction code in Q01 and can i Record that transaction code and collect logic to build run BDc.

Thanks.

[jayanthi_jayaraman]

Hi,

You can process BDC but for date filter, consider the option as suggested.

[ram_sahoo]

Hi Jayanthi,

Can i run SHDB transaction code in Quality system and can i Record that transaction code and collect logic to build run BDc.

Thanks.

[jayanthi_jayaraman]

Hi,

Do the recording in development system and then write the BDC program. Before populating the data from program for BDC, apply the criteria for filter in IDGT_INFO  as required. For restricting the data, you may need to do sent_date > = sy-datum and sent_date < date maintained in TVARC table or any other table in which you maintain run date. By doing this way, you need to make sure there won't be any further records on the same day in this table for current date. Because, you won't be considering the further records in tomorrow's run.

[ram_sahoo]

Hi Jayanthi,

While i Runed bdc program for change of  Referance field value in Tcode -FB02, Its showing error.Any bapi is there for chnage the Referance field value in Tcode - FB02.

Thanks,