Skip to Content
Author's profile photo Former Member

Table Control Settings for Hiding or Changing Column Positions.

Sometimes it’s a user requirement to personalize the settings like hide, change the sequence and width of columns in some transaction or creation of their own variants. The same we can do it via Table Control Settings which is the standard functionality in SAP, shows like a multicolored icon and appears at the upper right most corner of the transaction. Mostly users want to hide Cost Price in Invoice overview (VF01) and Net Price in Sale Order (VA01) so for that this is the best option.

ADVANTAGES:


  • Making the columns invisible.
  • Changing the position/width of any column.
  • Adjusting the fixed number of columns.


Users with authorization object ‘S_ADMI_FCD‘ and ‘TCTR‘ activity are only authorized to create the layout for Table Control as a standard setting which will be considered as global settings for all users. For the configuration please pursue with the following steps:

1.  After opening the desired transaction, click the Table Control icon untitled.JPG you will get the dialog box for Table Settings, under Maintain Variants give some variant name and click on Administrator.

222.JPG

2.  Here suppose my requirement is to hide the ‘Net Price’ Field in VA01 so i’ll simply check the invisible box for that specific field. This screen displays the technical field name along with its position and length.

dfdfsdfsdfsdf.JPG

3.  Click on ‘Activate and you are done. If you choose close without activation, settings remain unchanged. After this, layout will be set as default one every time the users hits that particular transaction with newly defined settings.

final.JPG

You can also try other attributes as mentioned above under advantages for Table Control configuration and the same includes:


  • Make invisible extra columns.
  • Hide or display the gridlines.
  • Configuring the number of fixed columns.


Regards,

Ammarah.

Assigned tags

      33 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Thanks Ammarah for sharing this very short but nice and useful document. Good work.

      Author's profile photo G Lakshmipathi
      G Lakshmipathi

      Good one.  Also this is similar to Mozzam Ali's suggestion given in this thread

      Hiding Cost in billing Overview Screen

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Dear Sir,

      Thank you for the comments, I've done the same for Sale Order. Actually the thought was to start from a basic document that's why shared on SCN.

      Author's profile photo Prasun Jha
      Prasun Jha

      Hi Ammarah.

      What should I do to move the new layout to production (as Administrator button is not available in production) and I need to display some new columns in production. Please reply, urgent!!!

       

      Thanks,

      Prasun

      Author's profile photo Joseph BERTHE
      Joseph BERTHE

      Hello,

      Thanks for this nice post.

      However, I wasn't able to hide any column, should I do something specific ?

      Currently, I have created a role with the authorization object S_ADMI_FCD with all fields (even TCTR).

      I have no idear why it doesn't work.

      Kind regards,

      Joseph

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi

      This object is used to remove authorization of users to modify the table control variant. The settings will be done in table control variant and Ammarah has explained it very well. It should work,

      Author's profile photo Joseph BERTHE
      Joseph BERTHE

      Thanks for your reply, in fact it works without variant name :

      • Administration -> Hide columne -> Activate -> close -> save

      but I found out something,  in some cases, some tables are not customizable. But I didn't find out why it's happen like this.

      In my case the table in PR05->Create Trip->Cost allocation table doesn't work properly. If someone can tell me why ?`! 🙂

      Kind Regards,

      Joseph

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Josep,

      In some overview screes hiding of fields cant be controlled by Table Control Administration functionality. Here, you can go for some cuztomization via screen variants. Thanks.

      Author's profile photo Former Member
      Former Member

      Thanks Ammarah for this useful info. , i used this table control settings with my client and he was so pleased as i summarized the columns he would search to enter the data quickly

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Pleasure Moshira 🙂

      Author's profile photo Srinu S
      Srinu S

      Hi Ammarah,

      This is very helpful document. Thanks for sharing. Keep posting this kind of valuable document.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you dear.

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Helpful Document Ammarah

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      I am working on sap from long time ....but we are missing so many useful options ....thanks for sharing * Ammarah *

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      It feels great to know that the document which i was reluctant to share on SCN by thinking that it's quiet common is appreciable by many of you people. Don't have enough words to express the gratitude for the same. Rgds.

      Author's profile photo Rajneesh Saxena
      Rajneesh Saxena

      Dear Ammarah

      Sometimes we feel that our knowledge is very little to share but this is not the fact always. I have observed that usually small tricks and techniques are left (unknowingly overlooked) by very senior consultants also. Secondly not all of us have gone to all the areas of SAP even in our own modules so there are very good chances of ignorance for many of the functionalities available in standard SAP.

      So, I request you to keep sharing good contents like this. I liked it.

      Regards

      Rajneesh Saxena

      ' MoazzaM ' Dear sorry, till now I could not read your doc but for sure I am going to read it.

      Author's profile photo Anandkumar KS
      Anandkumar KS

      Hi * Ammarah *

      Such a nice document but am late, thank you for sharing this to every one.

      Anand Kumar KS

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Good Day K S Anand Kumar,

      Thank you for reading the same.

      Author's profile photo Suhaib Bin Aziz
      Suhaib Bin Aziz

      Good Document * Ammarah * (Away) to personalize the settings changing, hiding the sequence and width of columns in some transaction. Thanks for sharing 😉

      BR,

      Suhaib

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks dear and i think you rarely visit SAP ERP SD Sales community as this was the 1st document which i've posted on SCN. 🙂

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi ammarah,

      Its nice Document and have Followed the same Procedure but not Able to make Effective for all the Users.

      i had created a Variant but the same variant not Effected with all users Except my User.

      Plz guide me

      Regards

      Siva

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Have you activated and generated the same? Please be noted that system wide settings should appear in the 'Basic Settings' option for all the users only then it will effect the overview screen of every user every time the desired transaction will run. Do lemme know if you need any further help in this. Thanks.

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi Ammarah,

      Thank you for the reply

      my requirement is to Drag and drop few columns to various positions so that Users can View the Columns directly when opening the Order,

      Does the Variant generated Apply for the Drag and Drop procedure.

      Regards

      Siva

      Author's profile photo NR NR
      NR NR

      Hello Ammarah

      i just want to add two columns at item detail tab in service PR (start time and End time), however i am not able to change it to visible, i have all the authorizations you have mentioned,

      Can you help me please...

      Thanks

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi,

      This is a Good document,i think with same procedure we can also change the position of the columns in the Transaction by Drag and Drop Method

      Author's profile photo Drashti Amrutia
      Drashti Amrutia

      Hi Ammarah,

      I have a bit different requirement.

      I have created a customized variant as I have administrator rights,which is working perfectly as per requirement.

      As of now all endusers have basic settings ,among them only 3 needs this newly created variant but this is variant is not visible to add into their standard settings, how  do I that ? As endusers have no administrator rights.

      What could be solution in this scenario ?

      Manythanks

      Drashti

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi

      I think you have to give administrative rights to those users, assign variant and then remove the administrative rights. I am not sure but I think we did similar thing in past.

      Thank$

      Author's profile photo Drashti Amrutia
      Drashti Amrutia

      Hi Moazzam,

      I tried with the same thing ,it worked at the moment fingers crossed.

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi

      Congratulations then 🙂

      Thank$

      Author's profile photo Pradeep Mani
      Pradeep Mani

      Sometimes it surprises me, why there is a box at right corner .

      This one opened my vision in this area...Keep sharing..Thank you

      Author's profile photo Former Member
      Former Member

      Does anybody how to apply this variant to a specific group of users. I have generated that variant but I don't see how to apply it trought SHD0 ?

      Regards

      Author's profile photo Anubhav Parashar
      Anubhav Parashar

      can we add new field which is not available in table list