Skip to Content

SQVI Join Tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 06, 2009 at 06: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2009 at 08: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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 30, 2011 at 08:46 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.