R_ProdPlantWorkSchedulingTP_2

DDL: R_PRODPLANTWORKSCHEDULINGTP_2 Type: view_entity TRANSACTIONAL Package: VDM_MD_PRODUCT_BO_V2

Product Plant Work Scheduling - TP

R_ProdPlantWorkSchedulingTP_2 is a Transactional CDS View that provides data about "Product Plant Work Scheduling - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductWorkScheduling) and exposes 32 fields with key fields Product, Plant. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_BO_V2.

Data Sources (1)

SourceAliasJoin Type
I_ProductWorkScheduling I_ProductWorkScheduling from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ProductTP_2 _Product $projection.Product = _Product.Product
[1] E_Productplant _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.Plant = _ActiveExtension.Plant

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
EndUserText.label Product Plant Work Scheduling - TP view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY Plant Plant
ProductBaseQuantity MaterialBaseQuantity
UnlimitedOverDelivIsAllowed UnlimitedOverDelivIsAllowed
OverDeliveryTolerancePercent OverDelivToleranceLimit
UnderDeliveryTolerancePercent UnderDelivToleranceLimit
ProductionInvtryManagedLoc ProductionInvtryManagedLoc
ProductionOrderBatchCode ProdnOrderIsBatchRequired
ProdIsWithdrawnFrmProdnBin ProdIsWithdrawnFrmProdnBin
TransitionMatrixProductsGroup TransitionMatrixProductsGroup
OrderChangeManagementProfile OrderChangeManagementProfile
ProductComponentBackflushCode MatlCompIsMarkedForBackflush
SetupAndTeardownTime SetupAndTeardownTime
ProductionSchedulingProfile ProductionSchedulingProfile
TransitionTime TransitionTime
ProcessingTimeInDays ProcessingTimeInDays
ProductionSupervisor ProductionSupervisor
ProductProductionQuantityUnit ProductProductionQuantityUnit
BaseUnit BaseUnit
_BaseUnitOfMeasure _BaseUnitOfMeasure
_Plant _Plant
_Product _Product
_ProductionInvtryManagedLoc _ProductionInvtryManagedLoc
_ProductionSchedulingProfile _ProductionSchedulingProfile
_ProductionSupervisor _ProductionSupervisor
_ProductPlant _ProductPlant
_ProductProductionQuantityUnit _ProductProductionQuantityUnit
_ProdnOrdBatDetnCodeText _ProdnOrdBatDetnCodeText
_ProdComponentBackflushCodeT _ProdComponentBackflushCodeT
_ProductDescription _ProductDescription
_BaseUnitOfMeasureText _BaseUnitOfMeasureText
_ProdProdnQuantityUnitText _ProdProdnQuantityUnitText
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@Search.searchable: true
@ObjectModel.semanticKey: [ 'Product','Plant' ]
@EndUserText.label: 'Product Plant Work Scheduling - TP'
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view entity R_ProdPlantWorkSchedulingTP_2
  as select from I_ProductWorkScheduling
  association        to parent R_ProductPlantTP_2 as _ProductPlant  on  $projection.Product = _ProductPlant.Product
                                                                    and $projection.Plant   = _ProductPlant.Plant
  association [1..1] to R_ProductTP_2           as _Product         on  $projection.Product = _Product.Product
  association [1]    to E_Productplant          as _ActiveExtension on  $projection.Product = _ActiveExtension.Product
                                                                    and $projection.Plant   = _ActiveExtension.Plant
{
      @Search:{
            defaultSearchElement: true,
            fuzzinessThreshold: 0.8,
            ranking: #HIGH
          }
  key cast (Product as productnumber preserving type ) as Product,
  key Plant,
      MaterialBaseQuantity                             as ProductBaseQuantity,
      UnlimitedOverDelivIsAllowed,
      OverDelivToleranceLimit                          as OverDeliveryTolerancePercent,
      UnderDelivToleranceLimit                         as UnderDeliveryTolerancePercent,
      ProductionInvtryManagedLoc,
      ProdnOrderIsBatchRequired                        as ProductionOrderBatchCode,
      ProdIsWithdrawnFrmProdnBin,
      TransitionMatrixProductsGroup,
      OrderChangeManagementProfile,
      MatlCompIsMarkedForBackflush                     as ProductComponentBackflushCode,
      SetupAndTeardownTime,
      ProductionSchedulingProfile,
      TransitionTime,
      ProcessingTimeInDays,
      ProductionSupervisor,
      ProductProductionQuantityUnit,
      //      HasProductionVersion, //read-only field

      BaseUnit,
      /* Associations */
      _BaseUnitOfMeasure,
      _Plant,
      _Product,
      _ProductionInvtryManagedLoc,
      _ProductionSchedulingProfile,
      _ProductionSupervisor,
      _ProductPlant,
      _ProductProductionQuantityUnit,
      _ProdnOrdBatDetnCodeText,
      _ProdComponentBackflushCodeT,
      _ProductDescription,
      _BaseUnitOfMeasureText,
      _ProdProdnQuantityUnitText
}