C_MfgOrderSplitOrderDetail

DDL: C_MFGORDERSPLITORDERDETAIL SQL: CMFGORDEROFSPLIT Type: view CONSUMPTION

Details of an order of a manufacturing order split

C_MfgOrderSplitOrderDetail is a Consumption CDS View that provides data about "Details of an order of a manufacturing order split" in SAP S/4HANA. It reads from 2 data sources (I_ManufacturingOrder, P_MfgOrderSplitOrder) and exposes 20 fields with key field ManufacturingOrder. It has 4 associations to related views.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_ManufacturingOrder ManufacturingOrder inner
P_MfgOrderSplitOrder MfgOrderSplitOrder from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ManufacturingOrder _ManufacturingOrder $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
[1..1] I_ManufacturingOrder _ParentOrder $projection.MfgOrderSplitParentOrder = _ParentOrder.ManufacturingOrder
[1..1] I_ManufacturingOrder _LeadingOrder $projection.MfgOrderSplitLeadingOrder = _LeadingOrder.ManufacturingOrder
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMFGORDEROFSPLIT 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 #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
EndUserText.label Details of an order of a manufacturing order split view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder P_MfgOrderSplitOrder ManufacturingOrder
MfgOrderSplitParentOrder P_MfgOrderSplitOrder MfgOrderSplitParentOrder
MfgOrderSplitLeadingOrder P_MfgOrderSplitOrder MfgOrderSplitLeadingOrder
ProductionPlant I_ManufacturingOrder ProductionPlant
ManufacturingOrderType I_ManufacturingOrder ManufacturingOrderType
ManufacturingOrderCategory I_ManufacturingOrder ManufacturingOrderCategory
ProductionUnit I_ManufacturingOrder ProductionUnit
MfgOrderPlannedTotalQty I_ManufacturingOrder MfgOrderPlannedTotalQty
Material I_ManufacturingOrder Material
MaterialName
WBSElementInternalID
WBSElementExternalID _WBSElement WBSElementExternalID
_ManufacturingOrder _ManufacturingOrder
_ParentOrder _ParentOrder
_LeadingOrder _LeadingOrder
_WBSElement _WBSElement
_ProductionPlant I_ManufacturingOrder _ProductionPlant
_MfgOrderType I_ManufacturingOrder _MfgOrderType
_MfgOrderCategory I_ManufacturingOrder _MfgOrderCategory
_Material I_ManufacturingOrder _Material 
@AbapCatalog.sqlViewName: 'CMFGORDEROFSPLIT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Details of an order of a manufacturing order split'
define view C_MfgOrderSplitOrderDetail
  as select from P_MfgOrderSplitOrder as MfgOrderSplitOrder
    inner join   I_ManufacturingOrder as ManufacturingOrder on ManufacturingOrder.ManufacturingOrder = MfgOrderSplitOrder.ManufacturingOrder

  association [1..1] to I_ManufacturingOrder  as _ManufacturingOrder on $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
  association [1..1] to I_ManufacturingOrder  as _ParentOrder        on $projection.MfgOrderSplitParentOrder = _ParentOrder.ManufacturingOrder
  association [1..1] to I_ManufacturingOrder  as _LeadingOrder       on $projection.MfgOrderSplitLeadingOrder = _LeadingOrder.ManufacturingOrder
  association [0..1] to I_WBSElementBasicData as _WBSElement         on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

{
      @ObjectModel.foreignKey.association: '_ManufacturingOrder'
  key MfgOrderSplitOrder.ManufacturingOrder,
      @ObjectModel.foreignKey.association: '_ParentOrder'
      MfgOrderSplitOrder.MfgOrderSplitParentOrder,
      @ObjectModel.foreignKey.association: '_LeadingOrder'
      MfgOrderSplitOrder.MfgOrderSplitLeadingOrder,
      ManufacturingOrder.ProductionPlant,
      ManufacturingOrder.ManufacturingOrderType,
      ManufacturingOrder.ManufacturingOrderCategory,
      @UI.hidden: true
      ManufacturingOrder.ProductionUnit,
      ManufacturingOrder.MfgOrderPlannedTotalQty,
      @ObjectModel.text.element: 'MaterialName'
      ManufacturingOrder.Material,
      @UI.hidden: true
      ManufacturingOrder._Material._Text[1: Language=$session.system_language].MaterialName,
      @UI.hidden: true
      cast(ManufacturingOrder.WBSElementInternalID as ps_s4_pspnr preserving type ) as WBSElementInternalID,
      _WBSElement.WBSElementExternalID,

      _ManufacturingOrder,
      _ParentOrder,
      _LeadingOrder,
      _WBSElement,
      ManufacturingOrder._ProductionPlant,
      ManufacturingOrder._MfgOrderType,
      ManufacturingOrder._MfgOrderCategory,
      ManufacturingOrder._Material

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_WBSELEMENTBASICDATA",
"P_MFGORDERSPLITORDER"
],
"ASSOCIATED":
[
"I_MANUFACTURINGORDER",
"I_MATERIAL",
"I_MFGORDERCATEGORY",
"I_MFGORDERTYPE",
"I_PLANT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_MANUFACTURINGORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More