cancel
Showing results for 
Search instead for 
Did you mean: 

Loading extra long text - XXL attribute in Info Object

Former Member
0 Kudos

Dear All,

We have requirement from client to implement XXL feature available in InfoObject with SAP BW 7.4 to display extra long text.

Our system is currently on SAP BW 7.4 with SP level 16.

I have created InfoObject and enabled the option 'Supports XXL attribute' and checked the box 'long text, long text is XL'.
In the XXL Attribute tab we have created XXL InfoObject as well with data type STRING.
I understand from SDN and help portal that the data type and table structure definition and field length (1333) is correct.

Request your inputs on the below pointers.

1. How exactly this functionality works.
2. Do we need to implement any note, need to do any settings or use any FM to use this option.
3. Will this support flat file datasource interface. If yes, what should be the file format, how to load end to end etc.
4. Once loaded to tables how do we display the text in reports, data validation etc.

I understand that long text can be displayed by creating multiple InfoObject, split and load the data and concatenate in the report.
However client want to implement XXL feature.

Please do let me know if you have knowledge or worked on similar requirement and implemented this feature in any of your projects.

Appreciate if you could share documents if any which will help us drive this requirement.

Thanks in advance.


Thanks and Regards
Mohan

Accepted Solutions (0)

Answers (2)

Answers (2)

dominik_kramer
Explorer
0 Kudos

Hello,

the question is how to get XXL Attributes into the Output of a bex query?

As far as i see it, they can not be added to a Report.

So what is the sence of this technique?

Kind regards

Dominik

Kramer

Former Member
0 Kudos

Dear Kramer,

Thank you for the revert.

There are two parts.

1. In InfoObject Master Data/ Text tab -> if we enable Supports XXL Attributes then system will automatically add XXL attributes tab.

2. Under text property - check box - Long text , Long text is XL

I want to know how we can maintain data to at least InfoObject table level, for now output on Bex is not required. When option 2 is enables then system is automatically adding SSTRING of length 1333. But there is no InfoObject available with length 1333 unlike Medium and short to extract this from PSA.

How do we load this data to Long text field from PSA?

Below screen shot for your reference.

Thanks and Regards,

Mohan

Former Member
0 Kudos

Hello;

1) In IO, tab master data/text flag the XXL attributes option. The XXL attribute table will be created and a new tab XXL Attributes will be available (You can also flag for XL text)

2) Add a new XXL atribute into tab XXL Attributes

3) Go back to RSA1 and you will see a new metada is available

4) Link it to a datasource and load it (just like ATTR or TEXT) and it's done.

Hope it helps;

Regards

Former Member
0 Kudos

Hello Ricardo,

Thank you for the revert.

I just linked it to a flat file DataSource and tested.

However the extra long text is not making it to even PSA. I tried with Data type of the text field as

STRING and RAWSTRING. But nothing works !

Will this work with file interface? Can you please explain me the loading process in detail?

Manage of XXL ATTRIBUTES flow taking me to browser page and just display meta data.

Thanks in advance.

Regards,

Mohan

Former Member
0 Kudos

Hello;

In one example I create the datasource with the XXL InfoObject as reference.

It works fine.

Regards;

Ricardo

Former Member
0 Kudos

Dear Ricardo,

Thank you for the revert.

There are two parts.

1. In InfoObject Master Data/ Text tab -> if we enable Supports XXL Attributes then system will automatically add XXL attributes tab.

2. Under text property - check box - Long text , Long text is XL

I want to know how we can maintain data to at least InfoObject table level, for now output on Bex is not required. When option 2 is enables then system is automatically adding SSTRING of length 1333. But there is no InfoObject available with length 1333 unlike Medium and short to extract this from PSA.

How do we load this data to Long text field from PSA?

Can you please give me the mapping details to bring data longer than 250 chars into PSA and to object?

Below screen shot for your reference.

Thanks and Regards,

Mohan