I_MfgOrderForSplitInfo

DDL: I_MFGORDERFORSPLITINFO SQL: IMFGORDSPLITINFO Type: view COMPOSITE

Order info relevant for executing an order split

I_MfgOrderForSplitInfo is a Composite CDS View that provides data about "Order info relevant for executing an order split" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderBasic) and exposes 9 fields with key field ManufacturingOrder. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderBasic MfgOrderBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Plant _ProductionPlant $projection.ProductionPlant = _ProductionPlant.Plant

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMFGORDSPLITINFO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Order info relevant for executing an order split view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_MfgOrderBasic ManufacturingOrder
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType
ProductionPlant I_MfgOrderBasic ProductionPlant
OrderHasParallelSequence
OrderHasReworkOperation
_MfgOrderCategory I_MfgOrderBasic _MfgOrderCategory
_MfgOrderType I_MfgOrderBasic _MfgOrderType
_ProductionPlant _ProductionPlant 
@AbapCatalog.sqlViewName: 'IMFGORDSPLITINFO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Order info relevant for executing an order split'
define view I_MfgOrderForSplitInfo
  as select from           I_MfgOrderBasic               as MfgOrderBasic
    left outer to one join P_MfgOrderHasParallelSequence as MfgOrderHasParallelSequence on MfgOrderHasParallelSequence.ManufacturingOrder = MfgOrderBasic.ManufacturingOrder
    left outer to one join P_MfgOrderHasReworkOperation  as MfgOrderHasReworkOperation  on MfgOrderHasReworkOperation.ManufacturingOrder = MfgOrderBasic.ManufacturingOrder
  association [1..1] to I_Plant as _ProductionPlant on $projection.ProductionPlant = _ProductionPlant.Plant
{
  key MfgOrderBasic.ManufacturingOrder,
      MfgOrderBasic.ManufacturingOrderCategory,
      MfgOrderBasic.ManufacturingOrderType,
      @ObjectModel.foreignKey.association: '_ProductionPlant'
      MfgOrderBasic.ProductionPlant,
      coalesce(MfgOrderHasParallelSequence.OrderHasParallelSequence, '') as OrderHasParallelSequence,
      coalesce(MfgOrderHasReworkOperation.OrderHasReworkOperation, '')   as OrderHasReworkOperation,

      MfgOrderBasic._MfgOrderCategory,
      MfgOrderBasic._MfgOrderType,
      _ProductionPlant
}

Learn More