SE11 select

[former_member582701]

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?

ty

[Former Member]

Hi Manel,

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

Regards,

Sangeetha.A

[Former Member]

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

[former_member404244]

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

[Former Member]

try this

matnr > '000000000000000000' and < '000000000000009999'

null

[Former Member]

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.

[Former Member]

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