C_LinkedProductionVersionAll

DDL: C_LINKEDPRODUCTIONVERSIONALL Type: view_entity CONSUMPTION Package: ODATA_PP_PRODNVERS_API

All Linked Production Version

C_LinkedProductionVersionAll is a Consumption CDS View that provides data about "All Linked Production Version" in SAP S/4HANA. It reads from 2 data sources (I_ProductionVersion, R_RecmddProductionVersionTP) and exposes 33 fields with key fields Material, Plant, RecommendedProductionVersion, ProductionVersion, Plant. 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. Part of development package ODATA_PP_PRODNVERS_API.

2 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 33 fields

Data Sources (2)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from
R_RecmddProductionVersionTP R_RecmddProductionVersionTP union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaterialBOM _BillOfMaterial $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and $projection.BillOfMaterialVariantUsage = _BillOfMaterial.BillOfMaterialVariantUsage and _BillOfMaterial.HeaderValidityStartDate <= $session.system_date and _BillOfMaterial.HeaderValidityEndDate >= $session.system_date
[1..1] I_MfgBillOfOperationsChgSt _RoutingStatusText $projection.BillOfOperationsType = _RoutingStatusText.BillOfOperationsType and $projection.BillOfOperationsGroup = _RoutingStatusText.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _RoutingStatusText.BillOfOperationsVariant and _RoutingStatusText.ValidityStartDate <= $session.system_date and _RoutingStatusText.ValidityEndDate >= $session.system_date

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label All Linked Production Version view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED 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 (33)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY RecommendedProductionVersion
KEY ProductionVersion ProductionVersion
LinkedProductionVersionAll
BillOfMaterialVariant BillOfMaterialVariant
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVariant BillOfOperationsVariant
BillOfOperationsType BillOfOperationsType
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
MaterialName _MaterialText MaterialName
PlantName _Plant PlantName
ProductionVersionText ProductionVersionText
ProducerEventType
ProducerBusinessObjectType
BOMHeaderText _BillOfMaterial BOMHeaderText
system_datekeyMaterialasMaterial
KEY Plant Plant
KEY RecommendedProductionVersion RecommendedProductionVersion
KEY ProductionVersion
LinkedProductionVersionAll RecommendedProductionVersion
BillOfMaterialVariant BillOfMaterialVariant
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVariant BillOfOperationsVariant
BillOfOperationsType BillOfOperationsType
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
MaterialName _MaterialText MaterialName
PlantName _Plant PlantName
ProductionVersionText ProductionVersionText
ProducerEventType ProducerEventType
ProducerBusinessObjectType ProducerBusinessObjectType
BOMHeaderText _MaterialBOM BOMHeaderText
BillOfOperationsDesc _RoutingStatusText BillOfOperationsDesc 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'All Linked Production Version'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{ serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED }
@Metadata.allowExtensions: true
@Consumption.dbHints:['USE_HEX_PLAN']

define view entity C_LinkedProductionVersionAll
  as select from I_ProductionVersion

  association [1..1] to I_MaterialBOM              as _BillOfMaterial    on  $projection.Material                    = _BillOfMaterial.Material
                                                                         and $projection.Plant                       = _BillOfMaterial.Plant
                                                                         and $projection.BillOfMaterialVariant       = _BillOfMaterial.BillOfMaterialVariant
                                                                         and $projection.BillOfMaterialVariantUsage  = _BillOfMaterial.BillOfMaterialVariantUsage
                                                                         and _BillOfMaterial.HeaderValidityStartDate <= $session.system_date
                                                                         and _BillOfMaterial.HeaderValidityEndDate   >= $session.system_date

  association [1..1] to I_MfgBillOfOperationsChgSt as _RoutingStatusText on  $projection.BillOfOperationsType     = _RoutingStatusText.BillOfOperationsType
                                                                         and $projection.BillOfOperationsGroup    = _RoutingStatusText.BillOfOperationsGroup
                                                                         and $projection.BillOfOperationsVariant  = _RoutingStatusText.BillOfOperationsVariant
                                                                         and _RoutingStatusText.ValidityStartDate <= $session.system_date
                                                                         and _RoutingStatusText.ValidityEndDate   >= $session.system_date
{
  key    Material                                   as Material,
  key    Plant                                      as Plant,
  key    cast ( ' ' as abap.char(20) )              as RecommendedProductionVersion,
  key    ProductionVersion                          as ProductionVersion,
         cast ( ProductionVersion as abap.char(8) ) as LinkedProductionVersionAll,
         BillOfMaterialVariant                      as BillOfMaterialVariant, //Alt Bom

         BillOfOperationsGroup                      as BillOfOperationsGroup,
         BillOfOperationsVariant                    as BillOfOperationsVariant, //Task List Type

         BillOfOperationsType                       as BillOfOperationsType,
         BillOfMaterialVariantUsage                 as BillOfMaterialVariantUsage,
         _MaterialText.MaterialName                 as MaterialName,
         _Plant.PlantName                           as PlantName,
         ProductionVersionText                      as ProductionVersionText,
         cast ( ' ' as abap.char(1) )               as ProducerEventType,
         cast ( ' ' as abap.char(1) )               as ProducerBusinessObjectType,
         _BillOfMaterial.BOMHeaderText              as BOMHeaderText,
         _RoutingStatusText.BillOfOperationsDesc    as BillOfOperationsDesc
}

union all select from R_RecmddProductionVersionTP

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

//                                                                       and $projection.Plant                       = _BillOfMaterial.Plant

//                                                                       and $projection.BillOfMaterialVariant       = _BillOfMaterial.BillOfMaterialVariant

//                                                                       and _BillOfMaterial.HeaderValidityStartDate <= $session.system_date

//                                                                       and _BillOfMaterial.HeaderValidityEndDate   >= $session.system_date


association [1..1] to I_MfgBillOfOperationsChgSt as _RoutingStatusText on  $projection.BillOfOperationsType     = _RoutingStatusText.BillOfOperationsType
                                                                       and $projection.BillOfOperationsGroup    = _RoutingStatusText.BillOfOperationsGroup
                                                                       and $projection.BillOfOperationsVariant  = _RoutingStatusText.BillOfOperationsVariant
                                                                       and _RoutingStatusText.ValidityStartDate <= $session.system_date
                                                                       and _RoutingStatusText.ValidityEndDate   >= $session.system_date

{
  key    Material                                as Material,
  key    Plant                                   as Plant,
  key    RecommendedProductionVersion            as RecommendedProductionVersion,
  key    cast ( ' ' as abap.char(4) )            as ProductionVersion,
         RecommendedProductionVersion            as LinkedProductionVersionAll,
         BillOfMaterialVariant                   as BillOfMaterialVariant,
         BillOfOperationsGroup                   as BillOfOperationsGroup,
         BillOfOperationsVariant                 as BillOfOperationsVariant,
         BillOfOperationsType                    as BillOfOperationsType,
         BillOfMaterialVariantUsage              as BillOfMaterialVariantUsage,
         _MaterialText.MaterialName              as MaterialName,
         _Plant.PlantName                        as PlantName,
         ProductionVersionText                   as ProductionVersionText,
         ProducerEventType                       as ProducerEventType,
         ProducerBusinessObjectType              as ProducerBusinessObjectType,
         _MaterialBOM.BOMHeaderText              as BOMHeaderText,
         _RoutingStatusText.BillOfOperationsDesc as BillOfOperationsDesc
}

Learn More