I_ProductWorkSchedulingWD

DDL: I_PRODUCTWORKSCHEDULINGWD SQL: IPRDWORKSCHEDWD Type: view TRANSACTIONAL

Product-Work Scheduling Node (draft)

I_ProductWorkSchedulingWD is a Transactional CDS View that provides data about "Product-Work Scheduling Node (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProductWorkScheduling) and exposes 17 fields with key fields Product, Plant. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductWorkScheduling WorkScheduling from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_Productplant _ActiveProductExt $projection.Product = _ActiveProductExt.Product and $projection.Plant = _ActiveProductExt.Plant
[0..1] E_Productplant _DraftProductExt $projection.Product = _DraftProductExt.Product and $projection.Plant = _DraftProductExt.Plant
[1..1] I_ProductWD _Product $projection.Product = _Product.Product
[1..1] I_ProductPlantWD _Plant $projection.Product = _Plant.Product and $projection.Plant = _Plant.Plant

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPRDWORKSCHEDWD view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Product-Work Scheduling Node (draft) view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeDraftPersistence PROD_PLANT_WORK 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 (17)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductWorkScheduling Product
KEY Plant I_ProductWorkScheduling Plant
PlantForEdit I_ProductWorkScheduling Plant
MaterialBaseQuantity I_ProductWorkScheduling MaterialBaseQuantity
UnlimitedOverDelivIsAllowed I_ProductWorkScheduling UnlimitedOverDelivIsAllowed
OverDelivToleranceLimit I_ProductWorkScheduling OverDelivToleranceLimit
UnderDelivToleranceLimit I_ProductWorkScheduling UnderDelivToleranceLimit
ProductionInvtryManagedLoc I_ProductWorkScheduling ProductionInvtryManagedLoc
ProductionSupervisor I_ProductWorkScheduling ProductionSupervisor
ProductionSchedulingProfile I_ProductWorkScheduling ProductionSchedulingProfile
BaseUnit I_ProductWorkScheduling BaseUnit
MatlCompIsMarkedForBackflush I_ProductWorkScheduling MatlCompIsMarkedForBackflush
_Product _Product
_Plant _Plant
_ProductionInvtryManagedLoc _ProductionInvtryManagedLoc
_ProductionSupervisor _ProductionSupervisor
_ProductionSchedulingProfile _ProductionSchedulingProfile
@AbapCatalog.sqlViewName: 'IPRDWORKSCHEDWD'
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Product-Work Scheduling Node (draft)'
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    writeDraftPersistence: 'PROD_PLANT_WORK',
    semanticKey: [ 'Product','Plant' ],
    createEnabled : true,
    deleteEnabled : true,
    updateEnabled : true,
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #XL,
    usageType.dataClass: #TRANSACTIONAL
}


define view I_ProductWorkSchedulingWD
  as select from I_ProductWorkScheduling as WorkScheduling

  association [0..1] to E_Productplant   as _ActiveProductExt on  $projection.Product = _ActiveProductExt.Product
                                                              and $projection.Plant   = _ActiveProductExt.Plant
  association [0..1] to E_Productplant   as _DraftProductExt  on  $projection.Product = _DraftProductExt.Product
                                                              and $projection.Plant   = _DraftProductExt.Plant
  //  association[0..1] to E_Productworkschedulingd as _DraftProductExt on $projection.DraftKey = _DraftProductExt.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 WorkScheduling.Product,
      @ObjectModel.readOnly:true
  key WorkScheduling.Plant,
      WorkScheduling.Plant as PlantForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.MaterialBaseQuantity,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.UnlimitedOverDelivIsAllowed,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.OverDelivToleranceLimit,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.UnderDelivToleranceLimit,
      //      WorkScheduling.GoodsIssueUnit,   "PSTAT Revert : Moved back to I_ProductPlantWD

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert : Moved back to I_ProductPlantWD

      //      WorkScheduling.StockDeterminationGroup,

      //      WorkScheduling.DistrCntrDistributionProfile,   "PSTAT Revert : Moved back to productplant

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'   "PSTAT Revert : Moved back to productplant

      //      WorkScheduling.ProductCFOPCategory,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION' //PSTAT Revert

      WorkScheduling.ProductionInvtryManagedLoc,
      //      WorkScheduling.ProductUnitGroup, "PSTAT Revert : Moved back to productplant

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert : back to productplant

      //      WorkScheduling.ProfileCode,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.ProfileValidityStartDate,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.FiscalYearVariant,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      //      WorkScheduling.PeriodType,  "PSTAT Revert

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.ProfitCenter,

      //      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.SerialNumberProfile,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.ConfigurableProduct,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.IsBatchManagementRequired,

      //      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  "PSTAT Revert

      //      WorkScheduling.IsNegativeStockAllowed,


      //      cast('' as kokrs )                                                             as  ControllingArea,  "PSTAT Revert

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.ProductionSupervisor,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.ProductionSchedulingProfile,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      WorkScheduling.BaseUnit,
      WorkScheduling.MatlCompIsMarkedForBackflush,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _Product,
      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
      _Plant,
      _ProductionInvtryManagedLoc,
      _ProductionSupervisor,
      _ProductionSchedulingProfile
      //      _GoodsIssueUnit,   "PSTAT Revert : Moved back to I_ProductPlantWD

      //      _UnitOfMeasureText,"PSTAT Revert : Moved back to I_ProductPlantWD

      //      _ProductStatus,    "PSTAT Revert : back to productplant

      //      _ProductStatusText,  "PSTAT Revert : back to productplant

      //      _FiscalYearVariant,   "PSTAT Revert

      //      _FiscalYearVariantDescription,  "PSTAT Revert

      //      _ConfigurableProduct,  "PSTAT Revert

      //      _ConfigurableProductName  "PSTAT Revert


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTWORKSCHEDULING"
],
"ASSOCIATED":
[
"E_PRODUCTPLANT",
"I_PRODUCTIONSCHEDULINGPROFILE",
"I_PRODUCTIONSUPERVISOR",
"I_PRODUCTPLANTWD",
"I_PRODUCTWD",
"I_STORAGELOCATION"
],
"BASE":
[
"I_PRODUCTWORKSCHEDULING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/