Function Module for clearing customer open line items?

[Former Member]

Hi,

Can anyone suggest me, the FM for clearing the customer open line items/

Manually we can do by f-32.....but, i need an FM for this?

Thanks in Advance,

Manju.

[former_member194797]

The FM was given in the second answer: POSTING_INTERFACE_CLEARING.

Please search also in the forum with keyword "POSTING_INTERFACE_CLEARING".

[ravi_nagh]

Hi

There is no function module. How ever you can find Selection and Preparation of Open Items in program SAPMF05B

FORM_SEL_PRUEFEN -> FORM POSTEN_LESEN -> FORM SELTAB_ABARBEITEN -> FORM SELTAB_ABARBEITEN_S1 -> FORM POSTAB_DATEN.

I hope this helps.

Regards

Ravinagh Boni

[Former Member]

Hi. I just found a good way of doing this from a program. It sort of uses BDC but in such a way that you don't get all the problems you normally get with BDC.

First create a custom program with an internal table called YBSID of type BSID, and select into it from BSID the items you want to clear, 1 customer at a time. You must call your internal table YBSID.

Then you need to populate a BDC table with very basic data, the easiest way to do it is to set a break-point in form "CALL_TRANSACTION" of include F124_MERGE, then run F.13, it will break at this point and you can copy the contents of BDCDTAB.

Then in your custom program put the same statement as the include "EXPORT YBSID TO MEMORY ID '%F124%'." then call transaction 'FB1D' using the BDC table.

What this does is clear exactly whatever data you put in YBSID. It uses the transaction FB1D but all the clearing data is already populated from YBSID. If you call a transaction normally it is very hard to select the right items to clear, using YBSID you only enter 1 screen and do not have to select anything.

You can also use this same method to clear vendor line items using YBSIK and transaction FB1K and G/L line items using YBSIS and FB1S.

I hope this helps.

Regards,

Dave.

[Former Member]

hi,

Did any bosy tried this solution when i am trying to do this.its not stopping here.

can u suggest any alternative of doing this.

Thanks &Regards,

Malathi

[Former Member]

Hi. Are you trying to set the break point in F124_MERGE to find the contents of BDCDTAB? It should break from F.13, but if not let me know, I can give you the contents that the BDC table needs, it is only 10 lines or so.

This whole process definitly works, I have a working program that uses it and all seems to work well.

Regards,

Dave.

[Former Member]

This message was moderated.

[Former Member]

Hi. My method has to be done via BDC, as per the post on July 28.

You have found the items you want to clear and exported YBSIS to memory OK?

In that case, please see below for the BDC contents. It is a bit different to how I would normally do a BDC table, but I copied it exactly from how SAP did it using F.13. It is very basic, only 9 lines in total:

Program Dynpro Dynbegin Fnam Fval

SAPMF05A 0131 X

SAPMF05A RF05A-AGKON 0000020030

SAPMF05A BKPF-BUKRS 1000

SAPMF05A BKPF-WAERS GBP

SAPMF05A BKPF-BUDAT 07.09.2009

SAPMF05A BKPF-MONAT 06

SAPMF05A BDC_OKCODE /11

SAPMF05A 0700 X BDC_OKCODE /

SAPMF05A BDC_OKCODE /11

Basically in transaction FB1S if you send through OK code /11 it imports YBSIS from memory and clears exactly what you specify.

Regards,

Dave.

[Former Member]

Hi.

I need to clear open G/L line items of different accounts. Following the steps which mentioned David, I'm not able to transfer them to FB1S using YBSIS. It seems that the same account is required in all the items.

Is there another way to do this which allow me to clean open G/L line items of different accounts?

Thanks.

[uygur_burak]

Hello,

If you want to write some ABAP codes for clearing FI documents, I propose BDC method for this case, but you also try POSTING_INTERFACE_CLEARING FM .

Regards,

Burak.

[Former Member]

Hi,

Have to tried transaction F.13, since it will clear customer/ vendor / GL open items.

And try tcode OKB9 and OB74, these will be helpful to automatic clearing og the open line items.

Thanks,

Srinu