Skip to Content
Former Member
Jul 23, 2007 at 03:28 AM

I want to know the tables in FI for my report requirement


I have a requirement to develop a report which contains selection-screen as

Company code ---

G/L Account o 305400

o 305500

Period --- to ---

305400 is stock-excess

305500 is stock-shortage

if user enters company code,selects first radiobutton and enters period as 11 to 12 it should display all the Reference documents with date,reference document(4900066123), material, plant, qty, value(6999.33)

please go through FS10N

my requirement is same like this tcode

but my report should display all the reference documents((4900066123)) with amounts in single screen not the total amount for G/L account(305400)

can any one tell me from which tables i have to pull the data

the tables which have relation between g/l account and reference document and period

thanks & regards

Pradeep Reddy.M