Table for credit block

[Former Member]

Hi All,

I wanted to know which table or tables tell me about which orders are in credit block. I wanted to put this logic in my report table.

My purpose is just wanted to know which sales order are in credit block

cheers

shalsa007.........

[Former Member · Accepted solution]

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

VBKRED structure has the documents that are credit blocked.

Hope this helps

Regards

Sai

[former_member131745]

Hi,

SAP have already reports available for such a purpose. Sales documents can be checked according to their status in VKM1 and VKM4.

If you want to create your own report you can use status table VBUK. I have included a list of all the relevant fields below:

CMPSA Status of static credit limit check

CMPSB Status of dynamic credit limit check in the credit horizon

CMPSC Status of credit check against maximum document value

CMPSD Status of credit check against terms of payment

CMPSE Status of credit check against customer review date

CMPSF Status of credit check against open items due

CMPSG Status of credit check against oldest open items

CMPSH Status of credit check against highest dunning level

CMPSI Status of credit check against financial document

CMPSJ Status of credit check against export credit insurance

CMPSK Status of credit check against payment card authorization

CMPSL Status of credit check of reserves 4

CMPS0 Status of credit check for customer reserve 1

CMPS1 Status of credit check for customer reserve 2

CMPS2 Status of credit check for customer reserve 3

CMGST Overall status of credit checks

I hope this helps.

Thanks,

Gerard

[Former Member]

Hi,

I hope the answer in the below will be helpful to you up to some extent.

1. go to T-code VKM3 and select credit control

2. Execute or F8

3. Now you can find the list of SD documents blocked for Credit check

[Former Member]

Hi,

I hope the answer in the below will be helpful to you up to some extent.

1. go to T-code VKM and select credit control

2. Execute or F8

3. Now you can find the list of SD documents blocked for Credit check

[Former Member]

Hi,

You can view documents blocked for credit in the T Code VKM3. You can also use this transaction to release a blocked document.

I will find out and give u the table ....

Regards,

Srinivas

Edited by: Srinivasa Rao Nemalipuri on May 5, 2010 9:04 PM