P_MSPWWorkItem

DDL: P_MSPWWORKITEM SQL: PMSPWWORKITEM Type: view BASIC

P_MSPWWorkItem is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (P_MSPWMovableProduct, I_Product, P_MSPWProductStock) and exposes 11 fields with key fields Store, Product, TargetStorageLocation.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
P_MSPWMovableProduct MovableProduct from
I_Product StoreProduct inner
P_MSPWProductStock TargetStorageLocationStock inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMSPWWORKITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Store P_MSPWMovableProduct Store
KEY Product P_MSPWMovableProduct Product
KEY TargetStorageLocation P_MSPWMovableProduct TargetStorageLocation
TargetStorageLocationStock P_MSPWProductStock MatlWrhsStkQtyInMatlBaseUnit
UnprocessedSalesQuantity UnprocessedSale quantityinbaseuom
BaseUnit I_Product BaseUnit
ProductName
_BaseUnitOfMeasure _BaseUnitOfMeasure
_Store _Store
_Product _Product
_TargetStorageLocation _TargetStorageLocation 
@AbapCatalog.sqlViewName: 'PMSPWWORKITEM'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MIXED
    }
}
define view P_MSPWWorkItem
  as select from           P_MSPWMovableProduct           as MovableProduct
    inner join             P_MSPWProductStock             as TargetStorageLocationStock on  TargetStorageLocationStock.Plant    = MovableProduct.Store
                                                                                        and TargetStorageLocationStock.Material = MovableProduct.Product
    inner join             I_Product                      as StoreProduct               on  StoreProduct.Product                       = MovableProduct.Product
                                                                                        and TargetStorageLocationStock.StorageLocation = MovableProduct.TargetStorageLocation
    left outer to one join P_MSPWAggregatedUnprocessdSale as UnprocessedSale            on  UnprocessedSale.store   = MovableProduct.Store
                                                                                        and UnprocessedSale.product = MovableProduct.Product
{

  key MovableProduct.Store,
  key MovableProduct.Product,
  key MovableProduct.TargetStorageLocation,

      TargetStorageLocationStock.MatlWrhsStkQtyInMatlBaseUnit as TargetStorageLocationStock,
      UnprocessedSale.quantityinbaseuom                       as UnprocessedSalesQuantity,

       @Semantics.unitOfMeasure: true
      StoreProduct.BaseUnit,
      
      _Product._Text[1: Language = $session.system_language].ProductName,
      _BaseUnitOfMeasure,
      _Store,
      _Product,
      _TargetStorageLocation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"I_PRODUCTTEXT",
"P_MSPWAGGREGATEDUNPROCESSDSALE",
"P_MSPWMOVABLEPRODUCT",
"P_MSPWPRODUCTSTOCK"
],
"ASSOCIATED":
[
"I_PRODUCT",
"I_SITE",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PRODUCT",
"P_MSPWMOVABLEPRODUCT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More