Need to develop new Report

[Former Member]

Please use a meaningful subject in future

Hi,

can any one please tell me from which table i have to fetch data (i think bseg and bkpf) is it correct.give me an idea for fetching

data and developing report.if possible please give the field names along with table name of below info i would be thankfull.

Report will contain the following information:

-General Ledger account number

-Name of Account

-Amount of Entry

-Date of the document

-Document number

-Debit & Credit side of entry with general ledger and customer account numbers (if applicable).

The filter data will contain:

-User ID

-General Ledger Range fields: From & To

- Date fields: From & To.

The purpose of this report is to list all general ledger entries made by a User for a certain time frame.

Edited by: mohd khan2 on Aug 25, 2009 11:34 AM

Edited by: Matt on Aug 25, 2009 1:08 PM

[Former Member]

Please use a meaningful subject in future

Hi,

can any one please tell me from which table i have to fetch data (i think bseg and bkpf) is it correct.give me an idea for fetching

data and developing report.if possible please give the field names along with table name of below info i would be thankfull.

Report will contain the following information:

-General Ledger account number

-Name of Account

-Amount of Entry

-Date of the document

-Document number

-Debit & Credit side of entry with general ledger and customer account numbers (if applicable).

The filter data will contain:

-User ID

-General Ledger Range fields: From & To

- Date fields: From & To.

The purpose of this report is to list all general ledger entries made by a User for a certain time frame.

Edited by: mohd khan2 on Aug 25, 2009 11:34 AM

Edited by: Matt on Aug 25, 2009 1:08 PM

[Former Member]

Hi,

BSEG is the master table(Has all GL/Vendor/Customer) and hence try to restrict the usage. Instead you can use the below tables(they form the child tables for BSEG). This will be performance issues.

Since your requirement is to fetch the GL account and Customer account items,

BSAD :(Accounting: Secondary index for customers (cleared items))

BSID :(Accounting: Secondary index for customers)-Open items

You can also fetch the header details from the table BKPF.

Below are the fields:

General Ledger account number(HKONT)

-Name of Account(You need to get the desciption from SKA1 or SKB1 for the above HKONT)

-Amount of Entry (BSEG/BSAD/BSID-WRBTR)

-Date of the document (BKPF-BUDAT)

-Document number(BKPF-BELNR/BSAD-BELNR/BSID-BELNR/BSEG-BELNR)

-Debit & Credit side of entry with general ledger and customer account numbers (if applicable).(BSEG/BSID/BSAD-SHKZG)

Additioally you need the field KOART which will differentaiat if the line items is for GL/Vendor(K)/Customer(D). This is available in BSEG. For BSAD/BSID you need not check because the table will store only customer line items

Hope this helps

Regards

Shiva

[Former Member]

Hi Shiva,

can you please tell me about filter data .

1)user-id: (this field is bkpf-usnam--- correct if i am wrong)

2)GL range fields : from and to (this field is HKONT---Correct if i am wrong)

3)date fields : from and to (this field is BUDAT ---Correct if i am wrong)

[Former Member]

Hi,

You are correct for all the above points.

Thanks

Shiva

Edited by: Shiva Kumar Tirumalasetty on Aug 25, 2009 4:12 PM

[matt]

Please use a meaningful subject in future