Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2009 at 08:37 AM

    Get it from table VBUP

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2009 at 08:40 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2009 at 08:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2009 at 09:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.