P_RecommendedProductionVersion

DDL: P_RECOMMENDEDPRODUCTIONVERSION Type: view_entity COMPOSITE

Recommended Production Version

P_RecommendedProductionVersion is a Composite CDS View that provides data about "Recommended Production Version" in SAP S/4HANA. It reads from 1 data source (R_RecmddProductionVersionTP) and exposes 75 fields with key fields Material, Plant, RecommendedProductionVersion.

1 data source(s) 75 fields

Data Sources (1)

SourceAliasJoin Type
R_RecmddProductionVersionTP R_RecmddProductionVersionTP from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Recommended Production Version view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY RecommendedProductionVersion RecommendedProductionVersion
ProductionVersion ProductionVersion
ProductionVersionText ProductionVersionText
BillOfOperationsType BillOfOperationsType
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVariant BillOfOperationsVariant
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVariant BillOfMaterialVariant
ProductionLine ProductionLine
ProductionSupplyArea ProductionSupplyArea
ProductionVersionGroup ProductionVersionGroup
MainProduct MainProduct
MaterialCostApportionmentStruc MaterialCostApportionmentStruc
IssuingStorageLocation IssuingStorageLocation
ReceivingStorageLocation ReceivingStorageLocation
OriginalBatchReferenceMaterial OriginalBatchReferenceMaterial
QuantityDistributionKey QuantityDistributionKey
ProductionVersionStatus ProductionVersionStatus
ProductionVersionLastCheckDate ProductionVersionLastCheckDate
RateBasedPlanningStatus RateBasedPlanningStatus
PreliminaryPlanningStatus PreliminaryPlanningStatus
BOMCheckStatus BOMCheckStatus
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
ProductionVersionLock ProductionVersionLock
ProdnVersIsAllowedForRptvMfg ProdnVersIsAllowedForRptvMfg
HasVersionCtrldBOMAndRouting HasVersionCtrldBOMAndRouting
PlanningAndExecutionBOMIsDiff PlanningAndExecutionBOMIsDiff
ExecBillOfMaterialVariantUsage ExecBillOfMaterialVariantUsage
ExecBillOfMaterialVariant ExecBillOfMaterialVariant
ExecBillOfOperationsType ExecBillOfOperationsType
ExecBillOfOperationsGroup ExecBillOfOperationsGroup
ExecBillOfOperationsVariant ExecBillOfOperationsVariant
EWMWarehouse EWMWarehouse
DestinationStorageBin DestinationStorageBin
ProcurementType ProcurementType
MaterialProcurementProfile MaterialProcurementProfile
UsgeProbltyWthVersCtrlInPct UsgeProbltyWthVersCtrlInPct
MaterialBaseUnit MaterialBaseUnit
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity
CostingLotSize CostingLotSize
TargetProductionSupplyArea TargetProductionSupplyArea
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ProdnVersLastChangeDateTime ProdnVersLastChangeDateTime
RecmddProductionVersionStatus RecmddProductionVersionStatus
ProducerEventType ProducerEventType
ProducerBusinessObjectType ProducerBusinessObjectType
MaterialName _MaterialText MaterialName
PlantName _Plant PlantName
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_IssuingStorageLocation _IssuingStorageLocation
_MainProduct _MainProduct
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_MaterialText _MaterialText
_MatlCostApportionmentStruc _MatlCostApportionmentStruc
_MatlProcurementProfile _MatlProcurementProfile
_OriglBatchReferenceMaterial _OriglBatchReferenceMaterial
_Plant _Plant
_Product _Product
_ProductionLine _ProductionLine
_ProductionSupplyArea _ProductionSupplyArea
_ProductionVersionGroup _ProductionVersionGroup
_ProductPlant _ProductPlant
_QuantityDistributionKey _QuantityDistributionKey
_ReceivingStorageLocation _ReceivingStorageLocation
_TargetProductionSupplyArea _TargetProductionSupplyArea 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Recommended Production Version'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_RecommendedProductionVersion
  as select from R_RecmddProductionVersionTP
{
  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,
      ProductionVersionLock,
      ProdnVersIsAllowedForRptvMfg,
      HasVersionCtrldBOMAndRouting,
      PlanningAndExecutionBOMIsDiff,
      ExecBillOfMaterialVariantUsage,
      ExecBillOfMaterialVariant,
      ExecBillOfOperationsType,
      ExecBillOfOperationsGroup,
      ExecBillOfOperationsVariant,
      EWMWarehouse,
      DestinationStorageBin,
      ProcurementType,
      MaterialProcurementProfile,
      UsgeProbltyWthVersCtrlInPct,
      MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MaterialMinLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MaterialMaxLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      CostingLotSize,
      TargetProductionSupplyArea,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      ProdnVersLastChangeDateTime,
      RecmddProductionVersionStatus,
      ProducerEventType,
      ProducerBusinessObjectType,
      _MaterialText.MaterialName,
      _Plant.PlantName,
      /* Associations */
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _IssuingStorageLocation,
      _MainProduct,
      _Material,
      _MaterialBaseUnit,
      _MaterialText,
      _MatlCostApportionmentStruc,
      _MatlProcurementProfile,
      _OriglBatchReferenceMaterial,
      _Plant,
      _Product,
      _ProductionLine,
      _ProductionSupplyArea,
      _ProductionVersionGroup,
      _ProductPlant,
      _QuantityDistributionKey,
      _ReceivingStorageLocation,
      _TargetProductionSupplyArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALTEXT",
"I_PLANT",
"R_RECMDDPRODUCTIONVERSIONTP"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MATLCOSTAPPORTIONMENTSTRUC",
"I_MATLPROCUREMENTPROFILE",
"I_MRPQUANTITYDISTRIBUTIONKEY",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTIONLINE",
"I_PRODUCTIONSUPPLYAREA",
"I_PRODUCTIONVERSIONGROUP",
"I_PRODUCTPLANT",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"R_RECMDDPRODUCTIONVERSIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More