R_ProdPlantWorkSchedulingTP

DDL: R_PRODPLANTWORKSCHEDULINGTP Type: view_entity TRANSACTIONAL

Product Plant Work Scheduling - TP

R_ProdPlantWorkSchedulingTP 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 27 fields with key fields Product, Plant. It has 2 associations to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductWorkScheduling I_ProductWorkScheduling from

Associations (2)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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

Fields (27)

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 
@AccessControl.authorizationCheck: #CHECK
@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'
define view entity R_ProdPlantWorkSchedulingTP
  as select from I_ProductWorkScheduling
  association        to parent R_ProductPlantTP as _ProductPlant    on  $projection.Product = _ProductPlant.Product
                                                                    and $projection.Plant   = _ProductPlant.Plant
  association [1..1] to R_ProductTP             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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTWORKSCHEDULING"
],
"ASSOCIATED":
[
"I_PLANT",
"I_PRODUCTIONSCHEDULINGPROFILE",
"I_PRODUCTIONSUPERVISOR",
"I_STORAGELOCATION",
"I_UNITOFMEASURE",
"R_PRODUCTPLANTTP",
"R_PRODUCTTP"
],
"BASE":
[
"I_PRODUCTWORKSCHEDULING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More