Two Ways to Use Custom Fields in Reports

  • by Ned Falk, Senior Education Consultant, SAP
  • November 15, 2007
To report on custom attribute fields in business partner master data, you need to extract them from SAP CRM into SAP NetWeaver BI. Get an overview of this process and find out what information you need to share with your BI team for a successful extraction. Then see what your reporting options are so that you can determine the best option for your data.
Key Concept

An SAP system stores marketing attributes in SAP CRM via tables that were originally the R/3 classification system. During the extraction phase, SAP NetWeaver BI DataSources read these tables using standard extractor programs.

In recent articles, I showed you three ways to add custom fields to business partner master data. To use these fields in reporting, you need to extract them to SAP NetWeaver BI. The most challenging type of field to extract involves business partner marketing attributes. SAP NetWeaver BI has a hard time storing this information, especially on the BI business partner master table. BI master data is set up to handle only a single value in a unique business partner’s attribute at any one moment.

I’ll explain how to store marketing attributes in SAP NetWeaver BI for both single-value (Joe likes tennis) and multi-value (Joe likes tennis and golf) attributes. The target audience for this article is both CRM functional and BI technical team members. These two teams need to work together to implement the processes described.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

See more by this author


Comments

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.