|Home • Trainings •Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
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.
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
Select the ‘PS Structure’ from sub
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.
Save and Activate the PS structure.
back to the initial screen of PM01.
on ‘Generate Objects’ push button. Now few message boxes appear – click on
green check box on them. Finally we reach the ‘Infotype Characteristics’
on ‘New Entries’ Button. We see the ‘Details of added entries’ Screen.
our Infotype number and short text.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards