C_ProcmtHubStorageLocationVH

DDL: C_PROCMTHUBSTORAGELOCATIONVH SQL: CPROCHUBSLOCVH Type: view CONSUMPTION
4 Fields 1 Data Sources

C-View for Storage Location Value Help in Central Contracts

C_ProcmtHubStorageLocationVH is a Consumption CDS View that provides data about "C-View for Storage Location Value Help in Central Contracts" in SAP S/4HANA. It reads from 1 data source (I_StorageLocation) and exposes 4 fields with key fields Plant, StorageLocation, ProcurementHubSourceSystem.

Data Sources (1)

SourceAliasJoin Type
I_StorageLocation I_StorageLocation from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPROCHUBSLOCVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
EndUserText.label C-View for Storage Location Value Help in Central Contracts view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY ProcurementHubSourceSystem
StorageLocationName StorageLocationName Storage Loc. Name

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_ProcmtHubStorageLocationVH.
-- 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: CPROCHUBSLOCVH

CREATE VIEW C_ProcmtHubStorageLocationVH AS
SELECT
  Plant,
  StorageLocation,
  cast(' ' as mmpur_d_source_sys ) AS ProcurementHubSourceSystem,
  StorageLocationName
FROM I_StorageLocation
;

Learn More