topic Re: How do I validate against a Data Element within ABAP? in Application Development and Automation Discussions

How do I validate against a Data Element within ABAP?

Former Member — Fri, 08 Jul 2005 14:46:18 GMT

I'm working on an ABAP that will upload a CSV file into SAP and create Activity Group Authorisations based on the contents of the CSV. One of the requirements is that the CSV is validated before processing.

How can I validate a value against a Data Element specification?

For info, I'm trying to validate Activity Group Org Level values. For example, is the value read from the CSV a valid BUKRS value? I need to confirm to the user that all the data is good the actual creating of the auth's starts.

Thanks,

Malc

Re: How do I validate against a Data Element within ABAP?

Vinod_Chandran — Fri, 08 Jul 2005 14:52:18 GMT

Hi Malc,

You need to find out the corresponding database table and validate against that. One way to find out the table is to go to the domain and look for the value table.

Thanks

Vinod

Re: How do I validate against a Data Element within ABAP?

RichHeilman — Fri, 08 Jul 2005 15:04:01 GMT

You will need to validate against table T001 for BUKRS.

Select Single * from t001w
           where bukrs = itab-bukrs.
If sy-subrc <> 0.
Messsage E001(00) with 'Company Code not found'.
Endif.

Regards,

Rich Heilman

Re: How do I validate against a Data Element within ABAP?

Former Member — Fri, 08 Jul 2005 16:22:51 GMT

Thanks for the answers but they don't quite answer my question. My CSV input file will have something like this:

Company Code, BUKRS, 800

Business Area, GSBER, 400

Account Type, KOART, 5

For BUKRS and GSBER I now see that I can check the Data Elements "Value table" and validate against it but some of my fields don't have a value table, eg KOART.

When I read the CSV I need to check that "5" is a valid value for KOART. For example, if the CSV contained:

Account Type, KOART, wumpus

I need to detect that "wumpus" is not a valid value for KOART. Is there a SAP function I can call to check if a value is a valid value for any given Data Element?

Thanks,

Malc

Re: How do I validate against a Data Element within ABAP?

Vinod_Chandran — Fri, 08 Jul 2005 16:27:48 GMT

Try the function module DDIF_FIELDINFO_GET which will return the possible values of a field. Then you can check the value from the file.

Re: How do I validate against a Data Element within ABAP?

RichHeilman — Fri, 08 Jul 2005 17:16:11 GMT

Here is a sample.....



data: dbdiff_values type ddfixvalues, "Festwerttexte zu dbdiffkind
      dbdiff_val    type ddfixvalue.

parameters: p_koart type koart.

at selection-screen.

  call function 'DDIF_FIELDINFO_GET'
       exporting
            tabname      = 'BSEG'
            fieldname    = 'KOART'
            lfieldname   = 'KOART'
       tables
            fixed_values = dbdiff_values.

  read table dbdiff_values into   dbdiff_val
                   with key low = p_koart.

  if sy-subrc <> 0.
    message e001(00) with 'Entry not found'.

  endif.

Regards,

Rich Heilman