topic Re: SE11 select in Application Development and Automation Discussions

SE11 select

former_member582701 — Fri, 20 Apr 2007 07:18:48 GMT

Hi!!

I have a select to MARA table where matnr > '0000' and < '9999' i onehave seen result is not good. I have gone to SE11 and i have same sleection.

MATNR 0000 to 9999. The result return 0100, 0295, etc but too 01010149585, 01022045423, etc.... if I filter 0101 TO 9999 then, 01010149585 is not returned, but yes 01022045423, etc... why?

How i can a select between a really 0000 TO 9999?

Re: SE11 select

Former Member — Fri, 20 Apr 2007 07:21:51 GMT

Hi Manel,

Can you pls expain your problem in a clear and detailed way.

Regards,

Sangeetha.A

Re: SE11 select

Former Member — Fri, 20 Apr 2007 07:22:55 GMT

Hi,

Enter the 18 char field for material like '000000000000000000' to

'000000000000009999',

there is no need to give the first value because all zero's means nothing, only enter the upper limit as 000000000000009999.

you will get the desired results.

reward if useful

regards,

Anji

Re: SE11 select

former_member404244 — Fri, 20 Apr 2007 07:23:20 GMT

Hi ,

try like this..

select matnr from mara into table itab where matnr in s_matnr..

delete itab where matnr LE '000000000000000000'.

delete itab where matnr GE '000000000000009999'.

Regards,

Nagaraj

Re: SE11 select

Former Member — Fri, 20 Apr 2007 07:23:43 GMT

try this

matnr > '000000000000000000' and < '000000000000009999'

null

Re: SE11 select

Former Member — Fri, 20 Apr 2007 07:28:46 GMT

Hi Manel,

SAP internally checks the data input on screen.

You can check material number by executing all material numbers and search for a perticular one.

Reward if useful.

Re: SE11 select

Former Member — Fri, 20 Apr 2007 07:31:26 GMT

HiManel,

Go through this program.

If u want put some condition (range) we can use this AT SELECTION-SCREEN ON FIELD.

REPORT YCLASSICREPORTING NO STANDARD PAGE HEADING LINE-COUNT 20(5)

LINE-SIZE 88 MESSAGE-ID ZMGSVMR .

TABLES : LFA1.

SELECT-OPTIONS : VENDOR FOR LFA1-LIFNR.

DATA: BEGIN OF ITAB OCCURS 0,

LIFNR LIKE LFA1-LIFNR,

NAME1 LIKE LFA1-NAME1,

ORT01 LIKE LFA1-ORT01,

END OF ITAB.

DATA : FNAME(10) , FVAL(10) TYPE N.

INITIALIZATION .

VENDOR-LOW = 100.

VENDOR-HIGH = 1500.

VENDOR-OPTION = 'BT'.

VENDOR-SIGN = 'I'.

APPEND VENDOR.

AT SELECTION-SCREEN ON VENDOR.

IF VENDOR-LOW < 100 OR VENDOR-HIGH > 1500.

MESSAGE I000(ZMSGVMR) WITH 'enter oroper input'.

ENDIF.

START-OF-SELECTION.

SELECT LIFNR NAME1 ORT01 FROM LFA1 INTO TABLE ITAB WHERE LIFNR IN

VENDOR.

LOOP AT ITAB.

FORMAT COLOR 1.

WRITE : / ' accno' , 'name of vendor' , 'city of vendor' .

WRITE : / ITAB-LIFNR ,SY-VLINE , ITAB-NAME1,SY-VLINE , ITAB-ORT01,

SY-VLINE.

ULINE.

FORMAT COLOR OFF.

ENDLOOP.

SET PF-STATUS 'YVMR'.

AT USER-COMMAND.

CASE SY-UCOMM.

WHEN 'VENDOR'.

GET CURSOR FIELD FNAME VALUE FVAL.

SET PARAMETER ID 'LIF' FIELD FVAL.

CALL TRANSACTION 'XK02' AND SKIP FIRST SCREEN.

ENDCASE.

TOP-OF-PAGE.

WRITE : / 'VENDOR DETAILS ' COLOR 3 .

END-OF-PAGE.

WRITE 😕 'PAGE NO:' , SY-PAGNO COLOR 6.

END OF SELECTION.

Rewords some points if it is helpful.

Rgds,

P.Naganjana Reddy