Credit Mgmnt - User Exit Logic

[Former Member]

Dear Experts

Automatic credit mgmnt settings are completed . Customized authorizations required is like below:

The reqt is like

1) Rs 0- Rs 50 Lakh - Person A

2) Rs50 Lakhs-Rs 1 Crore - Person B

3) Rs 1 Cr- Rs 2.5 Cr- - Person C

4) Rs 2.5 Cr & above - Person D

I presume that this can be done by using user exit... Field of 'Credit Limit'- KLIMK

'Credit Exposure'. OBLIG [from FD32]

Help/suggestions request ASAP.

Rgds

Sumanth.G

[reazuddin_md]

Dear Sumanth G,

You already got enough inputs it seems,

to add to the above,

You didnt mentioned,that this credit check wants to happen @ order or delivery level.

in such case, you need to let the system block the credit for every order / delivery ( for which you need to use maximum document value which is "1" -minimum price OR while defning credit control area - set the credit limit as minimum).

So that every order/delivery created will be blocked due to credit.

Now Create Zreport- to fetch all the credit blocked orders/ deliveries

( you can use the VBUK table - where overall credit status not equal to A)

in Zreport, fetch the document value either from Table S066(orders) or S067(delivery/billing) or VBAK-NETWR

Create Ztable as UserID - From Currency - To Currency as the key fields .

at the time of execution of the respective blocked orders / deliveries , system should filter with doc value & delete those records which is greater than "To Currency " field in Ztable.

the remaining documents only user can able to release.

Provide the functional spec to your ABAPer with complete logic. Very interesting report you can develop, which we are currently using such report.

Regards,

ReazuddinMD

[Former Member]

Dear Mr.Reazuddin MD

I extend my genuine thanks for your response.

Will Surely keep you posted.

Good day..

Rgds

Sumanth.Gururaj

[Former Member]

hi,

this is to inform you that,

you can solve your issue with an ABAPER,

he will write a big code for this.

these are the steps:

please write a piece of code in USER_EXIT_SAVE_DOCUMENT_PREPARE, which saves a document and triggers an email and stops proceeding further.

1) if the credit limit in KNKK reaches 50 lakhs mark you have to trigger a mail through a work flow to person ARs 0- Rs 50 Lakh - Person A

read the data basing on CCA/CREDIT LIMIT OF THE CUSTOMER/CUSTOMER NUMBER by catching user id who is preparing the sales order goto PA0105 to get the employee number and using employee number go to get the manager for amployee number using Z_GET_MANAGER a function module. after getting manager id from PA0105 trigger an standard function module called EFG_GEN_GET_USER_EXIT to get teh mail id of the manager - and trigger to approve the mail.

for this you have to link WORK FLOW event also in Z_GET_MANAGER function module.

here you have to create

1.new function module : Z_GET_MANAGER - which gets the total details of persons who are working in the whole organization.

2. 2 HR tables to get the details upto manager : PA0001, PA0105.

3. use standard FM : EFG_GEN_GET_USER_EXIT

4.finally link WORK FLOW EVENT which triggers an mail id to manager's in box with approval infomation.

hope this should help you

regards,

balajia

Edited by: balaji timmampalli achari on Nov 30, 2010 12:06 PM

[Former Member]

Dear Mr.Timmampalli

I am glad for your prompt response.

I am looking into it & surely update you.

Rgds

Sumanth.G

[Former Member]

hi sumanth gururaj,

many many thanks.

and

update the forum

because its a peruliar requriment.

balajia

[Former Member]

Hi Sumanth,

For credit limit along with FD32 there are other settings which we have to do in Spro.

The steps are as follows,

1.defining credit control area,

2.Assign the cca to company code.

3.Assing sales area to cca.

4.Define riks categories.

5.define credit groups.

i)credit limit check for order types,

ii)credit limit check for delivery types.

After all these steps it comes to the settings in fd32.

After that Automatic credit control.

Regards,

Ramesh.

[Former Member]

Dear Ramesh

All that has been done, long back.Now, the work is related to authorization settings as mentioned.

Any ideas on, how to proceed further..?

Rgds

Sumanth