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.
Key Concept
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.

D. Russell Sloan

D. Russell Sloan is a specialist in project and program governance for IBM. He focuses on the use of SAP Solution Manager for global rollout projects for IBM’s largest customers, having worked with SAP software since 1996. Russell has degrees in accounting and information systems and has been a team and project leader for SAP projects for more than 14 years. He has been developing and deploying software systems for over 30 years.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.