hi,

how can we can know the main table of a standard session,

OR
Which table is being used by session tfacp3425m000

anybody can help ?

Option 1 -
In "Maintain Session", on Form 1, there is a field for main table.

Option 2 -
From the session name. The 1st, 3rd and the 4th "digit" of the session code refers to the main table used. But, this is not always true, as in your case too.

Option 3 -
Use session "ttadv2450m000". After using this session, probably the main table used in the specified session is "tfacp004".

Hope this helps.

And if you are looking to use in your program code, then you can use the predefined variable -

string main.table$(9) 4R Name of current main table.

Yes, this is another option. But, in case of Leena's query, probably she does not have the code for the specified session.

hi morpheus

tahnx for the help

but:
option 1:
it is not showing any main table for this standard session,means the main table coloumn is blank in this case.

and for option 3:
it is showing 'No data with in selection" while running the "ttadv2450m000" session.
and tfacp004 table is using only for analysis coding,i want the main transaction table.

Please help

it is not showing any main table for this standard session,means the main table coloumn is blank in this case.

Yes, I have checked the same at my end also. The field is left blank.

it is showing 'No data with in selection" while running the "ttadv2450m000" session.

It is giving me the output. Check VRC, script code, etc. when you execute the session.

i want the main transaction table.

I am sure the output of the above session will certainly help you, but if you need some more information then you post your query under "Finance, Invoicing and Integration" forum. I am not the right person to answer this query.

Good Luck!!

Dear Leena,

Print sessions technically don't have main table. To find out where the reports get most of their data, you'll have to either
read the program script of the session
be very well versed in the module, in your case tf, to be able to recognise immediately which table it is using

I don't have the program script of tfacp2450m000 and BaanERP finance is not my specialisation. But I'm sure someone in this board can help you with this

Rgds,
Paul

Originally posted by morpheus

Option 3 -
Use session "ttadv2450m000". After using this session, probably the main table used in the specified session is "tfacp004".


"PROBABLY"

Hi Leenaa,

must be tfacp200 Open Items (Purchase Invoices & Payments).

Rgds,
Juergen

hi Juergen

yes it is the transaction table,but it is not satisfying my requirements,


My exact query is this (It is not related with tfacp3425m000,this is my actual problem)
In my session the program script selects the following data

A=100,B=200,C=50,E=100,G=300

While report script is selecting the following data by setting relation into standard and report table
A=50,D=20,E=10,F=50

Now my report is showing A=150,B=200,C=50,E=110,G=300

Though what I exactly want is A=150,B=200,C=50, D=20,E=110, F= 50,G=300

So how can I get this ?

:(

Dear Leena,

Could you also explain from the functional side, beside technical side, what kind of report you are trying to make, please? This may help us help you better. Thanks

Rgds,
Paul

What I want to do is, I want to merge the payments which is posted or still pending to post,

Session tfacp3425m000 is printing the supplier aging summary (posted payments).

Now what I m doing is ,I m writing a report script using table tdpur045(putting condition tdpur045.matc = tdpur.matc.no(for unposted payments)),

by doing this it is showing only that supplier which have any posted payment or
it is not showing that supplier which have only unposted payment.
(Means it is showing the same suppliers for customized or standard report, but it is adding up the data i.e posted or unposted payments in customized report by writing the report script)

hope u got any idea,

Hi,

Use bic_info6.1 ti trace the tables which are involved.
bic_info6.1 -a otfacp3425


GN

OR

You can look up in the table ttadv233 (Maintain Tables by Functions/Program Scripts/Reports) in company 000.

now i have got all the tables used in the standard session,but still my problem is same,i m unable to print output from the report script,

My problem

Session tfacp3425m000 is printing the supplier aging summary (posted payments).

Now what I m doing is ,I m writing a report script using table tdpur045(putting condition tdpur045.matc = tdpur.matc.no(for unposted payments)),

by doing this it is showing only that supplier which have any posted payment or
it is not showing that supplier which have only unposted payment.
(Means it is showing the same suppliers for customized or standard report, but it is adding up the data i.e posted or unposted payments in customized report by writing the report script)

hope u got any idea,