Skip to Content

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

Offset Control in Char

Dear All,

I am using BEx query Designer. I am making a report on an HR module infoset.There is a characteristic which contains social security number. i.e. a eleven digit number. I want to show only the last 4 digits. This report does not contain any key figures, so no structures. I want to keep it that way for requested design reasons, so NO structures allowed. Is there a way where I can manipulate a characteristic value and show only part of it, maybe some sort of offset trick in BEx tool?


Jack Silverz

Former Member
Former Member replied

Hi Jack,

Try the scenario with formula variable. In query designer toolbar you will get to see table display (left to tools ), click on it . System will then show everything char/kf in one columns area without any structure.

In the Modeling part you may always write a small formula & add new characteristics to get populated and the same can be used for reporting as suggested earlier by a good friend.

Hope it helps.


Mr Kapadia

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