R_PURCHASEORDERPLAINLONGTEXT
Restricted view for Purchase Order Long text
R_PURCHASEORDERPLAINLONGTEXT is a CDS View in S/4HANA. Restricted view for Purchase Order Long text. It contains 5 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PurchaseOrderWorkflowEmail | view | left_outer | CONSUMPTION | Purchase Order Details for Workflow Deadline Email |
| R_PPS_PurchaseOrderNoteTP | view_entity | from | TRANSACTIONAL | Purchase Order Notes |
| R_PurchaseOrderNoteTP | view_entity | from | TRANSACTIONAL | Notes for Purchase Order |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Language | Language | 2 |
| KEY | PurchaseOrder | PurchaseOrder | 2 |
| KEY | TextObjectType | DocumentText,TextObjectType | 2 |
| _Language | _Language | 1 | |
| PlainLongText | PlainLongText,POHeaderTextPlainLongText | 3 |
@AbapCatalog.sqlViewName: 'RMMPURPOLONGTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'TextObjectType'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations: ['_TextObjectPlainLongText']
@EndUserText.label: 'Restricted view for Purchase Order Long text'
define view R_PurchaseOrderPlainLongText as select from R_PurchaseOrder as PurchaseOrder
inner join I_TextObjectPlainLongText as PurchaseOrderText
on PurchaseOrder.PurchaseOrder = PurchaseOrderText.TextObjectKey
association[1..*] to I_TextObjectPlainLongText as _TextObjectPlainLongText
on _TextObjectPlainLongText.TextObjectKey = $projection.PurchaseOrder
and _TextObjectPlainLongText.TextObjectCategory = 'EKKO'
{
key PurchaseOrder.PurchaseOrder,
key PurchaseOrderText.TextObjectType,
key PurchaseOrderText.Language,
PurchaseOrderText.PlainLongText,
PurchaseOrderText._Language,
_TextObjectPlainLongText
}
where PurchaseOrderText.TextObjectCategory = 'EKKO'