topic Re: Relationship between tables in Application Development and Automation Discussions

Relationship between tables

Former Member — Mon, 25 Jul 2011 12:22:44 GMT

Hi,

Is there any relatonship between tables TJ48 and QALS ?

As i m working to create a copy of QA33 with one additional field,

Need help

Re: Relationship between tables

Former Member — Mon, 25 Jul 2011 12:29:11 GMT

Do you mean field STSMA?

Regards

Re: Relationship between tables

RaymondGiuseppi — Mon, 25 Jul 2011 12:36:53 GMT

TJ48 is the ID table (header) for status selection schema and refers to many objects type. You can use the field STSMA, status profile, to identify selection Ids that can apply to QALS.

 TJ48-STSMA = QALS-STSMA.

Regards,

Raymond

Re: Relationship between tables

Former Member — Tue, 26 Jul 2011 07:29:33 GMT

Hi,

Thanxs,

Points alloted

Please also let me know the relationship between structure RQEVA and table QALS

As I want to add rejection reason from this structure to my report

Re: Relationship between tables

RaymondGiuseppi — Tue, 26 Jul 2011 08:00:21 GMT

RQEVA is filled with fields of multiple origins: like QALS or QAVE look at this last table to get Usage Decision.

Regards,

Raymond

Re: Relationship between tables

Former Member — Fri, 29 Jul 2011 09:06:51 GMT

I m not able to fetch data from RQEVA structure field Name - SGTXT04 used for rejection reason in QA11, I need to fetch data from this field

i have trying to use READ_Text FM but not getting the Header text information for this like ID, Name, Object

How to do it suggest

Edited by: Nishantbhargava on Jul 29, 2011 12:58 PM

Re: Relationship between tables

RaymondGiuseppi — Fri, 29 Jul 2011 12:33:44 GMT

Not sure (without taking some time to debug) try table QPCD and QPCT to translate code to text.

Regards,

Raymond

Re: Relationship between tables

Former Member — Mon, 13 May 2013 13:19:19 GMT

Hi,

The text you are entering for the blocked text or rejection text will be stored in MSEG table with respect to the material document. You can get this document number from QAMB with respect to inspection lot.
Also you need to check whether you are using enhancement MBCF0002 (include ZXMBCU02). In this case you must fill the export parameter E_SGTXT with the value you want (or I_MSEG-SGTXT). If you don't do this, the item text gets cleared.

Regards

Danny