R_OutbDelivItemSerialNumberTP

DDL: R_OUTBDELIVITEMSERIALNUMBERTP Type: view_entity TRANSACTIONAL

Outbound Dlv Item Serial Number - TP

R_OutbDelivItemSerialNumberTP is a Transactional CDS View that provides data about "Outbound Dlv Item Serial Number - TP" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberDeliveryDocument) and exposes 7 fields with key fields OutboundDelivery, OutboundDeliveryItem, SerialNumber. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberDeliveryDocument OutbDelivItemSerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_OutboundDeliveryTP _Delivery $projection.OutboundDelivery = _Delivery.OutboundDelivery

Annotations (9)

NameValueLevelField
EndUserText.label Outbound Dlv Item Serial Number - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey SerialNumber view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery
KEY OutboundDeliveryItem
KEY SerialNumber SerialNumber
Equipment Equipment
Material Material
_Item _Item
_Delivery _Delivery 
@EndUserText.label: 'Outbound Dlv Item Serial Number - TP'
@AccessControl.authorizationCheck: #MANDATORY
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory:   #XL
    },
    semanticKey: ['OutboundDelivery', 'OutboundDeliveryItem', 'SerialNumber'],
    representativeKey: 'SerialNumber'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_OutbDelivItemSerialNumberTP
  as select from I_SerialNumberDeliveryDocument as OutbDelivItemSerialNumber
  association        to parent R_OutboundDeliveryItemTP as _Item     on  $projection.OutboundDelivery     = _Item.OutboundDelivery
                                                                     and $projection.OutboundDeliveryItem = _Item.OutboundDeliveryItem
  association [1..1] to R_OutboundDeliveryTP            as _Delivery on  $projection.OutboundDelivery = _Delivery.OutboundDelivery
{
      // Key

      @ObjectModel.foreignKey.association: '_Delivery'
  key cast(DeliveryDocument as outbound_delivery preserving type) as OutboundDelivery,
      @ObjectModel.foreignKey.association: '_Item'
  key cast(DeliveryDocumentItem as outbound_delivery_item preserving type) as OutboundDeliveryItem,
  key SerialNumber,

      // Material

      Equipment,
      Material,


      /*Association*/
      _Item,
      _Delivery

}
where
  _Delivery.SDDocumentCategory = 'J'

Learn More