topic Re: SAP QUERY in Application Development and Automation Discussions

SAP QUERY

Former Member — Wed, 12 Feb 2014 14:04:14 GMT

HI ,

I have created a SAP query in sq02 and created 2 extra fields.

first extra field

Materialnumber (coding as below )

Move PRPS-USR01 to MaterialNumber .

and second field I have below coding

CLEAR :EXTERNALMATERIALGROUP.

SELECT single EXTWG

into EXTERNALMATERIALGROUP

from MARA

where ISMREFMDPRFAM = PRPS-USR00

AND MATNR = MATERIALNUMBER.( my first extra field )

now when I create sq01 query .my first field is populated with material number but second field is BLANK .

any idea WHY

Its quite URGENT . PLEASE help us .

Many Thanks

Regards

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 14:09:41 GMT

The most obvious reason is that the select was empty. Put a break point in the code and find out what it returned.

Neal

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 14:10:01 GMT

Hi Preeti,

Is the data present in MARA against the selection criteria?

What's the data type of MATERIALNUMBER? It should be same as of MATNR.

Can you try to debug the code and check?

Thanks

Amit

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 14:25:51 GMT

Hi amit .

There is lots of data in MARA table .I am getting at materialnumber but externalmaterial not getting .

screen shot .

can you please tell me how to debug this code .

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 15:34:08 GMT

Hi Preeti,

As said Neal you can put a break point in the code after your "select".

SELECT single EXTWG

.........................

AND MATNR = MATERIALNUMBER.

BREAK-POINT.

Regards

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 15:51:55 GMT

Break-point does not work in all systems.

Last i checked,

Break <user name>.

Still did.

If that doesn't work, the query generates ABAP code. Your select will be literally in that code. You can find it that way and put it in via debugger / se38 methods.

Neal

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 17:59:40 GMT

i did put break point and got the below screen shot .

there i can see 2 values are coming for variables but Material group is blank.

now what should I do . I am new in ABAP .

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 18:10:20 GMT

There looks to be an issue with your 'where' clause. Table 'MARA' does not have a field ISMREFMDPRFAM.

Re: SAP QUERY

Former Member — Wed, 12 Feb 2014 20:02:34 GMT

The sy-subrc = 4 means that your select could not find a match. The most likely cause of this is that your material number must be 18 characters long with leading zeros for your select to work. Use the same conversion exit the it's domain uses before calling the select.

Neal

Re: SAP QUERY

Former Member — Thu, 13 Feb 2014 07:48:01 GMT

Could you please explain in detail how it can be that " Break-point does not work "

but the macro " Break <user name> " which based on statement " Break-point "

still do.

Boris

Re: SAP QUERY

RaymondGiuseppi — Thu, 13 Feb 2014 08:00:50 GMT

First execute SE11 and look for domain of

PRPS-USR01 : no conversion exit
MARA-MATNR : a conversion-exit, e.g. MATN1 (or ALPHA, depends on actual SAP solution/version implemented)

So before moving value from first to second field you must convert from external to internal format with CONVERSION_EXIT_MATN1_INPUT.

Nb: If there were no exit a simple MOVE would have been enough, with two different exits two conversions would have been required. field1 internal.->external , field 2 external->internal. with same exit and different length a conversion may also be required; e.g. more leading zeroes required if target field is longer with ALPHA conv. exit.

Regards,

Raymond

Re: SAP QUERY

Former Member — Thu, 13 Feb 2014 10:00:59 GMT

I will give your example of code.

DATA: materialnumber TYPE char18,
externalmaterialgroup TYPE mara-extwg.

CLEAR :externalmaterialgroup.
CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'
    EXPORTING
      input        = materialnumber
    IMPORTING
      output       = materialnumber
    EXCEPTIONS
      length_error = 1
      OTHERS       = 2.

SELECT single EXTWG

.........................

Regards