R_PPS_PurchaseOrderNoteTP

DDL: R_PPS_PURCHASEORDERNOTETP Type: view_entity TRANSACTIONAL

Purchase Order Notes

R_PPS_PurchaseOrderNoteTP is a Transactional CDS View that provides data about "Purchase Order Notes" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderPlainLongText) and exposes 7 fields with key fields DocumentText, Language, TechnicalObjectType, ArchObjectNumber.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderPlainLongText PlainLongText from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Notes 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 (7)

KeyFieldSource TableSource FieldDescription
KEY DocumentText R_PurchaseOrderPlainLongText TextObjectType
KEY Language R_PurchaseOrderPlainLongText Language
KEY TechnicalObjectType
KEY ArchObjectNumber
PurchaseOrder R_PurchaseOrderPlainLongText PurchaseOrder
PlainLongText R_PurchaseOrderPlainLongText PlainLongText
_PurchaseOrder _PurchaseOrder 
//@JIRA-KEY<S4PPS-0000>

@AbapCatalog.viewEnhancementCategory: [#NONE]
//@AccessControl.authorizationCheck: #MANDATORY

@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Order Notes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#MIXED
    },
    semanticKey: ['PurchaseOrder',
                  'DocumentText',
                  'Language'
                 // 'ArchObjectNumber' 

                  ]
 //   representativeKey: 'DocumentText'

}
@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
        viewType: #TRANSACTIONAL }

define view entity R_PPS_PurchaseOrderNoteTP
  as select from R_PurchaseOrderPlainLongText  as PlainLongText

//   inner join   P_PurchaseOrderItemActive    as _PurchaseOrderItemActive on PlainLongText.PurchaseOrder = _PurchaseOrderItemActive.PurchaseOrder

//

 association        to parent R_PPS_PurchaseOrderTP as _PurchaseOrder           on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
//

// -- association [0..1] 

//  association to I_TextObjectPlainLongText    as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.PurchaseOrder

//                                                                                 and _TextObjectPlainLongText.TextObjectCategory = 'EKKO'

//                                                                                 and _TextObjectPlainLongText.TextObjectType     = $projection.DocumentText

//                                                                                 and _TextObjectPlainLongText.Language           = $projection.Language

{
key PlainLongText.TextObjectType                                                                                                                                                                                                                                                                                                as DocumentText,
//      @ObjectModel.foreignKey.association: '_Language'

  key PlainLongText.Language,
////      @ObjectModel.editableFieldFor: 'TechnicalObjectType'

//     @ObjectModel.foreignKey.association: '_TextObjectPlainLongText'

  key cast( PlainLongText.TextObjectType as tdobject )   as TechnicalObjectType,
////           @ObjectModel.editableFieldFor: 'ArchObjectNumber'

////             @ObjectModel.foreignKey.association: '_PurchaseOrder.PurchaseOrder'

    key     cast(PlainLongText.PurchaseOrder as tdobname ) as ArchObjectNumber,
////      @ObjectModel.foreignKey.association: '_TextObjectPlainLongText'

////  key _TextObjectPlainLongText.TextObjectCategory                                                                                                                                                                                                                                                                                 as TechnicalObjectType,

////      @ObjectModel.foreignKey.association: '_PurchaseOrder'

////  key _TextObjectPlainLongText.TextObjectKey                                                                                                                                                                                                                                                                                      as ArchObjectNumber,

      PlainLongText.PurchaseOrder,

      PlainLongText.PlainLongText,
      
      

//      //@JIRA-KEY<S4PPS-12976>

//      cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,

//

//

//      /* Adding missing attributes */

//  

//      //      @ObjectModel.editableFieldFor: 'DocumentText'

//      //      PlainLongText.TextObjectType                as DocumentTextForEdit,

//      //      @ObjectModel.editableFieldFor: 'Language'

//      //      PlainLongText.Language as LanguageForEdit,

//

//      /* Associations */

//      @ObjectModel.filter.enabled: false

//      @ObjectModel.sort.enabled: false

//      PlainLongText._Language,

//      @ObjectModel.filter.enabled: false

//      @ObjectModel.sort.enabled: false

      _PurchaseOrder
//      _TextObjectPlainLongText

 }

Learn More