I_ProjectProductionOrder

DDL: I_PROJECTPRODUCTIONORDER Type: view_entity BASIC

Project Production Order

I_ProjectProductionOrder is a Basic CDS View (Dimension) that provides data about "Project Production Order" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 4 fields with key field ProductionOrder.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrder I_ManufacturingOrder from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Production Order view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Consumption.ranked true view
Metadata.allowExtensions true view
ObjectModel.representativeKey ProductionOrder view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProductionOrder ManufacturingOrder
ManufacturingOrderCategory ManufacturingOrderCategory
ProductionPlant ProductionPlant
ManufacturingOrderType ManufacturingOrderType
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Project Production Order'
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@Consumption.ranked: true
@Metadata.allowExtensions: true
@ObjectModel.representativeKey: 'ProductionOrder'
@ObjectModel.semanticKey: ['ProductionOrder']
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@Search.searchable: true
@VDM.viewType: #BASIC
define view entity I_ProjectProductionOrder
  as select from I_ManufacturingOrder
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.text.element: [ 'OrderDescription' ]
  key ManufacturingOrder         as ProductionOrder,
      ManufacturingOrderCategory,
      @Search: { defaultSearchElement: true, ranking: #LOW }
      @Semantics.text: true
      //      cast(ManufacturingOrderText as pph_auftext preserving type) as OrderDescription,

      //      cast(_Product._Text[1: Language = $session.system_language].ProductName as pph_auftext preserving type ) as OrderDescription,

      case
      when ManufacturingOrderText = ''
      then
      cast(_Product._Text[1: Language = $session.system_language].ProductName as pph_auftext preserving type )
      else
      ManufacturingOrderText end as OrderDescription,
      ProductionPlant,
      ManufacturingOrderType
}
where
  ManufacturingOrderCategory = '10'