R_InbDelivItemSerialNumberTP

DDL: R_INBDELIVITEMSERIALNUMBERTP Type: view_entity TRANSACTIONAL

Inbound Delivery Item Serial Number - TP

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

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberDeliveryDocument InbDelivItemSerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_InboundDeliveryTP _Delivery $projection.InboundDelivery = _Delivery.InboundDelivery

Annotations (9)

NameValueLevelField
EndUserText.label Inbound Delivery 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 InboundDelivery DeliveryDocument
KEY InboundDeliveryItem DeliveryDocumentItem
KEY SerialNumber SerialNumber
Equipment Equipment
Material Material
_Item _Item
_Delivery _Delivery 
@EndUserText.label: 'Inbound Delivery 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: ['InboundDelivery', 'InboundDeliveryItem', 'SerialNumber'],
    representativeKey: 'SerialNumber'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_InbDelivItemSerialNumberTP
  as select from I_SerialNumberDeliveryDocument as InbDelivItemSerialNumber
 association        to parent R_InboundDeliveryItemTP as _Item on          $projection.InboundDelivery     = _Item.InboundDelivery
                                                                       and $projection.InboundDeliveryItem = _Item.InboundDeliveryItem
 association [1..1] to R_InboundDeliveryTP            as _Delivery     on  $projection.InboundDelivery = _Delivery.InboundDelivery
{
      // Key

      @ObjectModel.foreignKey.association: '_Delivery'
  key DeliveryDocument as InboundDelivery,
      @ObjectModel.foreignKey.association: '_Item'
  key DeliveryDocumentItem as InboundDeliveryItem,
  key SerialNumber,
  
      // Material

      Equipment,
      Material,
      

      /*Association*/
      _Item,
      _Delivery

}
where
  _Delivery.SDDocumentCategory = '7'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERIALNUMBERDELIVERYDOCUMENT",
"R_INBOUNDDELIVERYTP"
],
"ASSOCIATED":
[
"R_INBOUNDDELIVERYITEMTP",
"R_INBOUNDDELIVERYTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More