Import from Text File in Select-option

[Former Member]

Hi,

Is there any way to import text file for Ranges tab in select-option(i.e., to fill both low and high values in select-option intervals)?

If so,how the input file should be?

[Former Member]

Hi,

Yes there is an option:

1. Define a select-option in ur screen say S_TEST.

2. Then in the file give data in two columns e.g.

10 100

120 200

3. Upload the file using GUI_UPLOAD into an internal table of the same structure that is having 2 columns.

4. Now loop at that internal table and chec if only 1st column is filled then need to fill only the LOW option:

S_TEST-OPTION = 'EQ'.

S_TEST-SIGN = 'I'.

S_TEST-LOW = ITAB-1st column

APPEND S_TEST.

CLEAR S_TEST.

If both the columns of ITAB are filled then

S_TEST-OPTION = 'BT'.

S_TEST-SIGN = 'I'.

S_TEST-LOW = ITAB-1st column.

S_TEST-HIGH = ITAB-2nd column

APPEND S_TEST.

CLEAR S_TEST.

Regards,

Himanshu

[jayanthi_jayaraman]

Hi,

I am asking about the standard import text file icon appearing in the select-option range.

Without coding, how to import from text file range of values.

[Faaiez]

Hi Jayanthi

The following notes will explain how you can achieve this:

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_aba/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d343134323837%7d">SAP Note 414287 - Upload function for multiple selection</a>

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_aba/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d343331353037%7d">SAP Note 431507 - Upload from clipboard for multiple selection</a>

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_aba/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d343334363235%7d">SAP Note 434625 - Upload for multiple selection, without field conversion</a>

Regards

[jayanthi_jayaraman]

Hi Faaiez,

I am not having permission to access the site.

Can you paste the notes Upload from clipboard for multiple selection.

[Faaiez]

The most important note is the first one:

Here is the text:

<b>Upload function for multiple selection

SAP Note Number: 414287</b>

<b>Symptom</b>

These functions (Shift + F11, ICONS 'Import from text file') offer the option that the single values on the multiple selection screen can be filled from one text file. It is especially useful if you have to enter many single values (e.g. more than 100).

Currently, however, you can only upload these values from text files (and not from Excel files). This file should only have one column:

1) For single values the complete row is loaded

2) For intervals the characters '&&' are used as separators. The part in front of '&&' is read into the Field1 and the part following the '&&' is read into the Field2.

<b>Example 1 (single values):</b>

Textfield: 1234

5678

ABCD

Multiple selection: 1234

5678

ABCD

<b>Example 2 (range):</b>

Text file: 1234&&5678

ABCD&&EFGH

Multiple selection: 1234 to 5678

ABCD to EFGH

<b>Additional key words</b>

Batch input, multiple selection

Cause and prerequisites

[Former Member]

Hi

You can fill in your range of values in an excel cells.Low values in once column and High values in the immediate next column. Copy the contents using CTRL+C.

Paste the values in the multiple selection popup.

Hope this helps you.

Regards,

Sreekanth

[former_member223537]

Hi,

Create a text file using Notepad. Enter following content

10

20

30

Save as low.txt

Now create another file with content

50

60

70

Save as high.txt

Now place the cursor in low value & click IMPORT file & pass Low.txt file name.

Simlarly place cursor in high value & pass high.txt file.

Best regards,

Prashant