regarding Se11

[Former Member]

Hi,

When we display d/b table (let say vbap) by se11 then it will display all the fields in the sequence same as we defined it in table structure.["vbeln" then "posnr" then "matnr" etc]

now suppose i want to display 2nd column as 1st and 1st as a 2nd [that is,POSNR then VBELN and MATNR]..How will i do it...?

note : I dont want to change the sequence of the fields in the table structure..

[Former Member]

Hi,

When we display d/b table (let say vbap) by se11 then it will display all the fields in the sequence same as we defined it in table structure.["vbeln" then "posnr" then "matnr" etc]

now suppose i want to display 2nd column as 1st and 1st as a 2nd [that is,POSNR then VBELN and MATNR]..How will i do it...?

note : I dont want to change the sequence of the fields in the table structure..

[seshatalpasai_madala]

Hi,

This is not possible for a table.

This option is not provided in SE11.

<b>But you can acheive this by CREATING A PROJECT VIEW on this table and selecting the fields as you wish and the order in which you wish.</b>

If you want to change the position of the fields in the data broswer, that is when you see the table contents this is possible.

Regards,

Sesh

[varma_narayana]

Hii..

We can Achieve this in Data browser (SE11 or SE16 or SM30).

Goto Tcode SE16.

Enter Your Table Name : VBAP

Press Enter .. Selection Screen will come.

Select the menu : Settings -> User parameters.

Select the <b>ALV List Display</b> radio button.

Now display the List.

You have a button called <b>Change Layout </b>.(Ctrl+F8).

This will open a window where you can specify the Field positions .

Save this Layout.

Note: Key field positions cannot be changed.

<b>Reward if Helpful.</b>

[Former Member]

goto vbap table .........click on contents function key in apllication toolbar ......

a selection screen will come ..in that screet ...choose setting tab........

settings......> format list.....>choose fields.......

choose fields based on u r relavence ..........

but u cannot change the positions of the fields in list ..........

u can display contents as a list or grid or se16 standards .....

[Former Member]

using the change layout u can hide the columns wat ever u want but u cannot jumble the columns and rows ...........for that u need to use col pos field in field catalog........but here u cannot change the display code of standard programn .....right........!

reward points if helpful

[Former Member]

First of all it is not possible becuase everthing related any database table it follows the fields in sorted manner ...

thatis why we have

"secondary index

to sort the fields to get into our reports .

if you want to have your table inyour sorted format then .. there is concept of

"buliding  View 's

.basically project view is best suitable for it.

so create a view with your formating and use it for display purpose ...

for your information .... in any implementation there is no Access to SE11 to the End user for them se16 is the TCODE see the data . so can create on view on you table with your fields in sorted way and give it to him ...

reward points if it is usefull .....

Girish