Skip to Content
0
Former Member
Jan 04, 2008 at 03:48 PM

Age Analysis report for asset

333 Views

Hi All,

I have to create a Age analysis report for FI documents

which have line items with posting key 75 & 70 (Asset)

Given logic is

1 Selection screen has parameters - Company code, Key date

2 Need to take all line items with posting key 70 & 75

(BSEG-BSCHL = 70 or 75)

Layout of report is

Asset no 0-30 31-60 61-90 91-120 . 151-360 (days)

80000003 2000.00 3000.00 1000.00 4000.00 7000.0

80000006 1000.00 5000.00 300.00 5000.00 4000.0

Local curency amount should be categorised under the days

diferences between key date (selection screen) & posting date

of the accounting document.

My problem is,

Posting date of the document is not in the BSEG table. It is

in the BKPF table.Therefore I have to extract all FI documents(Not only documents with posting key 75 or 70) within 360 days from Key date in BKPF the table.

I cannot join BSEG & BKPF. Because, BSEG table is a cluster table.

Can you please tell me the way how can i extract the data for this report with out any performance issues.

Pra