I_MfgOrderOrderReport

DDL: I_MFGORDERORDERREPORT Type: view_entity COMPOSITE Package: ODATA_PP_MULTILVL_ORDER_REPORT

Order Report Manufacturing Order

I_MfgOrderOrderReport is a Composite CDS View that provides data about "Order Report Manufacturing Order" in SAP S/4HANA. It reads from 2 data sources (I_ManufacturingOrder, I_MfgOrderWithStatus) and exposes 2 fields with key fields ManufacturingOrder, ManufacturingOrderItem. Part of development package ODATA_PP_MULTILVL_ORDER_REPORT.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_ManufacturingOrder header from
I_MfgOrderWithStatus OrdData inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Order Report Manufacturing Order view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable false view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_ManufacturingOrder ManufacturingOrder
KEY ManufacturingOrderItem I_ManufacturingOrder ManufacturingOrderItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Order Report Manufacturing Order'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #MIXED}
@Search.searchable: false
@VDM.viewType:  #COMPOSITE
define view entity I_MfgOrderOrderReport
  as select from I_ManufacturingOrder     as header
    inner join   I_MfgOrderWithStatus as OrdData on header.ManufacturingOrder = OrdData.ManufacturingOrder
{
  key header.ManufacturingOrder,
  key header.ManufacturingOrderItem
}
where
      OrdData.OrderIsTechnicallyCompleted <> 'X'
  and OrdData.OrderIsDelivered            <> 'X'
  and OrdData.OrderIsDeleted              <> 'X'
  and OrdData.OrderIsClosed               <> 'X'
  and OrdData.OrderIsMarkedForDeletion    <> 'X'

Learn More