Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Linking tables CATSDB and PROJ

0 Kudos

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?

4 REPLIES 4

chris_keating
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

ABAP Development might be a better option.

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Do you know Joins or Subqueries?