topic Re: please help me in Application Development and Automation Discussions

please help me

laxman_sankhla3 — Wed, 27 Jun 2007 09:59:19 GMT

i want to send mail automatic to user when below condition is satified.

Data: ZUONR1 LIKE BSEG-ZUONR.

data: 2days_out type sy-datum.

2days_out = sy-datum + 2.

data: lv_date type sy-datum.

data: lv_formatdate(10) type c.

data: var1(4) type c,

var2(2) type c,

var3(2) type c.

lv_date = 2days_out.

var1 = lv_date+(4).

var2 = lv_date+4(2).

var3 = lv_date+6(2).

concatenate var3 var2 var1 into lv_formatdate separated by '.'.

<b>select single zuonr from bseg into zuonr1

where bukrs = 'GSEG' and ZUONR = lv_formatdate.</b>

<b>zuonr is not date field its character field .</b>

thanks.

Re: please help me

former_member378318 — Wed, 27 Jun 2007 10:03:08 GMT

You do not need to reformat the date, it is already in the correct format. Change you code as follows:

Data: ZUONR1 LIKE BSEG-ZUONR.

data: 2days_out type sy-datum.

2days_out = sy-datum + 2.

data: lv_date type sy-datum.

lv_date = 2days_out.

select single zuonr from bseg into zuonr1

where bukrs = 'GSEG' and ZUONR = lv_date.

Re: please help me

former_member378318 — Wed, 27 Jun 2007 10:05:58 GMT

Oops ignore my last message, you are right ZUONR is char not date. Is the select not working or do you require details on how to send an email??

Re: please help me

laxman_sankhla3 — Wed, 27 Jun 2007 10:11:04 GMT

select not working and also i require details on how to send an email?? .

please help .

thanks.

Re: please help me

Former Member — Wed, 27 Jun 2007 10:16:14 GMT

hi,

declare var1, var2, var3 as string variables n try

wit regards,

Suresh.A

Re: please help me

laxman_sankhla3 — Wed, 27 Jun 2007 10:25:29 GMT

i got data in select but now i want how to send mail to perticular user.

thanks.

Re: please help me

Former Member — Wed, 27 Jun 2007 10:25:37 GMT

Hi,

correct it var1 = lv_date+0(4).

regards,

ruchika

Reward if useful.........

Re: please help me

former_member378318 — Wed, 27 Jun 2007 10:25:39 GMT

Well I don't see any problems with the select statement and it should work so long as you have an entry in BSEG where bukrs = 'GSEG' and zuonr = DD.MM.YYYY

Have you checked an entry exists with the data you see in debug?

What makes you suspect the select is not working?

Re: please help me

former_member378318 — Wed, 27 Jun 2007 10:29:12 GMT

You can use methods of the class CLS_BCS to send an external email, see the following examples:

BCS_EXAMPLE_1

BCS_EXAMPLE_2

BCS_EXAMPLE_3

BCS_EXAMPLE_4

BCS_EXAMPLE_5

BCS_EXAMPLE_6

Re: please help me

laxman_sankhla3 — Wed, 27 Jun 2007 10:45:08 GMT

thanks man .

problem is solved.