R_POItemExternalReferenceTP

DDL: R_POITEMEXTERNALREFERENCETP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_PO

PO Item External References

R_POItemExternalReferenceTP is a Transactional CDS View that provides data about "PO Item External References" in SAP S/4HANA. It reads from 1 data source (R_PurOrdItemExternalReference) and exposes 13 fields with key fields PurchaseOrder, PurchaseOrderItem, LinkType, PurgExtRefSequenceNumber. It has 1 association to related views. Part of development package RAP_MM_PUR_PO.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
R_PurOrdItemExternalReference R_PurOrdItemExternalReference from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label PO Item External References view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY LinkType LinkType
KEY PurgExtRefSequenceNumber PurgExtRefSequenceNumber
PurgDocExternalSystem PurgDocExternalSystem
PurgDocExtReferenceNodeType PurgDocExtReferenceNodeType
PurgDocExternalReference PurgDocExternalReference
Plant Plant
PurchaseOrderType PurchaseOrderType
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'PO Item External References'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define view entity R_POItemExternalReferenceTP
  as select from R_PurOrdItemExternalReference
  association [1..1] to R_PurchaseOrderTP            as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association        to parent R_PurchaseOrderItemTP as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                           and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  //  on $projection.element_name = _association_name.target_element_name

{
  key PurchaseOrder,
  key PurchaseOrderItem,
  key LinkType,
  key PurgExtRefSequenceNumber,

      PurgDocExternalSystem,
      PurgDocExtReferenceNodeType,
      PurgDocExternalReference,

      Plant,
      PurchaseOrderType,
      PurchasingOrganization,
      PurchasingGroup,

      _PurchaseOrder,
      _PurchaseOrderItem

}
where
  _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''

Learn More