Skip to Content
Author's profile photo Bhavinkumar Vyas

SAP BW Reporting For Credit Limit and Credit Exposure.

In SAP R3/ECC, Credit Limit is stored as part of credit limit master data table KNKK and Credit Exposure is getting populated in different tables using Function Module.

This document illustrates, How to fetch the data for Credit Limit and Credit Exposure for a particular customer for its respective credit control area.  

What is Customer Credit Limit?

A credit limit defines the maximum amount of credit that you are willing to grant a customer without the necessity of completing the approval process on a continual basis.

Options to Bring Credit Limit in SAP BW,

1> Install “0FI_AR_9 – Customer Credit Managmt. Cntrl Area Data via Delta Extractn” data source and activate the dataflow for the same.

2> Enhance the customer master data to bring the credit limit data from KNKK.


Note: Customer Info-object must have Credit Control Area as a Compounding Object.


What is Customer Credit Exposure?

As per Investopedia, Customer Credit Exposure is – The total amount of credit extended to a borrower by a lender. The magnitude of credit exposure indicates the extent to which the lender is exposed to the risk of loss in the event of the borrower’s default.


Customer Credit Exposure is a summation of Total receivables, Open sales order credit value, Open delivery credit value, Open Invoice Value and Special Liabilities i.e. down payments etc.


How Customer Credit Exposure Calculated?

– Go to FD33 T-code.

– Enter Customer and Customer Credit Control Area.

a.PNG

/wp-content/uploads/2015/08/b_768232.png

– Enhance “0FI_AR_9” Data source to apply following Logic for Customer Credit Exposure,

– Go to SE37 and Execute Function Module “SD_CREDIT_EXPOSURE”.

– Enter Customer and Credit Control Area Value.

/wp-content/uploads/2015/08/c_768242.png

– Total Amount Field is getting populated from KNKK Table in “0FI_AR_9” Data source.

/wp-content/uploads/2015/08/d_768243.png

e.PNG

  

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahip Mehta
      Mahip Mehta

      Very useful blog.

      Got to know something new with this blog.

      Author's profile photo Naga Ravi Kanth Batchu
      Naga Ravi Kanth Batchu

      Nice blog! well explained!

      Author's profile photo Former Member
      Former Member

      Very clear and precise document.

      Good work...

      Author's profile photo Nagendra Agarwal
      Nagendra Agarwal

      Excellent document !!

      Author's profile photo Former Member
      Former Member

      Thanks for sharing. Nice Information.

      Author's profile photo Former Member
      Former Member

      thanks for informative sharing..

      can you please write the code for 0FI_AR_9 enhancement to bring "Customer Credit Exposure" ?

      Author's profile photo Former Member
      Former Member

      Thanks for the information !!!