R_PURCHASEORDITEMPLAINLONGTEXT

CDS View

Purchase Order Item Long text

R_PURCHASEORDITEMPLAINLONGTEXT is a CDS View in S/4HANA. Purchase Order Item Long text. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_PPS_PurchaseOrderItemNoteTP view_entity from TRANSACTIONAL Purchase Order Item Notes
R_PurchaseOrderItemNoteTP view_entity from TRANSACTIONAL Purchase Order Item Notes TP View

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Language Language 2
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
KEY TextObjectType TextObjectType 2
PlainLongText PlainLongText 2
PurchaseOrderItemUniqueID PurchaseOrderItemUniqueID 2 
@AbapCatalog.sqlViewName: 'RMMPURPOILONGTXT'
@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: 'Purchase Order Item Long text'
define view R_PurchaseOrdItemPlainLongText
  as select from R_PurchaseOrderItem       as PurchaseOrderItem
    inner join   I_TextObjectPlainLongText as PurchaseOrderText on PurchaseOrderItem.PurchaseOrderItemUniqueID = PurchaseOrderText.TextObjectKey
  association [1..*] to I_TextObjectPlainLongText as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.PurchaseOrderItemUniqueID
                                                                              and _TextObjectPlainLongText.TextObjectCategory = 'EKPO'
{

  key PurchaseOrderItem.PurchaseOrder,
  key PurchaseOrderItem.PurchaseOrderItem,
  key PurchaseOrderText.TextObjectType,
  key PurchaseOrderText.Language,
      PurchaseOrderItem.PurchaseOrderItemUniqueID,
      PurchaseOrderText.PlainLongText,
      PurchaseOrderText._Language,
      
      _TextObjectPlainLongText

}
where
  PurchaseOrderText.TextObjectCategory = 'EKPO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECTPLAINLONGTEXT",
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[
"I_TEXTOBJECTPLAINLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More