topic Run BDC for tcode FB02 in Application Development and Automation Discussions

Run BDC for tcode FB02

ram_sahoo — Wed, 04 Feb 2015 08:25:45 GMT

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,

Re: Run BDC for tcode FB02

jayanthi_jayaraman — Wed, 04 Feb 2015 09:03:24 GMT

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.

Re: Run BDC for tcode FB02

ram_sahoo — Wed, 04 Feb 2015 09:40:22 GMT

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.

Re: Run BDC for tcode FB02

jayanthi_jayaraman — Wed, 04 Feb 2015 09:46:57 GMT

Hi,

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

Re: Run BDC for tcode FB02

ram_sahoo — Wed, 04 Feb 2015 12:53:29 GMT

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.

Re: Run BDC for tcode FB02

jayanthi_jayaraman — Thu, 05 Feb 2015 03:35:08 GMT

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.

Re: Run BDC for tcode FB02

ram_sahoo — Fri, 06 Feb 2015 07:23:46 GMT

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,