Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Most-Urgent-Interface _GL balances

Hi ,

I need to extract data from COSS & cosp tables based on the given criteria and write at application server file.What I need to do is I need to Calculate debit balance and credit balance & net amount based on debit credit indicator (BEKNZ).

while calculating debit balance I am getting struck here.

I have some sample data here i am specifying.

c.code fiscal c.center GLA/C i p1 p2 p3 net

1234 2006 40051800 656928 D 1000 2000 500

1234 2006 40051800 656928 C 500 1000 100 400

1234 2006 40056001 656928 D 100 300 50 50

1234 2006 40056001 656929 C 200 400 100 -100

1234 2006 40056001 656929 C 400 600 300

1234 2006 40056001 656929 C 600 300 800

1234 2006 40056001 656929 C 100 500 900

Here I need to calculate debit balance = sum of all periods debit amnt

cridit balance = sum of all peeriods creidit amount

net = debit balance - credit balance

c.center = cost center

i = Debit credit identifier

In above scenario how can i write logic .Please have a look in to above data .

Please reply soon.

Regards

vijaya

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question