07-06-2009 7:45 PM
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
07-06-2009 7:54 PM
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
07-07-2009 9:16 AM
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
07-07-2009 2:12 PM
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
07-07-2009 2:29 PM
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
07-22-2009 12:11 PM
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,
07-22-2009 1:17 PM
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
09-28-2011 4:21 PM
Did you ever find a solution to this? I've been trying to do the same thing.
09-30-2011 9:46 AM
I personally download the tables and import them in a personal database such as MS Access and perform the join in there.
09-30-2011 7:18 PM
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.