Skip to Content
avatar image
Former Member

Loading extra long text - XXL attribute in Info Object

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 14, 2017 at 11:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

      chrlf.png (26.4 kB)
  • Jul 24, 2017 at 12:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

      cn8kl.png (9.4 kB)
      ic6nn.png (12.6 kB)