Adding custom fields for retail product comparisons in SAP BW

Need to analyze and compare product sales, product cost and suggested retail price etc? This tip shows you how to customize the R/3 BW datasource/extractor to get elementary fields such as AFS color and size into BW.

Retail companies may have a requirement to analyze and compare product sales, product cost and suggested retail

price etc. SAP BW AFS delivered extractor doesn't support this requirement. In AFS industry, product/sku can be a combination of material, color and/or size.

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.


This was first published in June 2008

Dig deeper on SAP business warehouse

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close