gr date is invalid in report

[Former Member]

Hi

I have an issue  in one of my report gr date is showing invalid date like item actually dated in 1st july 2011 but in query output its showing as 07/01/2011.

and also some time its showing 00/00/000.

can please some one help me how to solve this issue.

Thanks

Bhaskar

[Former Member]

Hi Bhaskar,

It looks like, the date is showing in the format MM/DD/YYYY.

In your case, 1-July-2011 as 7/1/2012(MM/DD/YYYY).

In order to get it in DD/MM/YYYY format kindly do the following system setting chane.

Goto Control Panel > Regional & Language Options >

tab Date > choose or type your Short Date Format as (DD.MM.YYYY)

For your 2nd issue: Date is showing like 00/00/0000.

I think, the date filed value would be balnk for that record. That would be the reason to get value as 0.

In order to resolve this issue, you can create transformation routine for that field to be blank if no value exist.

Cheers

Regards,

Karthick.

[Former Member]

Hi karthic

But in gr date only few values showing MM/DD/YYYY

remaing are showing correctly as DD/MM/YYYY

Please help me this is very urgent.

Thanks

Bhaskar

[Former Member]

Hi Bhaskar,

Could you pls check the date in the inforpovider over which the query is developed.

I think the value in the infoprovider would be entered in MM/DD/YYYY format for few records.

If the value is incorrect in cube then we may need to do selective deletion of those records, then reload the particular records upto PSA, then we need to correct the date value in PSA to DD/MM/YYYY format, then we need to load to data target.

Regards,

Karthick.

[Former Member]

Hi karthic

Thaks.

please explain me after deleted  those records in info povider how to load those records to psa from source. its  z info provider and may be generic data source.

please explain me.

I will assign full points.

Thanks

Bhaskar

[Former Member]

Hi Bhaskar,

Im not sure what the data flow design is.Also not syre whether 3.x flow or 7.x flow.

I have explained in general for both 3.x and 7.x version. You can make use of it to get is loaded.

Before performing deletion in Infocube, we need to extract those records upto PSA. IF the records got extracted utpo PSA , then we can proceed with selective deletion.

1) If datasource is extracting delta records, then you need to create new infopackage with repair full load option checked.

2) Then give selection in the selection tab of Infopackage for the particular records for which we need to load. Like document number or Order number, date,etc.

3) in processing tab, give option as, ONLY PSA (Uncheck Update subsequently to data target)

4) Save and execute the infopackage.

5) once the request gets successful, then we need to correct the date in the records in PSA and save it.

6) Then perform selective deletion in the infoprovider with the selection for that particular record.

7) Then execute DTP (if 7.x version) or click on "process manually" button in the status tab of the monitor screen(If 3.x version).

😎 Perform rollup  activities.

Now you can try checking the value in report.

Regards,

Karthick.

[Former Member]

Hi karthic

Good one.

just i checked the data in infoprovider its a key figure and showing value as 734,320 but in query output its showing 07/01.2011.

in infoprovider level the keyfigure defined data type as date (Dec-counter or amount field with comma and sign.)

In query level there is no CKF and variables

and in rsa1-kf definition ------- aggeregation tab

AGGREGATION-----> maximun.

EXCEPTION AGGREGATION----->no aggregation (X,If more than one value occur)

Agregation ref char-------------------------->Zgspinvnl (Gsap invoicenumber) its a charactrstick

ADDITIONAL PROPERTY TAB

BEX DESCRIPTION-----------------------------> short desc

only above values in kf definition and no ckf and varibles in designet, in infoprovider output data showing number  and query output showing date can some one help me how it converted from number to date .

please explain.

Thanks

Bhaskar

[Former Member]

Hi karthic

Good one.

just i checked the data in infoprovider its a key figure and showing value as 734,320 but in query output its showing 07.01.2011.

in infoprovider level the keyfigure defined data type as date (Dec-counter or amount field with comma and sign.)

In query level there is no CKF and variables

and in rsa1-    kf definition -------

aggeregation tab

AGGREGATION-----> maximun.

EXCEPTION AGGREGATION----->no aggregation (X,If more than one value occur)

Agregation ref char-------------------------->Zgspinvnl (Gsap invoicenumber) its a charactrstick

ADDITIONAL PROPERTY TAB

BEX DESCRIPTION-----------------------------> short desc

only above values in kf definition and no ckf and varibles in designer, in infoprovider output data showing number  and query output showing date can some one help me how it converted from number to date

please explain how the number 734,320 converted in to date 07.01.2011.

Thanks

BHaskar

[venkateswaran_k]

Is it a standard report or Z report.

In first case it shows in MM/DD/YYYY format.. So this can be set by User Profle.. SU01.

Secondly for showing 00/00/0000 -  Iwould like to know more detail.. if it is a Z program then whould like to see th code

Regards,

Venkat

[Former Member]

Hi Venkateswan

it is a z report .

can u please explain what we have to do in su01.

but in gr date filed only few values showing MM/DD/YYYY and remaining are showing  as DD/MM/YYYY.

Please explain step by step procedure because its very urgent.

Thanks

Bhaskar

[venkateswaran_k]

IN SU01

give your user id..

Select change

go to Default tab

verify the date format specified...

Or  Follow  Karthik Suggestion

Secondly,

For Date format.. Can you please paste the screen shot  and  Field Catalog in the ABAP code

Or ask ABAPER to use Field mask in the gr_date field while printing the report in catalog

Regards,

Venkat