drop down menu

[Former Member]

Hi experts ,

I have the following requirements :

1. I have to make a customizing z_tabel to be filled via transaction sm30 with the following fields :

a. Day : hier i want to make a drop down menu with the days of the weeks (monday .. sunday) .

if i choose monday i want the value 1 to be saved in the db table.

tuesday -

---

> 2

....etc

b. To_be_used : here i want to use a checkbox via sm30.

with the values X or enpty in the database table.

Can anybody tell me how to achieve the isses a and b ?

2. I have to build a z-program. This program can only be run om the background.

The application server is of typw windows NT.

Is it possible to make an excel file on the application server on the background? if yes , how ?

with Fm i have to use ?

thanks in advance.

[chaiphon]

Hi Moo,

1 a) use domain or data element SDBA_DAY.

b) use any data element that has domain XFELD.

2) Check SY-BATCH = 'X' and allow program to run only when SY-BATCH = 'X' otherwise error.

you should create a normal tab delimited file in application server with .xls file type then tab will separate the column when you open the file with excel.

Chaiphon