P_MFGORDERSPLITORDER
Order belonging to a Manufacturing Split
P_MFGORDERSPLITORDER is a CDS View in S/4HANA. Order belonging to a Manufacturing Split. It contains 3 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MfgOrderSplitOrderDetail | view | from | CONSUMPTION | Details of an order of a manufacturing order split |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ManufacturingOrder | ManufacturingOrder | 1 |
| MfgOrderSplitLeadingOrder | MfgOrderSplitLeadingOrder | 1 | |
| MfgOrderSplitParentOrder | MfgOrderSplitParentOrder | 1 |
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_MfgOrderSplitOrder
as
-- Select all Children
select distinct from I_MfgOrderSplitChildOrder as MfgOrderSplitChildOrder
{
key MfgOrderSplitChildOrder.MfgOrderSplitChildOrder as ManufacturingOrder,
MfgOrderSplitChildOrder.MfgOrderSplitParentOrder,
MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder
}
-- Select all Leading Orders
union all select distinct from I_MfgOrderSplitChildOrder as MfgOrderSplitChildOrder
{
key MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder as ManufacturingOrder,
cast(' ' as split_paufnr preserving type ) as MfgOrderSplitParentOrder,
MfgOrderSplitChildOrder.MfgOrderSplitLeadingOrder
}