help on creating a custom transaction

[Former Member]

Hi,

I need to create an interface that will have to have the following:

Plant

FiscalYear/Period

Customer Returns Cost

Full Pallet Cost

Remaining Cases Cost

Pallet PLD Process Cost

Pallet Expense Cost.

Add Delete Change Save Exit

The interface needs to connected to a Ztable that we need to create.This interface should also allow the ability to update data from a csv file upload.The Ztable needs to capture the persons userid and system date and store it.

We need to create roles so that only the concerned persons can enter data and some others to read and some others to change the data like for example based on his userid he can add the data and if he doesn’t have edit authorization then he can only read the data and all the input values will be grayed out. So based on his userid we need to change the data.

Also I want to know , let us say a certain record already exists in the Ztable and its more than 20 days old from the system date now the program must not allow that record to be changed. The input values can also have negative numbers which needs to be taken care of.

I will appreciate all the help that you can send across.

Thanks

Amit

[Former Member]

Hi,

I need to create an interface that will have to have the following:

Plant

FiscalYear/Period

Customer Returns Cost

Full Pallet Cost

Remaining Cases Cost

Pallet PLD Process Cost

Pallet Expense Cost.

Add Delete Change Save Exit

The interface needs to connected to a Ztable that we need to create.This interface should also allow the ability to update data from a csv file upload.The Ztable needs to capture the persons userid and system date and store it.

We need to create roles so that only the concerned persons can enter data and some others to read and some others to change the data like for example based on his userid he can add the data and if he doesn’t have edit authorization then he can only read the data and all the input values will be grayed out. So based on his userid we need to change the data.

Also I want to know , let us say a certain record already exists in the Ztable and its more than 20 days old from the system date now the program must not allow that record to be changed. The input values can also have negative numbers which needs to be taken care of.

I will appreciate all the help that you can send across.

Thanks

Amit

[ssimsekler]

Hi Amit

I would like to give some hints about separate portions for your program.

<b>>> The interface needs to connected to a Ztable that we need to create.</b>

As you know, you can create a table from the transaction code <b>SE11</b>

<b>>> This interface should also allow the ability to update data from a csv file upload.</b>

In your program, you can uitilize the function modules <b>"GUI_UPLOAD"/"GUI_DOWNLOAD"</b> to operate on presentation layer files.

<b>>> The Ztable needs to capture the persons userid and system date and store it.</b>

You can retrieve the current user id from the system variable <b>sy-uname</b>, the current date from <b>sy-datum</b> and the current time from <b>sy-uzeit</b>. You need fields for these in your table to store them in the transaction.

<b>>> We need to create roles so that only the concerned persons can enter data and some others to read and some others to change the data like ...</b>

You can use the statement <b>"AUTHORITY-CHECK"</b> for this purpose. You can create authorization fields via transaction codes <b>SU20</b> and <b>SU21</b> as I remember. And make authorization checks at proper places in your program to toggle between write and read modes.

<b>>> Also I want to know , let us say a certain record already exists in the Ztable and its more than 20 days old from the system date now the program must not allow that record to be changed. </b>

Since you will store change date on the record itself, you can check this using it.

Hope I could help...

*--Serdar

[Former Member]

Hi Serdar,

Could you tell me what is the advantage of GUI_UPLOAD compared to WS_UPLOAD. I am reading and trying all that you have mentioned to me and doing all this in parallel. I thank you for the patience in advance with me.

thanks

amit

[ssimsekler]

Hi Amit

Firstly, I am happy that I am sharing my knowledge with you.

The function module "WS_UPLOAD" is announced officially to be obsolete by SAP. I do not know underlying technical reasons. But since they have the same functionality, use the new one.

If you are familiar with ABAP OO. You can also use the static method "GUI_UPLOAD" of the class "CL_GUI_FRONTEND_SERVICES".

*--Serdar

[nablan_umar]

Your questions seems needs a lot of programming. But in short answer, this is what you need to do:

1. Create a table using SE11

2. Generate a maintenance view to this table within SE11.

3. Create a parameter transactions-1 for display and one for maintain.

4. Give display transaction to users that are allowed for display. Give maintain transaction to users that are allowed for maintain

5. Develop a program that will be able to upload a CSV file from PC into this table.