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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECTPLAINLONGTEXT",
"R_PURCHASEORDER"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[
"I_TEXTOBJECTPLAINLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/