Customer history

[Former Member]

Hello,

How to find the Credit/Debit history by Customer?

Please give me the transaction and also the table where the data is stored?

Thanks

Mike

[Former Member · Accepted solution]

HI

Check the tcode VC/2 and also FD33 and in table KNVV

regards

[Former Member · Accepted solution]

Thanks, But I want to get the credits and debits given or taken from the customer from the past 7years.

I am looking for the table where the data is stored.

[Former Member]

Thanks for all your help guyz.

[Jelena]

BSID and BSAD tables store the accounting documents by Customer. One of them is for cleared documents, another for the open ones. Payment is type DZ, I think.

P.S. This is not an SD but FI question IMHO.

[Former Member]

Hi

Check in t code FBL5N

regards

[Former Member]

Thanks.The one's you guyz provided are the customer credit master.

I am looking for the tables which gives the details of payments made by the customer and payments to the customer.

Thanks

Mike

[Shiva_Ram]

Hi,

In SE16, you can try with tables

KNB4-Customer payment history

KNB5-Customer master dunning data

KNBK-Customer master bank details

KNC1-Customer master(transactional figures)

KNC3-Customer master (SPL Transactional figures)

Regards,

[Former Member]

Hi,

KNB4 Table gives you the payment history for your customer master.

Please check in SE11/SE16 T.Code.

KNBK table gives you the Customer Master Bank Details

KNC1 table gives you the Customer Master Transaction Figures

KNC3 table gives you the Customer Master Special GL Transactions

BSAD table gives you the all the cleared items of your customer master means out going payments.

BSID gives you the all the open items.

Please go through the following link:

[Outgoing Payments|http://help.sap.com/saphelp_sbo2005asp1/helpdata/en/19/c63e4eb0d64d02a608e73d7412c112/content.htm]

Regards,

Krishna.

[Former Member]

Hi,

Tcodes: FD32, FD33

Table : KNKK , KNKA

Thank you

[Former Member]

Hi Learner,

Did u check these standard reports :

S_ALR_87012177 - Customer Payment History

F.23 - Account Balances Customer

also check BSID table.......

Thanks,

Raja