P_ORDEROPPRTSTATUSBASICAGGRGN
Aggregated System Status of Order Operation PRT
P_ORDEROPPRTSTATUSBASICAGGRGN is a CDS View in S/4HANA. Aggregated System Status of Order Operation PRT. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MfgOrdOperationPRTWithStatus | view_entity | inner | COMPOSITE | Manufacturing Order Operation PRT with Status |
Fields (10)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _PRTIsCreatedCode | _PRTIsCreatedCode | 1 | |
| _PRTIsDeletedCode | _PRTIsDeletedCode | 1 | |
| _PRTIsNotAvailableCode | _PRTIsNotAvailableCode | 1 | |
| _PRTIsPrintedCode | _PRTIsPrintedCode | 1 | |
| _PRTIsReleasedCode | _PRTIsReleasedCode | 1 | |
| OrderOperationPRTIsCreated | OrderOperationPRTIsCreated | 1 | |
| OrderOperationPRTIsDeleted | OrderOperationPRTIsDeleted | 1 | |
| OrderOperationPRTIsPrinted | OrderOperationPRTIsPrinted | 1 | |
| OrderOperationPRTIsReleased | OrderOperationPRTIsReleased | 1 | |
| OrdOperationPRTIsNotAvailable | OrdOperationPRTIsNotAvailable | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated main operation PRT status per ObjectInternalID
// to be used in OrderOperationPRT views (join) only!
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view entity P_OrderOpPRTStatusBasicAggrgn
as select from P_OrderOpPRTStatusBasic
{
// Key
key ObjectInternalID,
// Status
cast(max(OrderOperationPRTIsCreated) as prtiscreated preserving type) as OrderOperationPRTIsCreated,
cast(max(OrderOperationPRTIsReleased) as prtisreleased preserving type) as OrderOperationPRTIsReleased,
cast(max(OrderOperationPRTIsPrinted) as prtisprinted preserving type) as OrderOperationPRTIsPrinted,
cast(max(OrderOperationPRTIsDeleted) as prtisdeleted preserving type) as OrderOperationPRTIsDeleted,
cast(max(OrdOperationPRTIsNotAvailable) as prtisnotavailable preserving type) as OrdOperationPRTIsNotAvailable,
// Associations
_StatusObject,
_PRTIsCreatedCode,
_PRTIsReleasedCode,
_PRTIsPrintedCode,
_PRTIsDeletedCode,
_PRTIsNotAvailableCode
}
group by
ObjectInternalID;