Daily automatic vendor confirmations FK08

[LeeFung]

We have a need to automatically confirm vendor creations/changes on a daily basis.  We have 10 vendor account groups , but only one account group needs daily automatic confirmations.  Transaction code is FK08.   I am not sure how to schedule this job?  LSMW?  iDoc?   or a Custom Z report?   gurus, Please advise.

Thanks.

[João_FI_FIN-CS]

Hi,

In the creenhots below, maybe you can see what I did. I created a query with these tables and you can run foreground or background with company code, country, vendor account group, vendor's name, creation date, modification date, blocked code, etc in the insert or output report.

Please, take a look:

Foreground execution

Background execution

Output background

Remember that you've to do the query to run faster, so you've to insert some data to program research the tables faster.

JPA

[João_FI_FIN-CS]

Hi,

Remeber that you've standard options,i.e without Z report. Are you want to create for continous use or just for once consult?

JPA

[LeeFung]

I need it to automatically happen every day . No human intervention needed; but only for one vendor account group not all.

[LeeFung]

Thanks guys. Rather I am looking for a daily confirmations batch job run, which confirms vendors of a certain account group.   I am not sure if I can do this without ABAP.

[João_FI_FIN-CS]

Hi,

Also you can try to do a query between two tables: LFA1 and LFB1:

1. In the LFA1 you'll find the date and what time is confirmed;
2. With the result of LFA1, you will research in the LFB1 what company code they were assigned;

If you don't want do the step 2, you'n need. You can do just first step to view table and send to user how to run foreground or background.

If you have any doubt in how to buid queries, please check the document below:

JPA

[Former Member]

Hi,

You can try scheduling background job for T-Code FK09 Program RFKCON00 with the variant and set it to run daily as per requirement.

Thanks

SJ