How to read overall status of line item in Tab Status of Sales Order

[Former Member]

Hi Friends,

I need to read the overall status of a sales order line item in transaction VA02.

For example line item 00010, in its status tab under processing status there is a field overall status which has value Open, Completed etc.

I need to read the text like open, completed etc.

Kindly help.

Thanks,

Pradeep

[Former Member]

Get it from table VBUP

[Former Member]

Hi,

I know that the status are being stored in table VBUP but they are like A, C etc. I need the full text of the status.

thanks,

pradeep

[Former Member]

Hi Pradeep again,

Hi,

For Overall Header status and administrative data you can check in VBUK table.

For overall Item status and administrative data you can check in "VBUP" table.

In both these cases you have to pass the order number number only in SE11/SE16 T.Code.

For object status you have to check in "JCDS" table.

In this initially you have to pass the order number in "VBAK" table and then fetch the "OBJNR" for that order.

Pass this OBJNR into "JCDS" to get the header object status in SE11/SE16 T.Code.

Regards,

Vijay

[Former Member]

its coming from domain of GBSTA.

i.e: STATV

use FM to read the value of this domain

Function module              DOMAIN_VALUE_GET " Fm name. use this

  Import parameters               Value
  I_DOMNAME                       STATV
  I_DOMVALUE                      A "pass the value that you are getting from VBUP, similarly for B and C

  Export parameters               Value
  E_DDTEXT                        Not yet processed

open the domain STATV for more details..

Edited by: Soumyaprakash Mishra on Sep 15, 2009 2:30 PM

[Former Member]

Hi Pradeep,

Try these tables.

Please have a look at below tables.

AUSP

Characteristic Values

CMFK

Storage Structure for the Error Log Header

CMFP

Storage Structure for Errors Collected

FMSU

FI-FM Totals Records

FPLA

Billing Plan

FPLT

Billing Plan: Dates

INOB

Link between Internal Number and Object

JCDO

Change Documents for Status Object (Table JSTO)

JCDS

Change Documents for System/User Statuses (Table JEST)

JEST

Object Status

JSTO

Status Object Information

KANZ

Assignment of Sales Order Items u2013 Costing Objects

KEKO

Product Costing - Header

KEPH

Product Costing: Cost Components for Cost of Goods Mfd

KNKO

Assignment of a Cost. Est. Number to Config. Object

KOCLU

Cluster for Conditions in Purchasing and Sales

KSSK

Allocation Table: Object to Class

NAST

Message Status

SADR

Address Management: Company Data

VBAK

Sales Documents: Header Data

VBAP

Sales Documents: Item Data

VBEH

Schedule Line History

VBEP

Sales Document: Schedule Line Data

VBEX

SD Document: Export Control: Data at Item Level

VBFCL

Sales Document Flow Cluster

VBLB

Sales Document: Release Order Data

VBSN

Change Status Relating to Scheduling Agreements

VBUK

Sales Document: Header Status and Administrative Data

VBUP

Sales Document: Item Status

VBUV

Sales Document: Incompleteness Log

VEDA

Contract Data

Regards,

Vijay

[Former Member]

Hi,

You can use the function module ADS2KIPBRO_GET_DOMAIN_TEXT

CALL FUNCTION 'ADS2KIPBRO_GET_DOMAIN_TEXT'

EXPORTING

e_table = 'VBUP'

e_field = 'RFGSA'

e_value = 'A'

IMPORTING

I_TEXT = V_TEXT

EXCEPTIONS

ILLEGAL_INPUT = 1

DOMAIN_NOT_FOUND = 2

OTHERS = 3 .

You will get the required text in V_TEXT.

Regards,

Gautham Paspala

[Former Member]

Hi Gautham,

Actually i want to capture Open, Completed

but the solution gave me gives the text from table VBUP

if A = Not yet processed

B = Partially Processed

C = Completely Processed

If you double click on line item and go to STATUS tab.

The status which is displayed for line item in status tab in field OVERALL STATUS like OPEN, COMPLETE

Thanks,

Pradeep

[Former Member]

not yet processed => its open

[Former Member]

Hi All,

I have solved this problem on my own,

Please find the solution for everyone's reference.

From Table VBUP enter Sales Order Number and get status A or B or C or blank

Go to table TVBST

Fields enter value

SPRAS = EN

TBNAM = VBUP

FDNAM = GBSTA

STATUS = A or B or C retrieved from table VBUP

get text in Field BEZEI.

thanks,

Pradeep Singh Dhadwal

[Former Member]

Thank you, Pradeep

[Former Member]

Hi Pradeep,

Atlast i found it.

You will find the text in table TVBST.

SELECT * FROM TVBST into ITAB WHERE SPRAS EQ sy-langu

AND TBNAM EQ 'VBUP' and FDNAM EQ 'GBSTA'.

regards,

Gautham Paspala