R_PurchaseOrderPlainLongText

DDL: R_PURCHASEORDERPLAINLONGTEXT SQL: RMMPURPOLONGTXT Type: view COMPOSITE

Restricted view for Purchase Order Long text

R_PurchaseOrderPlainLongText is a Composite CDS View that provides data about "Restricted view for Purchase Order Long text" in SAP S/4HANA. It reads from 2 data sources (R_PurchaseOrder, I_TextObjectPlainLongText) and exposes 6 fields with key fields PurchaseOrder, TextObjectType, Language.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
R_PurchaseOrder PurchaseOrder from
I_TextObjectPlainLongText PurchaseOrderText inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RMMPURPOLONGTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TextObjectType view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Restricted view for Purchase Order Long text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrder PurchaseOrder
KEY TextObjectType I_TextObjectPlainLongText TextObjectType
KEY Language I_TextObjectPlainLongText Language
PlainLongText I_TextObjectPlainLongText PlainLongText
_Language I_TextObjectPlainLongText _Language
_TextObjectPlainLongText _TextObjectPlainLongText 
@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":""
}
}*/

Learn More