Which table has a Credit Status text in sales order?

[Former Member]

Hi all.

I've like to get a Credit Status text in sales order header.

but I don't know which table has it.

I think that status value of a Credit Status is VBUK-CMGST.

If you know that, please let me know.

Regards.

Rie.

[Former Member]

Hi,

Get the values from database view DD07V. Pass Domain name (CMGST) , language and value to get the text.

Regards,

Srini.

[Former Member]

Thank you for your reply, Srini Vas.

It's a different value...

It displayed 'Not performed' on VA03, and VBUK-CMGST is initial.

and I checked DD07V-DDTEXT, this value is 'Credit check was not executed/Status not set'.

It's different...

Do you know that?

Regards.

Rie.

[Former Member]

Hi,

I think it is hardcoded if cmgst is initial.

Regards,

Srini.

[Former Member]

Hi

Try this function module which SAP is using,

CALL FUNCTION 'RV_DOCUMENT_HEAD_STATUS_TEXTS'

EXPORTING

VBUK_GELESEN = CHARX

VBUK_IN = VBUK

WINDOW_SENDEN = SPACE

IMPORTING

VBSTT_WA = VBSTT.

And you can use VBSTT-CMGST_BEZ as the text you want.

You can also check the table TVBST, here you can give the language, table name VBUK , field name CMGST and status as blank,

You will get the texts as Not Performed.

Best Regards,

Nikhil Patil

Edited by: Nikhil Patil on Mar 10, 2011 8:59 AM

[Former Member]

Thank you for your repry, Nikhil and Andrea.

I can get the text using TVBST.

I appreciate you helping me !

Regards.

Rie.

[Former Member]

Hi Rie,

you found it in table TVBST

regards

Andrea

[former_member659926]

Thanks you, this is the real answer at the question.