SAP Reports

[former_member229757]

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

[former_member229757]

Hi Jimmy,

I want to execute the report in sql.

can u please guide me.

Thanks

Vinoth

[jimmyl]

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