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

[Former Member]

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

[former_member189059]

See if <b>SKB1</b> helps

[Former Member]

I checked the table SKB1 it only contains G/L Account (305400 and 305500) but no relation with reference documents

Thanks for u r reply

if u find other tables please let me know

Thank you

[p291102]

Hi,

U can find all d details regarding FI tables & their relations here....

http://www.sapgenie.com/abap/tables_fi.htm

You can find the details about the FI module here

http://www.sap-img.com/sap-fi.htm

Thanks,

Sankar M

[Former Member]

Use BSIS, BKPF and BSEG tables to extract the required data..

[Former Member]

Thanks anju

Very useful answer

thank you very much

[Former Member]

Hi anju

now i got reference document number (4900050202)

for this i want to find out the material, movement type, quantity

from which table i can get that

can u please tell me

just like FS10N tcode

but i want everything in single output.

thanks & regards,

Pradeep Reddy.M

Message was edited by:

Pradeep Reddy Miriyala

[Former Member]

Thanks anju

[Former Member]

go to table mseg.....pass that refrence document no in the mblnr field and get the matnr, bwart, erfmg (quantity) etc..

[Former Member]

sorry, u first pass that ref no to mkpf-xblnr and get the mblnr and mjahr and then pass these value to mseg table to get the required field.

[Former Member]

hi anju

No data in MKPF with XBLNR = 4900050202

from BSIM table using this numberi got Material, Quantity

Now I want to find movement type and storage location

can u tell me the table

Thanks anju

[Former Member]

If u have the material and plant field u can get storage location (LGORT) from mchb /mard /mseg and movement type (BWART) from mseg.