I_StorageLocation
Storage Location
I_StorageLocation is a Basic CDS View (Dimension) that provides data about "Storage Location" in SAP S/4HANA. It reads from 1 data source (t001l) and exposes 10 fields with key fields Plant, StorageLocation. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| t001l | t001l | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant |
Annotations (20)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ISTORAGELOCATION | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | Storage Location | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.representativeKey | StorageLocation | view | |
| ObjectModel.sapObjectNodeType.name | StorageLocation | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| Search.searchable | true | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (10)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Plant | werks | ||
| KEY | StorageLocation | lgort | ||
| StorageLocationName | ||||
| SalesOrganization | vkorg | |||
| DistributionChannel | vtweg | |||
| Division | spart | |||
| IsStorLocAuthznCheckActive | xblgo | |||
| HandlingUnitIsRequired | xhupf | |||
| ConfigDeprecationCode | configdeprecationcode | |||
| _Plant | _Plant |
@AbapCatalog: {
sqlViewName: 'ISTORAGELOCATION',
preserveKey: true,
compiler.compareFilter: true
}
@EndUserText.label: 'Storage Location'
@ObjectModel: {
usageType: {
sizeCategory: #S,
serviceQuality: #A,
dataClass:#CUSTOMIZING
},
representativeKey: 'StorageLocation',
sapObjectNodeType: {
name: 'StorageLocation'
},
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
}
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
authorizationCheck: #NOT_REQUIRED,
personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction.enabled: true
}
@Search.searchable: true
@Metadata: {
allowExtensions: true,
ignorePropagatedAnnotations: true
}
define view I_StorageLocation
as select from t001l
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
{
@ObjectModel.foreignKey.association: '_Plant'
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
key werks as Plant,
@ObjectModel.text.element: 'StorageLocationName'
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
key lgort as StorageLocation,
@Semantics.text: true
cast(lgobe as lgort_name) as StorageLocationName,
vkorg as SalesOrganization,
vtweg as DistributionChannel,
spart as Division,
xblgo as IsStorLocAuthznCheckActive,
xhupf as HandlingUnitIsRequired,
configdeprecationcode as ConfigDeprecationCode,
_Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001L"
],
"ASSOCIATED":
[
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA