C_LinkedProdnVersBOO

DDL: C_LINKEDPRODNVERSBOO Type: view_entity CONSUMPTION

BOO to Material Assignment for ProdnVers

C_LinkedProdnVersBOO is a Consumption CDS View that provides data about "BOO to Material Assignment for ProdnVers" in SAP S/4HANA. It reads from 4 data sources (I_MasterRecipeHeader, I_MasterRecipeHeader, I_ProductionRouting, I_MasterRecipe) and exposes 31 fields with key fields Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. It has 1 association to related views.

4 data source(s) 31 fields

Data Sources (4)

SourceAliasJoin Type
I_MasterRecipeHeader plko from
I_MasterRecipeHeader plko union
I_ProductionRouting plkz inner
I_MasterRecipe plkz inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdnRoutingMatlAssgmtTP _MatlAssgmt $projection.BillOfOperationsGroup = _MatlAssgmt.ProductionRoutingGroup and $projection.BillOfOperationsVariant = _MatlAssgmt.ProductionRouting and $projection.ValidityEndDate >= _MatlAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _MatlAssgmt.ValidityEndDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BOO to Material Assignment for ProdnVers view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Material _MatlAssgmt Product
KEY Plant _MatlAssgmt Plant
KEY BillOfOperationsType I_MasterRecipe BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_MasterRecipe BillOfOperationsGroup Task List Group
KEY BillOfOperationsVariant I_MasterRecipe BillOfOperationsVariant Task List Counter
KEY ProductionRoutingInternalVers I_MasterRecipeHeader BOOInternalVersionCounter
BillOfOperationsDesc I_MasterRecipeHeader BillOfOperationsDesc Description
BillOfOperationsStatus I_MasterRecipeHeader BillOfOperationsStatus Overall Status
BillOfOperationsUsage I_MasterRecipeHeader BillOfOperationsUsage Usage
ValidityStartDate I_MasterRecipeHeader ValidityStartDate Valid From
ValidityEndDate I_MasterRecipeHeader ValidityEndDate Valid To
BillOfOperationsUnit I_MasterRecipeHeader BillOfOperationsUnit
MinimumLotSizeQuantity I_MasterRecipeHeader MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity I_MasterRecipeHeader MaximumLotSizeQuantity Maximum Lot Size
BillOfOperationsUsageDesc _UsageText BillOfOperationsUsageDesc
ProductasMaterial
KEY Plant _MatlAssgmt Plant
KEY BillOfOperationsType I_MasterRecipe BillOfOperationsType
KEY BillOfOperationsGroup I_MasterRecipe BillOfOperationsGroup
KEY BillOfOperationsVariant I_MasterRecipe BillOfOperationsVariant
KEY ProductionRoutingInternalVers I_MasterRecipeHeader BOOInternalVersionCounter
BillOfOperationsDesc I_MasterRecipeHeader BillOfOperationsDesc
BillOfOperationsStatus I_MasterRecipeHeader BillOfOperationsStatus
BillOfOperationsUsage I_MasterRecipeHeader BillOfOperationsUsage
ValidityStartDate I_MasterRecipeHeader ValidityStartDate
ValidityEndDate I_MasterRecipeHeader ValidityEndDate
BillOfOperationsUnit I_MasterRecipeHeader BillOfOperationsUnit
MinimumLotSizeQuantity I_MasterRecipeHeader MinimumLotSizeQuantity
MaximumLotSizeQuantity I_MasterRecipeHeader MaximumLotSizeQuantity
BillOfOperationsUsageDesc _UsageText BillOfOperationsUsageDesc
BillOfOperationsStatusDesc _StatusText BillOfOperationsStatusDesc 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BOO to Material Assignment for ProdnVers'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{ serviceQuality: #X, sizeCategory: #S, dataClass: #MIXED }
@Metadata.allowExtensions: true

define view entity C_LinkedProdnVersBOO
  as select distinct from I_RoutingHeader     as plko
    inner join            I_ProductionRouting as plkz on  plko.BillOfOperationsType    = plkz.BillOfOperationsType
                                                      and plko.BillOfOperationsGroup   = plkz.BillOfOperationsGroup
                                                      and plko.BillOfOperationsVariant = plkz.BillOfOperationsVariant

  association [0..*] to I_ProdnRoutingMatlAssgmtTP   as _MatlAssgmt on  $projection.BillOfOperationsGroup   =  _MatlAssgmt.ProductionRoutingGroup
                                                                    and $projection.BillOfOperationsVariant =  _MatlAssgmt.ProductionRouting
                                                                    and $projection.ValidityEndDate         >= _MatlAssgmt.ValidityStartDate
                                                                    and $projection.ValidityStartDate       <= _MatlAssgmt.ValidityEndDate

  association        to I_BillOfOperationsUsageText  as _UsageText  on  $projection.BillOfOperationsUsage = _UsageText.BillOfOperationsUsage
                                                                    and _UsageText.Language               = $session.system_language

  association        to I_BillOfOperationsStatusText as _StatusText on  $projection.BillOfOperationsStatus = _StatusText.BillOfOperationsStatus
                                                                    and _StatusText.Language               = $session.system_language

{
  key _MatlAssgmt.Product                    as Material,
  key _MatlAssgmt.Plant                      as Plant,
      @EndUserText.label: 'Task List Type'
  key plkz.BillOfOperationsType              as BillOfOperationsType,
      @EndUserText.label: 'Task List Group'
  key plkz.BillOfOperationsGroup             as BillOfOperationsGroup,
      @EndUserText.label: 'Task List Counter'
  key plkz.BillOfOperationsVariant           as BillOfOperationsVariant,
  key plko.BOOInternalVersionCounter         as ProductionRoutingInternalVers,
      @EndUserText.label: 'Description'
      plko.BillOfOperationsDesc              as BillOfOperationsDesc,
      @EndUserText.label: 'Overall Status'
      @ObjectModel.text.element: ['BillOfOperationsStatusDesc']
      plko.BillOfOperationsStatus            as BillOfOperationsStatus,
      @EndUserText.label: 'Usage'
      @ObjectModel.text.element: ['BillOfOperationsUsageDesc']
      plko.BillOfOperationsUsage             as BillOfOperationsUsage,
      @EndUserText.label: 'Valid From'
      plko.ValidityStartDate                 as ValidityStartDate,
      @EndUserText.label: 'Valid To'
      plko.ValidityEndDate                   as ValidityEndDate,
      plko.BillOfOperationsUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      @EndUserText.label: 'Minimum Lot Size'
      plko.MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      @EndUserText.label: 'Maximum Lot Size'
      plko.MaximumLotSizeQuantity,
      _UsageText.BillOfOperationsUsageDesc   as BillOfOperationsUsageDesc,
      _StatusText.BillOfOperationsStatusDesc as BillOfOperationsStatusDesc

}
where
      plko.BillOfOperationsType = 'N'
  and plko.ValidityEndDate      > plko.ValidityStartDate

union select from I_MasterRecipeHeader as plko
  inner join      I_MasterRecipe       as plkz on  plko.BillOfOperationsType    = plkz.BillOfOperationsType
                                               and plko.BillOfOperationsGroup   = plkz.BillOfOperationsGroup
                                               and plko.BillOfOperationsVariant = plkz.BillOfOperationsVariant

association [0..*] to I_MasterRecipeMaterialAssgmtTP as _MatlAssgmt on  $projection.BillOfOperationsGroup   =  _MatlAssgmt.MasterRecipeGroup
                                                                    and $projection.BillOfOperationsVariant =  _MatlAssgmt.MasterRecipe
                                                                    and $projection.ValidityEndDate         >= _MatlAssgmt.ValidityStartDate
                                                                    and $projection.ValidityStartDate       <= _MatlAssgmt.ValidityEndDate

association        to I_BillOfOperationsUsageText    as _UsageText  on  $projection.BillOfOperationsUsage = _UsageText.BillOfOperationsUsage
                                                                    and _UsageText.Language               = $session.system_language

association        to I_BillOfOperationsStatusText   as _StatusText on  $projection.BillOfOperationsStatus = _StatusText.BillOfOperationsStatus
                                                                    and _StatusText.Language               = $session.system_language

{
  key _MatlAssgmt.Product                    as Material,
  key _MatlAssgmt.Plant                      as Plant,
  key plkz.BillOfOperationsType              as BillOfOperationsType,
  key plkz.BillOfOperationsGroup             as BillOfOperationsGroup,
  key plkz.BillOfOperationsVariant           as BillOfOperationsVariant,
  key plko.BOOInternalVersionCounter         as ProductionRoutingInternalVers,
      plko.BillOfOperationsDesc              as BillOfOperationsDesc,
      plko.BillOfOperationsStatus            as BillOfOperationsStatus,
      plko.BillOfOperationsUsage             as BillOfOperationsUsage,
      plko.ValidityStartDate                 as ValidityStartDate,
      plko.ValidityEndDate                   as ValidityEndDate,
      plko.BillOfOperationsUnit,
      plko.MinimumLotSizeQuantity,
      plko.MaximumLotSizeQuantity,

      _UsageText.BillOfOperationsUsageDesc   as BillOfOperationsUsageDesc,
      _StatusText.BillOfOperationsStatusDesc as BillOfOperationsStatusDesc

}

where
      plko.BillOfOperationsType = '2'
  and plko.ValidityEndDate      > plko.ValidityStartDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSSTATUSTEXT",
"I_BILLOFOPERATIONSUSAGETEXT",
"I_MASTERRECIPE",
"I_MASTERRECIPEHEADER",
"I_MASTERRECIPEMATERIALASSGMTTP",
"I_PRODNROUTINGMATLASSGMTTP",
"I_PRODUCTIONROUTING",
"I_ROUTINGHEADER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More