C_ProdStorageLocationVH

DDL: C_PRODSTORAGELOCATIONVH SQL: CPRDSTORAGELOCVH Type: view CONSUMPTION
8 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Product Storage Location Value Help View

C_ProdStorageLocationVH is a Consumption CDS View (Dimension) that provides data about "Product Storage Location Value Help View" in SAP S/4HANA. It reads from 1 data source (I_StorageLocation) and exposes 8 fields with key fields Plant, StorageLocation. It is exposed through 1 OData service (UI_RETURNSWORKORDERVIEW). It is used in 1 Fiori application: Initiate Returns - By order.

Data Sources (1)

SourceAliasJoin Type
I_StorageLocation StorageLocation from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPRDSTORAGELOCVH view
EndUserText.label Product Storage Location Value Help View view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.representativeKey StorageLocation view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RETURNSWORKORDERVIEW UI_RETURNSWORKORDERVIEW V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F4682 Initiate Returns - By order Transactional An application to initiate Returns from a remote location in Field Logistics via the Maintenance Order List View.

Initiate Returns - By order

Business Role: Warehouse Clerk (Oil & Gas)

This feature enables you as a warehouse clerk (IOG) to post the products back to remote stock, which can then be returned. This is allowed for a single reservation as well as for multiple products assigned to a particular maintenance order.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant I_StorageLocation Plant Valuation Area
KEY StorageLocation I_StorageLocation StorageLocation StorageLocation
StorageLocationName I_StorageLocation StorageLocationName Storage Loc. Name
SalesOrganization I_StorageLocation SalesOrganization Sales Organization
DistributionChannel I_StorageLocation DistributionChannel RefDistCh-Cust/Mat.
Division I_StorageLocation Division Internal Division ID
IsStorLocAuthznCheckActive I_StorageLocation IsStorLocAuthznCheckActive Authorization
_Plant _Plant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProdStorageLocationVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPRDSTORAGELOCVH

CREATE VIEW C_ProdStorageLocationVH AS
SELECT
  StorageLocation.Plant AS Plant,
  StorageLocation.StorageLocation AS StorageLocation,
  StorageLocation.StorageLocationName AS StorageLocationName,
  StorageLocation.SalesOrganization AS SalesOrganization,
  StorageLocation.DistributionChannel AS DistributionChannel,
  StorageLocation.Division AS Division,
  StorageLocation.IsStorLocAuthznCheckActive AS IsStorLocAuthznCheckActive
FROM I_StorageLocation AS StorageLocation
;

Learn More