Interfaces - (FI/CO) - GL Account Balances Extract To Legacy
I Need to extract data from coss and cosp tables based on selection criteria given in Functional design.Company code and Fiscal Year and Fiscal Period is the selection screen input.
From cosp and coss tables
LEDNR,objnr,wrttp,versn,kstar,beknz,twaer fields needs to be retrieved and I need to write it in to a file at application server.At the same time I need to calculate debit balance and credit balance and netamount.
In these two tables GL account field is not available.
How can I calculate debit ,credit balances and net amount based on this criteria by cosidering G/L accounts.
Please give me clear picture of this.(Tables ,fields and regarding selection )
Please reply immediately.