Service Name |
|
Calculation View |
|
Role |
|
The MultiChannelSalesQueryResults
service retrieves data from the following sources:
The POS transaction log
Sales data from SAP ERP
Master data from SAP ERP
This service requires the following input parameters:
P_SAPClient: A three-character SAP client identifier.
http://<domain-name>:<port-number>/sap/hba/t/rtl/car/int/odata/CARServices.xsodata/MultiChannelSalesQuery(P_SAPClient='<client-number>')/Results?$format=json&$select=Article,NetSalesAmount&$filter=Article eq '<article-number>'
This service returns the following information:
Column | Property Type |
---|---|
SAP Client | Attribute |
Order Channel | Attribute |
Order Channel Name | Attribute |
Base Unit | Attribute |
Unit Of Measure Commercial Name | Attribute |
Unit Of Measure Long Name | Attribute |
Sales Unit | Attribute |
Unit Of Measure Commercial Name | Attribute |
Unit Of Measure Long Name | Attribute |
Location | Attribute |
Retail Location Customer Number | Attribute |
Retail Location Description Text | Attribute |
Article | Attribute |
Article Name | Attribute |
Material Group | Attribute |
Material Category | Attribute |
Division | Attribute |
Billing Document | Attribute |
POS Transaction Number | Attribute |
Billing Document Date | Attribute |
European Article Number | Attribute |
Document Currency | Attribute |
Sales Quantity in Sales Unit | Measure |
Sales Quantity in Base Unit | Measure |
Number of Sales Items | Measure |
Number of Return Items | Measure |
Retail Sales Amount | Measure |
Retail Net Sales Amount | Measure |
Returns Amount | Measure |
Net Returns Amount | Measure |
Returns Quantity in Sales Unit | Measure |
Returns Quantity in Base Unit | Measure |
Promotion Sales Amount | Measure |
Promotion Net Sales Amount | Measure |
Promotion Quantity in Sales Unit | Measure |
Number of Promotion Items | Measure |
Tax Amount | Measure |
Merchandise Sales Amount | Measure |
Merchandise Discount Amount | Measure |
Merchandise Returns Amount | Measure |
Discount Amount | Measure |
Discount Returns Amount | Measure |
Normal Sales Amount | Measure |
Number of Transactions | Measure |
POS Cost Amount | Measure |
POS Returns Cost Amount | Measure |
POS Merchandise Sales Cost Amount | Measure |
Billing Document Cost Amount | Measure |
Billing Document Returns Cost Amount | Measure |
Billing Document Merchandise Cost Amount | Measure |