topic Clearing data in Application Development and Automation Discussions

Clearing data

former_member445510 — Thu, 05 Dec 2013 16:13:54 GMT

Hello Every body,

I'm using the table BSAK and BSAD for extracting clearing docs of Accounting docs extracted from BSEG and BSET and BKPF.

1- For Clearing Data:

Where can i find Payment method ?

Where can i find accounting information (banking account) ?

2- I have extract documents from bkpf - bseg -bset for posting, i want now extract the cleared documents for the same extracted accounting documents.

How can i do that ?

Abap example is great.

Thank u .

Ouail

Re: Clearing data

Former Member — Thu, 05 Dec 2013 16:56:45 GMT

Hi,

1. You can find the payment method BASK-ZLSCH

2. bsak-lifnr = LFBK-LIFNR ( get the LFBK-BANKN)

Re: Clearing data

Former Member — Fri, 06 Dec 2013 05:36:44 GMT

Hi ouail,

You can find the payment method and payment terms from ZLSCH and ZTERM correspondingly from the table BSAK.

You can get the accounting information like bank account number(BANKN) from the vendor master(bank details)

table LFBK and customer master (bank details) KNBK respectively by inputting the vendor no or customer no that you get from BSAK or BSAD respectively.

From the extracted documents of BSEG or BKPF only the cleared items will be there in BSAK and BSAD, all the open items will be in BSIK and BSID.

Thanks and regards,

Ashish Kumar