C_MSPWStorageLocation

DDL: C_MSPWSTORAGELOCATION SQL: CMSPWSTORLOC Type: view CONSUMPTION
3 Fields 1 Data Sources

C_MSPWStorageLocation is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_StorageLocation) and exposes 3 fields with key fields Store, StorageLocation.

Data Sources (1)

SourceAliasJoin Type
I_StorageLocation I_StorageLocation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMSPWSTORLOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Store Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
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_MSPWStorageLocation.
-- 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: CMSPWSTORLOC

CREATE VIEW C_MSPWStorageLocation AS
SELECT
  Plant AS Store,
  StorageLocation,
  StorageLocationName
FROM I_StorageLocation
;

Learn More