Infotypes with buttons and huge data fields stored in cluster tables

By Ribhu Ahuja, Tata Consultancy Services

Creating the infotype and putting active button in the same

Some infotype and cluster table properties 

Generally the infotype would contain some 10 - 15 fields with each field having a length of say 10 - 15 characters.  But sometimes the requirement may arise to store huge amount of data of an employee. Imagine we want to create an infotype - exit interviews with say around 20 - 25 fields and we want to store remarks for say 10 15 of these fields, which would be of roughly 500 characters each. Just to let you know, if we create a custom infotype for the same, we must be aware that SAP gives a total space of 2000 characters for all fields in an infotype. In other words, we can't increase the fields in an infotype if the sum of length of all fields in the infotype increases 2000 characters. Now what??? Nothing to worry about. We can create a button in the infotype and then call a sub screen on the click of that button. In this sub screen, we can type as much as we want and on the green tick mark below, we can code to write this data in cluster table PCL3, simultaneously creating a unique 40 character key comprising of personal number, system date, system time and a 2 character key which would work as a switch when data is written. This key is used to insert and retrieve data while creating and displaying the data respectively.

Creating the infotype

Go to transaction PM01. We can create a custom infotype through the transaction PM01. The number range for custom infotypes starts from 9001 to 9999. SAP has reserved infotypes numbers from 0000 to 9000 for its standard infotypes.

For creating an infotype say Exit Interview, go to transaction PM01 and type any infotype number from 9001 to 9999.

Select the ‘Employee Infotype’ radio button.

Select the ‘PS Structure’ from sub objects box.

Click on the edit button below… A separate table maintenance window appears.

Create a PS structure with all the fields we want on the Infotype. Whatever fields we will put in this PS structure will come in the infotype as input fields.

Notice that the first field ZTYPEOFEXIT is type of Exit - whether resignation or retirement and would be an LOV in our infotype. For this, domain and data element have to be created.

Double click on Component type ZTYPEOFEXIT, it gives a warning, Click yes.

   

Choose Data element  

Give short description and domain name, which we are about to create as ZTYPEOFEXIT

Double click on this domain ZTYPEOFEXIT and choose Yes when it prompts us to create the domain.

Give short description and data type as CHAR 1 as shown.  

Choose the value ranges tab and give the keys and values as shown. We will see these values in the infotype, while creating a record and displaying and in Keys values (1 or 2) would be actually getting stored in the database table of the infotype.  

Save and activate the domain and the data element and go back. We are now in the PS Structure of the infotype.

It is to be noted that we have to put all the fields which we want to make input enabled in the PS structure.  Now we have to give the enhancement type of the PS Structure.

Choose Can be Enhanced – radio button and click on copy.

Now Save and Activate the PS structure.

Go back to the initial screen of PM01.

Click on ‘Generate Objects’ push button. Now few message boxes appear – click on green check box on them. Finally we reach the ‘Infotype Characteristics’ screen. 

Click on ‘New Entries’ Button. We see the ‘Details of added entries’ Screen.  

Enter our Infotype number and short text.

Here we have to set different Infotype Characteristics as per the requirement. (Better open another session with some standard Infotype’s infotype characteristics screen and use as the reference to fill ours).

Click here to continue....

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image