Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Montly Sales Analysis Report ,Total by customer

Hi,

I need help on a query that a customer needs for a sales analysis report.

It should also contain:

Parameters from date X to Y and Warehouse  Z

Columns should be as follows

#Item No.Item DescriptionCustomer CodeCustomer NameCityAnnual TotalApril  (2014) - QuantityApril  (2014) - Sales AmountApril  (2014) - Gross ProfitApril  (2014) - Gross Profit %May  (2014) - QuantityMay  (2014) - Sales AmountMay  (2014) - Gross ProfitMay  (2014) - Gross Profit %June  (2014) - QuantityJune  (2014) - Sales AmountJune  (2014) - Gross ProfitJune  (2014) - Gross Profit %July  (2014) - QuantityJuly  (2014) - Sales AmountJuly  (2014) - Gross ProfitJuly  (2014) - Gross Profit %August  (2014) - QuantityAugust  (2014) - Sales AmountAugust  (2014) - Gross ProfitAugust  (2014) - Gross Profit %September  (2014) - QuantitySeptember  (2014) - Sales AmountSeptember  (2014) - Gross ProfitSeptember  (2014) - Gross Profit %

This report we can take from  sap business one sales analysis report but customer asking city column.that why

Please send me query ASAP.

Regards,

Rajeev.

Former Member
Not what you were looking for? View more on this topic or Ask a question