cancel
Showing results for 
Search instead for 
Did you mean: 

Which table i will get the status of the User decision Result status

Former Member
0 Kudos

Hi Experts

Which table i will get the status of the User decision Result status

(eg : Inspection completion forced )

This i can see in QA33

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member387317
Active Contributor
0 Kudos

Hi Jagdish,

It's not getting stored directly into any tables.. there is a logic to get the value for that field.

Program : SAPMQEVA

Include: MQEVAF22

Line No: 395 to 521..

You have to hit QALS first... Based on Status there you have to build the logic as mentioned above in your program.

Put break-point at line number 395 in include MQEVAF22 and see how the values are getting populated in field RQEVA-INFO_LINE.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Former Member
0 Kudos

Try QPCD with codegroup and code.

Regards,

Nilesh.

Former Member
0 Kudos

No not solved My issue.

Go To QA33 and Enter Lot Number then select user decisions the in header this status text will available

Former Member
0 Kudos

Hi Jagadish,

Did you try with my solution.

Regards

Abhii..

Former Member
0 Kudos

Hi,

this is coming from QPCD-KURZTEXT.

regards,

nilesh.

Former Member
0 Kudos

Dear nilesh

There is such field in QPCD .

What you writen that is Shot text of Inspection Chaercterstics

Former Member
0 Kudos

Hi,

can you use the bapi BAPI_INSPLOT_GETDETAIL. I hope i have got your requirement now.

regards,

nilesh.

Former Member
0 Kudos

No nilesh

It is not giving that result.

Text Line for Special Information about Inspection Lot

It is stored in the Structure called RQEVA

Fileld Name INFO_LINE

Data Element QINFO_line

Screen Field RQEVA-INFO_LINE

I want this status For particular Lot Number.

Former Member
0 Kudos

Hi JAGADISH,

I am not sure if this will be available in any table as in QA33 it is calculated based on details from QALS

Check Include MQEVAF22

Check the text symbols of program SAPMQEVA

K01 Inspection completion forced etc

May be you can use the same logic in include MQEVAF22

Regards

former_member156446
Active Contributor
0 Kudos

Hi JEST table acitve or inactive X is based on which are completed... say for ex: PO status if stat TECO is X for active it means TECO is done for the PO... so you wanted the latest status of an Lot.. so hit table JEST and get the stat which is active (say teco)

hit TJ02T table and have tj02t-stat = jest-stat. This will give you the text of the status associated to the lot..

If you are searching for status in QA table, you are wasting your time... bcoz in SAP all the status's are store in JEST table like all long text are stored in STXH table..

Edited by: Jay Sadaram on Nov 13, 2009 1:18 PM

Former Member
0 Kudos

In which table i ll get the following field along with Inspection lot

Text Line for Special Information about Inspection Lot

It is stored in the Structure called RQEVA

Fileld Name INFO_LINE

Data Element QINFO_line

Screen Field RQEVA-INFO_LINE

I want this status For particular Lot Number.

Former Member
0 Kudos

Hi jay

Not solved It is giving Over Lot Status but My Problem not solved .

I am expecting Particular that Text .

Where it will be available .

Regards

Jjagadish

Former Member
0 Kudos

Hi

Try it in QAMR table field ORIGINAL_INPUT....it will store the valu whether it is pass or fail or something else...

Former Member
0 Kudos

No Sai

It is not having any data.... Not solved....

Former Member
0 Kudos

Hi in qa33 where it is storing...can u tell me

Former Member
0 Kudos

GO TO QA33 inter Inspection Lot number Select line of Lot then click on Usage decisions (UD)

next Screen In Header after Insp Snda date Next It is showing Text

That field details as folows

Text Line for Special Information about Inspection Lot

*It is stored in the Structure called RQEVA*

Fileld Name INFO_LINE

Data Element QINFO_line

Screen Field RQEVA-INFO_LINE

I want this status For particular Lot Number.

Regards

Jagadish

Former Member
0 Kudos

Hi jag

Ok fine actually it is not storing in any table...these r all text symols...if u see this program MQEVAF22...U EILL GET SOME IDEA

CALL FUNCTION 'QAST_STATUS_CHECK'

EXPORTING

I_OBJNR = QALS-OBJNR

I_STATUS = C_STATUS_PAKO

EXCEPTIONS

STATUS_NOT_ACTIV = 01.

IF SY-SUBRC NE C_RC01.

MOVE C_KREUZ TO L_STAT_PAKO.

ELSE.

CLEAR L_STAT_PAKO.

ENDIF.

  • Prüfen, ob Los bestandsrelevant ist

MOVE RQEVA-STAT_BERF TO L_STAT_BERF.

  • Prüfen, ob Los auf SKIP sitzt

CALL FUNCTION 'QAST_STATUS_CHECK'

EXPORTING

I_OBJNR = QALS-OBJNR

I_STATUS = C_STATUS_SKIP

EXCEPTIONS

STATUS_NOT_ACTIV = 01.

IF SY-SUBRC NE C_RC01.

MOVE C_KREUZ TO L_STAT_SKIP.

ELSE.

CLEAR L_STAT_SKIP.

ENDIF.

IF QALS-STAT35 >< C_KREUZ.

  • VE noch nicht getroffen !

IF ( QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 )

AND QALS-STAT13 = C_PPKTTYP-PHPR

AND G_ANZAHL_PPKT_LOEVM > CI_0.

  • Es wurden physische Proben storniert ! PRIORITÄT 1A

MOVE TEXT-I17 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I17'.

ELSEIF ( QALS-STAT14 = C_KREUZ AND QALS-OFFENNLZMK > CI_0 )

OR ( L_STAT_PAKO = C_KREUZ

AND ( QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 ) ).

  • Prüfung wurde abgebrochen ! PRIORITÄT 1

MOVE TEXT-I04 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I04'.

MOVE C_KREUZ TO L_ICON.

ELSEIF G_ANZ_RUECK_MK > 0.

  • Es wurden Merkmale rückgewiesen ! PRIORITÄT 2

MOVE TEXT-I01 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I01'.

MOVE C_KREUZ TO L_ICON.

ELSEIF QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 .

IF QALS-OFFENNLZMK > CI_0.

  • Es sind nicht alle Merkmale abgeschlossen ! PRIORITÄT 3

MOVE TEXT-I02 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I02'.

ELSEIF QALS-OFFEN_LZMK > CI_0.

MOVE TEXT-I05 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I05'.

ENDIF.

ELSEIF QALS-WERK NE QALS-WERKVORG.

  • Prüflosmenge wurde umgelagert auf anderes Werk Priorität 4

MOVE TEXT-I16 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I16'.

ELSEIF QALS-LMENGEIST > QALS-LOSMENGE.

  • Istmenge im Los größer als Losmenge! Priorität 5

MOVE TEXT-I15 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I15'.

ELSEIF L_STAT_SKIP = C_KREUZ.

  • Prüfverzicht: Los ist geskippt ! PRIORITÄT 6

MOVE TEXT-I03 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I03'.

ENDIF.

ELSE.

  • VE getroffen bzw. eingetragen

IF ( QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 )

AND QALS-STAT13 = C_PPKTTYP-PHPR

AND G_ANZAHL_PPKT_LOEVM > CI_0.

  • Es wurden physische Proben storniert ! PRIORITÄT 1A

MOVE TEXT-I17 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I17'.

ELSEIF ( QALS-STAT14 = C_KREUZ AND QALS-OFFENNLZMK > CI_0 )

OR ( L_STAT_PAKO = C_KREUZ

AND ( QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 ) ).

  • Prüfung wurde abgebrochen ! PRIORITÄT 1

MOVE TEXT-I04 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I04'.

MOVE C_KREUZ TO L_ICON.

ELSEIF L_STAT_PAKO EQ SPACE

AND ( QALS-OFFENNLZMK > CI_0 OR QALS-OFFEN_LZMK > CI_0 ).

  • Es sind noch Langzeitmerkmale zu bearbeiten ! PRIORITÄT 2

MOVE TEXT-I05 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I05'.

ELSEIF L_STAT_BERF = C_KREUZ AND QALS-STAT34 EQ SPACE.

  • Los ist bestandsmäßig noch nicht entlastet ! PRIORITÄT 3

MOVE TEXT-I06 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I06'.

ELSEIF QALS-WERK NE QALS-WERKVORG.

  • Prüflosmenge wurde umgelagert auf anderes Werk Priorität 4

MOVE TEXT-I16 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I16'.

ELSEIF QALS-LMENGEIST > QALS-LOSMENGE.

  • Istmenge im Los größer als Losmenge! Priorität 5

MOVE TEXT-I15 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I15'.

ELSEIF L_STAT_SKIP = C_KREUZ.

  • Prüfverzicht: Los ist geskippt ! PRIORITÄT 6

MOVE TEXT-I03 TO RQEVA-INFO_LINE. L_TEXT_NR = 'I03'.

ENDIF.

ENDIF.

former_member156446
Active Contributor
0 Kudos

Hit JEST table with your OBJNR

Former Member
0 Kudos

No not solved it giving only Active or inactive

I need status text

eg 1.You have not completed all characteristics

2. Inspection completion forced

former_member217544
Active Contributor
0 Kudos

Hi,

Check TJ02T table and search based on description ( inspection) .

Regards,

Swarna Munukoti.

Former Member
0 Kudos

Hi Jagadish,

TJ30T is the table you are looking for & the text you can get from the field TXT04 & TXT30.

Please set to resolved if it helps you.

Regards

Abhii....

Former Member
0 Kudos

No Abhi

I want for particular Lot Number.

I tried QALS, QAMV, so many other QM tables i didnt find.

former_member217544
Active Contributor
0 Kudos

Hi,

Then use combination of JEST and TJ02T table.

JEST table will hold teh status codes. For desciptionwe need to check TJ02T table.Try this:

Get STAT value for your particular lot numberfrom JEST table (active value)

and search in TJ02T table with this STAT value to get the description of the same

Regards,

Swarna Munukoti.

Former Member
0 Kudos

Hi Swarna

It is not possible

because in JEST for Status Inact. is having value 'X' or null if it is 'X' is active

How possible combined with TJ02T.