C_SlsOrdProdnModProdnVersion

DDL: C_SLSORDPRODNMODPRODNVERSION Type: view_entity CONSUMPTION

Production Versions

C_SlsOrdProdnModProdnVersion is a Consumption CDS View that provides data about "Production Versions" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsVersion) and exposes 49 fields with key fields Material, Plant, ProductionVersion. It has 4 associations to related views.

1 data source(s) 49 fields

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperationsVersion BillOfOperations inner

Associations (4)

CardinalityTargetAliasCondition
[0..*] C_SlsOrdProdnModMstrRtgBOMVers _MasterBOMRoutingVers $projection.ProductionVersion = _MasterBOMRoutingVers.ProductionVersion and $projection.Material = _MasterBOMRoutingVers.Material and $projection.Plant = _MasterBOMRoutingVers.Plant
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_Plant _Plant ProductionVersion.Plant = _Plant.Plant and _Plant.Language = $session.system_language
[0..1] I_BillOfMaterialUsage _BOMVarUsgeVH ProductionVersion.BillOfMaterialVariantUsage = _BOMVarUsgeVH.BillOfMaterialVariantUsage and _BOMVarUsgeVH.Language = $session.system_language

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Versions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY Material ProductionVersion Material
KEY Plant ProductionVersion Plant
KEY ProductionVersion ProductionVersion ProductionVersion
ProductionVersionText ProductionVersion ProductionVersionText
PlantName _Plant PlantName
MaterialName _MaterialText MaterialName
CreationDate ProductionVersion CreationDate
CreatedByUser ProductionVersion CreatedByUser
BillOfOperationsType ProductionVersion BillOfOperationsType
BillOfOperationsGroup ProductionVersion BillOfOperationsGroup
BillOfOperationsVariant ProductionVersion BillOfOperationsVariant
BillOfMaterialVariantUsage ProductionVersion BillOfMaterialVariantUsage
BillOfMaterialVariant ProductionVersion BillOfMaterialVariant
ProductionLine ProductionVersion ProductionLine
ProductionSupplyArea ProductionVersion ProductionSupplyArea
ProductionVersionGroup ProductionVersion ProductionVersionGroup
MainProduct ProductionVersion MainProduct
MaterialCostApportionmentStruc ProductionVersion MaterialCostApportionmentStruc
IssuingStorageLocation ProductionVersion IssuingStorageLocation
ReceivingStorageLocation ProductionVersion ReceivingStorageLocation
OriginalBatchReferenceMaterial ProductionVersion OriginalBatchReferenceMaterial
QuantityDistributionKey ProductionVersion QuantityDistributionKey
ProductionVersionStatus ProductionVersion ProductionVersionStatus
RateBasedPlanningStatus ProductionVersion RateBasedPlanningStatus
PreliminaryPlanningStatus ProductionVersion PreliminaryPlanningStatus
ValidityStartDate ProductionVersion ValidityStartDate
ValidityEndDate ProductionVersion ValidityEndDate
ProdnVersIsAllowedForRptvMfg ProductionVersion ProdnVersIsAllowedForRptvMfg
HasVersionCtrldBOMAndRouting ProductionVersion HasVersionCtrldBOMAndRouting
PlanningAndExecutionBOMIsDiff ProductionVersion PlanningAndExecutionBOMIsDiff
ExecBillOfMaterialVariantUsage ProductionVersion ExecBillOfMaterialVariantUsage
ExecBillOfMaterialVariant ProductionVersion ExecBillOfMaterialVariant
ExecBillOfOperationsType ProductionVersion ExecBillOfOperationsType
ExecBillOfOperationsGroup ProductionVersion ExecBillOfOperationsGroup
ExecBillOfOperationsVariant ProductionVersion ExecBillOfOperationsVariant
DestinationStorageBin ProductionVersion DestinationStorageBin
ProcurementType ProductionVersion ProcurementType
MaterialProcurementProfile ProductionVersion MaterialProcurementProfile
UsgeProbltyWthVersCtrlInPct ProductionVersion UsgeProbltyWthVersCtrlInPct
MaterialBaseUnit ProductionVersion MaterialBaseUnit
MaterialMinLotSizeQuantity ProductionVersion MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity ProductionVersion MaterialMaxLotSizeQuantity
CostingLotSize ProductionVersion CostingLotSize
TargetProductionSupplyArea ProductionVersion TargetProductionSupplyArea
ConfigblProdProductionVersion ProductionVersion ConfigblProdProductionVersion
_MasterBOMRoutingVers _MasterBOMRoutingVers
_MaterialText _MaterialText
_Plant _Plant
_BOMVarUsgeVH _BOMVarUsgeVH 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@VDM: { viewType: #CONSUMPTION }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Production Versions'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity C_SlsOrdProdnModProdnVersion
  as select distinct from I_ProductionVersion       as ProductionVersion
    inner join            I_BillOfOperationsVersion as BillOfOperations on  BillOfOperations.BillOfOperationsType          = ProductionVersion.BillOfOperationsType
                                                                        and BillOfOperations.BillOfOperationsGroup         = ProductionVersion.BillOfOperationsGroup
                                                                        and BillOfOperations.BillOfOperationsVariant       = ProductionVersion.BillOfOperationsVariant
                                                                        and BillOfOperations.BillOfOperationsVersionStatus = '20'
  association [0..*] to C_SlsOrdProdnModMstrRtgBOMVers as _MasterBOMRoutingVers on  $projection.ProductionVersion = _MasterBOMRoutingVers.ProductionVersion
                                                                                and $projection.Material          = _MasterBOMRoutingVers.Material
                                                                                and $projection.Plant             = _MasterBOMRoutingVers.Plant
  association [0..1] to I_MaterialText                 as _MaterialText         on  $projection.Material   = _MaterialText.Material
                                                                                and _MaterialText.Language = $session.system_language
  association [0..1] to I_Plant                        as _Plant                on  ProductionVersion.Plant = _Plant.Plant
                                                                                and _Plant.Language         = $session.system_language
  association [0..1] to I_BillOfMaterialUsage          as _BOMVarUsgeVH         on  ProductionVersion.BillOfMaterialVariantUsage = _BOMVarUsgeVH.BillOfMaterialVariantUsage
                                                                                and _BOMVarUsgeVH.Language                       = $session.system_language
{
      @UI.facet: [ { id: 'ProductionVersion',
                          purpose         : #STANDARD,
                          type            : #FIELDGROUP_REFERENCE,
                          label           : 'Production Version',
                          targetQualifier : 'ProductionVersion',
                          position        : 10 },
                   { id: 'MasterBOMRTGVers',
                          purpose         : #STANDARD,
                          type            : #LINEITEM_REFERENCE,
                          label           : 'BOM & Routing Versions',
                          targetQualifier : 'MasterBOMRoutingVers',
                          position        : 20,
                          targetElement   : '_MasterBOMRoutingVers' } ]

      @ObjectModel.text.element: ['MaterialName']
      @UI: {  lineItem:       [ { position: 10 } ],
                  fieldGroup: [ { qualifier:'ProductionVersion' } ] }
  key ProductionVersion.Material,
      @ObjectModel.text.element: ['PlantName']
      @UI: {  lineItem:       [ { position: 20 } ],
                  fieldGroup: [ { qualifier:'ProductionVersion' } ] }
  key ProductionVersion.Plant,
      @UI: {  lineItem:       [ { position: 21 } ],
                  fieldGroup: [ { qualifier:'ProductionVersion' } ] }
  key ProductionVersion.ProductionVersion,
      @UI: {  lineItem:       [ { position: 30 } ],
                fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.ProductionVersionText,
      _Plant.PlantName,
      _MaterialText.MaterialName,
      @UI: {  lineItem:       [ { position: 70 } ],
            fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.CreationDate,
      @UI: {  lineItem:       [ { position: 80 } ],
            fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.CreatedByUser,
      @UI: {  lineItem:       [ { position: 40 } ],
                  fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.BillOfOperationsType,
      @UI: {  lineItem:       [ { position: 50 } ],
                  fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.BillOfOperationsGroup,
      @UI: {  lineItem:       [ { position: 60 } ],
            fieldGroup: [ { qualifier:'ProductionVersion' } ] }
      ProductionVersion.BillOfOperationsVariant,
      @UI.hidden: true
      ProductionVersion.BillOfMaterialVariantUsage,
      @UI.hidden: true
      ProductionVersion.BillOfMaterialVariant,
      ProductionVersion.ProductionLine,
      ProductionVersion.ProductionSupplyArea,
      ProductionVersion.ProductionVersionGroup,
      ProductionVersion.MainProduct,
      ProductionVersion.MaterialCostApportionmentStruc,
      ProductionVersion.IssuingStorageLocation,
      ProductionVersion.ReceivingStorageLocation,
      ProductionVersion.OriginalBatchReferenceMaterial,
      ProductionVersion.QuantityDistributionKey,
      ProductionVersion.ProductionVersionStatus,
      ProductionVersion.RateBasedPlanningStatus,
      ProductionVersion.PreliminaryPlanningStatus,
      ProductionVersion.ValidityStartDate,
      ProductionVersion.ValidityEndDate,
      ProductionVersion.ProdnVersIsAllowedForRptvMfg,
      ProductionVersion.HasVersionCtrldBOMAndRouting,
      ProductionVersion.PlanningAndExecutionBOMIsDiff,
      ProductionVersion.ExecBillOfMaterialVariantUsage,
      ProductionVersion.ExecBillOfMaterialVariant,
      ProductionVersion.ExecBillOfOperationsType,
      ProductionVersion.ExecBillOfOperationsGroup,
      ProductionVersion.ExecBillOfOperationsVariant,
      //      Warehouse,

      ProductionVersion.DestinationStorageBin,
      ProductionVersion.ProcurementType,
      ProductionVersion.MaterialProcurementProfile,
      ProductionVersion.UsgeProbltyWthVersCtrlInPct,
      ProductionVersion.MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      ProductionVersion.MaterialMinLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      ProductionVersion.MaterialMaxLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      ProductionVersion.CostingLotSize,
      //      DistributionKey,

      ProductionVersion.TargetProductionSupplyArea,
      ProductionVersion.ConfigblProdProductionVersion,
      //      ConfigurableProduct,

      _MasterBOMRoutingVers,
      _MaterialText,
      _Plant,
      _BOMVarUsgeVH
}
where
      ProductionVersion.BillOfOperationsType  = 'V'
  and ProductionVersion.BillOfOperationsGroup is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSVERSION",
"I_MATERIALTEXT",
"I_PLANT",
"I_PRODUCTIONVERSION"
],
"ASSOCIATED":
[
"C_SLSORDPRODNMODMSTRRTGBOMVERS",
"I_BILLOFMATERIALUSAGE",
"I_MATERIALTEXT",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More