Skip to Content
author's profile photo Former Member
Former Member

BEX REPORT:DATE FIELD THROWING "X"

Hi,

We have a report which is being executed on an infoset.The data is being pulled from ECC and SRM systems.There are primarily 2 issues with this report

1)Purchasing Group descriptions are not being pulled.Instead an abbreviation is being seen in the report.It looks like currently ony short description is being pulled.Is there a way to pull the long description/medium description for this particular infoobject "Purchasing Group ".Please advise on this issue.

2)We have date fields, SC create date(Shopping cart),First Approval date and Last Approval date and Requested Delivery date in the report.

But the issue is First Approval date and Last Approval date fields are throwing up"X" in the report.Also,Some times ,it appears that ,the date field is being populated in the underlying ODS but in the report ,it is throwing up"X"

Also, some information on the date fields at infoobject level.

The date field is defined as a keyfigure

Type/data type is Date

Data Type is u201CDEC-Counter or amount field with comma and signu201D

But whether it should be u201C DATS Date field (YYYYMMDD)stored as char(8) .

Please provide some resolutions to work around this particular issue.

If you require further information,I will provide it.

Thanks,

Amar

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 11:04 AM

    Hi Amar,

    As far as 'text' is concerned, check the following changes.

    -ensure that medium or long text is maintained for that field.

    -in Bex, under th display tab for that field, select 'text view' as Medium length text or Long length watever is maintained. (its standard by default).

    this should solve your text problem.

    Regards,

    Pritesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Any idea about the date field?Why it is throwing up "X" .

      Also ,can you tell me how exactly can we pull the descriptions in the query and where exactly do we need to make the changes?

      Thanks,

      Amar

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.