A_ProductWorkScheduling

DDL: A_PRODUCTWORKSCHEDULING SQL: APRODWORKSCHEDG Type: view COMPOSITE Package: VDM_MD_PRODUCT_API_V1

Work Scheduling Data

A_ProductWorkScheduling is a Composite CDS View that provides data about "Work Scheduling Data" in SAP S/4HANA. It reads from 1 data source (I_ProductWorkScheduling) and exposes 19 fields with key fields Product, Plant. It has 1 association to related views. Part of development package VDM_MD_PRODUCT_API_V1.

Data Sources (1)

SourceAliasJoin Type
I_ProductWorkScheduling I_ProductWorkScheduling from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName APRODWORKSCHEDG view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Scheduling Data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Product Product
KEY Plant Plant
MaterialBaseQuantity MaterialBaseQuantity
UnlimitedOverDelivIsAllowed UnlimitedOverDelivIsAllowed
OverDelivToleranceLimit OverDelivToleranceLimit
UnderDelivToleranceLimit UnderDelivToleranceLimit
ProductionInvtryManagedLoc ProductionInvtryManagedLoc
BaseUnit BaseUnit
ProductProcessingTime ProcessingTimeInDays
ProductionSupervisor ProductionSupervisor
ProductProductionQuantityUnit ProductProductionQuantityUnit
ProdnOrderIsBatchRequired ProdnOrderIsBatchRequired
TransitionMatrixProductsGroup TransitionMatrixProductsGroup
OrderChangeManagementProfile OrderChangeManagementProfile
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush
SetupAndTeardownTime SetupAndTeardownTime
ProductionSchedulingProfile ProductionSchedulingProfile
TransitionTime TransitionTime
_Product _Product
@AbapCatalog.sqlViewName: 'APRODWORKSCHEDG'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Scheduling Data'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
//@ObjectModel.deleteEnabled: true

define view A_ProductWorkScheduling
  as select from I_ProductWorkScheduling

  association [1..1] to A_Product as _Product on $projection.Product = _Product.Product


  //association [0..1] to E_Productplant   as _ProdWorkSchedulingExtn on  $projection.Product = _ProdWorkSchedulingExtn .Product

  //                                                            and $projection.Plant   = _ProdWorkSchedulingExtn.Plant


{

  key Product,
  key Plant,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MaterialBaseQuantity,
      UnlimitedOverDelivIsAllowed,
      OverDelivToleranceLimit,
      UnderDelivToleranceLimit,
      // GoodsIssueUnit,

      // StockDeterminationGroup,

      //  DistrCntrDistributionProfile,

      // ProductCFOPCategory,

      @ObjectModel.sapObjectNodeTypeReference:'StorageLocation'
      ProductionInvtryManagedLoc,
      //  ProductUnitGroup,

      // ProfileCode,

      // ProfileValidityStartDate,

      // FiscalYearVariant,

      //PeriodType,

      //ProfitCenter,

      // SerialNumberProfile,

      // ConfigurableProduct,

      // IsBatchManagementRequired,

      // IsNegativeStockAllowed,

      @Semantics.unitOfMeasure: true
      BaseUnit,
      //      new fields as part of 2005 release

      ProcessingTimeInDays as ProductProcessingTime,
      ProductionSupervisor,
      ProductProductionQuantityUnit,
      ProdnOrderIsBatchRequired,
      TransitionMatrixProductsGroup,
      OrderChangeManagementProfile,
      MatlCompIsMarkedForBackflush,
      SetupAndTeardownTime,
      @ObjectModel.sapObjectNodeTypeReference:'ProductionSchedulingProfile'
      ProductionSchedulingProfile,
      TransitionTime,
      _Product

}