P_ORDERITEMSTATUSBASICAGGRGN
Aggregated System Status of Order Item
P_ORDERITEMSTATUSBASICAGGRGN is a CDS View in S/4HANA. Aggregated System Status of Order Item. It contains 5 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MfgOrderItemWithStatus | view_entity | inner | COMPOSITE | Manufacturing Order Item with Status |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| OrderItemIsClosed | OrderItemIsClosed | 1 | |
| OrderItemIsCreated | OrderItemIsCreated | 1 | |
| OrderItemIsPartiallyDelivered | OrderItemIsPartiallyDelivered | 1 | |
| OrderItemIsReleased | OrderItemIsReleased | 1 | |
| SettlementRuleIsCreated | SettlementRuleIsCreated | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated main order item status per ObjectInternalID
// to be used in OrderItem views (join) only!
define view entity P_OrderItemStatusBasicAggrgn
as select from P_OrderItemStatusBasic
{
// Key
key ObjectInternalID,
// Status
cast(max(OrderItemIsCreated) as orderiscreated preserving type) as OrderItemIsCreated,
cast(max(OrderItemIsReleased) as orderisreleased preserving type) as OrderItemIsReleased,
cast(max(SettlementRuleIsCreated) as settlementruleiscreated preserving type) as SettlementRuleIsCreated,
cast(max(OrderItemIsClosed) as orderisclosed preserving type) as OrderItemIsClosed,
cast(max(OrderItemIsPartiallyDelivered) as ispartiallydelivered preserving type) as OrderItemIsPartiallyDelivered,
_StatusObject
}
group by
ObjectInternalID