I_MfgOrderSplitChildOrderDet

DDL: I_MFGORDERSPLITCHILDORDERDET SQL: IMFGORDSPLITDET Type: view COMPOSITE
20 Fields 1 Data Sources 1 Associations

Child order details of a order split

I_MfgOrderSplitChildOrderDet is a Composite CDS View that provides data about "Child order details of a order split" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderSplitChildOrder) and exposes 20 fields with key fields MfgOrderSplitChildOrder, MfgOrderSplitByProduct, MfgOrderSplitByProductBatch. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderSplitChildOrder MfgOrderSplitChildOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SerialNumberManufacturingOrd _SerialNumberManufacturingOrd _SerialNumberManufacturingOrd.ManufacturingOrder = MfgOrderSplitChildOrder.MfgOrderSplitChildOrder and _SerialNumberManufacturingOrd.ManufacturingOrderItem = '0001'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMFGORDSPLITDET 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 #COMPOSITE view
EndUserText.label Child order details of a order split view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderSplitChildOrder I_MfgOrderSplitChildOrder MfgOrderSplitChildOrder Child Order
KEY MfgOrderSplitByProduct I_MfgOrderSplitChildOrder MfgOrderSplitByProduct By-Product
KEY MfgOrderSplitByProductBatch I_MfgOrderSplitChildOrder MfgOrderSplitByProductBatch
Material
MfgOrderPlannedTotalQty
ProductionUnit
InspectionLot
NumberOfSerialNumbers
SerialNumber MfgOrdItmNmbrOfSerialNumbers SerialNumber Serial Number
MfgOrderSplitParentOrder I_MfgOrderSplitChildOrder MfgOrderSplitParentOrder ParentOrder
MfgOrderSplitLeadingOrder I_MfgOrderSplitChildOrder MfgOrderSplitLeadingOrder Leading Order
_ByProduct I_MfgOrderSplitChildOrder _ByProduct
_ByProductBatch I_MfgOrderSplitChildOrder _ByProductBatch
_ChildOrder I_MfgOrderSplitChildOrder _ChildOrder
_Material
_ProductionUnit
_InspectionLot
_LeadingOrder I_MfgOrderSplitChildOrder _LeadingOrder
_ParentOrder I_MfgOrderSplitChildOrder _ParentOrder
_SerialNumberManufacturingOrd _SerialNumberManufacturingOrd

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MfgOrderSplitChildOrderDet.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMFGORDSPLITDET

CREATE VIEW I_MfgOrderSplitChildOrderDet AS
SELECT
  MfgOrderSplitChildOrder.MfgOrderSplitChildOrder AS MfgOrderSplitChildOrder,
  MfgOrderSplitChildOrder.MfgOrderSplitByProduct AS MfgOrderSplitByProduct,
  MfgOrderSplitChildOrder.MfgOrderSplitByProductBatch AS MfgOrderSplitByProductBatch,
  MfgOrderSplitChildOrder._ChildOrder.Material AS Material,
  MfgOrderSplitChildOrder._ChildOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrderSplitChildOrder._ChildOrder.ProductionUnit AS ProductionUnit,
  MfgOrderSplitChildOrder._ChildOrder.InspectionLot AS InspectionLot,
  cast(MfgOrdItmNmbrOfSerialNumbers.NumberOfSerialNumbers as anzsn preserving type ) AS NumberOfSerialNumbers,
  MfgOrdItmNmbrOfSerialNumbers.SerialNumber AS SerialNumber,
  MfgOrderSplitChildOrder.MfgOrderSplitParentOrder AS MfgOrderSplitParentOrder,
  MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder AS MfgOrderSplitLeadingOrder,
  MfgOrderSplitChildOrder._ByProduct AS _ByProduct,
  MfgOrderSplitChildOrder._ByProductBatch AS _ByProductBatch,
  MfgOrderSplitChildOrder._ChildOrder AS _ChildOrder,
  MfgOrderSplitChildOrder._ChildOrder._Material AS _Material,
  MfgOrderSplitChildOrder._ChildOrder._ProductionUnit AS _ProductionUnit,
  MfgOrderSplitChildOrder._ChildOrder._InspectionLot AS _InspectionLot,
  MfgOrderSplitChildOrder._LeadingOrder AS _LeadingOrder,
  MfgOrderSplitChildOrder._ParentOrder AS _ParentOrder
FROM I_MfgOrderSplitChildOrder AS MfgOrderSplitChildOrder
LEFT OUTER JOIN I_SerialNumberManufacturingOrd AS _SerialNumberManufacturingOrd ON _SerialNumberManufacturingOrd.ManufacturingOrder = MfgOrderSplitChildOrder.MfgOrderSplitChildOrder AND _SerialNumberManufacturingOrd.ManufacturingOrderItem = '0001'  -- association [0..*]
;

Learn More