Question about long text in Excel (Empty) output variant

[Former Member]

Hi All,

When I run the Excel -> Empty Output Variant, I have the Nam Prod identifier for the ingredient showing the long text showing which is great, but for the related component(s) it's cutting off at 132.  Is there any configuration that changes this to long text as well?

I have the enviornment parameter set to show long text, but as you can see above, it's only working for the ingredient level, not subsequent component(s).

Any advice will be greatly appreciated.

Thanks,
Jason

[Former Member · Accepted solution]

Hi Jason,

What i understand You are in the specification workbench and you want to display specification

data with the output variant EXCEL.  You notice that characters or empty

characters are partially missing in the output.  In particular, this occurs in

long texts.

For this issue please refere SAP Note: Note 1379763 - Missing characters in
the specification output with Excel

if useful please reward points.

[Former Member · Accepted solution]

Thanks Swet,

We're actually on release 606, so these support packs are already implemented.  The issue is that the second field won't show the long text.  It only shows the first 132 characters.

[christoph_bergemann · Accepted solution]

Dear Jason

I did not check coding on detail level but it seems to be that the customizing paramater doas have no effect on identifiers of components. So if needed you should prepare a "copy" of  function module to read identfieres longer than 132 and to pass back values if components are of interest. It is a standard methodology. I was not aware of the parameter. Normally in 99% of the cases only the first 132 characters will be passed back (I am not sure about user defined text but here may be some methodology ios used). This is true as well in WWI context (or you need to use "special" symbol).,

In most cases this is really sufficient

So if you need different behaviour create your own output variant. The output variants delivered are useful clearly but they do not cover all cases

C.B.

[Former Member · Accepted solution]

Thanks Christoph.  What's really odd is that the first column that outputs the NAM PROD identifier is outputting the entire long text; however the second field for the NAM PROD identifier (column H) is not.

[christoph_bergemann · Accepted solution]

Dear Jason

as you may be know: there is a "identification listing" used to select the "correct" identifier. It is years ago since I have investigated this topic. May be identification listig of specification of hitlist is different to that of components;(regarding CG02: this is the case; identification listing is different)  the coding is "lengthy" and you need some time to find the correct place. In doing so you should be able to detect how the read is done and why there is a difference.

Based on your results: Then you have two options: try it with OSS dialog or cre<te a copy of the function module used and adapt it to your needs.

C.B.