Create Custom Tables and Fields for Attributes
- by D. Russell Sloan, Implementation and Governance Specialist — SAP Solution Manager, IBM Global Business Services
- October 19, 2011
Enhance your custom document attributes by creating your own custom Data Dictionary objects. With custom document attributes, you can control entry values, provide search lists, and link to other data in the system. Custom Data Dictionary objects give you more flexibility in defining your custom document attributes.
The real power of the custom table and field setup comes in the definition of the domain. The domain controls the data type, the length, and the data entry rules for the custom attribute. Becoming proficient in the use of domains extends your ability to create robust custom attributes for your solution documentation.
Sometimes, your project requirements for custom attributes include the need to control input to a specific list of values or to an input help. For example, the project may be deployed in waves or phases, and you’d like to have the wave or phase be a required attribute on your documents. Furthermore, you may wish to control the values that are available for the attribute so you can ensure consistency of entry. For this, you need to create your own custom data table and fields — Data Dictionary objects — for use with your attributes.
Remember, the Data Dictionary elements are used to describe the type of data and the behavior for input of the attributes. They are not the location in which the attribute data is physically stored in the database. To build these custom Data Dictionary elements, you need to request a developer key from your technical team. You also need developer access rights in your SAP Solution Manager system. Make sure you follow all your project standards for creating custom Data Dictionary objects.
For more information about custom document attributes, see my SAPexperts article, “Improve SAP Solution Manager Reporting Capabilities by Using Your Own Custom Document Attributes.” You should read that article before proceeding with this one.
Now I’ll show you how to create custom Data Dictionary objects. I’ll start by creating a document attribute, and then explain how to create an example table ZDOCTABLE and some associated fields.
Would you like to see this full item?