I_PRODUCTSTORAGELOCATION
Product Storage Location
I_PRODUCTSTORAGELOCATION is a CDS View in S/4HANA. Product Storage Location. It contains 21 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ATPRlvtProductStorLoc | view_entity | union | CONSUMPTION | Product Availability per StorLoc |
| A_ClfnProdStorLoc | view | from | COMPOSITE | Storage Location Data |
| A_ProductStorageLocation | view | from | COMPOSITE | Storage Location Data |
| C_SlsDocItemStorageLocationVH | view | from | CONSUMPTION | Storage Location |
| P_ProductStorageLocationWD | view | from | COMPOSITE |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Plant | ActivePlant,MRPArea,Plant | 3 |
| KEY | Product | ActiveProduct,Product | 1 |
| KEY | StorageLocation | ActiveStorageLocation,StorageLocation | 3 |
| CreationDate | CreationDate | 1 | |
| DateOfLastPostedCntUnRstrcdStk | DateOfLastPostedCntUnRstrcdStk | 1 | |
| FiscalMonthCurrentPeriod | FiscalMonthCurrentPeriod | 1 | |
| FiscalYearCurrentInvtryPeriod | FiscalYearCurrentInvtryPeriod | 1 | |
| FiscalYearCurrentPeriod | FiscalYearCurrentPeriod | 1 | |
| HasInvtryBlockStockPrevPeriod | HasInvtryBlockStockPrevPeriod | 1 | |
| InventoryBlockStockInd | InventoryBlockStockInd | 1 | |
| InventoryCorrectionFactor | InventoryCorrectionFactor | 1 | |
| InventoryStockPrevPeriod | InventoryStockPrevPeriod | 1 | |
| InvtryCurrentYearStockInd | InvtryCurrentYearStockInd | 1 | |
| InvtryQualInspCurrentYrStkInd | InvtryQualInspCurrentYrStkInd | 1 | |
| InvtryRestrictedUseStockInd | InvtryRestrictedUseStockInd | 1 | |
| InvtryRestStockPrevPeriodInd | InvtryRestStockPrevPeriodInd | 1 | |
| InvtryStockQltyInspPrevPeriod | InvtryStockQltyInspPrevPeriod | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| MaintenanceStatus | MaintenanceStatus | 1 | |
| PhysicalInventoryBlockInd | PhysicalInventoryBlockInd | 1 | |
| WarehouseStorageBin | WarehouseStorageBin | 1 |
// Product Storage Location (active)
@AbapCatalog.sqlViewName: 'IPRDSTORAGELOC'
@VDM:{
viewType: #BASIC,
lifecycle: {
status: #DEPRECATED,
successor: 'I_ProductStorageLocationBasic'
}
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Storage Location'
// performance related
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET
]
define view I_ProductStorageLocation
as select from nsdm_e_mard as StorageLocation
association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
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..*] to I_MaterialStock as _Stock on $projection.Product = _Stock.Material
and $projection.Plant = _Stock.Plant
and $projection.StorageLocation = _Stock.StorageLocation
//Start: enterprise search help (ESH) related associations------------------------------------------------------------------------------------
//These associations are required in I_ProductStorageLocation as N_ProductStorageLocation has these associations
//There can be no associations in N_ProductStorageLocation which are not present in I_ProductStorageLocation
association [1..1] to I_StorageLocation as _StorageLocation on $projection.Plant = _StorageLocation.Plant
and $projection.StorageLocation = _StorageLocation.StorageLocation
//End of ESH related associations-------------------------------------------------------------------------------------------------------------
{
key StorageLocation.matnr as Product,
key StorageLocation.werks as Plant,
key StorageLocation.lgort as StorageLocation,
StorageLocation.lgpbe as WarehouseStorageBin,
StorageLocation.pstat as MaintenanceStatus,
StorageLocation.lvorm as IsMarkedForDeletion,
StorageLocation.sperr as PhysicalInventoryBlockInd,
StorageLocation.ersda as CreationDate,
StorageLocation.dlinl as DateOfLastPostedCntUnRstrcdStk,
StorageLocation.bskrf as InventoryCorrectionFactor,
StorageLocation.kzile as InvtryRestrictedUseStockInd,
StorageLocation.kzill as InvtryCurrentYearStockInd,
StorageLocation.kzilq as InvtryQualInspCurrentYrStkInd,
StorageLocation.kzils as InventoryBlockStockInd,
StorageLocation.kzvle as InvtryRestStockPrevPeriodInd,
StorageLocation.kzvll as InventoryStockPrevPeriod,
StorageLocation.kzvlq as InvtryStockQltyInspPrevPeriod,
StorageLocation.kzvls as HasInvtryBlockStockPrevPeriod,
StorageLocation.lfgja as FiscalYearCurrentPeriod,
StorageLocation.lfmon as FiscalMonthCurrentPeriod,
StorageLocation.mdjin as FiscalYearCurrentInvtryPeriod,
cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity, // to enbale extensibility in Draft 2.0
// StorageLocation.labst as VltdUnrestrictedUseStkQty -- deprecated field ATC error 26.4.16
// New fields from MDG model, as part of unified API development
StorageLocation.lwmkb as LeanWrhsManagementPickingArea,
_Product,
_Stock,
//Start of ESH related associations---------------------------
_StorageLocation
//End of ESH related associations------------------------------
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"NSDM_E_MARD"
],
"ASSOCIATED":
[
"E_PRODUCTSTORAGELOCATION",
"I_MATERIALSTOCK",
"I_PRODUCT",
"I_STORAGELOCATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/