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: 

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

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

11 REPLIES 11

former_member189059
Active Contributor
0 Kudos

See if <b>SKB1</b> helps

0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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

0 Kudos

Thanks anju

Very useful answer

thank you very much

0 Kudos

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
0 Kudos

Thanks anju

Former Member
0 Kudos

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

0 Kudos

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.

0 Kudos

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

0 Kudos

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