Skip to Content
0

SAP Reports

Jan 18 at 04:59 PM

64

avatar image

My client having a requirement of below needs to identify the charges of the particular ledger.

Please help with that query

sample query

select oact.acctname as Account_Name,OACT.CurrTotal from OACT

where AcctCode IN('700904','700903')

Thanks

Vinoth

ledger.jpg (20.6 kB)
ledger.jpg (20.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vinoth D R Jan 19 at 05:59 AM
0

Hi Jimmy,

I want to execute the report in sql.

can u please guide me.

Thanks

Vinoth

Share
10 |10000 characters needed characters left characters exceeded
Jimmy Liang Jan 19 at 12:16 AM
0

Hi Vinoth,

This report will need data from the JEs so you will need a join with JDT1.

The grouping by Month/Qtr/Year will be achievable depends on where the report will be run, in B1 using query report, in a Crystal report or in Excel.

For Crystal report or Excel, it's relatively easy to use a pivot table format and have the numbers grouped by the dates. If it's required to run as a query report, then you may use some PIVOT statement in your SQL script.

Cheers,

Jimmy

Share
10 |10000 characters needed characters left characters exceeded