Date issue in Table ( SE16)

[Former Member]

Hi All,

Z-table is having the date field .when i see the entries of the table, all the date fields are like below.

DEV 00/00/0000

QAS / /0

PRD / /

when i tried to see the entries in ALV grid format,i am able to see only NULL values. This values are visible only at Standard list format list. If i download this value am gettin gthe above values in both the cases.

what is the reason for this issue? Please help me.

Regards,

Ashok

[Former Member]

Hi All,

Z-table is having the date field .when i see the entries of the table, all the date fields are like below.

DEV 00/00/0000

QAS / /0

PRD / /

when i tried to see the entries in ALV grid format,i am able to see only NULL values. This values are visible only at Standard list format list. If i download this value am gettin gthe above values in both the cases.

what is the reason for this issue? Please help me.

Regards,

Ashok

[Former Member]

Hi,

Most likely your Z-table is getting loaded with bad data. Look at where the table is getting updated and check this.

Regards,

Nick

[Former Member]

Date field is of type DATS. If the date field is NULL ,it should have only 00000000 right.

How it will be able to store only 1 zero or anyother data .

Regards,

Ashok

[Former Member]

Hi,

Yes, if a date is null it will contain 00000000. But my point is your date fields here do not contain null, they contain 0000/00/00 etc, which must be getting populated by some program. Find this program and analyse how it is filling these date fields with bad data.

Regards,

Nick

[Former Member]

when you see in SE16 that comes with conversion exit.

for each user convertion exit converts the date format to the format given in SU01. so you are getting values as 00/00/000 or any other types.

but if you do a select query on the ztable into a internal table then you can see that its 00000000