I_ProductStorageLocationWD

DDL: I_PRODUCTSTORAGELOCATIONWD SQL: IPRDSTORAGELOCWD Type: view TRANSACTIONAL

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)

SourceAliasJoin Type
I_ProductStorageLocationBasic StorageLocation from

Associations (4)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/