R_RECMDDPRODUCTIONVERSIONTP

CDS View

Recommended Production Version

R_RECMDDPRODUCTIONVERSIONTP is a CDS View in S/4HANA. Recommended Production Version. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_LinkedProductionVersionAll view_entity union CONSUMPTION All Linked Production Version
C_RecommendedProductionVersion view_entity projection CONSUMPTION Recommended Prodn Vers
P_RecommendedProductionVersion view_entity from COMPOSITE Recommended Production Version 
@AccessControl.authorizationCheck:#MANDATORY
@EndUserText.label: 'Recommended Production Version'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.sapObjectNodeType.name: 'ProductionVersion'

define root view entity R_RecmddProductionVersionTP
  as select from I_RecommendedProductionVersion

  association [1..1] to I_MaterialText           as _MaterialText      on  $projection.Material   = _MaterialText.Material
                                                                       and _MaterialText.Language = $session.system_language

  association [0..1] to I_ProdnVersLock          as _ProdnVersLockVH   on  $projection.ProductionVersionLock = _ProdnVersLockVH.ProductionVersionIsLocked

  association [0..1] to I_ProdnVersLockText      as _ProdnVersLockText on  $projection.ProductionVersionLock = _ProdnVersLockText.ProductionVersionIsLocked
                                                                       and _ProdnVersLockText.Language       = $session.system_language

  //  association [0..1] to I_MaterialBOM       as _MaterialBOM       on  $projection.Material                   =  _MaterialBOM.Material

  association [0..1] to I_RecmddProdnVersMatlBOM as _MaterialBOM       on  $projection.Material                   =  _MaterialBOM.Material
                                                                       and $projection.Plant                      =  _MaterialBOM.Plant
                                                                       and $projection.BillOfMaterialVariant      =  _MaterialBOM.BillOfMaterialVariant
                                                                       and $projection.BillOfMaterialVariantUsage =  _MaterialBOM.BillOfMaterialVariantUsage
                                                                       and $projection.ValidityStartDate          >= _MaterialBOM.HeaderValidityStartDate
                                                                       and $projection.ValidityStartDate          <= _MaterialBOM.HeaderValidityEndDate
{

  key Material,
  key Plant,
  key RecommendedProductionVersion,
      ProductionVersion,
      ProductionVersionText,
      BillOfOperationsType,
      BillOfOperationsGroup,
      BillOfOperationsVariant,
      BillOfMaterialVariantUsage,
      BillOfMaterialVariant,
      ProductionLine,
      ProductionSupplyArea,
      ProductionVersionGroup,
      MainProduct,
      MaterialCostApportionmentStruc,
      IssuingStorageLocation,
      ReceivingStorageLocation,
      OriginalBatchReferenceMaterial,
      QuantityDistributionKey,
      ProductionVersionStatus,
      ProductionVersionLastCheckDate,
      RateBasedPlanningStatus,
      PreliminaryPlanningStatus,
      BOMCheckStatus,
      ValidityStartDate,
      ValidityEndDate,
      //      @ObjectModel:{text.element:  [ '_ProdnVersLockText.ProductionVersionLockText' ]  }

      @ObjectModel.foreignKey.association: '_ProdnVersLockVH'
      cast(ProductionVersionLock as mpe_pv_lock_status preserving type ) as ProductionVersionLock,

      ProdnVersIsAllowedForRptvMfg,
      HasVersionCtrldBOMAndRouting,
      PlanningAndExecutionBOMIsDiff,
      ExecBillOfMaterialVariantUsage,
      ExecBillOfMaterialVariant,
      ExecBillOfOperationsType,
      ExecBillOfOperationsGroup,
      ExecBillOfOperationsVariant,
      EWMWarehouse,
      DestinationStorageBin,
      ProcurementType,
      MaterialProcurementProfile,
      UsgeProbltyWthVersCtrlInPct,
      MaterialBaseUnit,
      MaterialMinLotSizeQuantity,
      MaterialMaxLotSizeQuantity,
      CostingLotSize,
      TargetProductionSupplyArea,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      ProdnVersLastChangeDateTime,
      RecmddProductionVersionStatus,
      ProducerEventType,
      ProducerBusinessObjectType,
      //      concat(ProducerEventType, ProducerBusinessObjectType)              as ProdnVersProposalReason,

      //      _MaterialText.MaterialName                                         as MaterialName,

      //      _Plant.PlantName,

      @UI.hidden: true
      _ProdnVersLockVH,
      @UI.hidden: true
      //      _ProdnVersLockText.ProductionVersionLockText,

      //      using cast to delink the Conversion Routine "NUMCV" on BillOfMaterial

      //      cast ( _MaterialBOM.BillOfMaterial as abap.char(8) )               as BillOfMaterial,

      //      _MaterialBOM.BillOfMaterialCategory                                as BillOfMaterialCategory,

      dats_days_between(CreationDate, $session.system_date)              as ProdnVersProposalAgeInDays,

      /* Associations */
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _IssuingStorageLocation,
      _MainProduct,
      _Material,
      _MaterialBaseUnit,
      _MatlCostApportionmentStruc,
      _MatlProcurementProfile,
      _OriglBatchReferenceMaterial,
      _Plant,
      _Product,
      _ProductionLine,
      _ProductionSupplyArea,
      _ProductionVersionGroup,
      _ProductPlant,
      _QuantityDistributionKey,
      _ReceivingStorageLocation,
      _TargetProductionSupplyArea,
      _MaterialText,
      _ProdnVersLockText,
      _MaterialBOM
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECOMMENDEDPRODUCTIONVERSION"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MATLCOSTAPPORTIONMENTSTRUC",
"I_MATLPROCUREMENTPROFILE",
"I_MRPQUANTITYDISTRIBUTIONKEY",
"I_PLANT",
"I_PRODNVERSLOCK",
"I_PRODNVERSLOCKTEXT",
"I_PRODUCT",
"I_PRODUCTIONLINE",
"I_PRODUCTIONSUPPLYAREA",
"I_PRODUCTIONVERSIONGROUP",
"I_PRODUCTPLANT",
"I_RECMDDPRODNVERSMATLBOM",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_RECOMMENDEDPRODUCTIONVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More