Service Name |
|
Calculation View |
|
Role |
|
The POSSalesQueryResults
service retrieves a complete set of characteristics and measures from the POS transaction log combined with 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/POSSalesQuery(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 |
Location | Attribute |
Retail Location Customer Number | Attribute |
Retail Location Description Text | Attribute |
Article | Attribute |
Article Name | Attribute |
Retail Store ID | Attribute |
Business Day Date | Attribute |
Operator ID | Attribute |
Transaction Index | Attribute |
Transaction Number | Attribute |
Begin Timestamp | Attribute |
Transaction Currency | Attribute |
Customer Number | Attribute |
Sales Unit | Attribute |
Base Unit | Attribute |
Promotion | Attribute |
Retail Promotion | Attribute |
Retail Promotion Description Text | Attribute |
Retail Promotion Type | Attribute |
Retail Promotion Type Description Text | Attribute |
International Article Number | Attribute |
Retail Item Category | Attribute |
Retail Item Subcategory | Attribute |
Material Group | Attribute |
Sales Amount | Measure |
Sales Quantity in Base Unit | Measure |
Sales Quantity in Sales Unit | Measure |
Item Discounts Amount | Measure |
Tax Included Amount | Measure |
Tax Excluded Amount | Measure |
Discounts Amount Distributed from Header | Measure |
Distributed Header Tax Amount | Measure |
Distributed Tax Included Amount | Measure |
Distributed Tax Excluded Amount | Measure |
Number Of Sales Items | Measure |
Number Of Return Items | Measure |
Number Of Discount Items | Measure |
Number Of Promotion Items | Measure |
Retail Net Sales Amount | Measure |
Retail Sales Amount | Measure |
Discount Amount | Measure |
Tax Amount | Measure |
Line Item Tax Amount | Measure |
Returns Amount | Measure |
Net Returns Amount | Measure |
Returns Quantity in Sales Unit | Measure |
Returns Quantity in Base Unit | Measure |
Returns Cost Amount | Measure |
Returns Discount Amount | Measure |
Discounted Returns Amount | Measure |
Promotion Sales Amount | Measure |
Promotion Net Sales Amount | Measure |
Promotion Quantity In Sales Unit | Measure |
Merchandise Sales Amount | Measure |
Merchandise Sales Cost Amount | Measure |
Merchandise Returns Amount | Measure |
Merchandise Discount Amount | Measure |