Forms automated creation

[Former Member]

Hi folks,

I was wondering if anything exists for the following purpose:

Say for example, that we, in the Master Data departament , are going to create a customer. The way we currently do it is through an excel sheet (kinda like a bdc form) that is filled out by each user from the required departments (buying, taxes etc). The problem is that when we get the excel sheet at the end, we see a lot of invalid information that we cannot get into SAP to create the customer.

Is there anything to easily create a form out of a transaction with drop down lists taken from the current data base?

What do you suggest is best for doing this?

I was thinking of something like a transaction recorder that at the end creates a form ready to work on or something....

Thank you all,

Camilo

[Former Member]

Hi folks,

I was wondering if anything exists for the following purpose:

Say for example, that we, in the Master Data departament , are going to create a customer. The way we currently do it is through an excel sheet (kinda like a bdc form) that is filled out by each user from the required departments (buying, taxes etc). The problem is that when we get the excel sheet at the end, we see a lot of invalid information that we cannot get into SAP to create the customer.

Is there anything to easily create a form out of a transaction with drop down lists taken from the current data base?

What do you suggest is best for doing this?

I was thinking of something like a transaction recorder that at the end creates a form ready to work on or something....

Thank you all,

Camilo

[Former Member]

Hi

it depends on which error you need to prevent

for example you can create a model in excel, where every cell the user needs to fil is controlled: so the user can insert the allowed values only..

[arthur_alvesteixeira]

Apply a check if the line read is valid for upload, and not invalid.

For this review your file layout and
find a field that determines if the line is valid
to upload in SAP and apply a check using this field value.

I don´t have your code here, so check these examples:

IF field XXX = YYY.

    Upload data (your logic)

Or

IF field XXX <> YYY

  CONTINUE.   "If your are in loop and want to process the next entry

Or

IF field XXX <> YYY

  EXIT. "If it's the final lines and you want to abort the file

[Former Member]

I know I can add drop down dependant lists and data validations, but doing that for each field, each transaction etc would be too much work.

The kind of errors I want to avoid happening is that someone puts something like India in the country field and then New york in the city field. Or that they just leave them blank and pass them to the next person in the workflow (but thats a secondary concern) The main concern is if theres a way to automatically create these forms for a given transaction.

[Former Member]

Hi

that means yuo need to create a your transaction in SAP, but in this way excel file would be useless, the user could use that transaction.

So I don't understand where user have to create the data in or out of SAP?

Max

[Former Member]

Hi Max,

The problem is that there are multiple users involved. Therefore, the information needs to be prepared out of SAP before being put into it.  For example, when creating the master data for a customer, the sales person only knows the sales data, the tax person knows the tax data, the collections person knows the collections data etc. The record cannot be created until we have all this minimum mandatory data. Thats why we need to get it all in a form first and then put it into SAP.

Thank you,

Camilo

[arthur_alvesteixeira]

Camilo,

to validate each value inserted it's possible using STVARV transaction.

Example, create the parameter ZCUSTUPL_CITY and fill the possible cities,
so you maintain all the possible values in this parameter (using STVARV transaction).

It's more simple than change the program for each update, because If you modify the rule,
it's not necessary to change the code, you only have to update the parameter
in STVARV transaction and your process will be automatically
updated with your new configuration.

[Former Member]

Hi

That's ok, but the problem is how to do a validation out of SAP

Max

[former_member197622]

Hi Camilo,

No matter how you do you will still need the validation of SAP, in the case of a customer data there are many variables to analyze and many of that depends of configuration, lets say you create the form out of sap, even if the minimun data is achieved nothing says that is consistent at the moment of creation.

some combinations in the data need feedback

Regards

MC