Want to update table S066

[Former Member]

Hello Experts,

I want to update the infostructure S066 when the credit limit is under the limit.

For example my scenario is like this.

I have a customer X whose credit limit is 2000 EUR. When I create a Order with 1500 EUR, the credit exposure is not updated at all.

Could you please help me in this regard.

Thanks for your help in advance.

Waiting for your valuable suggestions.

Best Regards,

Vasanth M

Edited by: Vasanth M on Feb 22, 2010 2:43 PM

[Former Member · Accepted solution]

Hi,

S066 table is updated with open sales order values.Same value you can check in FD33 in the status screen sales value field.

You need to run RVKRED 77 to update and RVKRED88 to simulate the values and get updated concerned tables.

Please check and confirm updation group should be 0000012.

Regards

Jagan

[Former Member · Accepted solution]

Hello All,

Thanks for your help. But my requirement is when the sales order contains a item which is not confirmed then the table S066 is not updating.

Do we have any possibnility to achieve this. I.e) Need to update the table table when there is no confirmed quantity.

Please suggest.

Regards,

Vasanth M

[Former Member · Accepted solution]

Vasanth,

I dont think S066 table is updated without confirming the material.Logically if you think what ever updating in that table that much value has been deducted from customer credit limit. Here material is not confirmed means customer is not going to receive any thing.

Thanks&Regards

Jagan

[Former Member · Accepted solution]

Hello Jagan,

This is expalined in the OSS note number 377165.

Could you please suggest the possibility to achieve this.

Regards,

Vasanth M

[Former Member · Accepted solution]

Hi Vasanth,

Yes it is clearly mentioned in that note without confirmation of the material ( VBEP-BMENG) , the system does not update the open sales order value.

regards

Jagan

[Former Member · Accepted solution]

Hello Jagan,

So there is not possibility to achieve the requirement?

Regards,

Vasanth M

[Former Member · Accepted solution]

Vasanth,

Not at all possible to update.

regds

Jagan

[former_member131745]

There are several methods for doing this. You can use the 'requested quantity' instead of the 'confirmed quantity' to get the credit value. The requested quantity will always be present:

Userexit RMCS1US3:

With help of this userexit you can decide if the open delivery quantity (OLFMNG) is set from confirmed quantity (VBEP-BMENG) or from requested quantity (VBEP-CMENG).

You may find this old OSS note useful: 149559

You could also make use of the userexits offered by SAP for carrying out the credit check. See also OSS note: 751044

Either two of these options will work but may take a little modification.

I hope this helps.

Gerard

[Former Member]

Hello Gerad,

Thanks for your update. I have went through all the possibility. As you said in the user exit RMCS1US3 if you change the flag

CH_flg_required_QUANTITY to X, the required quantity is considered for checking. But it is not updating the table S066.

What shall I do?

Best regards,

Vasanth M

[former_member131745]

Note 149559 gives an example about how to make the system use the required quantity during sales order release (example VKM4). So you should adapt the userexit to your needs, so that the field CH_flg_required_QUANTITY is set to 'X' when you want.

I hope this helps.

Gerard

[Former Member]

Hi Vasanth -

Were you able to update S066? I have a similar issue and I can not get S066 to update with quantities which are not confirmed. Even after using the user-exit.

Thanks,

Suzanne

[Former Member]

We cannot update S066 when the item is not confirmed

[Former Member]

Standard SAP will not allow this.

Credit check will happen for the quantity confirmed in the sales order and same is updated in s066.

If you want to change this standar behaviour , then you have change the Requirement planning .

Check setting in ATP and requirement class . Remove the selection tick for AVIALABILTY and REQUIREMENT TRANSFER

for requirement class and check . If your requirement planning is based on strategy group then check settings for strategy group.

This might work , check and confirm

Senthils

[Former Member]

Hello Senthil,

Could you please explain more. In which Tcode we need to make this change.

Are it is possible to do this in any user exit.

Please explain.

Thankyou ver much.

Vasanth M

[Former Member]

Hello Experts,

Let me put my question directly.

When I don't have a confirmed quantity in the order, S066 table is not getting updated.

Do we any possibility to update it.

Please reply.

Regards,

Vasanth M

[Former Member]

hi

KIndly check the below

1. Delivery block is maintained in the sales order

2. Payment guarentee procedure has been mainytained in the sales order

3. kindly check the t code OVAD that credit group is maintained for the sales doc type

4. Check the t code OVA8 and see the settings for your credit control area and risk category

To update the table S066 kindly use the program RVKRED77

Regards

Damu

[Former Member]

Hi,

Please confirm the Update method assigned to your credit control area is 12. This will take Open Sales order value into consideration. (S066)

SAP Customizing Implementation Guide --> Definition --> Financial Accounting --> Define Credit Control Area

Dany

[cong_yu2]

Hi,

i'm afraid that it's the standard function that credit exposure only updating related to confirmed quantity in sales orders.

even with development you achevie the requirement, it will be a bit confused, as the confirmed quantity is changed from time to time, and it's also relevant to MRP etc... i will suggest that you can create a dummy order with confirmed quantity to update the credit exposure.

Thanks!