03-14-2018 6:00 PM
Hello
I have found a standard SAP cds view c_trialbalanceq0001 that I would like to use in an ABAP report.
I want to extract the opening and closing balances for a set of Company Codes and GL accounts etc.
If I run transaction RSRT with the query 2CIFIGLBALCUBE/2CCFITRIALBALQ0001 then I can see the opening and closing balances based on the Company Codes, Gl Accounts etc.
The above query use the CDS view c_trialbalanceq0001 in order to extract the opening and closing balances.
However when I try to use the CDS view c_trialbalanceq0001 in my ABAP code I am getting some strange results.
The fields in the CDS view that I expect to hold the opening and closing balances just hold the value "1". (StartingBalanceAmtInCoCodeCrcy, DebitAmountInCoCodeCrcy, CreditAmountInCoCodeCrcy, EndingBalanceAmtInCoCodeCrcy)
These fields use exception aggregation.
Can anyone point me in the right direction to extract out the starting and ending balances of Company Code and Gl Accounts etc using this CDS view in the same way the transaction RSRT does?
Thanks
Andrew