Show TOC

 Inventory Visibility

Technical Information

Service Name

InventoryVisibilityQueryResults

Calculation View

sap.hba.t.rtl.car.int.v:: InventoryVisibilityQuery

Role

sap.hba.t.rtl.car.int.roles::InventoryVisibility

 

The InventoryVisibilityQueryResults service retrieves information from the following sources:

  • Inventory information from SAP ERP

  • Current material stock based on information calculated from SAP for Retail and SAP Customer Activity Repository (SAP POS Data Transfer and Audit)

Input Parameters

This service requires the following input parameters:

  • P_SAPClient: A three-character SAP client identifier.

Example URL for calling the service

http://<domain-name>:<port-number>/sap/hba/t/rtl/car/int/odata/CARServices.xsodata/InventoryVisibilityQuery(P_SAPClient='<client-number>')/Results?$format=json&$filter=Article eq '<article-number>' and Location eq '<location-number>'

Result

This service returns the following information:

Column

Property Type

SAP Client

Attribute

Location

Attribute

Plant Name

Attribute

Plant Customer Number

Attribute

Street Name

Attribute

City Name

Attribute

Postal Code

Attribute

Region

Attribute

Country

Attribute

Material Base Unit

Attribute

Unit Of Measure Commercial Name

Attribute

Unit Of Measure Long Name

Attribute

Article

Attribute

Article Name

Attribute

Unrestricted Use Stock Quantity

Measure

In-Transit Stock Quantity

Measure

In-Transfer Stock Quantity

Measure

Total Valuated Stock Quantity

Measure

Total Valuated at Cost Stock Value

Measure

Total Valuated at Retail Stock Value

Measure

Article Safety Stock Quantity

Measure

Article Maximum Stock Level Quantity

Measure

Article Minimum Safety Stock Quantity

Measure

Cost per Stock Unit

Measure

Sales Value per Stock Unit

Measure

Current Stock

Measure

Unprocessed Sales Quantity

Measure