C_LinkedProdnVersBOO

Q: Which tables does C_LinkedProdnVersBOO use?

C_LinkedProdnVersBOO reads from 4 data source(s): I_MasterRecipeHeader, I_MasterRecipeHeader, I_ProductionRouting, I_MasterRecipe.

Q: How many fields does C_LinkedProdnVersBOO have?

C_LinkedProdnVersBOO has 31 fields. Key fields: Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant.

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. It is exposed through 1 OData service (UI_PRODUCTIONVERSION). It is used in 1 Fiori application: Process Production Versions.

Data Sources (4)

Source	Alias	Join Type
I_MasterRecipeHeader	plko	from
I_MasterRecipeHeader	plko	union
I_ProductionRouting	plkz	inner
I_MasterRecipe	plkz	inner

Associations (1)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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

OData Services (1)

Service	Binding	Version	Contract	Release
UI_PRODUCTIONVERSION	UI_PRODUCTIONVERSION	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
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 (31)

Key	Field	Source Table	Source Field	Description
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

Depth:

C_LinkedProdnVersBOO view_entity