P_ORDEROPERATIONPRTLONGTEXT
Order Operation PRT Long Text
P_ORDEROPERATIONPRTLONGTEXT is a CDS View in S/4HANA. Order Operation PRT Long Text. It contains 9 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_OrderOperationPRTLongText | view_entity | from | BASIC | Order Operation PRT Long Text |
Fields (9)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderInternalID | OrderInternalID | 1 |
| KEY | OrderProdnRsceToolInternalID | OrderProdnRsceToolInternalID | 1 |
| _Order | _Order | 1 | |
| _OrderCategory | _OrderCategory | 1 | |
| _OrderInternalID | _OrderInternalID | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrderProdnRsceToolText | OrderProdnRsceToolText | 1 | |
| TextObjectKey | TextObjectKey | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.private: true
@VDM.viewType: #BASIC
// This view builds key TDOBNAME for later associations
define view entity P_OrderOperationPRTLongText
as select from I_OrderProdnResourceTool as affh
{
// Key
key affh.OrderInternalBillOfOperations as OrderInternalID,
key affh.OrderProdnRsceToolInternalID,
cast(affh.OrderID as co_aufnr preserving type) as OrderID,
affh.OrderCategory,
// build TDOBNAME
cast(concat(concat($session.client,affh.OrderInternalBillOfOperations),affh.OrderProdnRsceToolInternalID) as tdobname ) as TextObjectKey,
// Text
cast(affh.Language as spras preserving type) as LongTextLanguage,
affh.OrderProdnRsceToolText,
// Association
_Order,
_OrderCategory,
_OrderInternalID
}
where affh.ProdnRsceToolHasLongText = 'X';