cancel
Showing results for 
Search instead for 
Did you mean: 

credit management urgent

Former Member
0 Kudos

Dear sap gurus,

after implementing credit management in middle or not from beginning and if you want to have the history a particular customer updated in LIS or if we want to know about his credit exposure.

What should be done.Kindly help me.

regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

How To Do Configuration For Credit Management

Credit and risk management takes place in the credit control area. According to your corporate requirements, you can implement credit management that is centralized, decentralized, or somewhere in between.

An organizational unit that represents the area where customer credit is awarded and monitored. This organizational unit can either be a single or several company codes, if credit control is performed across several company codes. One credit control area contains credit control information for each customer.

For example, if your credit management is centralized, you can define one credit control area for all of your company codes.

If, on the other hand, your credit policy requires decentralized credit management, you can define credit control areas for each company code or each group of company codes.

Credit limits and credit exposure are managed at both credit control area and customer level. You set up credit control areas and other data related to credit management in Customizing for Financial Accounting. The implementation guide is under Enterprise Structure -> Definition or Assignment -> Financial Accounting and then Maintain credit control area. You assign customers to specific credit control areas and specify the appropriate credit limits in the customer master record.

Settings for determining the credit control area of a document. The settings of items 1 - 4 are taken into account according to their priority. The credit control area found is stored in field VBAK-KKBER.

1. Transaction OB38

Check which credit control area is assigned to the company code.

Company code:

Credit control area:

2. Transaction OVFL

Check which credit control area is assigned to the sales area.

Sales area:

Credit control area:

3. Transaction XD02 or VD02

Check which credit control area is assigned to the payer.

Payer:

Credit control area:

4. Transaction SE37

Is user exit EXIT_SAPV45K_001 being used?

5. Transaction OBZK

For the settings under items 2 - 4, field "All company codes" must be marked in Transaction

OB45, or the credit control area must be entered under the relevant company code in table

T001CM of the credit control areas allowed.

Company code:

Credit control areas allowed:

6. Settings for the credit checks

7. Transaction OVAK

Which settings do exist for the sales document type used?

Sales document:

Check credit:

Credit group:

8. Transaction OVAD

Which settings do exist for the delivery type used?

Delivery type:

Credit group for delivery:

Credit group for goods issue:

9. Transaction OB01

Credit management/Change risk category

Definition of the risk category for each credit control area. This risk category can be

assigned to a credit account by using Transaction FD32.

10. Transaction OVA8

Here, the individual credit checks for key fields

o credit control area

o risk category

o credit group are set. Take these key fields from the above settings and go to the detail

screen. In particular, check whether fields "Reaction" and "Status/block" are set

correctly. To carry out follow-up actions in case of a credit block, the credit check

status must be set (field "Status/block").

11. Transaction FD32

Credit master data for the payer of the relevant document.

Credit account:

Credit limit:

Risk category:

Currency:

12. Settings for updating the credit values Update of the credit values is required for the limit

check (static or dynamic credit limit check).

13. Transaction OVA7

Update of the credit value is active for the corresponding item type if the check box is marked. This field corresponds to

field "Active receivable" in Transaction VOV7.

Item type:

Active receivable:

14. Transaction V/08, Pricing

In the pricing procedure used for pricing, subtotal "A" must be entered in a line for

determining the credit value (mark the pricing procedure and doubleclick on "Control").

Usually, the net value plus taxes is used. This way the system is determined to use this

subtotal for credit pricing. The credit price is stored in field VBAP-CMPRE and used for

update and credit check.

You can find the used pricing procedure of the order under "Item -> Condition -> Analysis".

Pricing procedure:

Line with subtotal = 'A':

15. Transaction OB45

Which update group (field "Update") do you use in the relevant credit control area? The

default setting is "12". If you use another update group, check whether this is fine with

you. If you open an OSS message, please tell us the alternative update group.

Credit control area:

Update:

16. Transaction OMO1

Which kind of update did you choose for structure S066?

In any case, "Synchronous update (1)" has to be chosen as the kind of update.

All other settings will lead to errors.

Difference Between Simple and Automatic Credit Check Types

In automatic check, difference between static and dynamic checks.

SIMPLE CREDIT CHECK : Tr.Code - FD32

It Considers the Doc.Value + Open Items.

Doc.Value : Sales Order Has been saved but not delivered

Open Item : Sales Order has been saved , Delivered, Billed & Transfered to FI, but not received the payment from the customer.

Eg: Customer Credit Limit is Rs.1,00,000/-

Suppose Doc.Value + Open Item Value is Rs.1,10,000/-

Here credit limit exceeds then system reacts.

Options : A) Warning Message

B) Error Message (Sales Order won't be saved)

C) Error Message with Delivery Block

AUTOMATIC CREDIT CHECK : Give extra credit facilities to the particular customer.

STATIC CREDIT LIMIT DETERMINATION :Checking Group + Risk Catageory + Credit Control Area.

A) Credit Checking Groups : Types of Checking Groups.

01) Sales

02) Deliveries

03) Goods Issue

At all the above 3 levels orders can be blocked.

B) Risk Catageory : Based on the risk catageories company decide how much credit has to give to the customer.

HIGH RISK (0001) : LOW CREDIT

LOW RISK (0002) : MORE CREDIT

MEDIUM RISK(0003) : Average Credit

Static Credit Check it checks all these doc value & check with the credit limit

1) Open Doc.Value / Sales Order Value : Which is save but not delievered

2) Open Delivery Doc.Value : Which is delivered but not billed

3) Open Billing Doc.Value : Which is billed but not posted to FI

4) Open Item : Which is transfered to FI but not received from the customer.

DYNAMIC CREDIT CHECK : 1) Open Doc

2) Open Delivery

3) Open Billing

4) Open Items

5) Horizon Period = Eg.3Months

Here the System will not consider the above 1,2,3& 4 values for the lost 3 months

Then assign the Sales Doc & Del Documents.

Sales Doc.Type(OR) + credit Check(0) + Credit Group (01)

Credit Limit Check for Delivery Type : Del.Type (LF) + Del Credit

Group (02) + Goods Issue Credit Group (03)

Set Up for Credit Card Payment Processing

Given below is the set up for credit card payment processing:

Set Up Credit Control Areas:

Define Credit Control Area

Transaction: OB45

Tables: T014

Action: Define a credit control area and its associated currency. The Update Group should be u201800012u2019. This entry is required so the sales order will calculate the value to authorize

Assign Company Code to Credit Control Area

Transaction: OB38

Tables: T001

Action: Assign a default credit control area for each company code

Define Permitted Credit Control Area for a Company

Code

Transaction:

Tables: T001CM

Action: For each company code enter every credit control area that can be used

Identify Credit Price

Transaction: V/08

Tables: T683S

Action: Towards the end of the pricing procedure, after all pricing and tax determination, create a subtotal line to store the value of the price plus any sales tax. Make the following entries:

Sub to: u201CAu201D

Reqt: u201C2u201D

AltCTy: u201C4u201D

Automatic Credit Checking

Transaction: OVA8

Tables: T691F

Action: Select each combination of credit control areas, risk categories and document types for which credit checking should be bypassed. You need to mark the field u201Cno Credit Checku201D with the valid number for sales documents.

Set Up Payment Guarantees

Define Forms of Payment Guarantee

Transaction: OVFD

Tables: T691K

Action: R/3 is delivered with form u201C02u201D defined for payment cards. Other than the descriptor, the only other entry should be u201C3u201D in the column labeled u201CPymtGuaCatu201D

Define Payment Guarantee Procedure

Transaction:

Tables: T691M/T691O

Action: Define a procedure and a description.

Forms of Payment Guarantee and make the following entries Sequential Number u201C1u201D

Payment Guarantee Form u201C02u201D

Routine Number u201C0u201D Routine Number can be used to validate payment card presence.

Define Customer Payment Guarantee Flag

Transaction:

Tables: T691P

Action: Define a flag to be stored in table.

Create Customer Payment Guarantee = u201CPayment Card Payment Cards (All Customers can use Payment Cards)u201D.

Define Sales Document Payment Guarantee Flag

Transaction:

Tables: T691R

Action: Define the flag that will be associated with sales document types that are relevant for payment cards

Assign Sales Document Payment Guarantee Flag

Transaction:

Tables: TVAK

Action: Assign the document flag type the sales documents types that are relevant for payment cards.

Determine Payment Guarantee Procedure

Transaction: OVFJ

Tables: T691U

Action: Combine the Customer flag and the sales document flag to derive the payment guarantee procedure

Payment Card Configuration

Define Card Types

Transaction:

Tables: TVCIN

Action: Create the different card types plus the routine that validates the card for length and prefix (etcu2026)

Visa , Mastercard, American Express, and Discover

Create the following entries for each payment card

AMEX American Express ZCCARD_CHECK_AMEX Month

DC Discover Card ZCCARD_CHECK_DC Month*****

MC Mastercard ZCCARD_CHECK_MC Month

VISA Visa ZCCARD_CHECK_VISA Month

The Routines can be created based on the original routines delivered by SAP.

*****SAP does not deliver a card check for Discover Card. We created our own routine.

Define Card Categories

Transaction:

Tables: TVCTY

Action: Define the card category to determine if a

payment card is a credit card or a procurement card.

Create the following two entries

Cat Description One Card Additional Data

CC Credit Cards No-check No-check

PC Procurement Cards No-check Check

Determine Card Categories

Transaction:

Tables: TVCTD

Action: For each card category map the account number range to a card category. Multiple ranges are possible for each card category or a masking technique can be used. Get the card number ranges from user community. Below is just a sample of what I am aware are the different types of cards.

Visa Credit Expires in 7 days.

400000 405500

405505 405549

405555 415927

415929 424603

424606 427532

427534 428799

428900 471699

471700 499999

Visa Procurement Expires in 7 days.

405501 405504

405550 405554

415928 415928

424604 424605

427533 427533

428800 428899

Mastercard Credit Expires in 30 days

500000 540499

540600 554999

557000 599999

Mastercard Procurement Expires in 30 days

540500 540599

555000 556999

American Express Credit Expires in 30 days

340000 349999

370000 379999

Discover Card Credit Expires in 30 days

601100 601199

Set Sales Documents to accept Payment Card Information Transaction:

Tables: TVAK

Action: Review the listing of Sales Document types and enter u201C03u201D in the column labeled u201CPTu201D for each type which can accept a payment card

Configuration for Authorization Request

Maintain Authorization Requirements

Transaction: OV9A

Tables: TFRM

Action: Define and activate the abap requirement that determines when an authorization is sent. Note that the following tables are available to be used in the abap requirement (VBAK, VBAP, VBKD, VBUK, and VBUP).

Define Checking Group

Transaction:

Tables: CCPGA

Action: Define a checking group and enter the

description. Then follow the below guidelines for the remaining fields to be filled.

AuthReq Routine 901 is set here.

PreAu If checked R/3 will request an authorization for a .01 and the authorization will be flagged as such. (Insight does not use pre-authorization check).

A horizon This is the days in the future SAP will use to determine the value to authorize

(Insight does not use auth horizon period).

Valid You will get warning message if the payment card is expiring within 30 days of order entry date.

Assign Checking Group to Sales Document

Transaction:

Tables: TVAK

Action: Assign the checking group to the sales order types relevant for payment cards

Define Authorization Validity Periods

Transaction:

Tables: TVCIN

Action: For each card type enter the authorization validity period in days.

AMEX American Express 30

DC Discover card 30

MC Master card 30

VISA Visa 7

Configuration for clearing houses

Create new General Ledger Accounts

Transaction: FS01

Tables:

Action: Two General Ledger accounts need to be created for each payment card type. One for A/R reconciliation purposes and one for credit card clearing.

Maintain Condition Types

Transaction: OV85

Tables: T685

Action: Define a condition type for account determination and assign it to access sequence u201CA001u201D

Define account determination procedure

Transaction: OV86

Tables: T683 / T683S

Action: Define procedure name and select the procedure for control. Enter the condition type defined in the previous step.

Assign account determination procedure

Transaction:

Tables:

Action: Determine which billing type we are using for payment card process.

Authorization and Settlement Control

Transaction:

Tables: TCCAA

Action: Define the general ledger accounts for reconciliation and clearing and assign the function modules for authorization and settlement along with the proper RFC destinations for each.

Enter Merchant IDu2019s

Transaction:

Tables: TCCM

Action: Create the merchant idu2019s that the company uses to process payment cards

Assign merchant idu2019s

Transaction:

Tables: TCCAA

Action: Enter the merchant idu2019s with each clearinghouse account

Reward points if useful.

Regards,

Anbu

Former Member
0 Kudos

Hello Srinivasan,

U should've given a suitable link, instead of pasting the whole stuff.

Rgds,

Raghu.

Answers (1)

Answers (1)

sridhar_muthekepalli3
Active Contributor
0 Kudos

Hi,

Use SAP Standard Reports to know about customer credit exposure.

Logistics - Sales and Distribution - Credit Management - Credit management info system

You can also use this FI Reports Regarding customer Payment history

Accounting - Financial Accounting - Accounts Receivable - Customers: Items -

S_ALR_87012168 - Due Date Analysis for Open Items

S_ALR_87012175 - Open Items - Customer Due Date Forecast

S_ALR_87012176 - Customer Evaluation with OI Sorted List

S_ALR_87012176 - Customer Evaluation with OI Sorted List

S_ALR_87012177 - Customer Payment History

S_ALR_87012178 - Customer Open Item Analysis by Balance of Overdue Items

Please let me know if you need more information.

Assign points if useful.

Regards

Sridhar M

Former Member
0 Kudos

hai sridhar ,

thanks for ur reply,but i would like to know that when before go live we update the data of master records and my question is how will comapanies update the date of credit history of customers and will the previous history of customer balances will be taken in to consideration ?? plz reply i will

sridhar_muthekepalli3
Active Contributor
0 Kudos

Hi,

Customer open items will be uploaded using T.code FB01 and also by customer invoice - T.code FB70.

If Customer cleared items are uploaded, all the customer payment history will also be known

Please let me know if you need more information.

Assign points if useful.

Regards

Sridhar M

.