fiscal year/fiscal period

Hi Friends,

I have a case where I need an optimized select statement.

For Last posting FY/period: for each G/L account, Company code combination, determine the MAX (Doc. No) in BSEG, and look up the corresponding document in BKPF table to get the last posting FY/Period.

Please get back to ASAP.

Thanks,

Prakash.