09-15-2009 9:33 AM
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
09-15-2009 9:37 AM
09-15-2009 9:46 AM
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
09-15-2009 9:55 AM
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
09-15-2009 9:59 AM
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
09-15-2009 9: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
09-15-2009 9: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
09-15-2009 10:16 AM
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
09-15-2009 10:31 AM
09-15-2009 10:43 AM
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
02-11-2016 2:24 PM
09-15-2009 10: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