SQVI Join Tables

[former_member318517]

Hello everyone,

I'm trying to use SQVI to join table AGR_TCODES and TSTC and link TCODE. However, (I'm guessing) that since the Long Text on TCODE in one table is different than the other, I can not create a link between the two.

Any thoughts?

Thanks,

Tom

[sdipanjan]

Yes, you are correct. You need to use AGR_TCDTXT instead of AGR_TCODES.

The field TCODE in AGR_TCODES is basically a field to provide the extended name of the Menu entry of the role what ever it is (may be a TCode or may be a report or a Query etc...)

Regards,

Dipanjan

[Former Member]

Hello Tom,

I suppose you need this join to get the text or discribtion of any transaction.

To do this right, you need to join table agr_tcodes with table TSTCT.

good luck.

best regards,

Haim Brauner

[former_member318517]

Hello Haim and Dipanjan,

Actually AGR_TCDTXT is not populated with any entries, so I can not use this table and yes, I did mean TSTCT not TSTC for the transaction code text but I still will face the same problem; I can not join TSTCT and AGR_TCODES via TCODE because the long text of TCODE is different from the two tables.

Maybe I'll try to join them via two other tables that I don't need but where the long description fits..

Thanks,

Tom

[Former Member]

Hello tom,

I made this join in the SQVI between this two tables (agr_tcodes & tstct) very often and its works good.

if the quickviewer has a problem with a joim, it doesnt work, but in this case its work well.

best regards,

Haim Brauner

[Former Member]

Hi Thomas,

I wanted to do the same thing, and like you I can't get it to work.

Like with you the table AGR_TCDTXT isn't filled. So this is of no use.

Then I tried using this empty table as a sort of dummy table, linking TSTCT and AGR_TCODES, using "left outer joins". The joins are accepted in SAP, but as I expected it didn't work.

Have you found the solution yet?

Best,

[former_member318517]

No solution yet, other than to find another way to get the information I need other than SQVI. The tables will just not join.

Thanks,

Tom

[Former Member]

Did you ever find a solution to this? I've been trying to do the same thing.

[m_coenjaerts]

I personally download the tables and import them in a personal database such as MS Access and perform the join in there.

[Former Member]

I do what M. Coenjaerts describes. Except I download the contents of tstct from different products (ecc, srm, etc) into an excel spreadsheet then I do Vlookups on TCD to this external file in Excel.