AGR_1251 &TSTCT Using SQVI?

[Former Member]

Hi All,

I need the Roles and its relevant TCodes with its text.When I combined AGR_1251 & TSTCT using SQVI.I used to combine both the tables with TCode field.But it shows as No relationship exists.

For what reason It shows as there is no relationship between 2 table even though it has TCode has common field?

Kindly help me to find the answer.

Thanks in Advance.

Regards

Karthika Devi

[Former Member]

Between these two tables there is no common field

Table AGR_1251 having T-codes under Object S_Tcode (Under field Name you will get the T-Code )in this table T-Code is not a field name that is field value

Table TSTC is picking T-codes directly from table TSTC . in this table T-codes is a field name

[Former Member]

Dear Karthika,

What ravi said is absolutely correct. Try combining the tables AGR_TCODES & TSTCT which should serve your purpose.

Regards,

[sdipanjan]

> I need the Roles and its relevant TCodes with its text.When I combined AGR_1251 & TSTCT using SQVI.I used to combine both the tables with TCode field.But it shows as No relationship exists

Correct

> For what reason It shows as there is no relationship between 2 table even though it has TCode has common field?

Where did you find "TCode" as a field in AGR_1251? Mapping of Two table extracts in ONLY possible if and only if there is a Primary Key (a common field) exists in between two Tables.

Regards,

Dipanjan