Objective: The blog explains on how to find customers contributing to give percentage of sales efficiently using Window functions. Assume that Company ABCD is selling their products across all the regions and Sales Area leads wants to concentrate t...

Hello All,No data is extracted into BI for the datasource 0BBP_ORGUNIT_ATTR, 0BBP_PURCH_ORG_ATTR, and 0BBP_PUR_GROUP_ATTR from SRM source system.But I could able to see the data in RSA3 in source system. No selection criteria been provided during t...

Hello,I recently got an assignment to integrate SRM with BI. Can you guys please let me know the usefull trasnaction codes in SRM side to extract the data to BI. Additionally,as far as I know we can enhance the datasource as in conventioanl way using...

Hello,I came accross some a point in SAP help portal saying that "SAP Recommends not to use 2004s Queries and Query views in 3.x webtemplates."Did any one of you used 2004s queries in 3.x webtemplates.I have tested many 3.x templates with 2004s queri...