topic Re: table in Application Development and Automation Discussions

table

Former Member — Mon, 23 Jul 2007 12:09:10 GMT

which table can i use to the user status of a PM notification object

Re: table

Former Member — Mon, 23 Jul 2007 12:11:55 GMT

Hello,

Check the table - TJ30


*--- Alle zu Projekten gehörene Anwenderstatus selektieren
  SELECT  TJ30~STSMA  TJ30~ESTAT  TJ30T~TXT04  TJ30T~TXT30
    INTO  CORRESPONDING FIELDS OF TABLE G_T_ESTAT
    FROM  TJ30
    INNER JOIN TJ30T ON  TJ30~STSMA = TJ30T~STSMA
                     AND TJ30~ESTAT = TJ30T~ESTAT
    INNER JOIN TJ21  ON  TJ30~STSMA = TJ21~STSMA
    WHERE TJ30T~SPRAS EQ SY-LANGU
      AND TJ21~OBTYP = 'PRN' " Check the object here
      OR  TJ21~OBTYP = 'PDN'.

Vasanth

Re: table

Former Member — Mon, 23 Jul 2007 12:18:35 GMT

Take the QM notification Object No (QMEL-OBJNR) field to JEST status (STAT) and take the Status of the Notification Object.

For user status see the table TJ30

Reward points for useful Answers

Regards

Anji

Re: table

Former Member — Mon, 23 Jul 2007 12:26:45 GMT

Hi,

use the table

VTIFHAZU Underlying transaction status table

JCDS Change Documents for System/User

Statuses (Table JEST)

JEST Object status

JSTO Status object information

TJ02T System status texts

TJ30T User status texts

T502T Marital Status Designators

T529U Status Values

NAST Message status

TBTCO Job status overview table

for more information on table please referr the following link it will help you

http://www.delantt.com/documents/sap_tables.pdf

you use either the following function code or the function module to check the status.

SELECT SINGLE stat FROM jest

INTO ls_stat

WHERE objnr = ls_objnr

AND stat = 'I0076' "LÖVM

AND inact = space.

IF sy-subrc = 0.

p_ch_meld-status = gc_status-deleted.

ENDIF.

or the function module

CALL FUNCTION 'STATUS_CHECK'

EXPORTING

OBJNR = ld_objnr

STATUS = 'I0076' " LÖVM

EXCEPTIONS

OBJECT_NOT_FOUND = 1

STATUS_NOT_ACTIVE = 2.

" Status 'I0076' is active

IF ( syst-subrc = 0 ).

p_ch_meld-status = gc_status-deleted.

ENDIF.

************please reward points if the information is helpful to you***********

Re: table

Former Member — Mon, 23 Jul 2007 12:29:40 GMT

Hi,

Look at tables JEST, JSTO and TJ30T

Look at note 300300.

Reward points

Regards