Relationship between tables

[Former Member]

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

[Former Member]

Do you mean field STSMA?

Regards

[RaymondGiuseppi]

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

[Former Member]

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

[RaymondGiuseppi]

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

Regards,

Raymond

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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

Regards,

Raymond