FBD1 posting - Recurring GL entries: Function module or BAPI for posting

[Former Member]

All,

I am trying to do posting of recurring GL entries through an excel upload program. For this I would require a BAPI or function module that does this in the background.

Has anybody used such a function module in your past experience.

Help is very much appreciated.

Regards,

Hari

[Former Member]

Go for a BDC recording.....

Batch-input is quite easy for transaction FBD1

[Former Member]

Erik,

The BDC has a problem where the screen fields will change based on the field status group of the GL account and the way the fields come on the screen is not consistent. That is why I wanted to know if there are any other options other than the BDC.

Regards,

Hari

[Former Member]

<<no_points_begging>>

Edited by: Vijay Babu Dudla on Mar 20, 2009 8:05 AM

[Former Member]

BDC Session is the best approach available. In order to have a clean BDC, use the Fast Data entry screen available in the transaction, which will help you in opening up all the fields irrespective of the field status groups

[Former Member]

Hi,

Use FM 'POST_DOCUMENT'

To use this FM you need to pass the document number, you can get the next document number using FM 'number_get_next' for object RF_BELEG.

I have used this for my implementation, it works.

Regards,

Sonal

[Former Member]

Hi Sonal,

how did you handle the error log in it?

I am using the FM and able to post documents. But since it is an update FM, I am not getting any error log.

Can you please help on this.

Thanks!

Sumit

[Former Member]

Hi Sumit,

Before posing the document we need to add one perform which will check for all valid data.

We need to add the validation manually and using BAPI.

Validation will include :

Mandatory field validation - similar to present in FBD1

start run < end run validation

date validation

Valid month check

Valid account check use table skb1

WBS validation

Document which are being posted should be validated using BAPI_ACC_DOCUMENT_CHECK

pass the header item and currency information to this bapi.

Regards,

Sonal