C_ProductionVersion

DDL: C_PRODUCTIONVERSION Type: view_entity CONSUMPTION

Production Version List

C_ProductionVersion is a Consumption CDS View that provides data about "Production Version List" in SAP S/4HANA. It reads from 1 data source (R_ProductionVersionTP) and exposes 90 fields with key fields Material, Plant, ProductionVersion. It has 2 associations to related views. It is exposed through 1 OData service (UI_PRODUCTIONVERSION). It is used in 1 Fiori application: Process Production Versions.

Data Sources (1)

SourceAliasJoin Type
R_ProductionVersionTP R_ProductionVersionTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_TaskListSequence _TaskListSequence $projection.BillOfOperationsType = _TaskListSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _TaskListSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _TaskListSequence.BillOfOperationsVariant
[0..*] C_TaskListActivity _Operation $projection.BillOfOperationsType = _Operation.BillOfOperationsType and $projection.BillOfOperationsGroup = _Operation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _Operation.BillOfOperationsVariant

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production Version List view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRODUCTIONVERSION UI_PRODUCTIONVERSION V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6400 Process Production Versions Transactional With this app, you can view the following details: Existing production versions Proposals for creating a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination Production versions if there are any inconsistencies related to missing information

Process Production Versions

Business Role: Others

With this app, you can achieve the following: View and edit existing production versions Create new production versions Mass lock and unlock of Production versions Mass consistency check of existing production versions View all proposals that are generated when a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination. Accept or Reject Proposals in a individual manner or through mass action. Delete selected production versions

Fields (90)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY ProductionVersion ProductionVersion
ProductionVersionText ProductionVersionText Production Version Description
ChangeHistoryCount ChangeHistoryCount
ChangeNumber ChangeNumber
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
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
RoutingCheckStatusText RoutingCheckStatusText
ProductionVersionLastCheckDate ProductionVersionLastCheckDate
RateBasedPlanningStatus RateBasedPlanningStatus
PreliminaryPlanningStatus PreliminaryPlanningStatus
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
MRPResponsible _ProductPlant MRPResponsible
PlantName _Plant PlantName
MRPController
MaterialName _MaterialText MaterialName
BillOfOperationsTypeName BillOfOperationsTypeName
ProductionVersionLockText _ProdnVersLockText ProductionVersionLockText
int1
BOMCheckStatus
OvrlProdnVersChkSts OvrlProdnVersChkSts
BillOfMaterial _MaterialBOM BillOfMaterial
BillOfMaterialCategory _MaterialBOM BillOfMaterialCategory
NmbrOfProdnVersConstcyWarning
NumberOfProdnVersConstcyError
NmbrOfProdnVersConstcySuccess
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsTypeText _BillOfOperationsTypeText
_ChangeMaster _ChangeMaster
_IssuingStorageLocation _IssuingStorageLocation
_MainProduct _MainProduct
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_MatlCostApportionmentStruc _MatlCostApportionmentStruc
_MatlProcurementProfile _MatlProcurementProfile
_OriglBatchReferenceMaterial _OriglBatchReferenceMaterial
_Plant _Plant
_MaterialText _MaterialText
_Product _Product
_ProductionLine _ProductionLine
_ProductionSupplyArea _ProductionSupplyArea
_ProductionVersionGroup _ProductionVersionGroup
_ProductPlant _ProductPlant
_QuantityDistributionKey _QuantityDistributionKey
_ReceivingStorageLocation _ReceivingStorageLocation
_TargetProductionSupplyArea _TargetProductionSupplyArea
_ProdnVersLockText _ProdnVersLockText
_ProdnVersLockVH _ProdnVersLockVH
_TaskListSequence _TaskListSequence
_Operation _Operation
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Version List'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel.usageType:{ serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED }
@Search.searchable: true
@Metadata.allowExtensions: true

define root view entity C_ProductionVersion
  provider contract transactional_query
  as projection on R_ProductionVersionTP
  association [0..*] to C_TaskListSequence as _TaskListSequence on  $projection.BillOfOperationsType    = _TaskListSequence.BillOfOperationsType
                                                                and $projection.BillOfOperationsGroup   = _TaskListSequence.BillOfOperationsGroup
                                                                and $projection.BillOfOperationsVariant = _TaskListSequence.BillOfOperationsVariant
  //Associated Task List Operations

  association [0..*] to C_TaskListActivity as _Operation        on  $projection.BillOfOperationsType    = _Operation.BillOfOperationsType
                                                                and $projection.BillOfOperationsGroup   = _Operation.BillOfOperationsGroup
                                                                and $projection.BillOfOperationsVariant = _Operation.BillOfOperationsVariant
{

          @Search:{ defaultSearchElement: true, fuzzinessThreshold: 0.9, ranking: #HIGH }
          ////          @UI.fieldGroup:[{qualifier:'MaterialFieldGroup', position:10 }]

          @Consumption.semanticObject: 'Material'
          @ObjectModel.text.element: ['MaterialName']
          @UI.textArrangement: #TEXT_LAST
  key     Material,
          @Search:{ defaultSearchElement: true, fuzzinessThreshold: 0.9, ranking: #HIGH }
  key     Plant,
  key     ProductionVersion,
          @EndUserText.label: 'Production Version Description'
          ProductionVersionText,
          ChangeHistoryCount,
          ChangeNumber,
          CreationDate,
          CreatedByUser,
          LastChangeDate,
          LastChangedByUser,
          @ObjectModel.text.element: ['BillOfOperationsTypeName']
          BillOfOperationsType,
          //          @ObjectModel.text.element: ['BillOfOperationsVariant']

          BillOfOperationsGroup,
          @Semantics.text: true
          BillOfOperationsVariant,
          BillOfMaterialVariantUsage,
          BillOfMaterialVariant,
          ProductionLine,
          ProductionSupplyArea,
          ProductionVersionGroup,
          MainProduct,
          MaterialCostApportionmentStruc,
          IssuingStorageLocation,
          ReceivingStorageLocation,
          OriginalBatchReferenceMaterial,
          QuantityDistributionKey,
          ProductionVersionStatus,
          RoutingCheckStatusText,
          ProductionVersionLastCheckDate,
          RateBasedPlanningStatus,
          PreliminaryPlanningStatus,
          //          BOMCheckStatus,

          ValidityStartDate,
          ValidityEndDate,
          @ObjectModel:{text.element:  [ 'ProductionVersionLockText' ]  }
          @ObjectModel.foreignKey.association: '_ProdnVersLockVH'
          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,
          _ProductPlant.MRPResponsible,
          _Plant.PlantName,
          cast(MRPController as pph_dispo preserving type )                                   as MRPController,
          @Search.defaultSearchElement: true
          //          @UI.lineItem: [{ label: 'Material', position: 10, type: #AS_FIELDGROUP, valueQualifier: 'MaterialFieldGroup'}]

          //          @UI.fieldGroup:[{qualifier:'MaterialFieldGroup', position:20, emphasized: true}]


          _MaterialText.MaterialName                                                          as MaterialName,
          BillOfOperationsTypeName,
          _ProdnVersLockText.ProductionVersionLockText,

          @UI.hidden: true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_PPH_PRV_OVERALL_CHECKSTATUS'
  virtual CheckStatusCriticality : abap.int1,


          cast(BOMCheckStatus as mpe_pv_bom_chksts preserving type )                          as BOMCheckStatus,
          OvrlProdnVersChkSts,
          _MaterialBOM.BillOfMaterial,
          _MaterialBOM.BillOfMaterialCategory,

          //Consistency Check Status

          _ConstcyLogCount[1:ProdnVersConstcyIssSvrtyLvl = 'W'].NumberOfProdnVersConstcyIssue as NmbrOfProdnVersConstcyWarning,
          _ConstcyLogCount[1:ProdnVersConstcyIssSvrtyLvl = 'E'].NumberOfProdnVersConstcyIssue as NumberOfProdnVersConstcyError,
          _ConstcyLogCount[1:ProdnVersConstcyIssSvrtyLvl = 'S'].NumberOfProdnVersConstcyIssue as NmbrOfProdnVersConstcySuccess,

          /* Associations */
          _BillOfOperations,
          _BillOfOperationsGroup,
          _BillOfOperationsType,
          _BillOfOperationsTypeText,
          _ChangeMaster,
          _IssuingStorageLocation,
          _MainProduct,
          _Material,
          _MaterialBaseUnit,
          _MatlCostApportionmentStruc,
          _MatlProcurementProfile,
          _OriglBatchReferenceMaterial,
          _Plant,
          _MaterialText,
          _Product,
          _ProductionLine,
          _ProductionSupplyArea,
          _ProductionVersionGroup,
          _ProductPlant,
          _QuantityDistributionKey,
          _ReceivingStorageLocation,
          _TargetProductionSupplyArea,
          _ProdnVersLockText,
          _ProdnVersLockVH,
          _TaskListSequence,
          _Operation,

          /*Compositional Association*/
          _ConstcyLog : redirected to composition child C_ProdnVersConsistencyLog
}

where
  (
       BillOfOperationsType = '2'
    or BillOfOperationsType = 'N'
    or BillOfOperationsType = 'S'
    or BillOfOperationsType = ' '
  )