Adding custom fields for retail product comparisons in SAP BW

I have listed below the steps and screens shots to customize R/3 BW datasource/extractor to get elementary fields such as AFS color and size into BW.

1. Activate R/3 datasource "2LIS_13_VDKON" using transaction code RSA5. Select datasource "2LIS_13_VDKON" and click "Activate DataSources" in attached screen shot# 1.

   Screen Shot #1
   

2. Enhance R/3 datasource "2LIS_13_VDKON" using transaction code "LBWE". Click "Maintenance" for datasource "2LIS_13_VDKON" in attached screen shot#2.

   Screen Shot #2
   

   Add following fields from communication pool (right) to selection criteria (left) as per attached screen shot# 3:

   • J_3ABWEL_COLOR
   • J_3ABWEL_COUNTRY
   • J_3ABWEL_QUAL_R
   • J_3ABWEL_SIZE
   • J_3ABWEL_QUAL
   • AFS/COLLECTION
   • J_3ASEAN
   • /AFS/THEME
   • J_3ASIZE

   Screen Shot #3
   

3. In same transaction code "LBWE" click on data source "2LIS_13_VDKON" as per attached screen shot # 4, create transport when prompted and then click Generate. The next step is to click "Inactive" next to data source "2LIS_13_VDKON" in attached screen shot # 4 and then flag will turn to "Active".

   Screen Shot #4
   

4. This datasource "2LIS_13_VDKON" can now be replicated in BW using transaction code "RSA1" under source systems.

5. Install BW delivered business content for billing conditions data such as info source, ODS, update rules as listed in attached screen shot# 5. Custom info cube can be created for billing conditions data to analyze product sale, product cost and product suggested retail price. Update rules can be crated using info source "2LIS_13_VDKON".

   Screen Shot #5
   

6. Enhanced the info source "2LIS_13_VDKON" by adding followings AFS fields in communication structure, transfer structure and map them in transfer rules as per attached screen shot# 6 from BW 3.5:
   • 0AF_COLOR
   • 0AF_COUN
   • 0AF_RQUAL
   • 0AF_SIZE
   • 0AF_SQUAL
   • 0AF_COLL
   • 0AF_SEAN
   • 0AF_THEME
   • 0AF_GRDVAL

   Screen Shot #6
   

   R/3 field "KSCHL" can be mapped to condition type info object "0KNART" in BW. R/3 field "KWERT" may be mapped to condition value info obejct "0KNVAL".

7. Enhance the update rules for ODs and info cube to map newly added AFS fields as per attached screen shot #7.

   Screen Shot #7
   

8. Condition types can be used to determine the product sales, cost, product suggested retail price and any other charges or discounts. BW queries can be created on custom info cube for any detail analysis on product/sku (material, color and size), color or size.

Rate this Tip To rate tips, you must be a member of SearchSAP.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT SAP business intelligence tips Choosing an SAP BI/BW database for InfoCube data Using Infoset to join, move DSO analysis to InfoCube Selecting InfoCubes in SAP BI/BW Business Content How to limit employee access to reports using roles in SAP NetWeaver SAP BI extractors vs. Business Objects for ETL process Top 10 SAP tips of 2007 Retrieve BI data with Web Services Adding special characters in SAP BI Currency translation using SAP BI How to acquire the runtime information of a data transfer process (DTP) SAP tips and best practices Minimizing business disruptions during an SAP upgrade or implementation Retrieving content from an SAP workflow attachment Updating URLs in SAP SRM How to change default settings in SAP SRM What are the benefits of implementing SAP SRM? Increase column width in a transaction screen Updating an RT table entry in SAP HR Payroll -- without the ADDWTE option Is this the quickest way to find a BADI? Improving performance with ABAP Objects in SAP Workflow Top 10 SAP tips of 2007 RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.