get_sales_analysis
Analyze sales performance by customer, item, brand, or salesperson, with filtering by document type and date range. Get insights from SAP HANA to support business decisions.
Instructions
Query SAP HANA Sales Analysis via sml.svc — group by customer, item, salesperson, brand (CogsOcrCod), sub-brand (CogsOcrCo2), universe (CogsOcrCo4), warehouse, period etc. Supports filtering by doc type (invoice/order/delivery). Use groupBy='CogsOcrCod' for brand-wise analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| topN | No | ||
| toDate | No | YYYY-MM-DD | |
| docType | No | Filter by document type: 'order' (Sales Orders), 'invoice' (AR Invoices), 'delivery' (Deliveries), 'credit_memo', 'return'. Omit for all types combined. | |
| groupBy | No | Comma-separated field names. Brand: CogsOcrCod, SubBrand: CogsOcrCo2, Budget: CogsOcrCo3, Universe: CogsOcrCo4, Customer: BusinessPartnerCode,BusinessPartnerName, Item: ItemCode,ItemDescription | |
| orderBy | No | e.g. NetSalesAmountLC desc | |
| cardCode | No | ||
| fromDate | No | YYYY-MM-DD | |
| itemCode | No |