on 2022 Oct 01 11:18 AM
Dear SAP Experts,
I need to display below column in a tabular format for a specific Value Assignment.
From Column Country to Hazard, the data belongs to header. Value and Desp belong to composition tab.
So I added all the necessary symbols of header from column Country to Hazard. For value(Composition) and desp (Identifier) I added Composition slave group.
My problem is in cell i.e. value and desp, I have multiple composition and hence multiple Desp. But they are not aligned as they are in separate cells. Also that Desp is longer so it ends up in 2 lines.
Below is how I would want to see my output for Value and Desp.
Is there a way to do this without playing with blank and spaces between report symbols?
Regards,
Rohan
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
Hello Christoph,
In the last few days I tried understanding what was I doing wrong. So I realised I was passing SPOS repetition group separately for value and separately for Description. Due to this the code was running individually for each column. So I decided to club both the cells in one. Added a table with 2 columns one for value and one for Desp. Wrote one SPOS repetition code this time for the inner 2 columns. This way I was able to achieve below result for Italy.
The problem was when there was no result I realised the centre border I drew between 2 cells use to disappear too. So then I wrote an else statement saying if no output then display No Data.
This is what I could achieve in the last few days.
So no more playing with spaces which I previously tried.
Regards,
Rohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rohan
looks as a good solution so far.. As i have explained: you can try to optimize the look and feel of values and decription by using "more" cells.. for your "tabluar" form But it is a kind of tricky to achieve something better
An as mentioned: the results (look and feel) depends on "language" to be printed (because of the font topic using WinWord)
C.B.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
let us try it "step by step".
a.) Any "identfier" can have "any kind of length".. the "WinWord" is able then (in a "cell" as part of a "table") to "optimize" the "look and feel". Here you can use all of the available "WinWord" options (in WWI context they are available as well)
b.) But I also have a condition that if NAM PROD is not maintained then display NAM CHEM. => I assume you have solved this using the "IF" option.. so this should not be an issue
c.) you "mix" SAP with "WinWord" problems...
"But the length of value and description are not same. So they don't end being aligned. Not sure what can I do here."
You will not get "always" a "perfect" solution (using all of the available "WinWord" options.)
Using now a "fictive" example.. e.g. you have the value "15 %" and the "text" "Hello SAP; Fantastic EHS World" to print
Using the "many" Winrod options. you can try to print "15%" as "centered" in a cell.. the same for "hello SAP; Fantastic EHS World".. but even by "clever" use of "whatsoever" WinWord option (topic of "Fonts" /" Languages" etc.) you well never get a "perfect" solution
C.B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Christoph for the reply. Yes space is not a solution I agree. I see few identifiers which have bigger names.
But I also have a condition that if NAM PROD is not maintained then display NAM CHEM.
I've tried playing around with columns by creating table inside table. But the length of value and description are not same. So they don't end being aligned. Not sure what can I do here.
Regards,
Rohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
i can not see an option to "play around with spaces" etc. But may be if you "just" change a little bit your "tabular form".. you might find a result
So within the "value" and "Descp" cell you could try to do like some like this
Country
Number
Status
Hazard
Value
Desp
xx
12345
Not applicable
NA
Value X
Value A
Value Y
Value B
Value Z
Value C
So you have to prepare a "table" in the "table" Might be tricky to get...
For the spaces proposal: The problem is mainly the "font" part...
By playing aorund with spaces etc. may be i will look fine in e.g. english but not in thai, chinese etc.
C.B.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.