I_PRODUCTSTORAGELOCATIONBASIC

CDS View

Product Storage Location

I_PRODUCTSTORAGELOCATIONBASIC is a CDS View in S/4HANA. Product Storage Location. It contains 19 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 19 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_ConfGoodsMvtMaterialVH view_entity from COMPOSITE Value Help CDS view for Goods Movement
I_ProductStorageLocationWD view from TRANSACTIONAL Product BO Storage Location Node (draft)
P_MltplMatlStk_L1_WOS_SLOC view_entity from COMPOSITE
P_Productstoragelocationref view from BASIC
P_ProductStorLocByInvStockType view_entity from COMPOSITE
P_ProductStorLocByInvStockType view_entity union COMPOSITE
P_WarehouseStorageBin view from COMPOSITE
R_ProdPlantStorageLocationTP view_entity from TRANSACTIONAL Product Plant Storage Location - TP

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Plant Plant,PlantForEdit 4
KEY Product Material,Product 4
KEY StorageLocation StorageLocation,StorageLocationForEdit 4
CreationDate CreationDate 1
DateOfLastPostedCntUnRstrcdStk DateOfLastPostedCntUnRstrcdStk 1
FiscalYearCurrentInvtryPeriod FiscalYearCurrentInvtryPeriod 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 
@AbapCatalog:{
    sqlViewName: 'IPRDSTORLOCBASIC',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Product Storage Location'
@Metadata.ignorePropagatedAnnotations:true
@Metadata.allowExtensions:true
@ObjectModel:{
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #XL,
    usageType.dataClass: #MASTER,
    representativeKey: 'Product'
}
@VDM.viewType: #BASIC

@Analytics:{
   dataCategory: #DIMENSION,
   dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
    },
    internalName: #LOCAL
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #EXTRACTION_DATA_SOURCE
]
// Scope of this view is V_MARD_MD no aggreated fields should be added to this view.


define view I_ProductStorageLocationBasic
  as select from P_ProductStorageLocationBasic as StorageLocation

  association [1..1] to I_Product                as _Product         on  $projection.Product = _Product.Product
  association [0..1] to E_Productstoragelocation as _ProdStorLocExt  on  $projection.Product         = _ProdStorLocExt.Product
                                                                     and $projection.Plant           = _ProdStorLocExt.Plant
                                                                     and $projection.StorageLocation = _ProdStorLocExt.StorageLocation
  association [0..*] to I_MaterialStock          as _Stock           on  $projection.Product         = _Stock.Material
                                                                     and $projection.Plant           = _Stock.Plant
                                                                     and $projection.StorageLocation = _Stock.StorageLocation
  association [1..1] to I_Plant                  as _Plant           on  $projection.Plant = _Plant.Plant
  //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 Product,
      @ObjectModel.foreignKey.association: '_Plant'
  key Plant,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      @ObjectModel.sapObjectNodeTypeReference:'StorageLocation'
  key StorageLocation,
      WarehouseStorageBin,
      MaintenanceStatus,
      IsMarkedForDeletion,
      PhysicalInventoryBlockInd,
      CreationDate,
      DateOfLastPostedCntUnRstrcdStk,
      InventoryCorrectionFactor,
      InvtryRestrictedUseStockInd,
      InvtryCurrentYearStockInd,
      InvtryQualInspCurrentYrStkInd,
      InventoryBlockStockInd,
      InvtryRestStockPrevPeriodInd,
      InventoryStockPrevPeriod,
      InvtryStockQltyInspPrevPeriod,
      HasInvtryBlockStockPrevPeriod,
      FiscalYearCurrentInvtryPeriod,
      LeanWrhsManagementPickingArea,
      cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,

      _Product,
      _Stock,
      _Plant,
      _StorageLocation //ESH related associations


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PRODUCTSTORAGELOCATIONBASIC"
],
"ASSOCIATED":
[
"E_PRODUCTSTORAGELOCATION",
"I_MATERIALSTOCK",
"I_PLANT",
"I_PRODUCT",
"I_STORAGELOCATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More