BKDF and BKPF

[Former Member]

I am currently using SAP ECC 60306. I am designing a solution to extend attachments (archive link) on recurring documents to the FI documents posted from them. Recurring documents only allow attachments when they are created in transaction FBD1.

I am starting in table BKDF to get the active recurring document numbers (company code, document number, fiscal year). Using this I can get the attachment - usually only one - from table TOA01 using the object ID (OBJECT_ID). Next, I need the posted FI documents from BKPF, but here is the problem. This table references the recurring entry document (DBBLG) without company code and fiscal year, so I am unable to return unique records. Because of this I will extend the attachment to the wrong documents by creating the entry in TOA01 with the wrong object key (company code, document number, fiscal year).

Anyone have suggestions for solving this problem? There are a few posts on this subject but no answers.

Thank you in advance,

Cliff

[former_member184223]

Dear Eli,

Got stuck in same issue kindly advise for fiscal year of BKDF what logic needs to be applied from BKPF as only recurring doc. no. is getting captured over there.

Thanks,

Gaurav

[Former Member]

No. This validity of the recurring document could cross fiscal years. For example, assuming a calendar fiscal year, there could be a recurring document having a validity of 06/01/2010 through 06/01/2011 created in fiscal year 2010, and another having a validty 01/01/2011 through 12/31/2011 created in fiscal year 2011. Running the first recurring document created in fiscal year 2010 would result in an FI document posted in 2011.

Thank you,

Cliff

[iklovski]

Hi,

Though, I did not get deep in your scenario, cannot you refer to the fiscal year, company code of BKPF table, assuming that if the link via DBBLG is referring to certain recurring document, this document would of the same parameters as the one in BKPF?

Regards,

Eli