C_LinkedProdnVersBOO

DDL: C_LINKEDPRODNVERSBOO Type: view_entity CONSUMPTION Package: ODATA_PP_PRODNVERS_API

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 1 data source (I_MfgBillOfOperationsChgSt) and exposes 16 fields with key fields Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. 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.

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

Data Sources (1)

SourceAliasJoin Type
I_MfgBillOfOperationsChgSt plko inner

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 #B view
ObjectModel.usageType.sizeCategory #S 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 (16)

KeyFieldSource TableSource FieldDescription
KEY Material _MatlAssgmt Product
KEY Plant _MatlAssgmt Plant
KEY BillOfOperationsType I_MfgBillOfOperationsChgSt BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_MfgBillOfOperationsChgSt BillOfOperationsGroup Task List Group
KEY BillOfOperationsVariant I_MfgBillOfOperationsChgSt BillOfOperationsVariant Task List Counter
KEY ProductionRoutingInternalVers I_MfgBillOfOperationsChgSt BOOInternalVersionCounter
BillOfOperationsDesc I_MfgBillOfOperationsChgSt BillOfOperationsDesc Description
BillOfOperationsStatus I_MfgBillOfOperationsChgSt BillOfOperationsStatus Overall Status
BillOfOperationsUsage I_MfgBillOfOperationsChgSt BillOfOperationsUsage Usage
ValidityStartDate I_MfgBillOfOperationsChgSt ValidityStartDate Valid From
ValidityEndDate I_MfgBillOfOperationsChgSt ValidityEndDate Valid To
BillOfOperationsUnit I_MfgBillOfOperationsChgSt BillOfOperationsUnit
MinimumLotSizeQuantity I_MfgBillOfOperationsChgSt MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity I_MfgBillOfOperationsChgSt MaximumLotSizeQuantity Maximum Lot Size
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: #B, sizeCategory: #S, dataClass: #MIXED }
@Metadata.allowExtensions: true
@Consumption.dbHints:['USE_HEX_PLAN']

define view entity C_LinkedProdnVersBOO
  as select distinct from I_MfgBOOMaterialAssgmtChgSt as _MatlAssgmt
    inner join            I_MfgBillOfOperationsChgSt  as plko on  plko.BillOfOperationsType    =  _MatlAssgmt.BillOfOperationsType
                                                              and plko.BillOfOperationsGroup   =  _MatlAssgmt.BillOfOperationsGroup
                                                              and plko.BillOfOperationsVariant =  _MatlAssgmt.BillOfOperationsVariant
                                                              and plko.ValidityEndDate         >= _MatlAssgmt.ValidityStartDate
                                                              and plko.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 plko.BillOfOperationsType              as BillOfOperationsType,
      @EndUserText.label: 'Task List Group'
  key plko.BillOfOperationsGroup             as BillOfOperationsGroup,
      @EndUserText.label: 'Task List Counter'
  key plko.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       =  '2' // Recipe

    or plko.BillOfOperationsType       =  'N' // Standard routing

  )

  and  plko.ValidityEndDate            >  plko.ValidityStartDate
  and  _MatlAssgmt.IsDeleted           <> 'X'
  and  _MatlAssgmt.IsImplicitlyDeleted <> 'X'

Learn More