I_ProductStorageLocationWD
Product BO Storage Location Node (draft)
I_ProductStorageLocationWD is a Transactional CDS View that provides data about "Product BO Storage Location Node (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProductStorageLocationBasic) and exposes 23 fields with key fields Product, Plant, StorageLocation. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ProductStorageLocationBasic | StorageLocation | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_Productstoragelocation | _ActiveExtension | $projection.Product = _ActiveExtension.Product and $projection.Plant = _ActiveExtension.Plant and $projection.StorageLocation = _ActiveExtension.StorageLocation |
| [0..1] | E_Productstoragelocation | _DraftExtension | $projection.Product = _DraftExtension.Product and $projection.Plant = _DraftExtension.Plant and $projection.StorageLocation = _DraftExtension.StorageLocation |
| [1..1] | I_ProductWD | _Product | $projection.Product = _Product.Product |
| [1..1] | I_ProductPlantWD | _Plant | $projection.Product = _Plant.Product and $projection.Plant = _Plant.Plant |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPRDSTORAGELOCWD | view | |
| EndUserText.label | Product BO Storage Location Node (draft) | view | |
| Search.searchable | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.writeDraftPersistence | PROD_PLNT_SLSTOR | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Product | I_ProductStorageLocationBasic | Product | |
| KEY | Plant | I_ProductStorageLocationBasic | Plant | |
| KEY | StorageLocation | I_ProductStorageLocationBasic | StorageLocation | |
| PlantForEdit | I_ProductStorageLocationBasic | Plant | ||
| StorageLocationForEdit | I_ProductStorageLocationBasic | StorageLocation | ||
| WarehouseStorageBin | I_ProductStorageLocationBasic | WarehouseStorageBin | ||
| MaintenanceStatus | I_ProductStorageLocationBasic | MaintenanceStatus | ||
| IsMarkedForDeletion | I_ProductStorageLocationBasic | IsMarkedForDeletion | ||
| PhysicalInventoryBlockInd | I_ProductStorageLocationBasic | PhysicalInventoryBlockInd | ||
| CreationDate | I_ProductStorageLocationBasic | CreationDate | ||
| DateOfLastPostedCntUnRstrcdStk | I_ProductStorageLocationBasic | DateOfLastPostedCntUnRstrcdStk | ||
| InventoryCorrectionFactor | I_ProductStorageLocationBasic | InventoryCorrectionFactor | ||
| InvtryRestrictedUseStockInd | I_ProductStorageLocationBasic | InvtryRestrictedUseStockInd | ||
| InvtryCurrentYearStockInd | I_ProductStorageLocationBasic | InvtryCurrentYearStockInd | ||
| InvtryQualInspCurrentYrStkInd | I_ProductStorageLocationBasic | InvtryQualInspCurrentYrStkInd | ||
| InventoryBlockStockInd | I_ProductStorageLocationBasic | InventoryBlockStockInd | ||
| InvtryRestStockPrevPeriodInd | I_ProductStorageLocationBasic | InvtryRestStockPrevPeriodInd | ||
| InventoryStockPrevPeriod | I_ProductStorageLocationBasic | InventoryStockPrevPeriod | ||
| InvtryStockQltyInspPrevPeriod | I_ProductStorageLocationBasic | InvtryStockQltyInspPrevPeriod | ||
| HasInvtryBlockStockPrevPeriod | I_ProductStorageLocationBasic | HasInvtryBlockStockPrevPeriod | ||
| FiscalYearCurrentInvtryPeriod | I_ProductStorageLocationBasic | FiscalYearCurrentInvtryPeriod | ||
| _Product | _Product | |||
| _Plant | _Plant |
@AbapCatalog.sqlViewName: 'IPRDSTORAGELOCWD'
@EndUserText.label: 'Product BO Storage Location Node (draft)'
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
writeDraftPersistence: 'PROD_PLNT_SLSTOR',
semanticKey: [ 'Product','Product','StorageLocation' ],
createEnabled : true,
deleteEnabled : true,
updateEnabled : true,
usageType.serviceQuality: #A,
usageType.sizeCategory : #XL,
usageType.dataClass: #TRANSACTIONAL
}
define view I_ProductStorageLocationWD
as select from I_ProductStorageLocationBasic as StorageLocation
association [0..1] to E_Productstoragelocation as _ActiveExtension on $projection.Product = _ActiveExtension.Product
and $projection.Plant = _ActiveExtension.Plant
and $projection.StorageLocation = _ActiveExtension.StorageLocation
association [0..1] to E_Productstoragelocation as _DraftExtension on $projection.Product = _DraftExtension.Product
and $projection.Plant = _DraftExtension.Plant
and $projection.StorageLocation = _DraftExtension.StorageLocation
// association[0..1] to E_Productstoragelocationd as _DraftExtension on $projection.DraftKey = _DraftExtension.DraftKey
association [1..1] to I_ProductWD as _Product on $projection.Product = _Product.Product
association [1..1] to I_ProductPlantWD as _Plant on $projection.Product = _Plant.Product
and $projection.Plant = _Plant.Plant
{
@ObjectModel.readOnly:true
key StorageLocation.Product,
@ObjectModel.readOnly:true
key StorageLocation.Plant,
@ObjectModel.readOnly:true
key StorageLocation.StorageLocation,
StorageLocation.Plant as PlantForEdit,
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.StorageLocation as StorageLocationForEdit,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.WarehouseStorageBin,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.MaintenanceStatus,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.IsMarkedForDeletion,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.PhysicalInventoryBlockInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.CreationDate,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.DateOfLastPostedCntUnRstrcdStk,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InventoryCorrectionFactor,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InvtryRestrictedUseStockInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InvtryCurrentYearStockInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InvtryQualInspCurrentYrStkInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InventoryBlockStockInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InvtryRestStockPrevPeriodInd,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InventoryStockPrevPeriod,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.InvtryStockQltyInspPrevPeriod,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.HasInvtryBlockStockPrevPeriod,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION' "PSTAT Delete
// StorageLocation.FiscalYearCurrentPeriod,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION' "PSTAT Delete
// StorageLocation.FiscalMonthCurrentPeriod,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
StorageLocation.FiscalYearCurrentInvtryPeriod,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT]
_Product,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTSTORAGELOCATIONBASIC"
],
"ASSOCIATED":
[
"E_PRODUCTSTORAGELOCATION",
"I_PRODUCTPLANTWD",
"I_PRODUCTWD"
],
"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