Quotation user staus

[Former Member]

HI Gurus ,

through the status management configuration i created a status profile . this status is being shown in the User status tab under header data .

i am creating a report to fetch this user status data.

it is not being stored in teh VBUK table

please suggest the table where the user status is being stored

Regards

zahid

[former_member186385 · Accepted solution]

Hi,

In VBAP you will get OBJNR which is the object number

with that OBJNR go to JEST table to get the status ID

with that Status ID you can get the description of the status in TJ02T

hope it is clear

regards,

santosh

[Former Member · Accepted solution]

Hi Gurus ,

i have created a quotation but the OBJNR field is not updated with any value in the VBAK or VBAP table . Please suggest

Regards

Zahid

[oiver_beie · Accepted solution]

Hi Zahid,

The object number is 'VB' + vbeln + posnr. Try to find that in the JEST table.

Sample code to read the status information:

* <SIGNATURE>---------------------------------------------------------------------------------------+
* | Instance Public Method ZCL_SALES_ORDER->CHECK_ITEM_OBJ_STATUS_ACTIVE
* +-------------------------------------------------------------------------------------------------+
* | [--->] I_POSNR                        TYPE        POSNR
* | [--->] I_STAT                         TYPE        J_STATUS
* | [<-()] R_BOOLEAN                      TYPE        BOOLEAN_FLG
* +--------------------------------------------------------------------------------------</SIGNATURE>
method CHECK_ITEM_OBJ_STATUS_ACTIVE.
* checks if a given object status for an item is active or not
data:
      l_objnr   type j_objnr.

  concatenate 'VB' m_vbeln i_posnr into l_objnr.
  select count(*)
    from jest
    where objnr  eq l_objnr
      and stat   eq i_stat
      and inact  eq space.
  if sy-dbcnt eq 0.
    r_boolean = con_false.
  else.
    r_boolean = con_true.
  endif.
endmethod.

Best regards,

Oliver

Message was edited by: Oliver Beie

[Former Member · Accepted solution]

Hello

But don't understand the reason why the VBAK-OBJNR is not getting updated. Please help me gurus .

[Former Member · Accepted solution]

Hello Oliver ,

Even in the JEST table i am not able to find the OBJNR with the above given logic . Please if you could help on why the OBJNR number is not getting updated.

[oiver_beie · Accepted solution]

Hi Zahid,

pls have on mind that JEST-STAT contains the internal representation of your user status not the short text which is displayed in the SO. You get this code from table TJ30T.

Or have a look on JEST with SE16N just by giving the object number but without an special status.

Another id: I'm not sure if the object id starts with 'VB' for quotations, I used that only for SO before. Play a little around with that value or try just 'V*'. If that does not help just search with the quotation number (with leading digits) or the quoatation + item number.

Or a even more technical way: Start a trace with ST05 and call VA23. Here you can see how SAP reads this information.

Best regards,

Oliver

Message was edited by: Oliver Beie

[former_member184080]

Hi Zahid,

Check this: http://scn.sap.com/thread/1059713

Regards, Sai Krishna.