Offset Control in Char
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?
NimeshKumar Kapadia replied
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.