Skip to Content

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

FORMATTED SEARCH FOR A SEGMENTED CHART OF ACCOUNTS

I'm using SBO 9.1 PL4 and a segmented chart.

I have added a udf field in my marketing document on which i want to populate the available balance using formatted search and the following query

SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'

FROM OBGT T0 WHERE T0.AcctCode = $[$39.94.0]

GROUP BY T0.AcctCode

The query does not pick the budget amounts as the code does not pick '-SYS......' codes.

Kindly help me amend it so that it picks the '_SYS.....' codes

I have attached screen shot of both segmented chart screen and normal chart screen

You assistance is highly appreciated

Regards

George Njuguna

Normal Chart.PNG (35231 B)
Former Member
replied

Hi George

try the below FMS

SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'

FROM OBGT T0 WHERE T0.AcctCode = $[POR1.ACCTCODE]

GROUP BY T0.AcctCode

--Manish

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question