cancel
Showing results for 
Search instead for 
Did you mean: 

BEX REPORT:DATE FIELD THROWING "X"

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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