Table For Checking Credit Limit Block

[Former Member]

Hi Expert,

We have scenario like this :

I have created Sales Order with number for example 120000. And then I'm going to create Delivery order from that sales order.

when i would like to save the delivery order, system gives the error message like this " Oldest of open items overdue". and i can't save the delivery order anymore.

Could u tell me what is the table where store the flag which make the delivery order couldn't saved ? cause i would like to make a report about that.

warm regards,

rhesa syahrial.

[Former Member]

This message was moderated.

[former_member365422]

Dear Rhesa,

I dont think you can find this flag in any table.

you have configured automatic credit check(OVA8) for deliveries.

When you create delivery, system runs the credit check again as per your configuration in OVA8.

Error is a result of credit check and not because of any flag in any table.

and as you have configured in OVA8 as error message for oldest open item, system will not allow you to save and since you cannot save no flag will be stored in any table.

Hope this clears

Regards

Mayank

[Former Member]

hi,

this is to inform you that,

check this programs and execute in SE38

RFDKLI20

RVKRED77

hope this clears your issue.

balajia

[Former Member]

Hello,

S066 / S067 for credit information

VBUK table for the status.

Regards

Waza

[Former Member]

hi

You can view documents blocked for credit in the T Code VKM3 / VKM4

Also Sales order Table VBUK , and field CMGST tells the credit status of the document

[Former Member]

Hi Vishal,

I have forgot to add this information in my question. I have checked before in table VBUK. but there is no value in field CMGST.

Thanks,

Rhesa

[Former Member]

hi Rhesa

you can check the program RFDKLI40 and see any oldest open items are there for the customer

Use SE38 to run this

Edited by: Vishal J on Jan 17, 2011 5:34 AM