C_ProdnRtgVersWrkflwInbox

DDL: C_PRODNRTGVERSWRKFLWINBOX SQL: CPRODRTGVERINBOX Type: view CONSUMPTION

Production Routing Workflow MyInbox

C_ProdnRtgVersWrkflwInbox is a Consumption CDS View that provides data about "Production Routing Workflow MyInbox" in SAP S/4HANA. It reads from 1 data source (I_ProductionRoutingVersion) and exposes 16 fields with key field BillOfOperationsKey. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionRoutingVersion I_ProductionRoutingVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BOOVersionStatusText _BOOVersionStatusText $projection.BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRODRTGVERINBOX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production Routing Workflow MyInbox view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName BillOfOperationsGroup view
UI.headerInfo.typeNamePlural BillOfOperationsGroup view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Routing Group view
UI.headerInfo.title.value BillOfOperationsGroup view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value BillOfOperationsDesc view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsKey
BillOfOperations
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsVersion BillOfOperationsVersion
BillOfOperationsVariant BillOfOperationsVariant
BillOfOperationsType BillOfOperationsType
BillOfOperationsStatus BillOfOperationsStatus
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsDesc BillOfOperationsDesc
BillOfOperationsVersionStatus BillOfOperationsVersionStatus
Plant Plant
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_BOOVersionStatusText _BOOVersionStatusText 
@AbapCatalog.sqlViewName: 'CPRODRTGVERINBOX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Routing Workflow MyInbox'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER}

@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.headerInfo: {
        typeName: 'BillOfOperationsGroup',
        typeNamePlural: 'BillOfOperationsGroup',
        title: {
            type: #STANDARD,
            label: 'Routing Group',
            value: 'BillOfOperationsGroup'
        },
        description: {
            type: #STANDARD,
            value: 'BillOfOperationsDesc'
        }
}
define view C_ProdnRtgVersWrkflwInbox
  as select from I_ProductionRoutingVersion
  association [0..*] to I_BOOVersionStatusText as _BOOVersionStatusText on $projection.BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus
{
      @UI.hidden: true  
  key concat(concat(BillOfOperationsType, BillOfOperationsGroup), concat(BillOfOperationsVariant, BillOfOperationsVersion)) as   BillOfOperationsKey,
      
      @UI.identification: [{position: 10, label: 'Routing' }]
      @Consumption: { semanticObject: 'ShopFloorRouting'} 
      concat(concat(BillOfOperationsGroup, ('-')), concat(BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion))) as   BillOfOperations,
      

      BillOfOperationsGroup,
      BillOfOperationsVersion,
      BillOfOperationsVariant,
      BillOfOperationsType,
      BillOfOperationsStatus,
      BillOfOperationsUsage,
      
      @UI.identification: [{position: 20}]
      BillOfOperationsDesc,
      
      @UI.identification: [{position: 30}]
      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_BOOVersionStatusText'
      BillOfOperationsVersionStatus,
      
      @UI.identification: [{position: 40}]
      Plant,

//      @UI.identification: [{position: 57}]

//      case

//      when BillOfOperationsVersionStatus = '10'

//      then 2

//      when BillOfOperationsVersionStatus = '20'

//      then 3

//      else 1

//      end    as  BOOVersionStatusCriticality,

      
      @UI.identification: [{position: 50}]
      CreationDateTime,
      @UI.identification: [{position: 60}]
      CreatedByUser,
      @UI.identification: [{position: 70}]
      LastChangeDateTime,
      @UI.identification: [{position: 80}]
      LastChangedByUser,
      _BOOVersionStatusText
     
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONROUTINGVERSION"
],
"ASSOCIATED":
[
"I_BOOVERSIONSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More