P_ProductStorageLocationBasic

DDL: P_PRODUCTSTORAGELOCATIONBASIC Type: view BASIC

P_ProductStorageLocationBasic is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mard) and exposes 25 fields with key fields Product, Plant, StorageLocation. It has 1 association to related views.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
mard StorageLocation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRDSTORLOCBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY Plant mard werks
KEY StorageLocation mard lgort
MaintenanceStatus mard pstat
IsMarkedForDeletion mard lvorm
PhysicalInventoryBlockInd mard sperr
InvtryCurrentYearStockInd mard kzill
InvtryQualInspCurrentYrStkInd mard kzilq
InvtryRestrictedUseStockInd mard kzile
InventoryBlockStockInd mard kzils
InventoryStockPrevPeriod mard kzvll
InvtryStockQltyInspPrevPeriod mard kzvlq
InvtryRestStockPrevPeriodInd mard kzvle
HasInvtryBlockStockPrevPeriod mard kzvls
StorLocMRP mard diskz
StorLocSpecialProcurementType mard lsobs
StorLocMRPReplnmtQtyInBaseUoM mard lbstf
CountryOfOrigin mard herkl
WarehouseStorageBin mard lgpbe
DateOfLastPostedCntUnRstrcdStk mard dlinl
CreationDate mard ersda
LeanWrhsManagementPickingArea mard lwmkb
InventoryCorrectionFactor mard bskrf
FiscalYearCurrentInvtryPeriod mard mdjin
_Product _Product 
@AbapCatalog:{
    sqlViewName: 'PPRDSTORLOCBASIC',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:{
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #XL,
    usageType.dataClass: #MASTER
}
@VDM.viewType: #BASIC
@VDM.private: true

// Scope of this view is V_MBEW_MD no fields from redirect views should be added

define view P_ProductStorageLocationBasic
  as select from mard as StorageLocation
  association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{

  key cast ( StorageLocation.matnr as productnumber preserving type ) as Product,
  key StorageLocation.werks                                           as Plant,
  key StorageLocation.lgort                                           as StorageLocation,
      StorageLocation.pstat                                           as MaintenanceStatus,
      StorageLocation.lvorm                                           as IsMarkedForDeletion,
      StorageLocation.sperr                                           as PhysicalInventoryBlockInd,
      StorageLocation.kzill                                           as InvtryCurrentYearStockInd,
      StorageLocation.kzilq                                           as InvtryQualInspCurrentYrStkInd,
      StorageLocation.kzile                                           as InvtryRestrictedUseStockInd,
      StorageLocation.kzils                                           as InventoryBlockStockInd,
      StorageLocation.kzvll                                           as InventoryStockPrevPeriod,
      StorageLocation.kzvlq                                           as InvtryStockQltyInspPrevPeriod,
      StorageLocation.kzvle                                           as InvtryRestStockPrevPeriodInd,
      StorageLocation.kzvls                                           as HasInvtryBlockStockPrevPeriod,
      StorageLocation.diskz                                           as StorLocMRP,
      StorageLocation.lsobs                                           as StorLocSpecialProcurementType,
      StorageLocation.lbstf                                           as StorLocMRPReplnmtQtyInBaseUoM,
      StorageLocation.herkl                                           as CountryOfOrigin,
      StorageLocation.lgpbe                                           as WarehouseStorageBin,
      StorageLocation.dlinl                                           as DateOfLastPostedCntUnRstrcdStk,
      StorageLocation.ersda                                           as CreationDate,
      StorageLocation.lwmkb                                           as LeanWrhsManagementPickingArea,
      StorageLocation.bskrf                                           as InventoryCorrectionFactor,
      StorageLocation.mdjin                                           as FiscalYearCurrentInvtryPeriod,

      _Product

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARD"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More