R_PurchaseOrderNoteTP

DDL: R_PURCHASEORDERNOTETP Type: view_entity TRANSACTIONAL

Notes for Purchase Order

R_PurchaseOrderNoteTP is a Transactional CDS View that provides data about "Notes for Purchase Order" in SAP S/4HANA. It reads from 2 data sources (P_PurchaseOrderItemActive, R_PurchaseOrderPlainLongText) and exposes 6 fields with key fields PurchaseOrder, TextObjectType, Language.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_PurchaseOrderItemActive _PurchaseOrderItemActive inner
R_PurchaseOrderPlainLongText R_PurchaseOrderPlainLongText from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Notes for Purchase Order view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderPlainLongText PurchaseOrder
KEY TextObjectType R_PurchaseOrderPlainLongText TextObjectType
KEY Language R_PurchaseOrderPlainLongText Language
PlainLongText R_PurchaseOrderPlainLongText PlainLongText
_Language R_PurchaseOrderPlainLongText _Language
_PurchaseOrder _PurchaseOrder 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Notes for Purchase Order'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#MIXED
    },
    semanticKey: ['PurchaseOrder',
                  'TextObjectType',
                  'Language' ]
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_PurchaseOrderNoteTP
  as select from R_PurchaseOrderPlainLongText
  
  inner join P_PurchaseOrderItemActive as _PurchaseOrderItemActive on R_PurchaseOrderPlainLongText.PurchaseOrder = _PurchaseOrderItemActive.PurchaseOrder  
  
  association to parent R_PurchaseOrderTP as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder 
{
  key R_PurchaseOrderPlainLongText.PurchaseOrder,
  key R_PurchaseOrderPlainLongText.TextObjectType,
  key R_PurchaseOrderPlainLongText.Language,
      R_PurchaseOrderPlainLongText.PlainLongText,
      
      /* Associations */
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      R_PurchaseOrderPlainLongText._Language,
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _PurchaseOrder

}   

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURCHASEORDERITEMACTIVE",
"R_PURCHASEORDERPLAINLONGTEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"R_PURCHASEORDERTP"
],
"BASE":
[
"R_PURCHASEORDERPLAINLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More