Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Getting Data from table - TCCLG

Former Member

‎2009 May 26 9:19 PM

0 Likes
697

Hi All,

Sorry for not being specific earlier.

I'm trying to read the settlement data from TCCLG table.

Can I read directly from TCCLG table or Do I need to select the data from other tables and link them to TCCLG for an efficient data retrieval?

Please advise.

Meghna

Hi All,

Sorry for not being specific earlier.

I'm trying to read the settlement data from TCCLG table.

Can I read directly from TCCLG table or Do I need to select the data from other tables and link them to TCCLG for an efficient data retrieval?

Please advise.

Meghna

Reply
3 REPLIES 3
Read only

Former Member

‎2009 May 26 9:29 PM

0 Likes
613

If you know the settlement number, that would be the fastest way; otherwise, you have to find the settlement number form some other table and then use it in the SELECT.

Rob

Read only

Former Member
In response to Former Member

‎2009 May 26 9:38 PM

0 Likes
613

Thanks Rob.

I don't have the settlement number information.Could you please advise the most efficient way to get the settlement number data and from which table?

Meghna

Read only

Former Member
In response to Former Member

‎2009 May 26 9:46 PM

0 Likes
613

I don't know that.

However, if you can get a functional person to show you how a settlement is created, you can run transaction ST05 in parallel wit that and see what tables are updated.

Rob