C_LinkedProductionVersionAll

DDL: C_LINKEDPRODUCTIONVERSIONALL Type: view_entity CONSUMPTION

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 (R_ProductionVersionTP, R_RecmddProductionVersionTP) and exposes 33 fields with key fields Material, Plant, RecommendedProductionVersion, ProductionVersion, Plant. It has 2 associations to related views.

2 data source(s) 33 fields

Data Sources (2)

SourceAliasJoin Type
R_ProductionVersionTP R_ProductionVersionTP from
R_RecmddProductionVersionTP R_RecmddProductionVersionTP union

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_LinkedProdnVersBOM _BillOfMaterial $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and _BillOfMaterial.ValidityStartDate <= $session.system_date and _BillOfMaterial.ValidityEndDate >= $session.system_date
[1..1] C_LinkedProdnVersBOO _RoutingStatusText $projection.Material = _RoutingStatusText.Material and $projection.Plant = _RoutingStatusText.Plant and $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 #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

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 MaterialName
PlantName 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 _BillOfMaterial 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: #X, sizeCategory: #XL, dataClass: #MIXED }
@Metadata.allowExtensions: true

define view entity C_LinkedProductionVersionAll
  as select from R_ProductionVersionTP

  association [1..1] to C_LinkedProdnVersBOM as _BillOfMaterial    on  $projection.Material              = _BillOfMaterial.Material
                                                                   and $projection.Plant                 = _BillOfMaterial.Plant
                                                                   and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant
                                                                   and _BillOfMaterial.ValidityStartDate <= $session.system_date
                                                                   and _BillOfMaterial.ValidityEndDate   >= $session.system_date

  association [1..1] to C_LinkedProdnVersBOO as _RoutingStatusText on  $projection.Material                 = _RoutingStatusText.Material
                                                                   and $projection.Plant                    = _RoutingStatusText.Plant
                                                                   and $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(8) )               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,
         MaterialName                               as MaterialName,
         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 select from R_RecmddProductionVersionTP

association [1..1] to C_LinkedProdnVersBOM as _BillOfMaterial    on  $projection.Material              = _BillOfMaterial.Material
                                                                 and $projection.Plant                 = _BillOfMaterial.Plant
                                                                 and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant
                                                                 and _BillOfMaterial.ValidityStartDate <= $session.system_date
                                                                 and _BillOfMaterial.ValidityEndDate   >= $session.system_date

association [1..1] to C_LinkedProdnVersBOO as _RoutingStatusText on  $projection.Material                 = _RoutingStatusText.Material
                                                                 and $projection.Plant                    = _RoutingStatusText.Plant
                                                                 and $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,
         _BillOfMaterial.BOMHeaderText           as BOMHeaderText,
         _RoutingStatusText.BillOfOperationsDesc as BillOfOperationsDesc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_LINKEDPRODNVERSBOM",
"C_LINKEDPRODNVERSBOO",
"I_MATERIALTEXT",
"I_PLANT",
"R_PRODUCTIONVERSIONTP",
"R_RECMDDPRODUCTIONVERSIONTP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More