Regd: Sale order Overall Status

[Former Member]

Hi All,

I hav requirement that depending on the Overall staus of a Sale Order i hav to get the data's of the Invoice details.

For this i need to capture the filed value of <b>"GBSTA_BEZ"</b> for that particular Sale Order in the T-Code Va02 or 03. but wen i chkd the screen it seems to be displaying through structure only.

Any idea where can i get the value of this particular field in any DB table or through any other method.

Help and Suggestions will be much apprieciated.

Thanks & Regds.

Ramesh.

[Former Member]

Ramesh,

Look at the VBKD table, you will find all the statuses there.

Regards,

Ravi

[Former Member]

Hi Ravikumar Allampallam,

Evn I chkd in the VBKD DB table also in the related tables but its not available, But its displaying through the structure <b>"VBSTT"</b>, i chkd for the field if stored in any toher table but its not.

Do we have any other method to get that Field Value.

Thanks & Regds.

Ramesh.

[Former Member]

Hi Ramesh,

Check for VBUP table, Hope it helps.

Regds,

Akshay

[Former Member]

Hi,

VBUK for sales documnet header status.

Regds,

Akshay

[Former Member]

Please use table VBUK to get the order overall status.

[Former Member]

Hello Ramesh,

Use FM RV_DOCUMENT_POS_STATUS_TEXTS to derive the status. It uses table TVBST to detereminet the status.

[Former Member]

Hello Ramesh,

Just to elaborate, For header level status it uses VBUK table with field GBSTA and for item level it uses VBUP-GBSTA fields. Pass the values to the table TVBST as

SPRAS = sy-langu.

TBNAM = VBUK/VBUP

FDNAM = GBSTK

STATU = VBUK-GBSTA/VBUP-GBSTA.

[Former Member]

it looks like VBUP should use GBSTA, and VBUK use GBSTK, so it should be:

Pass the values to the table TVBST as

SPRAS = sy-langu.

TBNAM = 'VBUK' / 'VBUP'

FDNAM = 'GBSTK' / 'GBSTA'

STATU = VBUK-GBSTA / VBUP-GBSTA