topic Re: Sy-datum limitations in Application Development and Automation Discussions

Sy-datum limitations

Former Member — Sat, 02 Jun 2012 09:48:59 GMT

Hi all experts ,

i have a situation where i want to upload some entries in ztable , all entries are going except the entries which has date after 2013 are not going ,

Please i need a advise on this issue , i think this is an limitation of sy-datum field that it doesnt accept the date entries greater than date of present year ..

Re: Sy-datum limitations

kumud — Sat, 02 Jun 2012 09:57:29 GMT

Hello Akshay,

Question is very ambiguous. Sy-datum is a system field which holds the current date of the system.

What's the data element of the field which is storing the date in your Z* table?

Regards,

Kumud

Re: Sy-datum limitations

Former Member — Sat, 02 Jun 2012 09:59:00 GMT

Hi Akshay ,

Try using events in table maintained generator.

Follow this link

<link to blocked site removed by moderator>

Implement this below check

form create_entry.

if ztable-datefield ge sy-datum.

ztable-datefield = value passed from upload program.

endif.

endform.

With Regards,

Sudhir S

Message was edited by: Thomas Zloch

Re: Sy-datum limitations

Former Member — Sat, 02 Jun 2012 10:11:23 GMT

Hi kumud ,

situation is as below ..

i have program which upload entries from excel sheet to ztable..

in that ztable i have one date field , data element - sydatum..

whenever i run program , entries gets uploaded succesfully , except entries having date e.g. 1.1.2013 or entries containing 2013 are not going to ztable ..

Re: Sy-datum limitations

former_member213851 — Sat, 02 Jun 2012 10:12:02 GMT

Hi Akshay,

Please check the domain of data element of the zfield in which you are storing date.

If any Value table is assigned to that zField then it might be the case that the Dates greater than year 2012 are not present inside Value table and hence it is not allowing the zField to store Date greater than Current Year.

Regards,

Sachin

Re: Sy-datum limitations

Former Member — Sat, 02 Jun 2012 10:19:11 GMT

hi Sachin ,

I tried that also , but there is no such value table attached to its domain ..

Re: Sy-datum limitations

kumud — Sat, 02 Jun 2012 10:22:01 GMT

You may try by changing the data element to ENDDA. It hasn't given me any problem. Also, I assume you are taking care of internal date format conversions.

Regards,

Kumud

Re: Sy-datum limitations

former_member213851 — Sat, 02 Jun 2012 10:26:42 GMT

Hi Akshay,

Then something is wrong with your upload program only. Check if any condtion check is there for Date which is greater than year 2012 or any operations is carried out on such Dates.

Also, in excel sheet take only 1 entry that to with year 2013 and place Breakpoint where date is assigned to the table field and check sy-subrc value.It might give us idea about how to proceed further.

Re: Sy-datum limitations

Former Member — Sat, 02 Jun 2012 10:32:11 GMT

Hi Sachin ,

I am doing that , in that i have used one FM

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
     EXPORTING
*     I_FIELD_SEPERATOR        =
       i_line_header            = 'X'
       i_tab_raw_data           = it_raw       " WORK TABLE
       i_filename               = p_o_file
     TABLES
       i_tab_converted_data     = it_datatab[]    "ACTUAL DATA " CHANGED TO IT_DATATAB BEFORE IT WAS IT1.
    EXCEPTIONS
       conversion_failed        = 1
       OTHERS                   = 2.

this works very well for all other entries, except for the year 2013 , in this case sy-subrc eq 1.if year is 2013 ......

Re: Sy-datum limitations

venkateswaran_k — Sat, 02 Jun 2012 10:33:42 GMT

The problems should be simple.

I too faced sometimes this kind of date problem.

the problem lies in the Excel sheet only.

Please condisder the following in Excel sheet

1. What is the format of the column that contains Date value

2. Make it as Date or

3. Put values with single quote before that... exampe,, '21.05.2013

Hope this will work

Regards,

Venkat

Message was edited by: Vinod Kumar

Re: Sy-datum limitations

former_member213851 — Sat, 02 Jun 2012 10:37:44 GMT

Hi Akshay,

Please try using FM ALSM_EXCEL_TO_INTERNAL_TABLE instead of TEXT_CONVERT_XLS_TO_SAP to get excel data into internal table.

Re: Sy-datum limitations

former_member213851 — Sat, 02 Jun 2012 11:08:42 GMT

Hi Akshay,

TEXT_CONVERT_XLS_TO_SAP uses FM CONVERT_DATE_TO_INTERNAL internally to convert the date 10102013 to format 20131010 .

BUT this FM works currently in my system. Please check the separator or date format in excel because if it is not correct then it will throw error :

Enter a valid date (for example, 02.06.2012)

Otherwise try using FM ALSM_EXCEL_TO_INTERNAL_TABLE instead ofTEXT_CONVERT_XLS_TO_SAP to get excel data into internal table.

Best Regards,

Sachin

Re: Sy-datum limitations

Clemenss — Sat, 02 Jun 2012 13:20:13 GMT

Hi Akshay Rankhambe,

you face a problem with your code but you do not post the code. You did not check anything in debugger and you did not explain in detail what went wrong. How do you think people can help you? We can't read your mind and have no superficial power to look at your computer screen. I'd expect something more from an adult creature.

Generally I suggest that the date in excel is in external format. Date fields in SAP are stored as YYYYMMDD which is internal representation of whatever you have in excel and did not tell us.

This means an input conversion must be done for this field.

Do like this:

DATA:

ls_tabfield TYPE tabfield.

ls_tabfield-tabname = 'SYST'.

ls_tabfield-fieldname = 'DATUM'.

CALL FUNCTION 'RS_CONV_EX_2_IN'

EXPORTING

input_external = <excel field>

table_field = ls_tabfield

* CURRENCY = CURRENCY

IMPORTING

output_internal = <your table field>

EXCEPTIONS

input_not_numerical = 1

too_many_decimals = 2

more_than_one_sign = 3

ill_thousand_separator_dist = 4

too_many_digits = 5

sign_for_unsigned = 6

too_large = 7

too_small = 8

invalid_date_format = 9

invalid_date = 10

invalid_time_format = 11

invalid_time = 12

invalid_hex_digit = 13

unexpected_error = 14

invalid_fieldname = 15

field_and_descr_incompatible = 16

input_too_long = 17

no_decimals = 18

invalid_float = 19

conversion_exit_error = 20

OTHERS = 21

Regards,

Clemens

Re: Sy-datum limitations

Former Member — Sun, 03 Jun 2012 12:08:57 GMT

Hi Clemens,

i checked the code in debugger before posting this question ,

this works very well for all other entries, except for the year 2013 , in this case sy-subrc eq 1.if year is 2013 ......

isnt this information is insufficient , i am again telling you the above code and whole report works fine

for every entry except if entry is having 2013 year. ...

also i knw how SAP stores date , date format in excel sheet is 'yyyymmdd'' only

what details you expect from me more than this ..

Re: Sy-datum limitations

venkateswaran_k — Sun, 03 Jun 2012 12:18:03 GMT

Dear Akshay

What is the field name that stores your data in the Ztable.

Can you please let me know the type.

Cam you please change the type to AEDAT

regards,

venkat

Re: Sy-datum limitations

venkateswaran_k — Sun, 03 Jun 2012 12:21:52 GMT

Dear Akshay

The Sy-subrc eq 01 means , the record not found ... Do you have any reference or constraints built in the Z-table based on teh date field?

Re: Sy-datum limitations

Former Member — Tue, 05 Jun 2012 06:21:52 GMT

Hi Venkateswaran,

Yes i allready tried what u suggested , i mean as u said , my column of date in excel sheet is in single quote only & its format is general because that is its requirement..

data type of field in ztable is SYDATUM ..

and also chaging of data type in ztable wont be of use as function module TEXT_CONVERT_XLS_TO_SAP doesnt converting particular record(2013 year) into internal table..

Re: Sy-datum limitations

venkateswaran_k — Tue, 05 Jun 2012 06:41:53 GMT

Hi Akshay

1. just for a elimination strategy, try to change the datatype to EKPO-audat ... and try it..

2. Secondly, please paste your data insert block of your prgarm to find out any validations you put..

Regards,

Venkat

Re: Sy-datum limitations

venkateswaran_k — Tue, 05 Jun 2012 06:45:53 GMT

Hi Akshay

1. just for a elimination strategy, try to change the datatype to EKPO-audat ... and try it..

2. Also kindly paste the entries - the date value that does not get insert. Just want to see as a third eye view... ..

As you said, only 2013 values are not going... that means this is certainly not because of sydatum - but something small mistake which is escaping from your eye....

kindly update...

Regards,

Venkat

Re: Sy-datum limitations

RaymondGiuseppi — Tue, 05 Jun 2012 06:52:07 GMT

Check date format, I suspect this is the limit of month number to 12 and not the current year that is the problem...

Regards,

Raymond