on 09-22-2008 11:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.