Linking tables CATSDB and PROJ

[former_member512937]

I'm having trouble finding a way to link records from the CATSDB and PROJ tables.

There's a field (AWART) that I need from CATSDB for a custom report. The report pulls from PROJ. I need to be able to link the records in the report to the CATSDB table so that I'm able to get the desired field.

I'm having trouble finding a way to connect these tables. Any help?

[chris_keating]

Is this question for SQL Anywhere or the tool that you are using to create reports.If the later, you should add tags for that product. Will likely need schema info and how the tables relate if you are looking for what the query should look like in SQL Anywhere.

[former_member512937]

I'm writing the report in abap editor. Not sure if that's what you mean. SQL Anywhere is probably not the most accurate tag, but I'm not sure what is more accurate. Open to suggestions.

All I need is a way to connect the records from PROJ to CATSDB, so that I can get the proper AWART value for the PROJ records. Or find another way to get the AWART values for the PROJ records. I need to see that this is even possible before evaluating the requested enhancement that I'm looking into.

[chris_keating]

ABAP Development might be a better option.

[horst_keller]

What have you done up to now? Where do you fail?

Do you know Joins or Subqueries?