Skip to Content
avatar image
Former Member

HCI Master data task- blank description records failing

Loading data from SAP APO location table, where few records for one field is coming as Blank and when loading to IBP it is failing with error :

20 records failed with error, Attribute value having only SPACE characters are not allowed caused by: Inappropriate use of space character.

I also created a variable $G_DEFAULT_TEXT as varchar(1) with value '?' and this also does not seem to work, even in design time viewer if values are blank it does not show ? it shows only blank.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 19, 2017 at 12:00 PM

    You need to maintain SPACE_TO_NULL parameter with value 1 in IBP side, Global configuration.

    You can refer to model config guide page 170.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2017 at 02:18 AM

    I even checked that particular column is not 'required' in IBP also.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 10:01 PM

    FYI: This is the official Knowledge Base Article that references Alecsandra's explanation: https://launchpad.support.sap.com/#/notes/0002383566

    Best regards,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded